Power BI for Business Analytics

Master Power BI, the leading business intelligence tool to transform, analyze and visualize data.

Enroll Now
play icon

Taught by Instructors with Experience At

Overview

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

Lifetime Access on Any Device

Student Profiles

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

Module 1: Course Introduction
  • Course Overview
  • What is Power BI
  • Download Power BI
  • Important Power BI Settings
  • Power BI Interface View Options
  • Course Resources: DAX Measures Glossary
Module 2: Importing & Transforming Data
  • 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
Module 3: Data Visualization
  • 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
Module 4: DAX: Data Analysis Expressions
  • 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
Module 5: Advanced DAX
  • Logic Functions & Operators
  • CALCULATE Function
  • CALCULATE with ALL & FILTER Functions
  • Related
  • Iterators
  • Switch
  • Text Functions
  • Date Functions
  • Time Intelligence Functions
  • Variables
Module 6: McDonald's Business Case Study
  • 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
Module 7: Nike Financial P&L Case Study
  • 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
Module 8: Sharing & Collaborating: Power BI Service
  • 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)
Module 9: Next Steps
  • Next Steps After Power BI
Get Certified!

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!

Get started
career principle certificate
Testimonials

What our students say

Real stories from real people

"Very thorough and comprehensive! The guidance I received from the senior instructors helps me in my everyday life as a financial analyst at Amazon."1

Well Done!

Isabella W.

The course was presented in a way that was easy to access and understand. What really stood out to me were the informative tools that were provided to help make my skills and work easier, more professional, and stand out from others. These tools were incredibly helpful and I was able to apply them to my work immediately.

Excellent Experience!

David Rodrigues

As an investment club president, I wholeheartedly recommend the Finance & Valuation Module for people who want to develop their technical finance skills. The digestible lessons, straightforward content, and hands-on walkthroughs helped our new members secure finance internships as freshmen.

Exceptional Training Solution!

Michael Penna

"The lessons are structured, clear, and concise. They even have downloadable files that you can practice on! When you complete the courses, you can add them easily to your LinkedIn and reap the benefits! In addition, the team is quick to respond and happy to help."

Extremely Impressed

Josh McDonald

"This course is the best. It's packed with informational and realistic examples. I love the downloads that are available for you to practice what's being taught. This course has really enhanced my skills."

The Best!

Jasmine Akujobi

Amazing course, with the essential things that you might need in future workplace + the case studies are really good to test yourself.

Amazing Course!

Erik Reznicek

"I took this course before starting my job as an investing banking analyst, not being from a hardcore finance background, this course helped in solidifying my basic concepts as well building real life excel skills that are required for my job."

Amazing, Detailed and Realistic!

Ishaan Mathur

"Kenji & Michael's teachings are practical and focus almost entirely on giving the student the tools to succeed in real life business and finance scenarios. After finishing the course, I feel like I am no longer missing out on something that is so essential for my career."

Highly Recommend!

Yakuphan Alptekin

"Semi-retired physician doing this for fun. Wish I had this knowledge in Med School as it would have been very valuable for expanding business knowledge and maybe entrepreneurship."

Very Valuable

Robert Remondino

"I've seen a lot of Excel courses out there, but this one is definitely the best. It covers a lot of topics and gives great explanations for all of them. Plus you get to do real-world exercises at the end to put into practice what you've learned. I highly recommend."

Great Explanations!

Jamie Forschner

Very creative and informative, and I enjoyed learning the course. They cover all the small detailed points and explain each small point with its relation to other points in all the lectures. This is done with high-quality resolution videos. Thank you and good luck to the Career Principles team!

Just What I was Looking For!

Rashed Al-Romaithi

I've taken multiple courses with Career Principles and some of them I'm still going through. The way the material is presented in each course has been clear and easy to understand with the many examples. The key to effective training is the real world application of key concepts and projects. In other words, how can this training be used in real world projects that you would need in your career. Thank You!

Thank you!

Keith Aul

"This course managed to reactivate the knowledge from my university studies 15 years ago and, above all, to translate it into a practical context. The Excel skills taught along the way are at least as valuable to me. Thank you Kenji & Team ."

Very, very helpful!

Marco Horn

"Very thorough and practical, definitely recommend for those who want to level up their Excel skills."

Excellent

Bilal Kamara

This is handy and good. I like the explanations and clarity when formulas and the theory around the formulas are explained. I also like the keyboard cheat sheet and the fact he uses the keyboard shortcuts in the videos.

