About the Program

Download the course brochure with course outlines

Master the art of Data with Power BI and SQL

This is a 10-weekend program covering beginner to advanced concepts of Data Analysis, Data Visualization with Microsoft Power BI, and Database Querying with SQL.

Power BI is a leading Business Intelligence and Data Analytics tool used by most organizations and consultants to deliver key business insights derived from Data.

Similarly, organizations transactional datasets are stored in SQL Databases.

In this program, you will gain proficiency with Microsoft Power BI and Querying SQL Server with T-SQL.

The Power BI Class will run for 7 weekends and the SQL Class will run for 3 weekends.

There will be a 1-weekend break between both classes.

Timing

  • Starting: October 21, 2023
  • Class days: Saturdays and Sundays
  • Power BI Classes: (7 weeks)
  • SQL Classes: (3 weeks)
  • Class Time (West Africa Time ): 1pm - 5pm
  • Class Time (UTC): 12pm - 4pm
  • Class Time (Eastern Standard Time): 08am - 12pm

What you will learn

In this program, you will learn beginner to advanced Power BI and SQL concepts including:

  • Connecting to data sources & preparing data in Power BI

  • Understanding Fact and Dimension Tables and Power BI Data Modeling

  • Developing highly interactive Power BI Reports

  • Writing Power BI DAX formulas

  • Using SELECT statement to Query Databases

  • Filtering and Ordering Database Queries

  • Querying data from multiple Database Tables with JOINS

  • Using Built-in SQL functions

Instructor(s)

Ahmed Oyelowo

Microsoft MVP, Certified Trainer

Ahmed is a Microsoft Certified Trainer and a Microsoft MVP for the Data Platform. He is also a Microsoft Certified Power BI Data Analyst, a Microsoft Certified Azure Enterprise Data Analyst, a Microsoft Certified Office Specialist: Excel Expert and a Microsoft Certified Educator. He has taught Power BI to over 90,000 (Ninety Thousand) people globally with his unique and simplified approach to explaining complex concepts. He is the Managing Partner and Lead Trainer at Foresight BI & Analytics.

Toyyib Oyelowo

SQL Instructor

Toyyib is a Power BI Developer and a Microsoft Certified Power BI Data Analyst. He is particularly fond of SQL and has tutored hundreds of participants over the last 2 years. Fun fact about Toyyib, he is a graduate of Political Science but now an Instructor of Data Science 😁. When he is not engaged in Consulting or Training activities, he hunts for SQL challenges.

FAQ

  • Do I need to have previous experience to join the class?

    If you know how to operate a Windows Computer, open and close applications, download things, then you can participate in the class as the instructor considers participants with zero prior technical knowledge.

  • I am a complete novice and not sure if I can cope with the class

    Try the free 4 hours Data Visualization Essentials with Power BI Course. If you are able to follow the lessons, you can participate in this course. And what more? The free course also comes with a certificate of completion. Get the course on training.foresightbi.com.ng

  • What type of Laptop can I use? Can I use a Macbook?

    Microsoft Power BI Desktop and SQL Server are the primary applications for this course and are only available on Windows Computers. A Windows computer with Windows 10 OS. The higher the specs, the better.

  • Will I get a Certificate for this course?

    On completion of the course, you will have 2 Certificates of Completion. One for Power BI and one for SQL

  • What if I am unable to attend a class for important reasons?

    All the classes are recorded and the recordings will be shared with registered participants

  • How long will the class recordings be available for?

    All classes will be recorded and archived on our LMS. You will have lifetime access to the LMS and all class recordings.

Complete your purchase