Course Overview

Power BI is an analytics tool developed by Microsoft that turns your bits of unstructured data into a visually compelling story. It consists of the Power BI Desktop, the SaaS Power BI Service, and a range of mobile apps. Power BI users have a range of potential careers including data scientists, product managers, and business analysts. Understanding power query, the role played by data warehouses, and everything from Microsoft flow to self-service analytics makes knowledgable users valuable resources for a variety of organizations. Analysts use the robust platform to discover key insights that can change the course of a business or organization for the better.

Course Content:


♦ Getting Started

♦ Class Introduction (BI Basics)

♦ Class Introduction (Power BI Desktop Overview)

♦ Data Discovery with Power BI Desktop

♦ Transforming Data (Basic Transforms)

♦ Transforming Data (Add Column From Example)

♦ Transforming Data (Appending Queries)

♦ Transforming Data (Merging Queries)

♦ Transforming Data (Combine Files)

♦ Transforming Data (M Query Basics)

♦ Transforming Data (Parameters and Templates)

♦ Transforming Data (Other Query Features)

♦ Introduction to Modeling Data

♦ Creating the Data Model (Modeling Basics)

♦ Creating the Data Model (Model Enhancements)

♦ Creating the Data Model (What If Parameters)

♦ Creating Calculated Columns and Tables (DAX Basics)

♦ Creating Calculated Columns and Tables (Navigation Function)

♦ Creating Calculated Columns and Tables (Calculated Tables)

♦ Creating Calculated Measures (Measure Basics)

♦ Creating Calculated Measures (Time Intelligence Functions)

Introduction to Power BI Part 2

♦ Introduction to Visualizing Data

♦ Creating Basic Reports with the Power BI Desktop

♦ Creating Interactive Reports (Adding Slicers for Filters)

♦ Creating Interactive Reports (Visualizing Tabular Data)

♦ Creating Interactive Reports (Visualizing Categorical Data)

♦ Creating Interactive Reports (Visualizing Data Trends)

♦ Creating Interactive Reports (Visualizing Categorical and Trend Data Together)

♦ Creating Interactive Reports (Visualizing Geographical Data with Maps)

♦ Creating Interactive Reports (Visualizing Goal Tracking)

♦ Creating Interactive Reports (Using Custom Visuals)

♦ Creating Interactive Reports (Digital Storytelling)

♦ Creating Interactive Reports (Other Features)

♦ Using the Power BI Service (Deploying to the Power BI Service)

♦ Using the Power BI Service (Creating and Sharing Dashboards)

♦ Using the Power BI Service (Using Power BI Q&A)

♦ Using the Power BI Service (Setting up App Workspaces)

♦ Using the Power BI Service (Subscriptions and Alerts)

♦ Using the Power BI Service (Excel Integration)

♦ Using the Power BI Service (Export and Embed Options)

♦ Refreshing the Data (Refreshing Data Overview)

♦ Refreshing the Data (Installing the Data Gateway)

♦ Refreshing the Data (Scheduling a Data Refresh)

♦ Mobile BI (Power BI Mobile Overview)

♦ Mobile BI (Designing Reports and Dashboards for Mobile)

♦ Mobile BI (Interacting with the Power BI Mobile App)

Introduction to DAX

♦ Getting Started

♦ Data Modeling Basics (Overview)

♦ Data Modeling Basics (Tabular)

♦ What is DAX (Overview)

♦ What is DAX (Tabular)

♦ Creating Calculated Columns (Basics)

♦ Creating Calculated Columns (Basics Continued)

♦ Navigation Functions

♦ Conditional and Logical Functions

♦ Creating Calculated Measures

♦ Time Intelligence (Overview)

♦ Time Intelligence (Time Intelligence Functions)

♦ Using X-Functions and A-Functions

♦ Table Functions

♦ DAX as a Query Language

Advanced DAX

♦ Class Introduction (Class Files)

♦ Class Introduction (Why Advanced DAX)

♦ Working with Variables

♦ Working with Filter Context (What is Filter Context?)

♦ Working with Filter Context (CALCULATE)

♦ Working with Filter Context (Overriding Filter Context)

♦ Working with Filter Context (FILTER)

♦ Working with Filter Context (FILTER and ALL)

♦ Working with Filter Context (ALL EXCEPT)

♦ Working with Filter Context (Totals)

♦ CALCULATE and Time Intelligence (YTD and MTD)

♦ CALCULATE and Time Intelligence (Rolling 12 Months Total)

♦ CALCULATE and Time Intelligence (Rolling 3 Month Average Total)

♦ Semi-Additive Measures (Overview)

♦ Semi-Additive Measures (Opening and Closing Balance)

♦ Row Context (Understanding Row Context and Context Transition)

♦ Row Context (Working with Iterator Functions)

♦ Nested Row Context

♦ Error Handling

♦ Security (Implementing Basic Security)

♦ Security (Dynamic Security)

♦ Security (Implementing Basic Security – Tabular)

♦ Security (Dynamic Security – Tabular)

♦ Role-Playing Dimensions (Multiple Table Import)

♦ Role-Playing Dimensions (USERELATIONSHIP)

♦ Advanced DAX Function (CONTAINS)

♦ Advanced DAX Function (FIND)

♦ Advanced DAX Function (SEARCH and SUBSTITUTE)

♦ Advanced DAX Function (ALL SELECTED)

♦ Advanced DAX Function (RANKX)

Power BI Report Server

♦ Class Introduction

♦ Getting Started (Power BI Desktop)

♦ Getting Started (Licensing)

♦ Installation

♦ Configuration

♦ Deployment (Publish to Report Server)

♦ Deployment (Uploading from Report Server)

♦ Deployment (Folder Structure)

♦ Scheduling a Data Refresh

♦ Security (Row Level Security)

♦ Security (Assigning Power BI Report Permissions)

We can assure a 100% job guarantee and Placement. Contact us for Free - Demo.

Quick Enroll