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 6 Sep 2021
dbrownconsulting, Virtual Training Methodology

Course curriculum

  • 1

    Welcome to the Course!

  • 2

    Agenda , Manual & Resources

  • 3

    Overview of Power BI Technologies

    • What is Power BI?

    • Introduction to Power Bi Desktop

    • Star schema design

    • Comparing Power BI Desktop and the Power BI service

    • Introduction to Power Query

    • Introduction to DAX

    • Understanding the Power BI Eco System

    • Download Power BI Desktop

    • Power BI Technologies Quiz

  • 4

    Excel's Reporting Infrastructure

    • Introduction

    • How Excel Works

    • How Dates work in Excel

    • The 7 Golden Rules of Data

    • The 3 Sheet Framework

    • Excel's Reporting Infrastructure Quiz

  • 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

    • Data Modelling Quiz

  • 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

    • Visualization Quiz

  • 8

    Overview of DAX

    • Introduction in DAX

    • DAX Calculation types

    • DAX Functions

    • Writing DAX Formulas

    • DAX Syntax

    • DAX Expressions and Variables

    • Tables relationships and DAX

    • DAX works with Tables

    • Creating Calculated Columns

    • DAX Quiz

  • 9

    Analyzing Data with Power BI

    • Connect to Data Sources

    • Clean and transform data with Power Query Editor

    • Create Visuals in Power BI

    • Share a Power BI Report

  • 10

    Classroom

    • Download Power BI Desktop

    • Exercise File Downloads

    • Day 2 Download

  • 11

    Session 1

    • Session 1 Assignment

  • 12

    Session 2

    • Assignment - Session 2

  • 13

    Session 3

    • Assignment - Session 3

  • 14

    Session 4

    • Assignment - Session 4

  • 15

    Session 5

    • Assignment - Session 5

  • 16

    Session 6

    • Assignment - Session 6

  • 17

    Basic DAX Functions

    • Calculated tables

    • Insert a new data table in Power BI Desktop

    • Column from example

    • Merge queries

    • Query dependency view

    • Create calculated measures

    • Create calculated columns

    • Query parameters

    • Time intelligence

    • Conditional columns

    • Removing or re-ordering columns

  • 18

    Advanced DAX Functions

    • Advanced DAX

    • Calculate filter

    • Filter Context in DAX

    • Row Context in DAX

    • Nesting row contexts

    • Calculate Example

    • Introduction to Calculate

    • Working with Evaluation Context and the two types of Evaluation context

    • Creating a DAX calculated column based on ranking by price

    • Working with Variables in DAX

  • 19

    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 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.

David Brown

FCA, Microsoft MVP

David has worked with and taught Excel and financial modelling to over 4,000 people in the last 22 years. He is the Managing Partner of dbrownconsulting where he runs the Consulting Division.He is a Fellow of the Institute of Chartered Accountant of Nigeria & a Financial Analyst with over 16 years experience working as a Business intelligence, Financial Modelling & Tax Consultant with Arthur Andersen, KPMG & dbrownconsulting.He is also an International Consultant to the World Bank on Oil Revenue Modelling and is a registered financial adviser.David attained the Master Trainer & Master Instructional Designer designation from the Association for Talent Development (ATD).He is passionate about Financial Modelling, Business Intelligence and Analytics especially with Microsoft Power BI and Excel and regularly host meetups and speaker event in Nigeria and around the world.

Some of our Clients