Other Course Start Dates

live sessions delivered via GoTo Training

Starting 6 Sep 2021
Registration Options
dbrownconsulting, Virtual Training Methodology

Course curriculum

  • 1

    Welcome to the Course!

  • 2

    Power BI Resources

    • Comprehensive Resources on Power BI

    • Join a Power BI Community near you
  • 3

    Overview of the Course

    • Course Agenda & Delivery Structure

    • Meet your Trainers

    • Demystifying Reports & Analytics

    • The Typical Analytic Process

    • The 2 Systems every organisation runs

    • The 7 Golden Rules of Data

    • Focusing on End User Needs

    • The Birth of Power BI

    • Visualizing Data like a Pro

    • General Overview Quiz
  • 4

    Introducing Power BI

    • Overview of the Power Platform

    • The Power Platform Applications

    • The Evolution of BI

    • Driving a Data Culture

    • Why Power BI

    • Introduction to Power BI Quiz
  • 5

    Session 1

    • Introduction & Exercise Files

    • Assignment - Session 1

    • Introduction to Power Query

    • Power Query Best Practices

    • Dirty Data 1

    • Dirty Data 2

    • Dirty Data 3
  • 6

    Session 2

    • Introduction & Exercise Files

    • Building the Data Model

    • Building the Fact File

    • Building the Geography Dimension

    • Building Other Dimensions

    • What is a Date Table

    • Connecting your Date Table

    • Building Relationships

    • Assignment - Session 2
  • 7

    Session 3

    • Introduction & Exercise Files

    • Assignment - Session

  • 8

    Star Schema

    • Introducing the Star Schema

    • Increasing Analytic Power of your Model

    • Enriching the Model with Attributes: Modifying your Model

    • Enriching the Model with Attributes: bulding relationships

    • Method for building Dimension Tables

    • Reduced Redundancy with Star Schemas

    • Other Benefits of a Star Schema

    • Inserting Budget Data into your Model 1 of 2

    • Inserting Budget Data into your Model 2 of 2
  • 9

    Session 4

    • Introduction & Exercise Files

    • Assignment - Session
  • 10

    Introduction to DAX

    • What is DAX

    • Calculated Columns

    • Measures

    • Framework for Working with DAX

    • Anchor Measures

    • Filter Measures

    • Variance Measures

    • Table Functions

    • Evaluation Context

    • Iterator Functions

    • CALCULATE Function

    • The DATE Table

    • Time Intelligence Functions
  • 11

    Time Intelligence Measures

    • Introduction & Exercise Files

    • Building Time Intelligence Measures in Dax

    • Sales Year to Date

    • Sales Month to Date

    • Sales Quarter to Date

    • Sales for the same period Last month

    • Sales for the Previous Month

    • Sales for the Same Period Last Year

    • Sales for the Previous Year

    • Buidling Time Intelligence Variance Measures in DAX
  • 12

    Session 5

    • Introduction & Exercise Files

    • Assignment - Session 5
  • 13

    Report Building Tips

    • Steps for Building a Power BI Model

    • Framework for working with DAX

    • 6 Step Process to Present Data

    • When to use a Table or Graph

    • Applying Filters with Slicers
  • 14

    Session 6

    • Introduction to Session 6
  • 15

    Bonus Chapter

    • Q&A Session 1

    • Q&A Session 2
  • 16

    Evaluate this Course

    • Instructions

    • Course Evaluation

    • How to Attach your Certificates to your LinkedIn Profile

Instructor(s)

Wale 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

FAQ

  • How does Virtual Training Work?

    You cover fundamentals of Excel for the first 2 weeks on this platform with over 200 knowledge videos. Then you join a Virtual class to cover 10 virtual sessions.

  • How long is each Virtual Session?

    Each Virtual Session lasts two hours and is highly interactive. There is a 15 minute break in the middle and it is fully instructor led.

  • How long do I have access to the course content and platform?

    You have access to this platform will all the course content, videos, exercise files and access to the trainer via discussion forum for life. We will never switch you off.

  • Can I defer my Session?

    Deferral requests are treated on a case by case basis. Please email training@dbrownconsulting.net with your request.

  • Are the videos available offline?

    Our videos are only available for streaming online. But you can download all exercise files and materials.