POWER BI COURSE CONTENTS

Introduction To PowerBI

• Introduction to Power BI
• Power BI Architecture
• Components of Power BI
• Relationship between Excel &Power BI
• Why power BI
• Downloading and installing Power BI
• Power BI Desktop &Power BI Services
• Building blocks of Power BI
• PowerBI workspaces
• Exploring Power BI Editor

Power BI Data Sources & Data Sets

• Power BI Data Sources
• Power BI File Sources
• Power BI Web Sources
• Fetching data from different files
• Working with import and direct query
• Editing Data Sources
• Editing Data Queries
• Data Sets
• Editing Datasets
• Applying Changes to Datasets
• Cleaning Datasets in Power
• Reverting changes to Datasets
• Defining relationships between tables
• Creating custom table

Power BI Editor Features

• Merge Queries and Append Queries
• Merging Data from diff sources
• Remove columns and split columns
• Choosing required columns in the data
• Working with different transformations
• Applied steps in query editor
• Working with hierarchies
• Working with Pivot & UnPivot
• Creating index and custom columns
• Group By functionality in Query Editor

Power BI Visualizations

• Working with different visualizations
• Working with table and matrix visuals
• Working with different level of filters
• Data Visualizations with Power BI
• Gauge and cards

CHART REPORT PROPERTIES

• CHART Report Types and Properties
• STACKED BAR CHART, STACKED COLUMN CHART
• CLUSTERED BAR CHART, CLUSTERED COLUMN CHART
• 100% STACKED BAR CHART, 100% STACKED COLUMN CHART
• LINE CHARTS, AREA CHARTS, STACKED AREA CHARTS
• LINE AND STACKED ROW CHARTS
• LINE AND STACKED COLUMN CHARTS
• WATERFALL CHART, SCATTER CHART, PIE CHART
• Field Properties: Axis, Legend, Value, Tooltip
• Field Properties: Color Saturation, Filters Types
• Formats: Legend, Axis, Data Labels, Plot Area
• Data Labels: Visibility, Color and Display Units
• Data Labels: Precision, Position, Text Options
• Analytics: Constant Line, Position, Labels
• Working with Waterfall Charts and Default Values
• Modifying Legends and Visual Filters - Options
• Hierarchies: Grouping Multiple Report Fields
• Hierarchy Levels and Usages in Visualizations

Power BI Advanced Features

• Working with Data Hierarchies
• In-built slicers and custom slicers
• Date slicer
• Working with reference lines
• Developing KPIs
• Parameters
• Types of Parameters
• Linking Parameters with Datasets
• Power BI Templates
• Difference between Reports & Templates
• Importing custom visualizations

DAX functions with Power BI

• Working with DAX Functions
• Calculated Measures by using DAX
• Parameters with DAX
• Dynamic Report Filters, Expressions
• Variables
• Date functions
• String functions
• Arithmetic Functions

Calculated Columns / Measures

• Understanding Calculated Column
• Creating Calculated Columns
• Understanding Measures
• Creating Measures
• Difference between Columns & Measures

DAX Expressions & DAX Functions

• YTD, QTD, MTD Calculations with DAX
• DAX Calculations and Measures
• Using TOPN, RANKX, RANK.EQ
• SAMPLE Function, COUNTALL, ISERROR
• ISTEXT, DATEFORMAT, TIMEFORMAT
• Time Intelligence Functions with DAX
• Data Analysis Expressions and Functions
• DATESYTD, DATESQTD, DATESMTD
• ENDOFYEAR, ENDOFQUARTER,ENDOFMONTH
• FIRSTDATE, LASTDATE, DATESBETWEEN
• CLOSINGBALANCEYEAR,CLOSINGBALANCEQTR
• SAMEPERIOD and PREVIOUSMONTH,QUARTER
• FILTER FUNCTIONS

Power BI Deployment

• Power BI Server Configuration
• Power BI Workspaces
• Deployment Power BI Desktop Reports To Web
• Managing report in Power BI Services
• Editing Reports in Power BI Servers
• Share dashboards to Client /Users
• Security Features in Power BI