Foundation for Data Analysis: SQL and Power BI for Beginners

27–29 January 2025

Dr. Ibrahim Shafiu, https://www.linkedin.com/in/ishafiu/

Introductory offer with 90% discount. Course Fee MVR 99 one time offer (non-refundable)

This online course covers essential data analysis concepts, including data types, relational databases using Microsoft SQL, and SQL for exploration and querying. You'll also learn to create impactful visualizations with Power BI, transforming data into actionable insights. Perfect for beginners and those seeking to enhance their skills.

Day 1: Basics (3 hrs)

• Lecturer and participant introductions, 10 min
• Introduction to Data Analysis, 20 mins 
• How data is collected, stored and accessed, 20 min
• Types of data and data management, 20 mins
• Introduction to relational databases and data structures, 30  mins
• MS SQL Management Studio as a tool to interact with SQL Databases and underlying data objects, 30 mins
• Introduction to SQL as data analysis language, 90 mins

Day 2: Intermediate SQL (4 hours). 

• Querying multiple tables using various Joins, 
• Data summarization Aggregation (MIN, MAX,COUNT),
• Nested queries, 
• Views and Stored Procedures
• Using Generative AI to generate SQL scripts to answer a business question

Day 3: Data Exploration and Data visualisation using Power BI (4hrs)

• Introduction to Power BI and its features 15 mins
• PowerBI as a data exploration tool   15 mins
• Introduction to Data Story telling using Visuals. 2 hours
• Project: to Test the skills learned. 90 minutes

Enroll now to secure your spot! Scan QR code above or use the following link: https://tinyurl.com/sdrimv