Power BI for Business Analytics
Master Power BI, the leading business intelligence tool to transform, analyze and visualize data.
Taught by Instructors with Experience At
What you’ll learn
This course will teach you how to efficiently transform raw business data into beautiful and dynamic dashboards on Power BI. We’ll start with the basics, and gradually progress through more advanced modules covering Power Query transformations, data pivots, merging queries, DAX measures, calculated columns, and more. Course modules will frequently introduce practical exercises in the form of built-from-scratch reports and dashboards designed to help you visualize meaningful insights with complex data.
90+ High Quality Lessons
Downloadable Power BI, Excel, and PDF Files
Two Built-From-Scratch Sales and Finance Dashboards
Please note Power BI only works on a Windows OS
Who are these courses for?
University Students
If you're a college student looking to secure an internship or full-time job in a top tier business, finance, or investment firm, these courses are for you.
Working Professionals
If you're a working professional looking to level up your technical career skills, these courses are for you.
Career Switchers
If you're looking to boost your technical skills to better your chances of switching into a business or finance role, this course is for you.
Create stunning business reports and dashboards
Compile dynamic charts, slicers, matrices, and other visuals to make practical data-backed reports and visuals. This includes regional sales diagrams, an interactive finance dashboard, dynamic map charts, and other key visuals applicable to core business operations analysis.
Learn to use essential data transformation tools and formulas
Write fundamental DAX formulas to create essential measures and calculated columns needed to manipulate data and automate key calculations. Students can use this course to gain practical DAX writing experience that can elevate any resume or CV.
Practical lessons designed for your business career
Our courses are specifically tailored to current or aspiring professionals in corporate business, finance, or investment-oriented roles. We’ve designed the course curriculum to match the demand from Fortune 500 companies seeking data-oriented employees with technical skillsets.
Course Curriculum
- Course Overview
- What is Power BI
- Download Power BI
- Important Power BI Settings
- Power BI Interface View Options
- Course Resources: DAX Measures Glossary
- Importing Data (SQL, Excel, Web, etc.)
- Introduction to the Power Query Editor
- Basic Transformations in Power Query
- Text Tools & Functions
- Numerical Values
- Date & Time Tools
- Grouping
- Pivot & Unpivot
- Relationships
- Merge Queries
- Append Queries
- File Path Error
- Case Study: Data Cleaning
- Report View
- Dashboard Setup
- Inserting Elements
- Creating Charts & Visuals
- Adding Forecasts & Analytics
- Creating Maps
- Conditional Formatting
- Creating Tables & Matrices
- KPI Cards
- Slicers
- Filters
- Case Study: Create a Beautiful Dashboard
- Introduction to Measures and Calculated Columns
- Data Overview and Upload
- Creating Calculated Columns
- Creating Measures
- Measure Tools: Naming & Formatting
- DAX Syntax & Other Measures
- Applying Other Measures
- Intermediate Measures
- Adding Comments & Quick Measures
- Logic Functions & Operators
- CALCULATE Function
- CALCULATE with ALL & FILTER Functions
- Related
- Iterators
- Switch
- Text Functions
- Date Functions
- Time Intelligence Functions
- Variables
- Case Study Instructions
- Data Cleaning
- Relationships
- Report Formatting
- Slicers & KPIs
- Area and Pie Charts
- Country Breakdown Table
- Map Chart
- Manager Demographics
- Grouping Age Brackets
- Case Study Conclusion
- Case Study Introduction
- Data Overview
- Cleaning and Importing Data
- Base P&L Statement Setup
- SELECTEDVALUE Function
- P&L Base Values and Subtotals
- P&L Subpercentages
- ISFILTERED & ISBLANK Function
- P&L Subcategory Line Items
- FORMAT Function
- P&L Formatting Fix
- Base Colors Setup
- Stacked Column Chart
- Regional Doughnut Chart
- KPI Cards
- Dashboard Slicer & Title
- Power BI Service - Workspaces Overview
- Publishing Desktop Power BI into Online Power BI Service
- Report View on Power BI Service
- Datasets on Power BI Service
- Dashboards on Power BI Service
- Share a Web URL Power BI Report
- Power BI Mobile Optimization
- Report Export Options (Excel, PowerPoint, PDF)
- Commenting
- Share Feature (Power BI Pro)
- Next Steps After Power BI
Impress recruiters with your resume
Upon completion of all course lessons, you will receive a digital certificate with your credentials. Furthermore, you can add it to your LinkedIn to show your skills to recruiters!
What our students say
Thank you, so much.
Katia Rues
Great course!
Cristine Ramos
Definitely recommend it!
Arif Rashid
Great course
Tim Lorentz
Great stuff!
David H
Excellent Learning Experience
Dinah Fojas
Well Organized
Hyascar Jesus Vargas Zelada
Thank you
Evelyn Tah
I like this course and recommend it
Tom Munt-Davies
Very well structured course
Will
Awesome Course!
Andy Giro
Recommend to those in finance
Aditiya Kusuma
Great Content!
Naseef Kamal
Amazing Course!
Erik Reznicek
Exceptional Training Solution!
Michael Penna
Excellent Experience!
David Rodrigues
Excellent
Bilal Kamara
This course is worth it!
Selasi Kwame
Awesome learning Power BI
Jim Brooks
Just What I Needed!
Daniel Mwabila
Top Experience
Guillem Bigordà Freixas
Extremely Impressed
Josh McDonald
Pretty Good
Raghav Wasan
Clear Explanations!
Russell Tankoua
Great job!
Marco Franceschini
Superb Work
Johnny Chowdhury
The Best!
Jasmine Akujobi
I love that it's interactive
Ashley Thompson
Highly Recommend
J Lee
I do recommend it!
Vladimir Sobur
Awesome Practice
Rupali Kapadia
Well Done!
Tristan Chiu
Great Course on SQL
K R
A Very Complete Course!
Teo Ballbe
I grow tremendously
Antonio Newman
Learned a lot
Hai Nguyen
Enjoying it!
Yuling Zheng
Clear, concise instruction
Matt Pounch
Exceeded my expectations
Khin Yaminn
Very detailed
Steven Huang
Keep up the good work!
Jennifer Ng
Perfect!
Murilo Cangueiro
Exceptionally Helpful
Garay
Makes sense!
Ikmareka Hunt
Easy to follow
Michael Dos Santos
Wonderful Course!
Ebenezer Anane
I LOVE THE TRAINING PROGRAM
George Taylor
Outstanding!
Linda Fligg
Cheers!
Marvel Tanudjaja
Well paced
Reeta Sooknah
Very Valuable
Robert Remondino
Wise Decision to Purchase
Jamaal T
Thoroughly Enjoyed Power BI
Selina Chee
Worth the Money!
Jamaal Tobias
Engaging
Justin Risin
Just What I was Looking For!
Rashed Al-Romaithi
I cannot recommend their courses highly enough!
Justin Galczynski
Informative
Tam Tran
Super Helpful!
Isabella West
Excellent
Joseph Daher
Thank you!
Keith Aul
Amazing, Detailed and Realistic!
Ishaan Mathur
Highly Recommend!
Yakuphan Alptekin
Great Explanations!
Jamie Forschner
Beginner friendly
Julian Mascio
Worth Every Penny
Molly Dadzie
Very, very helpful!
Marco Horn
Our Students Now Work At
Meet Your Instructors
Kenji Farre
Michael Quach
Learn the skills you need to advance your career
Select the course or bundle that works best for you
- {yes} Access to Full Power BI Curriculum
- {yes} Power BI Course Completion Certificate
- {yes} Power BI DAX Measures Cheat Sheet
- {yes} Downloadable Start & End Files
- {yes} Business Case Study: McDonald's Data Visualization Report
- {yes} Finance Case Study: Nike P&L Dashboard
- {no} Access to Full Excel Curriculum
- {no} Excel Course Completion Certificate
- {no} Case Study: Excel Interview Test
- {no} Case Study: Excel Interactive Dashboard
- {yes} Access to Full Power BI Curriculum
- {yes} Power BI Course Completion Certificate
- {yes} Power BI DAX Measures Cheat Sheet
- {yes} Downloadable Start & End Files
- {yes} Business Case Study: McDonald's Data Visualization Report
- {yes} Finance Case Study: Nike P&L Dashboard
- {yes} Access to Full Excel Curriculum
- {yes} Excel Course Completion Certificate
- {yes} Case Study: Excel Interview Test
- {yes} Case Study: Excel Interactive Dashboard
FAQs
Frequently Asked Questions
Unfortunately Power BI does not directly support Mac devices. However, there are some workarounds where Mac users can consider running Power BI on a virtual Windows machine or installing Windows software on a Mac via Boot Camp.
The course is designed for students to complete around 2 modules per week, for a total of 4-5 weeks until course completion. However, the course can be completed at your own pace (faster or slower) and you'll have unlimited access to the materials.
We have designed this course specifically for corporate business roles by using our internship and full-time experience at top-tier companies such as Tesla, Amazon, and Goldman Sachs. Other courses tend to fill their curriculums with theoretical and unrealistic work examples that don’t consider important real-world business factors. With this in mind, we’ve created our lessons in the course using real-life examples with our McDonald’s Sales Report and Nike P&L Finance Dashboard. We also include an interactive discussion forum to help students with additional inquiries.
Nope. You can complete the entire course using Microsoft’s FREE Power BI Desktop App. You can download the app by searching for it in your computer’s Microsoft Store or by going to https://powerbi.microsoft.com/downloads/
The course is designed for all levels of Power BI users. Whether you're a complete beginner or an experienced user, there's something to be learned for everyone!
Yes, this course is accredited by the CPD Certification Service. Career Principles is a certified CPD member.
You don’t need any prior business or technical knowledge. All you need is a computer with Excel and Power BI.
You will have lifetime access to the lessons and materials. The course can be taken on both smartphone and computer.
For any other general inquiries, please contact us at info@careerprinciples.com