EXCEL DASHBOARD & POWER BI
Introducing...
40+ Lessons, Step-by-step Exercises, 4 hours of video lessons
To Help you Thrive in the Most Prestigious Jobs on Wall Street...
HERE’S JUST SOME OF WHAT YOU’LL GET IN THIS COURSE
Introduction and Setup (6 video lessons)
In this module, we use 6 video lessons to explain the key components and best practices when creating an Excel dashboard. This includes a step-by-step walkthrough of a company sales dataset and an explanation of important metrics pertinent to our case study.
KPI Squares and Speedometer Charts (7 video lessons)
In this module, we use 7 video lessons to provide a walkthrough on how to modify our dataset to create several key charts and indicators in our Excel dashboard. We wrap up this module by exploring Combo Charts, an efficient and dynamic way of comparing data.
Using COUNTIF and Dynamic Charts (6 video lessons)
In this module, we use 8 video lessons to expand upon the charts we created in previous modules by adding Dynamic Charts and Net Promoter Score (among other topics). This module also includes a tutorial on how we can use dynamic coding to make our data malleable and conditional formatting to provide visually appealing dashboards.
Drawing Conclusions (2 video lessons)
In this module, we use 2 video lessons to tie together the different charts we have created in previous modules, using the dashboard to provide conclusive data that can be presented. We wrap things up by offering several tips to continue improving on your Excel Dashboards.
Power BI Overview (5 video lessons)
In this module, we use 5 video lessons to dive into Power BI, a tool that provides additional customization and filters that are not available in Excel. This includes a brief overview of Power BI functionality, customizable slicers, and automatable data linking and sorting.
Basic Charts (5 video lessons)
In this module, we use 5 video lessons to explore column charts, pie charts, and bar charts and how to fully use Power BI to create dynamic visualizations. We wrap up this module by learning how to use slicers to control interactions between different charts.
Advanced Visualizations (7 video lessons)
In this module, we use 7 video lessons to dive deeper into more advanced visualizations such as Filled Map Visualizations, Scatter Plots, and Funnel Charts. This module also includes a step-by-step walkthrough on how to create these visualizations.
Power BI Online (2 video lessons)
In this module, we use 2 video lessons to explore the special features of Power BI online such as interconnectivity with clients. We wrap up this module by exploring insights and correlations that Power BI is able to autonomously generate using your data.
WSO Excel Dashboards & Power BI Course - Video Preview
Course Summary - Table of Contents
Below you will find a list of the modules and lessons included in this course.
- Dashboards Intro (2 Min)
- Key Components of a Dashboard (7 Min)
- Introducing the Case Study pt. I (4 Min)
- Introducing the Case Study pt. II (6 Min)
- Setting up our Data pt. I (8 Min)
- Setting up our Data pt. II (8 Min)
- Creating KPI Squares pt. I (9 Min)
- Creating KPI Squares pt. II (9 Min)
- Creating KPI Squares pt. III (2 Min)
- Creating a Speedometer Chart pt. I (7 Min)
- Creating a Speedometer Chart pt. II (7 Min)
- Creating a Speedometer Chart pt. III (5 Min)
- Creating a Combo Chart (9 Min)
- Comparing CY vs. PY sales pt. I (8 Min)
- Comparing CY vs. PY sales pt. II (4 Min)
- Creating a Dynamic Chart with a Spin Button pt. I (5 Min)
- Creating a Dynamic Chart with a Spin Button pt. II (7 Min)
- Using COUNTIFS and Recommended Charts pt. I (6 Min)
- Using COUNTIFS and Recommended Charts pt. II (5 Min)
- Drawing Conclusions from out Data pt. I (9 Min)
- Drawing Conclusions from our Data pt. II (6 Min)
- Downloading Power BI (2 Min)
- Overview of the Power BI visualizations (8 Min)
- Overview of Power BI (4 Min)
- Importing Data into Power BI (3 Min)
- Connecting and Updating our Data Sources (8 Min)
- Creating a Column Chart (6 Min)
- Formatting Data in Power BI (3 Min)
- Creating a Pie Chart (3 Min)
- Creating a Bar Chart and Slicer (7 Min)
- Editing the Interaction between Charts (3 Min)
- Creating a Filled Map Visualization (6 Min)
- Creating a Scatter Plot (6 Min)
- Creating a Speedometer Chart (4 Min)
- Creating a Funnel Chart (3 Min)
- Creating KPI Squares (4 Min)
- Creating a Combo Chart with a Custom Calculation pt. I (7 Min)
- Creating a Combo Chart with a Custom Calculation pt. II (4 Min)
- Creating a Dashboard on the BI Cloud (6 Min)
- Gaining Greater Insights into our Data (4 Min)
- Dashboards Outro (3 Min)
Our students have landed and thrived at positions across all top Wall Street firms, including:
Don’t Take Our Word For It
Hear from a few of our 57,000+ students...
[Testimonials to Come! New Course...]
Hear from a few of our 57,000+ students...
[Testimonials to Come! New Course...]
Get the Excel Dashboards & Power BI Course Certification
After completing the course, all students will be granted the WSO Excel Dashboards and Power BI Certification. Use this certificate as a signal to employers that you have the technical Excel and Power BI skills to immediately add value to your team.
Demonstrate that you have put in the work outside of university courses to make yourself more efficient and master the most critical program for success in finance careers. Easily share to LinkedIn and other social media sites to highlight your skills and strengthen your profile as a candidate.
How Much is Your
Finance Career Worth?
What You Get | Value |
|---|---|
WSO Excel Dashboards & Power BI Course 40+ video lessons across 9 Modules taught by an expert Big 4 Auditor with a CPA... | $500 |
Comprehensive Capstone Case Study Gain realistic practice drilling the concepts taught in the course so that you can apply them to the real world. | $450 |
24 Months of Unlimited Elite Support from Actual Finance Pros Have a technical question? Easily drop a comment into any lesson and get a response from a pro within 48hrs. | $300 |
6 Months of FREE Access to Macabacus Full access to this Excel plug-in that makes financial modeling even easier, including tools for PowerPoint and Word. | $120 |
TOTAL VALUE | $1,370 |
Get Unlimited Lifetime Access To The WSO Excel Dashboards & Power BI Course For 93% Off
$1,370
$97
...or get access today for only $37
Secure checkout
100% Unconditional Money-Back Guarantee
12 Month Risk-Free Guarantee
Your investment is protected by our 12-Month Risk-Free Guarantee. If, for any reason, you don't think the WSO Excel Dashboards & Power BI is right for you, just send us an email, and we'll refund every penny. No questions asked. In short, you get a great return on your investment, or you get your money back. It's that simple.