Power BI

  1. Home
  2. »
  3. Power BI

Power BI

  • Introduction to Power BI
  • Power BI Desktop and Data Transformation
  • Data Analysis Expression (DAX)
  • Data Visualization
  • Power BI Service
  • Connectivity Modes
  • Power BI Report Server
  • R & Python in Power BI
  • Advanced Analytics in Power BI
  • In-Class Hands-On
  • Added Features
  • Interview Preparation

Topics Covered

Power BI

Introduction to Power BI

  • Installation of Power BI
  • Concepts of Business Intelligence
  • Power BI installation

Power BI Desktop and Data Transformation

  • Data Cleaning using Power BI query editor
  • Creating Measures
  • Transform, Clean, Shape, and Model Data for further analysis
  • Data transformation using the query editor
  • Shaping data with measures
  • Managing Data Relationships

Data Analysis Expression (DAX)

  • Creating Calculated Columns and Measures
  • Performing Data Analysis using DAX
  • Data Analysis using DAX
  • Creating Calculated Measures and Columns

Data Visualization

  • Creating different visuals
  • Creating cards, measures, KPI, reference line, and slicers
  • Visuals in Power BI
  • Report creation
  • Visuals modification
  • Z-order and KPI in visuals

Power BI Service

  • Creating reports and dashboard
  • Publishing reports on Power BI Service
  • Using Power BI Service for operations on reports
  • Report and dashboard creation
  • Designing stories with dashboards

Connectivity Modes

  • Setting Up On-Premise Data Gateway
  • Connecting Power BI with SQL Server Database
  • Connecting Reports on Power BI Service with Local Data Files
  • On-Premise Data Gateway
  • Connecting Power BI with Databases
  • Connecting Power BI Service with Local Data Sources

Power BI Report Server

  • Setting Up Power BI Report Server
  • Using Power BI Report Server for Publishing Reports
  • Implementing Row Level Security
  • Power BI Report Server
  • Publishing reports on Report Server

R & Python in Power BI

  • Demonstrate connecting R and Python in Power BI
  • Using R and Python for data analysis
  • Data cleaning and transformation
  • Python and R scripts
  • Power BI integration

Advanced Analytics in Power BI

  • Connecting with Power BI service
  • Creating dataflow
  • Creating scorecard
  • Data flow creation
  • Anomalies detection
  • Smart Narrative implementation

Added Features

  • Resume Preparation
  • Resume Preparation Tips
  • Sample Resumes
  • Soft copy of Notes for each module
  • 4 case studies on use case diagrams
  • 2 Real-time project specifications