Power BI Classes in BTM Layout Bangalore

IT Networks offers the best Power BI Training in BTM Layout with most experienced professionals. We conduct all our students from the Basic Level of Power BI Classes to Advanced level. All these Classes are undergone not only theoretically, but also are executed on the real-time basis. Our Trainers are Real-time Working professionals in the Power BI Field from many years with hands on real time Power BI Project Knowledge.

IT Networks is a highly experienced Power BI Training Institute in BTM Layout. This has helped students to get placed in top MNCs. We Offer Power BI Classes in BTM Layout for working professionals and students. we offer Regular training classes in Morning Batches and Evening Batches we also offer Weekend Training classes and Fast-track Training Classes for Power BI Course.

Microsoft Power BI Course Content

Power BI Complete Introduction

 Power BI Introduction

 Data Visualization, Reporting

 Business Intelligence(BI), Traditional BI, Self-Serviced BI

 Cloud Based BI, On Premise BI

 Power BI Products

 Power BI Desktop (Power Query, Power Pivot, Power View)

 Flow of Work in Power BI Desktop

 Power BI Report Server, Power BI Service, Power BI Mobile

 Flow of Work in Power BI / Power BI Architecture

 A Brief History of Power BI

PBI Desktop Installation, PBI Desktop &Service Overview

 Power BI Desktop Installation

 Building Blocks of Power BI

 Datasets, Visualizations, Reports, Dashboards, Tiles

 Power BI Desktop User Interface

 Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas

 Overview of Power Query / Query Editor – Extract, Transform & Load Data

 Connecting to Data Sources, Establish connection to the Excel source

 Importing Data into Power BI or Query Editor

 Transforming the Data using Power Query

 Model the Data using Power Pivot – Relationship View

 Creating New Measures and New Columns using DAX – Data View

 Visualizing the Data using Power View and Power Maps – Report View

 Saving and Publishing the Visuals or Reports

 Logon to Power BI Service

 View the Reports in PBI Service and Share the reports

Power Query

Introduction to Power Query – Extract, Transform & Load

 Data Transformation, Benefits of Data Transformation

 Shape or Transform Data using Power Query

 Overview of Power Query / Query Editor, Query Editor User Interface

 The Ribbon (Home, Transform, Add Column, View Tabs)

 The Queries Pane, The Data View / Results Pane, The Query Settings Pane, Formula Bar

 Advanced Editor – Complete ETL Code

 Saving Your Work – Applying ETL Changes – Loading into Power Pivot Model

 Power Query Conceptually

Datatypes and Filters in Power Query

 Datatypes, Changing the Datatype of a Column

 Filters in Power Query

 Auto Filter / Basic Filtering

 Filter a Column using Text Filters

 Filter a Column using Number Filters

 Filter a Column using Date Filters

 Filter Multiple Columns

Inbuilt Column Transformations

 Remove Columns / Remove Other Columns

 Name / Rename a Column

 Reorder Columns or Sort Columns

 Add Column / Custom Column

 Split Columns

 Merge Columns

 PIVOT, UNPIVOT Columns

 Transpose Columns

In built Row Transformations

 Header Row or Use First Row as Headers

 Keep Top Rows, Keep Bottom Rows

 Keep Range of Rows

 Keep Duplicates, Keep Errors

 Remove Top Rows, Remove Bottom Rows, Remove Alternative Rows

 Remove Duplicates, Remove Blank Rows, Remove Errors

 Group Rows / Group By

Combine Queries (Append Queries & Merge Queries)

Append Queries / Union Queries

 Append Queries

 Append Queries as New

 Append 2 or more files individually with different queries

 Appending multiple files of same type from a folder using single query

 Query Options

 Copy Query, Paste Query

 Delete Query, Rename Query

 Enable Load, Include in report Refresh

 Duplicate Query, Reference Query

 Move to Group, Move Up, Move Down

Merge Queries / Join Queries

Merge Queries, Merge Queries as New

