Summer Sale! 20% OFF Sitewide 🔥
Don't miss out on this limited-time offer!
00
Days
00
Hours
00
Minutes
00
seconds
Claim Now

Power BI for Business Analytics

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

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

Please note Power BI only works on a Windows OS

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!

career principle certificate
Testimonials

What our students say

This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.

Our Students Now Work At

Instructors

Meet Your Instructors

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!

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

Select the course or bundle that works best for you

Power BI for Business Analytics
Single Course
Was:
$179.00
$143.20
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
Was:
$279.00
$223.20
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
No items found.

FAQs

Frequently Asked Questions

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.

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.

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!

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