I like this course and recommend it

Tom Munt-Davies

Yes, well done. Great job! Bring you step by step accross solving problems you usually find at work. With downloading file can practise at the same time and so easily memorize and get it. Thanks.

Great job!

Marco Franceschini

"Really enjoyed the practical case studies that made it feel like a real scenario I could encounter at work."

Super Helpful!

Isabella West

"This course has given me the opportunity to strengthen my accounting foundations, learn how to build a dynamic 3-statement model, conduct a complex DCF, Comps and Precedent Transactions valuation, and create a stock pitch deck to present to target clients."

Cheers!

Marvel Tanudjaja

"Clear explanation with concrete examples."

Clear Explanations!

Russell Tankoua

"It was a wise decision to purchase this course. As an analyst, I'm learning a lot and applying what I've learned to my current position."

Worth the Money!

Jamaal Tobias

"The course was extremely helpful, it has allowed me to build my Excel finance skills from the ground up, the course is perfect for anyone looking to strengthen their knowledge of Excel and finance. Amazing Work!"

A Very Complete Course!

Teo Ballbe

"The case studies are just perfect!"

Perfect!

Murilo Cangueiro

"The best Excel course. My Excel skills have improved significantly. Thank you guys for creating such a wonderful course."

Wonderful Course!

Ebenezer Anane

"The course delivered as promised. It had the right balance of theory and practical exercises with downloadable resources to further my learning. Great job!"

Awesome Course!

Andy Giro

"The senior instructors have really helped me develop the skills I needed to perform at the level of a finance professional. These practical skills have carried me a long way in my banking career!"

Just What I Needed!

Daniel Mwabila

"Very thorough and comprehensive! The guidance I received from the senior instructors helps me in my everyday life as a financial analyst at Amazon."

Well Done!

Tristan Chiu

The course was presented in a way that was easy to access and understand. What really stood out to me were the informative tools that were provided to help make my skills and work easier, more professional, and stand out from others. These tools were incredibly helpful and I was able to apply them to my work immediately.

Excellent Experience!

David Rodrigues

As an investment club president, I wholeheartedly recommend the Finance & Valuation Module for people who want to develop their technical finance skills. The digestible lessons, straightforward content, and hands-on walkthroughs helped our new members secure finance internships as freshmen.

Exceptional Training Solution!

Michael Penna

"The lessons are structured, clear, and concise. They even have downloadable files that you can practice on! When you complete the courses, you can add them easily to your LinkedIn and reap the benefits! In addition, the team is quick to respond and happy to help."

Extremely Impressed

Josh McDonald

"This course is the best. It's packed with informational and realistic examples. I love the downloads that are available for you to practice what's being taught. This course has really enhanced my skills."

The Best!

Jasmine Akujobi

Amazing course, with the essential things that you might need in future workplace + the case studies are really good to test yourself.

Amazing Course!

Erik Reznicek

"I took this course before starting my job as an investing banking analyst, not being from a hardcore finance background, this course helped in solidifying my basic concepts as well building real life excel skills that are required for my job."

Amazing, Detailed and Realistic!

Ishaan Mathur

"Kenji & Michael's teachings are practical and focus almost entirely on giving the student the tools to succeed in real life business and finance scenarios. After finishing the course, I feel like I am no longer missing out on something that is so essential for my career."

Highly Recommend!

Yakuphan Alptekin

"Semi-retired physician doing this for fun. Wish I had this knowledge in Med School as it would have been very valuable for expanding business knowledge and maybe entrepreneurship."

Very Valuable

Robert Remondino

"I've seen a lot of Excel courses out there, but this one is definitely the best. It covers a lot of topics and gives great explanations for all of them. Plus you get to do real-world exercises at the end to put into practice what you've learned. I highly recommend."

Great Explanations!

Jamie Forschner

Very creative and informative, and I enjoyed learning the course. They cover all the small detailed points and explain each small point with its relation to other points in all the lectures. This is done with high-quality resolution videos. Thank you and good luck to the Career Principles team!

Just What I was Looking For!

Rashed Al-Romaithi

I've taken multiple courses with Career Principles and some of them I'm still going through. The way the material is presented in each course has been clear and easy to understand with the many examples. The key to effective training is the real world application of key concepts and projects. In other words, how can this training be used in real world projects that you would need in your career. Thank You!

Thank you!

Keith Aul

"This course managed to reactivate the knowledge from my university studies 15 years ago and, above all, to translate it into a practical context. The Excel skills taught along the way are at least as valuable to me. Thank you Kenji & Team ."