Default Types of Joins / Join Kinds / Merge Type

                    Left Outer (all from first, matching from second)

                    Right Outer (all from second, matching from first)

                    Full Outer (all rows from both)

                    Inner (only matching rows)

                    Left Anti (rows only in first)

                    Right Anti (rows only in second)

Cartesian Join or Cross Join

Power Pivot

Power BI Data Modeling – Relationship View

 Data Modeling Introduction

 Relationship, Need of Relationship

 Relationship Types / Cardinality in General

 One-to-One, One-to-Many (or Many-to-One), Many-to-Many

 AutoDetect the relationship, Create a new relationship, Edit existing relationships

 Make Relationship Active or Inactive

 Delete a relationship

 Cross filter direction (Single, Both), Assume Referential Integrity

Enhancing the Data Model – DAX

 What is DAX, Calculated Column, Measures

 DAX Table and Column Name Syntax

 Creating Calculated Columns, Creating Measures

 Implicit Vs Explicit Measures

 Calculated Columns Vs Measures

 DAX Syntax & Operators

 DAX Operators

 Types of Operators

 Arithmetic Operators, Comparison Operators, Text Concatenation Operator, Logical Operators

DAX Functions Categories

 Date and Time Functions

 Logical Functions

 Text Functions

 Math & Statistical Functions

 Filter Functions

 Time Intelligence Functions

DAX Date & Time Functions

 YEAR, MONTH, DAY

 WEEKDAY, WEEKNUM

 FORMAT (Text Function), Month Name, Weekday Name

 DATE, TODAY, NOW

 HOUR, MINUTE, SECOND, TIME

 DATEDIFF, CALENDAR

 Creating Date Dimension Table

DAX Text Functions

 LEN, CONCATENATE (&)

 LEFT, RIGHT, MID

 UPPER, LOWER

 TRIM, SUBSTITUTE, BLANK

DAX Logical Functions

 IF

 TRUE, FALSE

 NOT, OR, IN, AND

 IFERROR

 SWITCH

DAX Math and Statistical Functions

 INT

 ROUND, ROUNDUP, ROUNDDOWN

 DIVIDE

 EVEN, ODD

 POWER, SIGN

 SQRT, FACT

 SUM, SUMX

 MIN, MINX

 MAX, MAXX

 COUNT, COUNTX

 AVERAGE, AVERAGEX

 COUNTROWS, COUNTBLANK

DAX Filter Functions

 CALCULATE

 ALL

 RELATED

DAX Time Intelligence Functions

 Time Intelligence Introduction

 TOTALMTD, TOTALQTD, TOTALYTD

 PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSYEAR

 NEXTDAY, NEXTMONTH, NEXTQUARTER, NEXTYEAR

 SAMEPERIODLASTYEAR

 YOY Growth

 MOM Growth

Power View

Report View / Power View

 Report View User Interface

 Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas

 Visual Interactions

 Interaction Type (Filter, Highlight, None)

 Visual Interactions Default Behavior, Changing the Interaction

Filters in Power View

 Filter Types

 Visual Level Filters, Page Level Filters, Report Level Filters, Drill Through Filters

 Filter Sub Types

 Basic Filtering, Advanced Filtering, Top N, Relative Date Filtering

 Numeric field filters, Text field filters, Date and Time field Filters

Grouping, Binning & Sorting

 Grouping and Binning Introduction

 Using grouping, Creating Groups on Text Columns

 Using binning, Creating Bins on Number Column and Date Columns

 Sorting Data in Visuals

 Changing the Sort Column, Changing the Sort Order

 Sort using column that is not used in the Visualization

 Sort using the Sort by Column button

Hierarchies and Drill-Down Reports

 Hierarchy Introduction, Default Date Hierarchy

 Creating Hierarchy, Creating Custom Date Hierarchy

 Change Hierarchy Levels

 Drill-Up and Drill-Down Reports

 Data Actions, Drill Down, Drill Up, Show Next Level, Expand Next Level

 Drilling filters other visuals option

