Learn Power BI by building one complete business project: 40+ hours, 1 year of access, US$ 9 paid once
The Power BI eXperience Complete Course, with Leonardo Karpinski, CEO of Xperiun.
You start from zero and solve one company's problems, mission by mission, until you have a complete project to show.
The course is 100% online and recorded. You get instant access to more than 40 hours of lessons and learn the most popular business intelligence tool in the market at your own pace.
You pay US$ 9 one time. There is no monthly fee. You get 1 year of access to everything: all the lessons, the 23 dashboards, the student community, the challenges and the certificate.
If the course is not for you, ask for your money back within 7 days.
One price, everything included
Monthly Plan
paid monthly
- 1 month commitment
- 7 day money back guarantee
- 40 hours of recorded content
- 23 Dashboards to download
Complete Course
once
Before: US$ 87 per year
- One payment, no monthly fee
- 1 year of access
- 7-day money-back guarantee
- 40+ hours of recorded lessons
- 23 dashboards to download
- Student community
- Exclusive challenges
- Certificate of completion
With Power BI, you will:
Stop repeating the same Excel tasks every month
Build interactive dashboards
Get your monthly reports done faster
Answer business questions with data
When I started working with Power BI, there was very little material to learn from. Hardly anyone was talking about it. I had to research almost everything on my own.
You do not have to go through the same struggle. I built this course to be the path I wish I had at the start: what to learn, in what order, and how to use it at work. The 6 missions are one project, so you always know why you are learning each topic.
The course is 100% online and self-paced. You watch wherever and whenever you want, for 1 year. You can pause, go back and watch a lesson again as many times as you need. You can start today and build your first report in Mission 1.
This course used to cost US$ 9 per month, or US$ 87 per year. Now there is only one plan, with everything inside.
One payment of US$ 9. No monthly fee.
Does this sound familiar?
Your company's data lives in many Excel files. At the end of every month, you rush to put it all together. Your manager asks for the report again, and something is always missing.
There is a better way. You build the report once. It updates with new data, and anyone can filter it. That is what Power BI does, and it is what you will learn here.
In the Power BI eXperience Complete Course, you learn from zero how to build modern, interactive reports with Power BI, the Microsoft tool that is replacing Excel reports in many companies.
Why I built it this way
My name is Leonardo Karpinski, and I am the CEO of Xperiun. I have worked with Power BI every day since 2016. Since then, I have put more than 20,000 hours into client projects, courses, training and research.
I studied what exists in the market, in Brazil and around the world. I can tell you that this is the most complete training program for professionals who want to master Power BI.
Short videos about single features are good for tips. They do not show you how the pieces fit together. So this course follows one project from Mission 1 to Mission 6, with the same client, step by step. By the end, you know how to take raw data and turn it into a published report that people use.
What changes when you start the course
Start from zero and build your first report in Mission 1
Spend less time on work a report can do
What students say
More than 35,000 students have studied in the Xperiun ecosystem. Here is what some of them wrote to me, translated from Portuguese.
In other words, the course has already more than paid for itself.
And I have not finished the course yet. I am at a little over 20%.
The investment was worth it.
With the consulting projects I have closed, I have already paid for the course almost 6 times. Thank you, Leo.
I used to build some dashboards, but without many concepts or good design. Only after the course could I improve all my projects, from data analysis to the final dashboard.
I was hired to lead a team and implement BI in a group of clinics and medical laboratories.
I just wanted to say thank you. After joining the course, I built a net sales dashboard for my company very easily.
When I presented it, I got recognition for it.
Class by class, I learned your way of building good DAX formulas, thinking from the inside out.
What seemed impossible before became real. I wrote the DAX myself and used it to solve a business problem.
I still have a long way to go, but I believe the course opened doors for me to build more solutions and grow in DAX.
You learn Power BI by acting as a BI consultant
This is what makes the course different. You solve real business problems for Heavy Power Nutrition (HPN), a food supplement company in Seattle, USA. HPN even has its own website.
You work on this project with me. We use Power BI to build every report and analysis that HPN needs.
The client sends us missions. Each mission needs new knowledge: business, ETL (data transformation), data modeling, DAX, visualization, sharing, automation and SQL Server.
One project, from start to finish, the way it works in a real job.
I will guide you, step by step
You do not need any experience with Power BI to start.
The course is for any professional who needs to build reports or analyze data. You do not need the job title of Analyst. If you use data in any way, you already do analysis, and this course is for you.
You will learn the whole process, from installing Power BI to setting up the automatic refresh of your reports.
I do not stay on the surface. I go deep into each concept, with examples, so you understand why things work and not only where to click.
And if you already use Power BI, the lessons on data modeling, DAX and governance will still teach you a lot.
Want to see every lesson?
The course has more than 40 hours of content, with exercises and challenges so you practice what you learn and use it in your own reports at work. This is practical content, validated by more than 35,000 students in the Xperiun ecosystem.
The 6 missions follow the HPN project, so each mission builds on the one before.
Here is the full list: Getting Started, the 6 missions and 6 bonuses. Click Getting Started or a mission to see its lessons.
- Welcome to a new Experience
- What are we gonna solve in this program?
- How do I download the materials?
- How to ask for help?
- What is Power BI and Business Intelligence?
- The 7 pillars for Mastering Power BI
- Case studies with Power BI
- Installing Power BI Desktop
- Creating your free online account
- Understanding the mission and downloading the data
- Where does data come from?
- Exploring Power BI Desktop
- Cleaning and transforming our data
- Comparing Excel (XLOOKUP) and Power BI (Merge Queries)
- Merge vs Append Queries
- Different types of Join in Merge Queries
- Creating our first visuals – Part 1
- Creating our first visuals – Part 2
- The problem aggregating columns
- Creating custom columns in Power Query
- What happens when data changes?
- What is the DAX Language?
- Calculated Columns (Power Query and DAX) vs Measures
- Removing Columns and checking the file size
- Evaluation Contexts: Understanding the Filter Context
- Evaluation Contexts: Understanding the Row Context
- Iterative functions (SUMX) to work row by row
- Exercise: what are the values for MINX, MAXX and AVERAGEX?
- Do I have a Filter Context when using SUMX?
- Where can I find a list of DAX functions?
- Creating all other measures for the Mission
- Organizing our measures into a specific folder and formatting them
- Completing Tasks 1 to 5 for the Mission
- Completing Task 6 of the Mission
- Visuals that help you answer your data
- Changing the theme
- Avoid manipulating your data before importing in Power BI
- Recap Mission #01
- Download the final solution for the Mission
- Understanding the mission and downloading the data
- Connecting to the Target table and preparing it
- Understanding the need for relationships
- Normalization vs Denormalization: which one?
- What is a data model, dimension tables and fact tables?
- Normalizing our data to create dimension tables
- Understanding relationships between tables
- What happens when I do not have a relationship?
- Creating many-to-many relationships
- Why you should avoid bidirectional relationships
- Using measures to filter slicers
- Optimizing the applied steps in Power Query
- Documenting Power Query steps
- Understanding the M Language
- Creating the Date (Calendar) Dimension in Power Query
- Connecting to the Web to including holidays
- Turning the Date Dimension dynamic
- Creating MonthYear column in the Date Dimension
- Comparing Net Sales and Target
- Connecting to a folder and cleaning the data
- What should we recommend to the client?
- [Tip] Why sometimes we get a blank value on slicers?
- [Tip] 4 different ways to do the VLOOUP in Power BI
- [Tip] Traditional Many to Many relationships between dimensions
- [Tip] Multi-column relationships
- Download the final solution for the Mission
- Understanding this mission
- Counting measures with DAX: COUNTROWS, COUNT and DISTINCTCOUNT
- Table functions: FILTER, ALL and VALUES
- Testing your understanding over filter context with MAX and MIN
- CALCULATE: the most important function in DAX
- Filtering expressions with CALCULATE
- Operators “AND” and “OR” in CALCULATE
- Removing filter with ALL and ALLSELECTED
- Context Transition with CALCULATE
- Using measures to filter other measures in CALCULATE
- Calculating averages
- Using GIF and Emojis in segmentation
- Creating a dynamic segmentation
- Using variables and adjusting sort by
- Adjusting the total to be the sum of the values
- Enabling inactive relationships with USERELATIONSHIP
- Ranking functions (RANKX, TOPN)
- Common mistakes when authoring measures
- Solving Task 1 for the Mission
- Solving Task 2 for the Mission
- Solving Task 3 for the Mission
- Solving Task 4 for the Mission
- Solving Task 5 for the Mission
- Solving Task 6 for the Mission
- Download the final solution for the Mission
- Understanding this mission and downloading the data
- Disabling Auto Date/Time
- Time Intelligence: SAMEPERIODLASTYEAR and PREVIOUSYEAR
- Analyzing Year over Year – Part 1
- Analyzing Year over Year – Part 2
- Time Intelligence: DATEADD and PREVIOUSMONTH
- Time Intelligence: DATESYTD
- Cumulative calculation with CALCULATE + FILTER + ALL
- DATESBETWEEN and DATESINPERIOD functions
- Creating dynamic ranges
- Hiding future dates
- Creating an Income Statement (Profit and Loss Statement)
- Performing a Vertical Analysis in the PnL
- Performing a Horizontal Analysis in the PnL
- Conditional formatting with icons for HA
- Download the final solution for the Mission
- Understanding this mission
- Best practices for Data Storytelling
- Adding background to pages
- Customizing the theme and formatting visuals
- Changing the interaction between visuals
- Understanding Drill-down
- Conditional formatting
- Tooltip – Part 1
- Tooltip – Part 2
- Creating dynamic titles for visuals
- Inserting tooltip in the visual header
- Adding slicers for data segmentation
- Adding filters for visual level, page level, report level
- Applying TOP N to the filter pane
- Using measures to filter slicers
- Changing pages with buttons and images
- Bookmarks + Selection + Buttons – Part 1
- Bookmarks + Selection + Buttons – Part 2
- Drill-through: see detailed information
- Changing pages with slicers
- Decomposition Tree visual
- Key Influencers visual
- Automatic analysis: Anomaly Detection
- Automatic analysis: Explain Increase and Decrease
- Automatic analysis: Find where the distribution is different
- Advanced analysis: Forecasting, Trend and Clustering
- Importing custom visuals
- Mobile view
- Download the final solution for the Mission
- Understanding Power BI Service
- Publishing a report
- Creating Dashboards
- Insights, Alerts, Subscriptions and Comments
- Downloading PBIX, exporting to PowerPoint, PDF and Excel
- Power BI Licensing: Free x Pro x Premium
- Creating Workspaces
- How to share content?
- Sharing individual reports and dashboards
- Publishing an App
- Publishing reports to the web
- Sharing with external users in the organization (B2B)
- Applying static Row Level Security (RLS)
- Applying dynamic Row Level Security (RLS)
- Installing and configuring the Personal Gateway for automatic updates
- Installing and configuring the Enterprise Gateway for automatic updates
- Setting up a schedule refresh
- Why should I worry about this?
- What are dataflows?
- Creating dataflows to reuse data across different models
- Importing data from dataflows
- Certifying and promoting dataflows
- What are shared datasets?
- Certifying and promoting datasets
- Using shared datasets to create new reports
- Ideal architecture with dataflows and shared datasets
- Understanding this mission and downloading the data
- Installing SQL Server and Management Studio
- Restoring the backup database in SSMS
- Import x DirectQuery
- Importing database tables into Power BI
- Basic SQL language commands
- Creating queries for dimensions
- How to create dimensions from tables in Power Query
- Be careful when using queries inside Power BI
- Creating views in the database and importing into Power BI
- Creating a Data Warehouse with procedures
- Configuring jobs for updating DW
Some of the 23 dashboards you can download
These are extra solutions, besides the dashboards you build during the missions. You can download them and use them as a reference for your own work.
You get 23 more solutions. 13 of them were built by my best students in Brazil, for the same Heavy Power Nutrition project, so you can compare how different people solved the same problem. The others cover areas like Human Resources, Logistics, Finance and Production.
Do you know what a project like this is worth? A company like HPN would pay a BI consultancy more than US$ 20,000 to build it. Here, all 23 solutions are part of the US$ 9.
Use them to study, to get ideas and to start your own portfolio.
Stand out with the platform that leads the BI market
Join more than 35,000 students in the Xperiun ecosystem. Many of them are using this moment to grow their careers at big companies like 3M, BIC, Continental, Bridgestone, Suzano, CBF, ArcelorMittal and Nestlé, among hundreds of others.
Now look at the image on the right:
Join more than 35,000 students in the Xperiun ecosystem. Many of them are using this moment to grow their careers at big companies like 3M, BIC, Continental, Bridgestone, Suzano, CBF, ArcelorMittal and Nestlé, among hundreds of others.
Now look at the image below:
This is the Magic Quadrant for Analytics and Business Intelligence Platforms from Gartner, a global research company, as of February 2021. It compares the main BI platforms on the market. Microsoft is in the Leaders area, at the top right, ahead of all the other platforms.
When you learn Power BI, you learn the platform that leads this market. That gives you a strong advantage when you look for a job or new projects.
If I were you, I would use this moment to learn it. With 7 days to ask for your money back, your risk is low.
Meet your instructor:
Leonardo Karpinski
Microsoft Certified Trainer
Microsoft MVP (Most Valuable Professional)
Over 600 certified students
More than 100 companies attended in person
35,000+ students in Xperiun's ecosystem
Student satisfaction: 4.9 out of 5
Q&A
All lessons are recorded and online. You watch them whenever you want, as many times as you want, during your 1 year of access.
You have 1 year of access to everything.
If you do not like the course, you have 7 consecutive days from your purchase to cancel it. You get 100% of your money back, without any paperwork.
Yes. When you complete 100% of the course, you receive a digital certificate of completion, issued by me. I am a Microsoft Certified Trainer and a Microsoft MVP.
Yes. I teach you everything from zero, starting with how to install Power BI. If you already work with data in some way, or want to, the course starts exactly where you are.
Free videos are good for extra tips and tricks. But they do not teach you in the right order, and they do not teach the BI concepts behind each step. In this course, you learn inside one project, so each mission builds on the one before. For US$ 9, you also get the 23 dashboards, the community, the challenges and the certificate.
Instead of me talking about myself, look at what students say. Read the testimonials on this page again. More than 35,000 students have studied in the Xperiun ecosystem, and our average student rating is 4.9 stars out of 5.
Also look at the method. In this course, you solve one company's problems from start to finish, the way a BI consultant does. Xperiun also has a free YouTube channel, in Portuguese, with about 388,000 subscribers and more than 900 videos.
Any new skill takes some effort. Knowing this, I designed the course so you can finish the main part in about 20 days, studying around one hour a day.
After that, you can already use Power BI at work and build good quality reports. You still have the rest of your year of access to go deeper, watch the bonuses and practice with the challenges.
My goal is to take you from zero and support you all the way, so you get past each obstacle quickly.