Very, very helpful!

Marco Horn

"Very thorough and practical, definitely recommend for those who want to level up their Excel skills."

Excellent

Bilal Kamara

This is handy and good. I like the explanations and clarity when formulas and the theory around the formulas are explained. I also like the keyboard cheat sheet and the fact he uses the keyboard shortcuts in the videos.

I like this course and recommend it

Tom Munt-Davies

Yes, well done. Great job! Bring you step by step accross solving problems you usually find at work. With downloading file can practise at the same time and so easily memorize and get it. Thanks.

Great job!

Marco Franceschini

"Really enjoyed the practical case studies that made it feel like a real scenario I could encounter at work."

Super Helpful!

Isabella West

"This course has given me the opportunity to strengthen my accounting foundations, learn how to build a dynamic 3-statement model, conduct a complex DCF, Comps and Precedent Transactions valuation, and create a stock pitch deck to present to target clients."

Cheers!

Marvel Tanudjaja

"Clear explanation with concrete examples."

Clear Explanations!

Russell Tankoua

"It was a wise decision to purchase this course. As an analyst, I'm learning a lot and applying what I've learned to my current position."

Worth the Money!

Jamaal Tobias

"The course was extremely helpful, it has allowed me to build my Excel finance skills from the ground up, the course is perfect for anyone looking to strengthen their knowledge of Excel and finance. Amazing Work!"

A Very Complete Course!

Teo Ballbe

"The case studies are just perfect!"

Perfect!

Murilo Cangueiro

"The best Excel course. My Excel skills have improved significantly. Thank you guys for creating such a wonderful course."

Wonderful Course!

Ebenezer Anane

"The course delivered as promised. It had the right balance of theory and practical exercises with downloadable resources to further my learning. Great job!"

Awesome Course!

Andy Giro

"The senior instructors have really helped me develop the skills I needed to perform at the level of a finance professional. These practical skills have carried me a long way in my banking career!"

Just What I Needed!

Daniel Mwabila

"Very thorough and comprehensive! The guidance I received from the senior instructors helps me in my everyday life as a financial analyst at Amazon."

Well Done!

Tristan Chiu

The course was presented in a way that was easy to access and understand. What really stood out to me were the informative tools that were provided to help make my skills and work easier, more professional, and stand out from others. These tools were incredibly helpful and I was able to apply them to my work immediately.

Excellent Experience!

David Rodrigues

As an investment club president, I wholeheartedly recommend the Finance & Valuation Module for people who want to develop their technical finance skills. The digestible lessons, straightforward content, and hands-on walkthroughs helped our new members secure finance internships as freshmen.

Exceptional Training Solution!

Michael Penna

"The lessons are structured, clear, and concise. They even have downloadable files that you can practice on! When you complete the courses, you can add them easily to your LinkedIn and reap the benefits! In addition, the team is quick to respond and happy to help."

Extremely Impressed

Josh McDonald

"This course is the best. It's packed with informational and realistic examples. I love the downloads that are available for you to practice what's being taught. This course has really enhanced my skills."

The Best!

Jasmine Akujobi

Amazing course, with the essential things that you might need in future workplace + the case studies are really good to test yourself.

Amazing Course!

Erik Reznicek

"I took this course before starting my job as an investing banking analyst, not being from a hardcore finance background, this course helped in solidifying my basic concepts as well building real life excel skills that are required for my job."

Amazing, Detailed and Realistic!

Ishaan Mathur

"Kenji & Michael's teachings are practical and focus almost entirely on giving the student the tools to succeed in real life business and finance scenarios. After finishing the course, I feel like I am no longer missing out on something that is so essential for my career."

Highly Recommend!

Yakuphan Alptekin

"Semi-retired physician doing this for fun. Wish I had this knowledge in Med School as it would have been very valuable for expanding business knowledge and maybe entrepreneurship."

Very Valuable

Robert Remondino

"I've seen a lot of Excel courses out there, but this one is definitely the best. It covers a lot of topics and gives great explanations for all of them. Plus you get to do real-world exercises at the end to put into practice what you've learned. I highly recommend."

Great Explanations!

Jamie Forschner

Very creative and informative, and I enjoyed learning the course. They cover all the small detailed points and explain each small point with its relation to other points in all the lectures. This is done with high-quality resolution videos. Thank you and good luck to the Career Principles team!

Just What I was Looking For!

Rashed Al-Romaithi

