Advanced Microsoft Power BI

Business Intelligence /Analytics is in high demand and companies are using data to make key business decisions. Power BI is a powerful (but easy to use) self service business analytics / business intelligence solution provided by Microsoft. This course is intended for students with a foundational understanding of Power BI fundamentals. In this class, we will build on the knowledge and instruction set forth in our Fundamentals of Power BI class and we will provide a deeper dive into extracting/transforming from various data sources, tabular data modelling, DAX, creating visualizations, Flow, mapping, the Power BI Service, and the Power BI Mobile App. In this 2-day class, you will learn how to import data from various sources, compose advanced formulas, manage the fields and columns in tables, use X-factor functions, use conditional statements, filter results, design charts, work with calculations, leverage the DAX language, create advanced queries, improve the querying process, and more.

Retail Price: $800.00

Next Date: 01/27/2020

Course Days: 2


Enroll in Next Date

Request Custom Course


About this Course

Business Intelligence /Analytics is in high demand and companies are using data to make key business decisions.  Power BI is a powerful (but easy to use) self service business analytics / business intelligence solution provided by Microsoft.  This course is intended for students with a foundational understanding of Power BI fundamentals.  In this class, we will build on the knowledge and instruction set forth in our Fundamentals of Power BI class and we will provide a deeper dive into extracting/transforming from various data sources, tabular data modelling, DAX, creating visualizations, Flow, mapping, the Power BI Service, and the Power BI Mobile App.

 

In this 2-day class, you will learn how to import data from various sources, compose advanced formulas, manage the fields and columns in tables, use X-factor functions, use conditional statements, filter results, design charts, work with calculations, leverage the DAX language, create advanced queries, improve the querying process, and more. 


Day 1

  • Importing Data to Power BI
  • Conditional Formatting
  • Custom Calendar functions
  • Data Modeling
  • Managing Data
  • Visualizations and Reports
  • Working with Dax
  • Embedding Power BI in SharePoint
  • Advanced DAX Functions
  • Using Power Query to do Complex Table Joins
  • Using Media Tiles in Dashboards

 

 

Day 2

  • Generating Analytics from Power BI Datasets
  • Creating Custom Templates and Content Packs
  • Automating PowerBI
  • Programmatic Interfacing w/ PowerBI
  • Generating Analytics from Power BI Datasets
  • Creating Custom Templates and Content Packs
  • Custom Maps
  • Integrating Power BI with MS Flow
  • Power BI Administration and Security
Course Dates Course Times (EST) Delivery Mode GTR
1/27/2020 - 1/28/2020 9:00 AM - 5:00 PM Instructor Live and Virtual Enroll