Realtime Advantage

  • Real Time Trainers
  • 100% Placement
  • Small Training Batch
  • Flexible Timings
  • Excellent Lab Facility
  • Practical Guidance
  • Hands on Experience
  • Certification Support
  •   Multiple Training Locations

Quick Contact

Power BI Online Training Reviews

Real Time Experts

4.9 out of 5 based on 306 Reviews


Power BI Online Training In Bangalore

Power BI Online Training In Bangalore


Power BI Online Training Training


Power BI Online Training Training Syllabus in Bangalore


Power BI Online Training In Bangalore,India

POWER BI COURSE OUTLINE


Power BI Desktop:

  1. Introduction (2 hr)

  • Introduction to business intelligence

  • Introduction to data analysis

  • Introduction to data visualization

  • Overview of self-service BI

  • Considerations of self-service BI

  • Microsoft tools for self-service BI

  • Power BI vs. SSRS Report

  • Installation – Power BI Desktop

  • Configure tools

 

  1. Getting and Shaping Data (3 hr)

  • Using databases as a Power BI data source

    1. SQL Server Database                         

    2. Microsoft Access Database                

  • Using Excel as a Power BI data source

  • Using databases as a Power BI data source

  • The Power BI service

  • Import data into Power BI

  • Data Clean up

  • Transforming Data

  • Append Operation

  • Merge Operations

  • Lab : 

    1. Import data into Power BI

    2. Data Clean up

    3. Transforming Data

    4. Append Operation

    5. Merge Operations

 

  1. M Language: (2 hr)

The Power Query M formula language is optimized for building highly flexible data mashup queries. It's a functional, case sensitive language similar to F#.
Power Query statements are made up of individual language elements such as functions, variables, expressions, and primitive and structured values that together define the logic necessary to shape the data. In this module, we will share 

  • Quick tour of the Power Query M formula language

  • Commonly used functions

    1. let expression

    2. RemoveColumns function

    3. PromoteHeaders function

    4. RenameColumns function

    5. SelectRows Function

    6. ReplaceValue function

    7. TransformColumns function

    8. Adding a Calculated column

 

  1. Power BI Model (3 hr) 

  • Creating Relationships

    1. Append

    2. Merge

  • Joins

    1. Left, Inner, Join, Full Outer Join, Left Anti Joins, Right Anti Join

  • Extracting Columns From XML

  • Setting Datatypes

  • Transforming Columns

  • Splitting Columns

  • Defining New Columns

  • Concatenating Columns

  • Performing Lookup

  • Translating

  • Adding Date Table

  • Lab:

    1. Creating Relationships

    2. Defining New Columns

    3. Concatenating Columns

    4. Performing Lookup

    5. Translating

    6. Adding Date Table

 

  1. Enhancing Power BI Model (3 hrs)

  • Defining Hierarchies

  • Configuring Properties e.g. Data Categories , Formatting

  • Creating Measures

  • Creating Parameters

  • Import from Reports

  • Lab

    1. Creating Measures

    2. Creating Parameters

    3. Import from Reports

 

  1. Data Flows (1 hr)

  • What is Data Flow

  • Why /When to use Data Flow?

  • Lab: 

    1. Implementing Data Flow

 

Here-in the data will be uploaded to Power BI Service, and different visualizations /reports will be created, and 

  1. Visualizing (3hrs)

  • Visualizing Data

  • Adding Visuals

  • Filtering

  • Slicer Filtering

  • Highlighting

  • Setting Properties

  • Drilling within the Hierarchy

  • Creating Bookmarks

  • Power BI Mobile

  • Custom Visuals

 

  1. Security (1 hr)

  • Data Storage Security

  • Row Level Security

  • Demo: Security

 

 

  1. Refreshing Data (2 hrs)

  • Publishing DataSets

  • Refreshing Data

  • Power BI Mobile Apps

  • Using Power BI Gateway - Personal

  • Understanding Power BI Gateway – Enterprise

  • Power BI Pro vs. Free

  • Publishing To Power BI

  • Setting Up Auto-Refresh

  • Content Packs

  • Sharing Within the team /with organization

  • Creating Dashboards 

  • Sharing Reports /Dashboards

 

 

DAX 

  1. Introducing DAX  (1 hr)

    1. Understanding DAX Calculations

    2. Understanding Calculated Columns And Measures 

    3. Variables 

    4. Handling Errors In DAX Expressions 

    5. Formatting DAX Code

    6. Common DAX Functions 

 

    1. Using Basic Table Functions (2 hrs)

      1. Introducing Table Functions 

      2. Evaluate Syntax 

      3. Using Table Expressions 

      4. Understanding Filter 

      5. Understanding All, Allexcept, And Allnoblankrow 

      6. UNDERSTANDING VALUES AND DISTINCT

 

    1. Understanding Evaluation Contexts  (2 hrs)

      1. Introduction To Evaluation Contexts 

      2. Testing Your Evaluation Context Understanding 

      3. Creating A Row Context With Iterators 

      4. Understanding Filter, All, And Context Interactions 

      5. Working With Many Tables 

      6. Evaluation Contexts Recap 

      7. Creating A Parameter Table 

 

    1. Understanding CALCULATE And CALCULATETABLE  (2 hrs)

      1. Understanding Calculate 

      2. Calculate Examples 

      3. Understanding Context Transition 

      4. Variables And Evaluation Contexts 

      5. Understanding Circular Dependencies 

      6. Calculate Rules 

      7. Introducing Allselected

 

    1. DAX Examples (2 hrs)

  1. Computing Ratios And Percentages 

  2. Computing Cumulative Totals 

 

    1. Optimizing Data Models and Strategy (1 hr)

      1. Gathering Information About The Data Model 

      2. Denormalization 

      3. Columns Cardinality 

      4. Calculated Columns

      5. Choosing The Right Columns To Store

      6. Optimizing Column Storage 


Power BI Online Training trainer Profile & Placement

Our Power BI Online Training Trainers


  • More than 10 Years of experience in Power BI Online Training Technologies
  • Has worked on multiple realtime Power BI Online Training projects
  • Working in a top MNC company in Bangalore
  • Trained 2000+ Students so far.
  • Strong Theoretical & Practical Knowledge
  • Certified Professionals

Power BI Online Training Placement Training in Bangalore


  • More than 2000+ students Trained
  • 92% percent Placement Record
  • 1000+ Interviews Organized

Power BI Online Training training batch size in Bangalore

Regular Batch ( Morning, Day time & Evening)


  • Seats Available : 8 (maximum)

Power BI Online Training Weekend Training Batch( Saturday, Sunday & Holidays)


  • Seats Available : 8 (maximum)

Power BI Online Training Fast Track batch


  • Seats Available : 5 (maximum)

Realtime Experts © 2021 | All Rights Reserved.