Power BI Training workshop

Microsoft Power BI course is designed for Microsoft Excel power users, who are ever trying to dig out insights from ever-growing piles of data. Microsoft Excel has been an evergreen tool For Data Analysis; Data Management is now more powerful with its office365 suite power Bi, which helps users do data discovery, data visualization, and collaboration. Technovids Microsoft Power BI Classes includes extensive hands-on power BI suite training on Power Pivot, Power Query, Power View, and Power Maps.

We will rapidly learn the essentials and some advanced Microsoft Power BI techniques to model transform and examine business information with Power BI Desktop. Strategies and best practices presented are from several workshops and years of field experience. Participants will learn to utilize self-service and enterprise-scale Power BI capacities that gain valuable skills to incorporate, shape, wrangle and visualize data for analysis. This workshop is the best way to learn about Microsoft Power BI and technologies and puts the participant in the driver’s seat.

Microsoft Power BI Workshop, we will rapidly learn the essentials and some advanced techniques to model transform and examine business information with Power BI Desktop.

Our four-day Power BI workshop includes hands-on training on Power Pivot, Power Query, Power View, and Power Maps (individual components of Power BI inside Excel). This workshop is the fastest way to learn about Microsoft Power BI technologies and puts the participant in the driver’s seat.

Workshop Agenda
After completing the Power BI course, participants will be able to:

Understand Analytics and Business Intelligence

• Create reports and Dashboards.
• Make use of self-service BI.
• Understand and use the Power BI suite of products.
• Connect to various data sources and optimize data models.
• Extract and Combine data from different sources.
• Apply required Transformations to source data
• Model data and specifically Dimension model (Star Schema)
• Connect to data sources using the Power BI service.
• Data gateway set up and Schedule refresh data
• Share, Subscribe and Publish the reports/dashboards
• Understand Power BI mobile app.

This module introduces participants to the concepts that comprise BI. Will be able to explore scenarios for using BI and how current trends affect the use of BI, along with project roles and data models.

Introduction to business intelligence

• Introduction to data analysis
• Introduction to data visualization
• Overview of self-service BI
• Considerations for self-service

This module will walk through the fundamental concepts of BI and Power BI Desktop. Participants will gain knowledge of query and file operations. Participants will learn how to connect multiple data sources to this tool and other concepts including tables, columns, and measures.

• Power BI Desktop Installation
• Building Blocks of Power BI
• The architecture of Power BI
• Salient Features of Power BI
• Understand the components of Power BI Desktop
• Report view
• Data View
• Data Model View
• Pages
• Visualization pane
• Fields pane
• A direct query versus import data
• Connecting to Common Data sources

In this module, participants will understand how to build simple(basic) visualization (reports) in with Power BI Desktop and publish in BI Service.

• Using Excel as a data source for Power BI
• The Power BI data model
• Using databases as a data source for Power BI
• The Power BI Service at Glance
• Publishing in Power BI Service

In this module, participants will understand how to prepare the data for Visualization. Participants will learn various transformations to Clean and load data with the query editor

• Introduction to query editor
• Features
• Basic transformations
• Changing data type
• Applied Steps
• Renaming steps
• Delete Columns/Rows
• De-Duplicate, Remove Null data
• Add a column from examples
• Text, Number and Date functions
• Create a list

This module will cover advanced topics in Query Editor. Designing concepts of Data model such as the Dimension model, Star schema will be covered in detail in this module

• Un Pivot and Pivot
• Advanced transformations
• Combine queries –Merge and Append
• Add custom columns
• Setting up parameters
• Dimension Modeling in Detail
• Create a Dimension Table
• Create Fact Table
• Design Star-Schema
• Manage Table Relationships
• Model Enhancements
• Create Calculated Columns

In this module, participants will understand how the visualization of data is done and the creation of interactive reports with Power BI Desktop. Creating charts and dashboards will be understood. Also, learn about custom visuals

• Visualizing Data – Creating Interactive Reports
• Adding Slicers for Filters
• Visualizing Tabular Data
• Visualizing Categorical Data
• Visualizing Data Trends
• Visualizing Categorical and Trend Data Together
• Visualizing Geographical Data with Maps (Map Visualizations)
• Card Gauge
• Treemap Visuals
• Visualizing Goal Tracking
• Using Custom Visuals
• Slicers & Timeline Slicers
• Drill Down/Up
• Hierarchies
• Tables, Matrices, Formatting

This module will help participants learn the basics of DAX in Power BI Desktop. Understand DAX functions that are the same or similar to Excel formulas Like Date, Text, Logical functions.

• Concepts in DAX and relevance of DAX needed
• DAX Syntax
• Data Types in DAX and Calculation Types
• DAX Measure Type –Column, Table, Measure
• DAX Operators
• DAX Quick measures
• Running total, YTD, MTD, QTD, YOY, MOM, QOQ measures

This module will help participants learn the advanced topics of DAX in Power BI Desktop. Participants will be learning advanced expressions and performing dynamic analysis using query context, row context, and filter context.

• Why Advanced DAX
• Iterator Functions (SUMX, RANKX)
• Filter Context Overview and Examples
• Date & Time Functions
• Conditional & Logical Functions (IF/AND/OR)
• Mostly used Text Functions
• Joining Data with RELATED
• Key Math & Stats Functions
• COUNT Functions (COUNTA, DISTINCTCOUNT, COUNTROWS)
• CALCULATE
• CALCULATE & ALL
• CALCULATE & FILTER
• FILTER, FILTER and ALL, ALL EXCEPT
• Time Intelligence Formulas
• Rank Function
• Row Context (Understanding Row Context and Context Transition)
• DAX Best Practices in Power BI Desktop

In this module, participants will understand Power BI services offering which is a straightforward approach to report creation, and the ability to create and share dashboards without dependency on a report developer (IT Team). Various export options will be learned and data gateways

• Sharing Options Overview
• Deploying Power BI Service
• Creating and Sharing Dashboards
• Using Power BI Q&A
• Setting up App Workspaces
• Subscriptions and Alerts
• Excel Integration
• Export and Embed Options
• Share Dashboard with Power BI Service
• Export Data from a Visualization
• Export to PowerPoint

In this module, the participant will learn about setting up data gateways and data refresh. Also, learn about designing Power BI Mobile reports.

• Data Refreshing
• Refreshing Data Overview
• Installing the Data Gateway
• Scheduling a Data Refresh
• Power BI Mobile Overview
• Designing Reports and Dashboards for Mobile
• Interacting with the Power BI Mobile App

This course requires the following prerequisites:
Basic knowledge of Microsoft Excel.