Advanced Power BI Course
Online Power BI Class by Chandoo
Total Value: $399 ~ Your price: $299
Hello friends, readers & fans of Chandoo.org. It is my pleasure to invite you to the most comprehensive, practical and creative Power BI training program. Advanced Power BI Course by Chandoo
What is Power BI?
Considered to be one of the fastest growing technologies in the world of data, Power BI is an incredible software to collect data, model it, analyze it, visualize and publish your work – all with ridiculous ease. Think of Power BI as a natural extension to Excel based reporting with built-in capabilities to publish to mobile phones, web and everyone in your organization securely.
You can use Power BI to,
- Connect to any type of data source (Excel files, web pages, databases, cloud storage etc.)
- Bring and transform data (ETL processes with Power Query)
- Analyze it manually or with built-in Artificial Intelligence
- Calculate values from it using Power Pivot measures
- Visualize data
- Create reports and dashboards
- Publish and securely share your outputs with colleagues & clients
- Automatically refresh your work when there is change in data
What can Power BI do for me?
I won’t tease. Check out below report about a fictional coffee shop sales. It is live. Feel free to click, select and play with it. Isn’t it amazing? #AWESOME.
Tip: click on any bars to interact with the report.
Your coach - Chandoo
My name is Chandoo and I will be your coach in this Advanced Power BI Course. I have been training people on Power BI, Power Pivot, Power Query, Excel and analytics for over a decade. My teaching is practical and hands-on with several real world examples. I have taught more than 20,000 people to date (online and offline) and I would love to help you. I live in coastal city of Wellington in New Zealand with my beautiful wife and two kids.
6 reasons why...
- Step by step instruction
- 12+ hours video
- 6 case studies + 20 sample files
- Connect & transform with Power Query
- Model & measure with Power Pivot
- Interactive viz with Power BI
- 24x7 access
- Download HD videos
- Secure classroom
- 2 year access
- 14 day money-back guarantee
Power BI + Your Data = Beautiful
What is Adv. Power BI Course?
Adv. Power BI Course is an online training program to teach you how to use Power BI.
This program is completely online and self-paced. You can learn about Power BI from the comfort of your couch (or office chair). I take you from a Power BI beginner to pro by the end of this course.
In this program (12+ hours long), you will learn:
- Getting started with Power BI – Your first ever play
- Working with Power Query for data collection & processing
- Data from Excel / CSV
- Getting data from Web
- Automating with Power Query functions
- Transformations & splits
- Adding columns based on rules & M formulas
- Power Pivot & DAX
- Creating implicit measures
- Writing DAX formulas for explicit measures
- Measures & filter context
- Manipulating filter context with CALCULATE
- Using variables in DAX
- Time intelligence calculations
- Creating text messages with DAX
- Reports & Dashboards with Power BI
- Overview of Power BI visuals
- Visual interactions explained
- Filters
- Card visuals
- Tables & Matrices
- Slicers
- Maps
- Formatting charts & other visuals
- Conditional formatting
- Colorscales
- Databars
- Rule based CF logic
- Visual analytics
- Forecasting
- Symmetry shading
- Explain feature
- Q&A
- Publishing your reports
- Adding interactivity thru Bookmarks
- Drillthrough pages
- Tooltips
- What-if parameters
- Power BI online ecosystem
- Setting up mobile view
- Using AI visuals & insights
Be warned though. This is thoroughly awesome and intense course. Prepare for some serious exercise.
Detailed Topics of the Power BI Course
Power BI Course has 6 modules. Refer to below lesson plan to understand what you will be getting.
Module 1 – Getting started with Power BI
- Getting started with Power BI – 37 mins
- Deep-dive intro of Power BI – 28 mins
- Building a quick sales dashboard with Power BI – 25 mins
Module 2 – Data management with Power Query
- Getting external data in to Power BI – Demo with US Population data – 23 mins
- Working with Web data – Election results from web – 20 mins
- Automating queries with parameters & functions – 20 mins
Module 3 – Data Analysis with DAX & Power Pivot
- Case study – Employee data
- DAX 101 – 28 mins
- DAX 101 contd. – 27 mins
- Case study – SnackTime
- Data model & star schema – 20 mins
- DAX deepdive – 20 mins
- Power Pivot & DAX – writing 10 measures – 42 mins
- Time intelligence patterns in Power BI – 2 videos, 23 mins
Module 4 – Executive Dashboards with Power BI
- Retail Dashboard for SnackTime – 10 videos, 3hrs 15 mins
- Dashboard design
- Power Query transformations
- Data modeling
- DAX, time intelligence
- Report Tooltips
- Conditional formats
- Text commentary with DAX
- Budget vs. Actual dashboard for AppraisalOwls- 5 videos, 2hrs 2mins
- Dimensional modeling with Power Query
- Reference vs. Duplicate queries
- Generating calendar tables
- Data modeling with multiple fact tables
- Measure development
- Dashboard design and implementation
- BONUS: Executive Dashboard for StorageMart – 5 videos, 3hrs
- Part 1 – Report goals and design
- Part 2 – Data Modeling and Measures
- Part 3 – CEO View with KPIs & forecast
- Part 4 – CEO View contd
- Part 5 – CFO View with What-if analysis
Module 5 – Story telling with Power BI
- Employee Report – 18 mins
- Squirrels in Central Park – 20 mins
- London Population in 2050 – 20 mins
Module 6 – Visualization Tricks and Inspiration
- Report pages & drillthrough – 17 mins
- Bookmarks & interactive reporting – 14 mins
- Labeling last point with measures – 10 mins
- Dynamic titles with conditional formatting – 10 mins
- Variance Charts in Power BI – 10 mins
Testimonial from Lisa
Course Specifics
Who is this course for?
Let’s be honest. Power BI is awesome and all, but not everyone can hop on the bandwagon. It is suited for people like:
- Analyst of most kinds
- Business Intelligence Professional
- Report writers, story tellers
- Managers and executives who need to build reports
- Self-employed consultants
- Data People
What do you need?
This is a completely online, self-paced class. To get most out of it, you need:
- A computer with internet connection: for accessing the classroom, watching lesson videos and downloading files.
- Power BI Desktop software: This is freely downloadable from Microsoft Power BI website. Works on any Windows computer.
You do need below skills to successfully use Power BI:
- Decent understanding of business and reporting concepts (ie are you building some reports in Excel or other tools already?)
- Beginner to intermediate level of Excel (while you won’t be using Excel in Power BI, knowing things can simplify your work)
- Passion to learn new things (Power BI feels almost nothing like Excel)
If your Excel skills also need brushing, consider the Excel School program bundle option.
How does this work?
Power BI Course is an online class. Once you purchase the program,
- You will get an email with your login details for our classroom website.
- Login to the class and locate Power BI course lesson plan.
- Start watching lessons, one at a time.
- Each lesson can be viewed online or downloaded for offline viewing.
- Download example files and sample data for each lesson so you can practice the ideas.
- After watching a lesson, go ahead and practice for some time.
- Post any questions you may have in the classroom for clarifications.
- Continue with lesson plan & become awesome in Power BI 🙂
Enroll in Adv. Power BI Course
Adv. Power BI Course
Great for mastering Power BI-
6 Modules of Power BI classes
-
12+ Hours material
-
50+ Video lessons, 6 Case studies
-
20+ Example Power BI files
-
2 Years online access
-
Download HD quality videos
-
Bonus: Executive Dashboard - 3hrs
-
14 Day money back guarantee
Adv. Excel, Dashboards &
Power BI Combo
My best combo offer
-
6 Modules of Power BI classes
-
6 Modules of Adv. Excel Lessons
-
1 Module on Dashboards
-
45+ Hours material
-
100+ Video lessons, 12+ Case studies
-
70+ Example Excel / Power BI files
-
2 Years online access
-
Download HD quality videos
-
Bonus: Executive Dashboard - 3hrs
-
Bonus: Excel School bonuses
-
14 Day money back guarantee
Frequently Asked Questions
What version of Power BI do I need?
The course videos are recorded with a mix of October 2024 & slightly older versions. You can use any recent version of Power BI Desktop to enjoy the lessons. Please upgrade Power BI to latest version if possible.
Some of the bonus content & case studies use older version of Power BI, but this should not be a problem.
Do I need Power BI Service / Online account?
Power BI online account is not necessary to participate in the course. That said, if you have an account, you can upload the files / datasets there to experience the last leg of Power BI report distribution concepts.
You can also register for free Power BI online account from their website.
Is this a onetime payment?
Yes. Adv. Power BI course (or the combo option) is a one time payment program. There are no recurring charges.
Can I get team / group discount?
Yes, you can. You get 25% discount when enrolling a team of 3 or more people. To avail this, just change the quantity during checkout process.
If you want to enroll a large team (50 or more people), please email me at chandoo.d@gmail.com so I can help you.
Can I get a purchase receipt / invoice?
Yes you can. After your payment you will get it automatically.
If you need it in a specific format, please email chandoo.d@gmail.com with “invoice” in the subject.
We can also invoice you before purchase so you can make a payment against it. Please email.
I am a complete newbie for Power BI, can I join?
Yes, you can. This course is aimed at beginner / intermediate users of Power BI. The first module of the course (Getting Started with Power BI) will teach you everything you need to enjoy the course.
Can I get a course certificate?
Yes you will. After you finish watching all lessons, please email us for a completion certificate. You will more information in the classroom website.
My question is not listed here…
No problem. Just email me to get the answer.
Email: chandoo.d@gmail.com
Thank you...
Thank you so much for being a supporter and learner of Chandoo.org. You motivate me to constantly learn & share my knowledge with others. I am excited about the launch of improved Advanced Power BI course and couldn’t wait to help you master Power BI. Thank you for considering this program.
Thank you 🙏