Hurry! The next class is almost full book your seat today, before the deadline.
live sessions delivered via GoTo Training
Virtual Course Overview
FREE PREVIEWHow to use this Main Course Platform
Requirements for Virtual Sessions
FREE PREVIEWGetting Ready for Virtual Training
Your Expectations
Ask the Trainer
FREE PREVIEWCourse Outline - Agenda
FREE PREVIEWGeneral Knowledge Manual - Power BI
More resources for you
Join our growing Community on Telegram
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
Introduction
How Excel Works
How Dates work in Excel
The 7 Golden Rules of Data
The 3 Sheet Framework
Excel's Reporting Infrastructure Quiz
What is Power Query?
Get Data with Power Query
Lab - Get Data with Power Query
Getting External Data into Excel
FREE PREVIEWConnect to Excel Files in a Folder
Consolidate Excel Workbooks
FREE PREVIEWTransform Data Types
Loading your Query to Excel
Power Query Quiz
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
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
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
Connect to Data Sources
Clean and transform data with Power Query Editor
Create Visuals in Power BI
Share a Power BI Report
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
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
Session 1 Assignment
Assignment - Session 2
Assignment - Session 3
Assignment - Session 4
Assignment - Session 5
Assignment - Session 6
Instructions
FREE PREVIEWEvaluate & get your Certificate
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.
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.
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.
Deferral requests are treated on a case by case basis. Please email training@dbrownconsulting.net with your request.
Our videos are only available for streaming online. But you can download all exercise files and materials.
