POWER BI COURSE CONTENTS

Web Designing Training Content

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

Need More Details ? Fill The Enquiry Form