Course Description

This Virtual course is designed to equip you with the much needed techniques that will help you in report building and data analytics. The course is designed to equip you in communicating business data effectively and gain clearer insights through powerful analytics. This course has 143 Lessons which you would need to cover within a study time not less than 67.7 hours. By the end of this course, you would be able to:

  • Demonstrate working knowledge of Power Query.

  • Use a framework for building a Data Model.

  • Assess various data visualization options in Power BI Desktop.

  • Make sense of the DAX formula Language.

  • Produce typical business reports using DAX formulas you will build on a Power BI Data Model.

  • incorporate budget data to your reporting, Building budget variable analysis reports.

  • Produce a complete reporting solution from scratch in a full Day Case Study Session.

Course curriculum

  • 1

    Welcome to the Course!

    • Introduction to the Course

    • How to use this Main Course Platform

    • Your Expectations

    • Ask the Trainer

      FREE PREVIEW
    • Join our growing Community on Telegram

    • More resources for you

    • Meet your Facilitators

  • 2

    Introduction

    • Demystifying Reports & Analytics

    • The Typical Analytic Process

    • The 2 Systems every organisation runs

    • Focusing on End User Needs

    • Overview of the Power Platform

    • The Power Platform Applications

    • The Birth of Power BI

    • The Power BI interface

    • Introductory Chapter Quiz

  • 3

    Understanding Data Preparation

    • Introduction to Power Query

    • Data Sources

    • Session Materials

    • Power Query Interface

    • Connecting to Excel

    • Connecting to Web Data Source

    • Link to Connecting to the data on the Web

    • Connecting to SQL Data Source

    • Cleaning Dirty Data 1

    • Cleaning Dirty Data 2

    • Cleaning Dirty Data 3

    • Power Query Editor

    • Data Preparation Chapter Quiz

  • 4

    Building your Report

    • Introduction

    • Review of Reporting and Analysis Life Cycle

    • Data Visualization - Edward Tufte

    • Tables or Graphs

    • When to use Tables

    • When to use Graphs

    • Building Reports - Introduction

    • Building Reports Demo - 1

    • Building Reports Demo - 2

    • Building Reports Demo - 3

    • Building Reports Demo - 4

    • Building Reports Demo - 5

    • Building Reports Demo - 6

    • Wrap Up

    • Building your report Chapter Quiz

  • 5

    Evaluate the Classroom Course

Instructor(s)

Adewale Yusuf

Microsoft MVP & MCT

Adewale is a Microsoft Most Valuable Professional (MVP) in the Data Platform and a Microsoft Certified Trainer (MCT) in Business intelligence and analysis, among other certifications he is a Microsoft certified Solution Associate and a Microsoft Certified Power Platform Functional Consultant. Wale facilitates our Data Analytics courses including, Excel, Office 365, Power BI, Power Apps and Advanced Presentation Skills. He is passionate about impacting knowledge to the community and currently leads many usergroups and communities driving Data Analytic Competencies.

Some of our Clients

Other Courses for you

  • $1,200.00

    $1,200.00Reporting & Analytics with Power BI Course

    Buy Now
  • $199.00

    $199.00Microsoft Excel Fundamentals for Analysts

    Buy Now