On the first day of the workshop, participants will gain a solid foundation in databases and SQL, essential for anyone looking to analyze and manage data effectively. The session starts with an introduction to databases, covering relational database concepts, data integrity, and best practices in database design. Attendees will then dive into SQL, learning how to retrieve, filter, and manipulate data using real-world examples. By the end of the day, participants will have hands-on experience designing a database and writing optimized SQL queries—crucial skills for data-driven decision-making.
On the second day, participants will explore Power BI, a powerful tool for transforming raw data into actionable insights. The session begins with an introduction to Power BI, including setup, data connections, and data transformation techniques. Attendees will then learn how to create interactive dashboards and visualizations, using charts, filters, and slicers to tell compelling data stories. By the end of the day, participants will have built a fully functional dashboard, equipping them with the skills to analyze and present data effectively.