Power BI Basic

Target Audience

IT users who want to turn raw data into knowledge

Content of Power BI Basic

Modules

• Introducing the Power BI Platform
• Getting Data with Power BI Desktop
• Applying basic transformations
• Beginning Data Modelling and DAX
• Introducing the Power BI Service
• Understanding Visualizations and Visual Interactions
• Filtering, Slicing and Dicing
• Geo Location (Map) Visualizations
• Using custom visuals

Outline Power BI Basics (2 days Level 1)

Day 1

Introducing the Power BI Platform

• What is Power BI?
• Power BI Desktop, The First Experience
• Exploring Power BI Website
• Introduction to Power Components

Getting Data and apply some basic transformations

• The Role of Power Query in a Power BI Solution
• Introduction to Data Mash-Up Engine of Power BI
• Τhe Query Editor Transformation GUIData Modelling Basics
• Power BI xVelocity engine basics and concepts
• Relationships in Power BI
• Hierarchies and Formatting
• Sorting by other columns
• Date Table
• Calculated Columns, Measures, and Calculated Tables

Data Visualization

• Power BI Desktop Visualization
• Formatting Visuals in Power BI Desktop
• Basic Charts and Visuals in Power BI
• Sorting, Filtering, and categorization
• Maps and Geo-Spatial Visualization

Power BI Service

• Basic Sharing and using workspaces in Power BI web site
• Dashboard vs. Report
• Power Q&A
• Mobile Dashboard Design
• Schedule Refresh vs. Other types of connections
• Gateway’s Role in the Service

Day 2

Understanding Visualizations

• Importance of Visualization
• Basic Charts; Bar and Column Charts
• Clustered vs. Stacked Charts
• Q&A for Reports
• Quick Measures in Power BI
• Drill Down and Up using visuals and hierarchies
• Table and Matrix
• Conditional formatting
• Multi Pages reports

Slicing and Dicing

• Filters
• Scopes of Filters: Visual Level, Page Level, Report Level
• Modes of Filtering: Basic, Advanced, Relative, Top N
• Drill through Page Filter
• Creating master-details page scenario in Power BI
• Slicers
• Types of Slicers; Date, Text, Number
• Slicer Formatting
• Syncing Slicer between Pages

Geo Location Visualization

• Using Bing to find spots
• Fine Tuning Address Details
• Using Latitude and Longitude
• Filled Map Regions and Polygons
• Filled Map Data Category importance
• Custom map visual with Shape Maps
• The Hero of all maps, ArcGIS Map;

Custom Visuals

• Adding and using a custom visual
• Infographic Designer
• Tachometer Gauge
• Map custom visuals
• Hierarchy Slicer
• R Custom Visuals

Basic Excel knowledge and Basic understanding of data analysis is a plus but no requirement