Excel Dashboards + Power BI

6.0 CPEComputer Software & Applications

Learn to create beautiful, powerful and dynamic dashboards in Excel and Power Bi. Microsoft’s free and extremely powerful business intelligence tool.

VIDEO COURSE

This course is free

Create a free account to enroll and earn CPE. No credit card required.

Create free account Already enrolled? Sign in to continue

About this course

Want to be the team rockstar? Learn to create dashboards! Dashboards are interactive tools that provide insights and analyses to users. This course will quickly teach you how to create amazing dashboards in Excel and Microsoft Power BI.

After learning dashboard fundamentals in Excel, we’ll supercharge your skills by teaching you Power BI. Power BI is Microsoft’s free business intelligence tool that allows you to easily create interactive and powerful dashboards.

At completion, you’ll know how to make dynamic dashboards in both Excel and Power BI.

What you’ll learn

Upon completion of this course, you will be able to:

Dashboard Fundamentals: Understand what makes an effective dashboard by focusing on key performance indicators (KPIs) such as sales, gross profit, and gross margin.
Excel Dashboard Creation: Learn to build insightful Excel dashboards from scratch using real-world sales data.
Power BI Essentials: Transition your Excel dashboard skills to Power BI, Microsoft's powerful business intelligence tool, to unlock deeper insights.
Dynamic and Interactive Visualizations: Create dashboards that are both visually appealing and interactive, allowing users to explore data intuitively.
Data Preparation Techniques: Discover methods for preparing, manipulating, and optimizing data to build robust dashboards.

Course content

7 lessons · 48 steps · 3h 43m of video

01LESSON 1Welcome2 items

02LESSON 2Introduction to Dashboards and to the Case Study6 items

03LESSON 3Creating a Dynamic Excel Dashboard pt. I8 items

04LESSON 4Creating a Dynamic Excel Dashboard pt. II9 items

05LESSON 5Analyzing Our Data Using Microsoft Power BI pt. I11 items

06LESSON 6Analyzing Our Data Using Microsoft Power BI pt. II10 items

07LESSON 7Conclusion1 item

Locked

Final assessment

Course access is required to take this assessment.

21 questions70% to passUnlimited attempts

On course completion: 6.0 CPE and a certificate

Course details

CPE: 6.0
Field of study: Computer Software & Applications
Course level: Not specified
Delivery method: QAS™ Self Study
Prerequisites: You should have an intermediate knowledge of Excel (e.g. IF statements, VLOOKUP, COUNTIFS, etc.).<strong> If you are not comfortable with Excel, we recommend taking our <a href="https://wisdify.com/bootcamps/free-online-excel-course-cpe/">Microsoft Excel Bootcamp</a>.</strong>
Advance preparation: Not specified
Course content: 7 lessons · 48 steps
Assessment: Final assessment · 21 questions · pass 70%
Completion deadline: 365 days from enrollment
Last updated: August 2017
Registration: A free Wisdify account and course enrollment are required.