Power BI Advanced eLearning Course
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 Advanced - Part 1
- 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
Power BI Advanced - Part 2
- 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
This course has a minimum of 25 learner registrations for us to provide a quotation.
Request a Quotation- Language
- UK
- Date last updated
- 6/22/2018
- Duration
- 2 Hours 40 Minutes
- Suitable Devices
-
- PC
- Phone
- Tablet
- Audio is Required
-
- Yes
- Includes Video
-
- Yes
- Downloadable Resources
-
- Sample Files
- Completion Criteria
-
- Visit all pages
- Pass Mark
-
- None
- Course Technology
-
- HTML5
- SCORM 1.2
- Can be customised
-
- No
- Accreditation or Endorsements
-
- No
- Languages
-
- English