Power BI Course

Power Bi Training Course Content

Introduction

  • Installation
  • Interface of Power BI
  • Introduction to our Source Data

Introduction to SQL

  • Data Definition Language
  • Data Manipulation Language
  • String Functions
  • Numeric Functions
  • Date Functions
  • Conversion Functions
  • Joins
  • ER Modeling
  • Normalization
  • SQL Select Variants
  • Sorting
  • Conditional Functions
  • Sub Queries
  • Set Operators
  • Manipulating large Data Sets

Different Data Sources in Power BI

  • Type of Connectors
  • Loading Data in Power BI
  • Ways to Create Visual
  • Understanding Fields Box
  • Understanding Aggregation
  • Power BI Architecture

Drilling into your data

  • Drill up and Down your data
  • Advanced drill down option

Formatting visual

Structuring your data

  • Wide Table Vs Tall Table
  • Transforming your Data Structure (Unpivot Data)
  • Fill & Replace Data
  • Splitting and formatting your data
  • Date & Time Transformations

Power BI Dashboard

  • Introduction to Dashboard Data
  • Loading Data & Knowing about Relationships
  • Ways to combine your data
  • Cardinality
  • Absence of Common Columns
  • Adding Tables & Matrix
  • Adding Bar & Column Charts
  • Adding Pie & Donut Charts
  • Adding Tree maps
  • Adding Line Charts
  • Adding Combo Charts
  • Adding Bubble Maps
  • Adding Filled maps
  • Adding Cards and Multi Row Cards
  • Inserting Elements

Filters

  • Adding Slicers
  • Understanding the Filters Pane
  • Drill through Filters
  • Month’s vs Calendar Months

Making your visuals Interactive

  • Using Bookmarks and Buttons to present insights
  • Refresh data and data source settings
  • Assignment instructions and introduction to dataset
  • Building Dashboard

Parameters and Functions

Data Analysis Expressions (DAX)

Introduction to DAX

  • Importance of DAX
  • Data Types in DAX
  • DAX Calculation Types
  • Steps to Create Calculated Columns
  • Measures in DAX
  • DAX Syntax DAX Functions DAX Operators DAX Tables and Filtering

Case Studies

Hi, fill the details our team will help you.

    Course





    Please fill the details our team will call you back.

      Course





      Azure

      Data Engineering Course

      New Batch

      17th-Feb-2025

      8:00 PM - 9:00 PM IST

      Please fill the details our team will call you back.