Learn Power BI from the masters!
Adam and Patrick will walk you though the Power BI Blueprint to create reports. This course is great for folks just getting started with Power BI, or for folks that are familiar with creating reports and want to get those tips and tricks that Guy in a Cube can bring to the table.
Course curriculum
Your journey with Power BI
-
01
Welcome to the course!
Show details- A message from the instructors
- Before we begin...
- Course Updates
-
02
Tools of the trade
Show details- Power BI Desktop
- Course files overview
- Course files download
-
03
Getting data
Show details- Starting with CSV
- Sidebar: Power Query interface
- Sprinkle in some web content
- Data from a database
- Sidebar: Import vs. DirectQuery/Live Connection
- Getting Data: Test your learning
-
04
Transforming data
Show details- Basic Power Query operations
- Adding a column
- Refresh Date/Time
- Not so basic Power Query items
- Parameters and applying data
- Transforming data: Test your learning
-
05
Preparing the model
Show details- Data model basics
- Introduction to relationships
- Bi-directional Relationships
- Hiding elements
- Categories and default summarization
- Introduction to DAX
- Hierarchies
- Prepare your model: Test your learning
-
06
Working with time
Show details- Date/Calendar table
- Auto Date/Time and Relationships
- Working with time: Test your learning
-
07
Working with measures
Show details- What's a measure? And, why you use them.
- Bi-Direction relationships and CROSSFILTER()
- Additional formatting
- How to handle multiple dates
- DAX Resources
- Working with measures: Test your learning
-
08
Visualizing the data
Show details- Base visualizations and custom visuals
- Building your overview page
- Spicing things up with backgrounds and layouts
- Ask a question of your data
- Visualizing the data: Test your learning
-
09
Taking visualizations to the next level
Show details- Themes and next level backgrounds
- Using drillthrough in your reports
- Make tooltips exciting!
- Selections, bookmarks and buttons. Oh my!
- Next level visualization: Test your learning
-
10
The Power BI Service
Show details- Signing up and signing in
- Sidebar: Browser search engine hacks
- Getting around the service
- All about workspaces
- Creating and using dashboards (not reports)
- Publishing and using Apps
- Refreshing your data with and without a gateway
- Power BI Service: Test your learning
-
11
Bonus
Show details- Row-level security
-
12
Next steps
Show details- Congrats! Here's what's next...
- More resources for you
- Before you go...
-
Instructors
Instructor Bio:
Adam Saxton Patrick LeBlanc
Instructors
Pricing options
This low prices gets you everything listed above and puts you on the right road to creating awesome reports in Power BI!
-
$299.00
FAQ
-
How is this different from Dashboard in a day?
Dashboard in a day is a great initial intro to Power BI, but it is limited to a 4 hour block. In our Power BI Blueprint, we walk you through Power BI, beginning to end. We go deeper into those items than what Dashboard in a day allows for. We also add in tips and tricks we've learned over time.
-
Is this a live broadcast of an in-person training?
No. This is an on-demand, self-paced, online training.
-
How long do I have access for?
The course is available to you for 1 year. During that time, you will receive all updates to the course, along with any new sections that are added.