Power BI

This course is included (as well as over 200 others) in every subscription!
Description
Materials

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.

Power BI Beginner

Sign up to view this video Video Description
  • 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
  • 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
 

Power BI Intermediate

Sign up to view this video Video Description
  • Introduction
  • Opening Power Pivot
  • Importing from Access
  • Save and Save Often
  • Importing from Excel
  • Creating Power Pivot Tables
  • Creating Relationships
  • Calculated Columns
  • Basic Measures
  • DAX & Derived Measures
  • CALCULATE
  • Lab - Creating Measures
  • Importing Excel Data Model into Power BI
  • Measures in Power BI
  • Visualizing Measures
  • Creating Calendar Tables
  • Save and Save Often
  • Sorting by Column
  • Drilling Down
  • Lab - Creating Analysis Reports
  • Publishing to Power BI Online
  • Creating Dashboards
  • Sharing Dashboards
  • Q&A
  • Conclusion
 

Power BI Advanced

Sign up to view this video Video Description
  • Introduction
  • Querying SharePoint Lists
  • Unpivot Columns
  • Copying and Pasting M Script
  • M Language Basics
  • Creating a Calendar Table with List.Dates
  • Adding Metadata with M Functions
  • Reusing Calendar M Script in Excel
  • Custom Query Functions
  • DATESYTD, DATESMTD, DATEADD, and DATESBETWEEN
  • Complicated Relationships
  • Granularity Discrepencies
  • Inactive Relationships
  • Many to Many
  • Filter Context Flows Downstream
  • Order of Operations
  • ALL to Clear Structural Filters
  • ALL - Choosing the Right Table
  • FILTER
  • Disconnected Tables
  • Lab Results
  • Disconnected Visuals
  • Row Level Security
  • Custom Visuals
  • Republish Dashboard
  • Excel Objects in Power BI Online
  • Designing for Mobile
  • Using the Power BI Mobile App
  • Alerts
  • Conclusion
 
Exercise Files Are Available

Related Courses

Why Choose Anytime

Over 450,000 students since 1996

Over 20 years teaching software to industry leaders

100% 7-day money back guarantee

Feel secure: Ask a teacher if you have questions

Classroom Training available in Downtown San Francisco - 33 New Montgomery, SF CA 94102