I've taken multiple courses with Career Principles and some of them I'm still going through. The way the material is presented in each course has been clear and easy to understand with the many examples. The key to effective training is the real world application of key concepts and projects. In other words, how can this training be used in real world projects that you would need in your career. Thank You!

Thank you!

Keith Aul

"This course managed to reactivate the knowledge from my university studies 15 years ago and, above all, to translate it into a practical context. The Excel skills taught along the way are at least as valuable to me. Thank you Kenji & Team ."

Very, very helpful!

Marco Horn

"Very thorough and practical, definitely recommend for those who want to level up their Excel skills."

Excellent

Bilal Kamara

This is handy and good. I like the explanations and clarity when formulas and the theory around the formulas are explained. I also like the keyboard cheat sheet and the fact he uses the keyboard shortcuts in the videos.

I like this course and recommend it

Tom Munt-Davies

Yes, well done. Great job! Bring you step by step accross solving problems you usually find at work. With downloading file can practise at the same time and so easily memorize and get it. Thanks.

Great job!

Marco Franceschini

"Really enjoyed the practical case studies that made it feel like a real scenario I could encounter at work."

Super Helpful!

Isabella West

"This course has given me the opportunity to strengthen my accounting foundations, learn how to build a dynamic 3-statement model, conduct a complex DCF, Comps and Precedent Transactions valuation, and create a stock pitch deck to present to target clients."

Cheers!

Marvel Tanudjaja

"Clear explanation with concrete examples."

Clear Explanations!

Russell Tankoua

"It was a wise decision to purchase this course. As an analyst, I'm learning a lot and applying what I've learned to my current position."

Worth the Money!

Jamaal Tobias

"The course was extremely helpful, it has allowed me to build my Excel finance skills from the ground up, the course is perfect for anyone looking to strengthen their knowledge of Excel and finance. Amazing Work!"

A Very Complete Course!

Teo Ballbe

"The case studies are just perfect!"

Perfect!

Murilo Cangueiro

"The best Excel course. My Excel skills have improved significantly. Thank you guys for creating such a wonderful course."

Wonderful Course!

Ebenezer Anane

"The course delivered as promised. It had the right balance of theory and practical exercises with downloadable resources to further my learning. Great job!"

Awesome Course!

Andy Giro

"The senior instructors have really helped me develop the skills I needed to perform at the level of a finance professional. These practical skills have carried me a long way in my banking career!"

Just What I Needed!

Daniel Mwabila

"Very thorough and comprehensive! The guidance I received from the senior instructors helps me in my everyday life as a financial analyst at Amazon."

Well Done!

Tristan Chiu

Our Students Now Work At

Your instructors

instructor image
Kenji Farre
Senior Instructor

Hey there, Iā€™m Kenji, a Cornell University graduate and Microsoft MVP with work experience at companies like Amazon, Goldman Sachs, and PwC. Over the past year, our tutorials have helped 15M+ people level up their Excel, Business, and Data skills. I know exactly where the pain points are -Iā€™ve lived them myself. Looking forward to getting started!

instructor image
Michael Quach
Senior Instructor

Aloha! Iā€™m Michael, a Cornell University graduate born and raised in Honolulu, Hawaii. Iā€™ve worked at companies like Tesla, Cushman & Wakefield, and IHG Hotels & Resorts. Throughout, Iā€™ve experienced first-hand the importance of being proficient in Excel, finance, and valuation to perform in any business role. My hope is that our courses will help you take your career to the next level.

Course Pricing

Learn the skills you need to advance your career

Boost your productivity and gain confidence in your business and finance skills by selecting a course that works best for you.

Power BI for Business Analytics
Single Course
$179.00
Includes:
  • {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
Get started
Excel + Power BI for Business Analytics
Bundle
$279.00
Recommended
Includes:
  • {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

ā€

Get started

FAQs

Frequently Asked Questions

How long will this course take me to complete?

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.

Do you offer any corporate deals / bulk discounts?

Yes we do, please email us at info@careerprinciples.com with your details.

How is this course different to other Power BI courses?

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.

Do I need to pay for Power BI software?

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/

What level of Power BI do I need?

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!

Can I complete the course on a Mac?

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.

What are the pre-requisites for this Power BI course?

You donā€™t need any prior business or technical knowledge. All you need is a computer with Excel and Power BI.

How long will I have the course materials for?

You will have lifetime access to the lessons and materials. The course can be taken on both smartphone and computer.

More questions?

For any other general inquiries, please contact us at info@careerprinciples.com