Power BI

Course Description

_______________________________________________________________________________________________

Introduction

Training Duration: 45 Hours

• What is Power 131

• Overview of Power BI

• Connecting to Software as Services

• Power 131 Community 

Power B1 Desktop Data Transformation Real time concepts

• Changing Locale

• Connecting to a Database

• Basic Transformations

• Managing Query Groups

• Splitting Columns

• Changing Data Types

• Working with Dates

• Removing and Reordering Columns

• Conditional Columns

• Connecting to Files in a Folder

• Merge Queries

• Query Dependency View

• Transforming Less Structured Data

• Enter Data

• Query Parameters 

Power BI Desktop Modelling

• Managing Data Relationships

• Creating Calculated Columns

• Optimizing Optimizing Models forModels for ReportingReporting

• Creating CalculatedCreating Calculated MeasuresMeasures

• Creating and Creating and ManagingManaging HierarchiesHierarchies

• Using Using CalculatedCalculated TablesTables

• Time Time IntelligenceIntelligence

• Manually Manually Typing Typing in in a Dataa Data TableTable

• IncludeInclude ExcludeExclude

• GroupingGrouping BinningBinning 

Power BI Desktop Visualization

• Pie and Pie and TreeTree mapmap

• Hierarchical Axis andHierarchical Axis and ConcatenatingConcatenating

• Filter Filter (Including(Including TopN)TopN)

• Bar Chart withBar Chart with LineLine

• Analytics PaneAnalytics Pane

• Clustering (and MachineClustering (and Machine Learning)Learning)

• SlicerSlicer

• Focus Focus Mode Mode and and SeeSee DataData

• DateDate SlicerSlicer

• Map Map and and FilledFilled MapMap

• Table Table andand MatrixMatrix

• Table Table StylesStyles

• ScatterScatter ChartChart

• WaterfallWaterfall

• Gauge, Gauge, Card, andCard, and KPIKPI

• ColoringColoring ChartsCharts

• Shapes, TexShapes, Tex--tboxes, tboxes, andand Images

Advanced

Advanced Visualization

• Page Page Layout Layout andand Formatting

• Visual Relationship

• Duplicate Page

• Categories Categories with with NoNo DataData

• Default Summarization Default Summarization andand CategorizationCategorization

• Positioning,Positioning, Aligning,Aligning, andand SortingSorting VisualsVisuals

• CustomCustom HierarchiesHierarchies

• Importing Importing CustomCustom VisualsVisuals

 Introduction

Introduction OfOf DaxDax

• Calculated ColumnsCalculated Columns

• MeasuresMeasures

 Power BI ServiceService

• Overview Overview of of Dashboards Dashboards andand ServiceService

• Uploading to Uploading to Power Power 131131 ServiceService

• QuickQuick InsightsInsights

• Configuring aConfiguring a DashboardDashboard

• Adding Textbox, Adding Textbox, ImageImage WidgetsWidgets

• Featured Featured and and FavouriteFavourite DashboardDashboard

• FilteringFiltering DashboardDashboard

• Sharing aSharing a DashboardDashboard

• InIn--FocusFocus ModeMode

• Pinning a Pinning a LiveLive PagePage

• Printing Printing Dashboard Dashboard and and ExportingExporting DataData

• Export to CSV Export to CSV andand ExcelExcel

• Alerts Alerts in the in the Power BIPower BI ServiceService

• PersonalPersonal GatewayGateway

 Working

Working withwith ExcelExcel

• Importing Importing Excel Excel Data using Data using SimpleSimple TableTable

• Excel Excel Workbook with Excel DataWorkbook with Excel Data ModelModel

• Analyzing Data Analyzing Data in in ExcelExcel

 Direct Connectivity

 Direct Connectivity

 Dataflow

 Dataflow RealReal--timetime Concepts Concepts

 Interview

 Interview QA

 Scenarios

 Scenarios Based Based Questions Questions andand AnswersAnswers