Register for the Next Class

Hurry! The next class is almost full book your seat today, before the deadline.

  • 00Days
  • 00Hours
  • 00Minutes
  • 00Seconds

Other Course Start Dates

live sessions delivered via GoTo Training

Starting 11 Aug 2020 | Starting 15 Sep 2020 | Starting 28 Sep 2020 | Starting 20 Oct 2020
dbrownconsulting, Virtual Training Methodology

Course curriculum

  • 1

    Welcome to the Course!

  • 2

    Agenda , Manual & Resources

  • 3

    Overview of Power BI Technologies

    • Overview of Power BI

    • What is Power BI?

    • What is Power BI Desktop?

    • What is the Power BI service?

    • Comparing Power BI Desktop and the Power BI service

    • Introduction to Power Query

    • Introduction to DAX

    • Understanding the Power BI Eco System

  • 4

    Excel's Reporting Infrastructure

    • Introduction

    • How Excel Works

    • How Dates work in Excel

    • The 7 Golden Rules of Data

    • The 3 Sheet Framework

  • 5

    Understanding Power Query

  • 6

    Overview of Data Modeling

    • What is Data Modelling?

    • Overview of modeling data

    • Manage data relationships

    • Understand star schema Data Model and the importance for Power BI

    • Working with Tables

    • Creating a Date Table

    • Define Data Granularity

    • Working with Relationships and Cardinality

  • 7

    Overview of Visualisation

    • Create Calculated Columns

    • Introduction to Visuals

    • Create Visualizations

    • Hierarchical axis and concatenating

    • Filters and TopN

    • Combo Charts

    • Analytics Pane

    • Clustering Data

    • Slicers

    • Date Slicers

    • Map Visualizations

    • Tables and Matrixes

    • Table Styles

    • Create and Format a Scatter chart

    • Waterfall Chart and Funnel Chart

    • Gauge,Cards and KPI Visuals

    • Coloring charts

    • Static Images

    • Visual interactions

    • Duplicate and Rename a Power BI report page

    • Show categories with no data

    • Visuals Summarization

    • Organizing your report

    • Creating and Working with hierarchies

    • Use advanced interactions and drill through

    • Tune Report Performance

    • Publish and Export Reports

  • 8

    Overview of DAX

    • Introduction in DAX

    • DAX Calculation types

    • DAX Functions

    • Writing DAX Formulas

    • DAX Expressions and Variables

    • Tables relationships and DAX

    • DAX works with Tables

    • Creating Calculated Columns

  • 9

    Virtual Sessions

  • 10

    Session 1

    • Virtual Session

    • Dirty Data Samples

    • Historical Sales Data

    • Factsales Demo

    • Dirty Data 1 Demo

    • Dirty Data 2 Demo

  • 11

    Session 2

    • Virtual Session

  • 12

    Session 3

    • Virtual Session

  • 13

    Session 4

    • Virtual Session

  • 14

    Session 5

    • Virtual Session

  • 15

    Session 6

    • Virtual Session

  • 16

    Evaluate the Classroom Course

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.

Instructor(s)

Wale Yusuf

Microsoft Certified Trainer

Adewale is a Microsoft Certified Trainer in Business intelligence and analysis, among other certification he is a Microsoft certified Solution Associate and Professional in BI Report.

David Abu

Microsoft Certified Trainer

David is a passionate trainer who specializes in business intelligence using Power B.I, Power Query, reporting and visualization using DAX. David is a is a Microsoft Certified Trainer in Business intelligence and analysis, among other certification he is a Microsoft certified Solution Associate and Professional in BI Report.

Ezekiel Adesawe

Trainer & Analyst