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.
Hurry! The next class is almost full book your seat today, before the deadline.
live sessions delivered via ZOOM Training
Virtual Course Overview
FREE PREVIEWHow to use this Main Course Platform
Requirements for Virtual Sessions
FREE PREVIEWGetting Ready for Virtual Training
How to use our Virtual Training Platforms
Your Expectations
Ask the Trainer
FREE PREVIEWCourse Brochure - Agenda
FREE PREVIEWCourse Manual
More resources for you
Join our growing Community on Telegram
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
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 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
Introduction
FREE PREVIEWDownload Power BI Desktop
Exercise File Downloads for Virtual Sessions
Requirements for the Virtual Sessions
FREE PREVIEWHow to use our Virtual Training Platforms
Introducing the Class Digital Whiteboard
Navigating the Whiteboard
Adding Content to the Whiteboard
Formatting content on the Whiteboard
Using Keyboard Shortcuts for the Whiteboard
Virtual Session
Dirty Data Samples
Historical Sales Data
Factsales Demo
Connecting to a Data Source
Dirty Data 1
Dirty Data 2
Dirty Data 3
Session 1 Assignment
Virtual Session
Historical Sales Data
D_Calender Data
Building Factfile and Dimension Files in Power Query
Building Connection in Modelling View
Assignment - Session 2
Virtual Session
Assignment - Session 3
Virtual Session
Power BI Best Practices
Assignment - Session 4
Virtual Session
Inserting a logo in Power BI
Using Text Box in Power BI
Area Chart in Power BI
Slicers in Power BI
Top N Using the Multi Row Card Visual-
Line Chart in Power BI
AI Visuals in Power BI
Edit Interaction in Power BI
Power BI Capstone Project
Virtual Session
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.
