Ultimate Beginner's Guide to
Power BI
Premium Power BI training for individuals looking to develop their analytical thinking and capabilities. This course aims to teach you how you can achieve this yourself through utilising the key features within the Power BI suite.
Here's What You'll Get
With The Course
3 hours of course video content
Demo data set
to practice with
Advanced Power BI model & report
Quiz to test your knowledge
Get an overview on all the introductory concepts of how to use Power BI as an analytical tool
- Step-by-step work through a real-world scenario so you can understand how data can start from its rawest form and be developed into a compelling analytical solution using Power BI
- Help you find valuable insights that can drive decision making within organisations
Details Of What You Will Learn
During This Course
- Learn - how to use Power BI as an analytical engine, turning raw data into unmatched insights
- Save - mountains of time by learning how to automate analysis and reporting
- Learn - how to look at raw data and then apply Power BI and DAX to find answers
- Learn - how to find the insights that make a difference and add value to decision making
- Develop - compelling visualizations that showcase insights that will add value to business discussions and actions
This Course Module is Tailored for:
Data Analysts
Reporting Managers
Excel Users
This course is designed for those who have little to no knowledge of Power BI but are working in data-driven environment.
LEARN HOW TO
Utilize the key features within the Power BI suite
- Develop a best practice Power BI model
- Plan Power BI development before you start
- Query, transform and load data
- Create a data model
- Write DAX measures
- Develop compelling reports and visualizations
- Publish to the Power BI online service
- Create dashboards
- Use the Q&A feature
- Use other online service features
Course Curriculum
1. Introduction
- How to get Certified for this course?
- Data & resource downloads
- Course Intro
- What is DAX and why do you need to learn it?
- A review of the data scenario
- Setting up your Power BI model
2. Querying & Transforming Data
- Query editor explained
- Simple transformations
- Creating a date table
- Organising your queries
- Advanced transformations
3. Data Modelling
- What is data modeling?
- Relationships between tables
4. DAX Calculations
- What is DAX?
- Measure groups
- Simple measures
- Measure branching
- Advanced DAX
5. Reports & Visualisations
- Visualisation options
- Colour and themes
- Custom visuals
- Visualisation best practices
6. Online Service
- Publish to online service
- Dashboards & Apps
- Natural language query
- Distribution features
Your Instructor
Sam McKay
Sam very early on saw the immense opportunity of using Power BI to create analytical solutions. After years of developing some advanced analysis and tools in excel, he was amazed that he could re-create most of those things in about 10% of the time with Power BI.
He is the founder and CEO at Enterprise DNA, a business intelligence training & consultancy business primarily focused on driving better decision making within organisations by empowering individuals and teams to transform raw data into unmatched insights using Microsoft's Power BI suite of tools.
Sam has a strong history in Finance, previously working at ANZ, PIMCO, and Fonterra. He is also a CFA charter holder, achieving the designation in 2011.
He has a passion for building highly scalable analytical solutions within organisations, and wants to see others learn how to do the same.
Frequently Asked Questions
- How long do I have access to the course? You have access to this course as long as you have Enterprise DNA On-Demand Subscription.
- Can I purchase a single course instead of the Enterprise DNA On-Demand? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full On-Demand Subscription here.
- Do you offer one-off support or coaching? All support around Power BI and Enterprise DNA's online training content now occurs at the Enterprise DNA Forum. You must have an Enterprise DNA On-Demand Subscription or CoE access to receive support.
- What if I need to train my team? We recommend exploring Enterprise DNA Center of Excellence platform. To learn more, see here.
Get full access to unparalleled training
& skill-building resources
For Individuals
Enterprise DNA
On-Demand
Empowering the most valuable Power BI users to expand their analytical thinking and insight generation possibilities
For Teams
Enterprise DNA
Center of Excellence