Power BI Visualizations

 Visualizing Data, Why Visualizations

 Visualization types, Field Wells

 Visuals for Filtering, Visualizing Categorical Data, Visualizing Trend Data

 Visualizing KPI Data, Visualizing Tabular Data, Visualizing Geographical Data

 Leveraging Power BI Custom Visuals

Visuals for Filtering

 Slicer Visualization

 When to use a Slicer

 Create and format Slicer Visualization

 Hierarchy Slicer (Custom Visualization)

 When to use a Hierarchy Slicer

 Create and format Hierarchy Slicer

 Advantages of Hierarchy Slicer

Visualizing Categorical Data

 Create and Format Bar and Column Charts

 Create and Format Stacked Bar Chart Stacked Column Chart

 Create and Format Clustered Bar Chart, Clustered Column Chart

 Create and Format 100% Stacked Bar Chart, 100% Stacked Column Chart

 Create and Format Pie and Donut Charts

 Create and Format the Tree Map Visual

 Create and Format Scatter Charts

Visualizing Trend Data

 Line and Area Charts

 Create and Format Line Chart, Area Chart, Stacked Area Chart

 Combo Charts

 Create and Format Line and Stacked Column Chart, Line and Clustered Column Chart

 Create and Format Ribbon Chart, Waterfall Chart, Funnel Chart

Visualizing KPI Data

 Create and Format Gauge Visual, KPI Visual

 Create and Format Card Visualization, Multi Row Card

Visualizing Tabular Data, Geographical Data & R Script Visual

 Create and Format Table Visual, Matrix Visualization

 Create and Format Map Visual, Filled Map Visual, Arc GIS Maps Visual

 Create and Format R Script Visual

Power BI Service

Power BI Service Introduction

 Power BI Service Introduction, Power BI Cloud Architecture

 Creating Power BI Service Account, SIGN IN to Power BI Service Account

 Publishing Reports to the Power BI service, Import / Getting the Report to PBI Service

 My Workspace / App Workspaces Tabs

 DATASETS, WORKBOOKS, REPORTS, DASHBOARDS

 Working with Datasets, Creating Reports in Cloud using Published Datasets

 Power BI Datasets Live Connection using Desktop

 Working with Workbooks, working with Reports, Sharing Reports

Dashboards Development

 Creating Dashboards

 Pin Visuals and Pin LIVE Report Pages to Dashboard

 Advantages of Dashboards

 Interacting with Dashboards

 Adding Tiles to Dashboards

 Web Content, Image, Text Box,Video

 Formatting Dashboard

 Sharing Dashboard

Data Gateways

 Introduction to Data Gateways

 How Data Gateways work

 Connect to an on premise Data Source by using a Data Gateway

 Download Data Gateway

 Installing a Data Gateway

 Types of Gateways

 On-premises Data Gateway, On-premises Data Gateway (personal mode)

 Manage Data Gateway

 Add and Remove Administrators

 Add Data Source, Add or Remove Users to a Data Source

 Refresh On Premise Data

 Configuring Automatic Refresh using Schedules

Collaboration in Power BI using App Workspace

 Introduction to App Workspaces

 Create an App Workspace

 Add Members to App Workspace to Collaborate

 App Workspace Access

 Admin, Member, Contributor

Sharing Power BI Content using Apps and Content Packs

 Introduction to App

 Publish an App

 Update a Published App

 Manage Content in App

 Include in App, Exclude in App

 Sharing App

 Entire Organization, Specific individuals or group

 Un publishing an App

 Content Pack Introduction

 Create Content Pack

 Sharing Content Packs

 Specific Groups, My Entire Organization

 Selecting the Content / Items to Publish or Share

Row Level Security in Power BI

 Introduction to Row Level Security

 Row Level Security (RLS) with DAX

 Manage Roles, Creating Roles, Testing Roles

 Adding Members to Roles in Power BI Service

 Dynamic Row Level Security

 Creating Users Table and Adding to the Model

 Capturing users using UserName () or UserPrincipalName () DAX Functions

ADD ON

 Real-time Project Explanation

 Resume Preparation

 Interview Questions Discussions

 Mock Interviews