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.
Introduction
♦ 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.
Copyright © 2017 - Developed by Infihive Consulting Services LLC changes