Who it's For:

Business Analysts, Data Analysts, and everyone in between looking to take the next step in data processing and visualization.

What it is:

Power BI is Microsoft's business analytics platform. It's designed from the ground up to take mass sets of data and organize, analyze, and visualize it using live dashboards and interactive reports.

What You'll Learn:

In this series, users will be introduced to the foundational concepts of building queries and prepping data for analysis. Users will learn to build relationships across multiple databases using Power Pivot, all the while learning useful functions to help take data to the next level. Become familiar with building and navigating live dashboards and interactive reports, and much more.

Topics

Power BI Beginner - Part 1

• Introduction
• Downloading Software
• What is Power BI?
• Course Trajectory
• What is a Query or Power Query?
• Querying Data
• Query Excel Files
• Normalizing Concepts
• Appending Queries
• Querying Web Pages
• Merging Queries
• Normalizing Data
• Lab - Querying Data and Analyzing Results

Power BI Beginner - Part 2

• Limitations of Excel's Pivot Tables
• Introduction to Power BI Desktop
• Querying
• Creating Basic Visuals
• Customizing Basic Visuals
• Map Visuals
• Card Visuals
• Shapes and Text Boxes
• Slicers
• Gauge Visuals
• Lab - Creating Reports
• Lab - Walkthrough
• Conclusion