REPORTING & ANALYTICS WITH POWER BI COURSE
Learn to build Data Models and Analytics with Power BI and share your insights with your colleagues enhancing your ability to make even smarter business decisions transforming the way you work.
live sessions delivered via GoTo Training
Introduction to the Course
FREE PREVIEWHow to use this Platform
Software & Hardware requirements
FREE PREVIEWUsing our Virtual Training Platforms
Course Brochure
FREE PREVIEWYour Expectations
Ask the Trainer Discussion Forum
FREE PREVIEWComprehensive Resources on Power BI
Join a Power BI Community near you
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
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
Introduction & Exercise Files
Introduction to Power Query
Power Query Best Practices
Dirty Data 1
Dirty Data 2
Dirty Data 3
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
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
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
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
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
Instructions
Course Evaluation
How to Attach your Certificates to your LinkedIn Profile
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 [email protected] with your request.
Our videos are only available for streaming online. But you can download all exercise files and materials.