power bi training institutes in hyderabad

Power BI Complete Introduction

• Power BI Introduction, Brief History of Power BI, Data, Data Visualization, Reporting, Business Intelligence (BI), Traditional BI, Self-Serviced BI, Cloud Based BI, On Premise BI.
• Power BI Report Server, Power BI Service, Power BI Mobile, Paginated Reports
• Flow of Work in Power BI / Power BI Architecture
• Power BI Desktop Installation and Hands on practice

PBI Desktop & Power View Overview

• Power BI Desktop Components (Power Query, Power Pivot, Power View, Power Map, Q&A, Data Gateway)
• Building Blocks of Power BI (Fields, Filters, Visualizations, Reports, Data, Model Dashboards and Tiles)
• Data Connectivity Modes (Import, Direct, Live & Composite Models)
• Get Data Connecting Multiple source and represent the data
• Overview of default and Custom visualizations
• Power BI Desktop User Interface.
• Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas, Visual Edit Interactions, Sync Slicer,
• Selection Pane, Buttons, Book Marks, Conditional formatting.

Power Query Editor \ Transform Editor

Introduction to Power Query – Extract, Transform and Load (ETL)

•  The Queries Pane, The Data View / Results Pane, The Query Settings Pane, Formula Bar, Advanced Editor –
• Complete ETL Code.
• Overview of Power Query / Transform Editor
• Data types, Changing the Data type of a Column
• Filters in Power Query, Auto Filter / Basic Filtering, Filter a Column using Text Filters
• Filter a Columns using Number, Date and Text

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, Invoke functions

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, 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).

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,
• Sort Order, Sort using column that is not used in the Visualization, Sort using the Sort by Column button.

Power Pivot (DAX)

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

• Introduction of DAX, Calculated Columns, Measures, Example of Creating Calculated Columns, Creating
• Measures and Calculated Tables, Implicit Vs Explicit Measures, Row Filter vs. Context filters, DAX
• Operators, Types of Operators, Arithmetic Operators, Comparison Operators, Text Concatenation
• Operator, Logical Operators.

DAX Functions Categories

• Date and Time Functions
• Text Functions
• Logical Functions
• Aggregate Functions
• Filter Functions
• Information Functions
• Relationship Functions
• Time Intelligence Functions
• Table Manipulation Functions

Date & Time Functions

• YEAR, MONTH, DAY, WEEKDAY, WEEKNUM, FORMAT (Text Function) a Month Name, Weekday Name
• DATE, TODAY, NOW, HOUR, MINUTE, SECOND, TIME,DATEDIFF, CALENDAR, Calendar Auto,            Creating Dimension Table

Text Functions

• COMBINEVALUES,CONCATENATE,CONCATENATEX,EXACT,FIND,FORMAT,LEFT,LEN,LOWER,REPLACE,RIGH
• T,SEARCH,SUBSTITUTE,TRIM,UPPER,VALUE

Aggregate Functions

• AVERAGE, AVERAGEA, AVERAGEX, COUNT, COUNTA, COUNTAX, COUNTBLANK, COUNTROWS, COUNTX,
• DISTINCTCOUNT, DISTINCTCOUNTNOBLANK ,MAX, MAXA, MAXX, MIN, MINA, MINX, SUM, SUMX.

Filter Functions

• ALL,ALL CROSS FILTERED,ALL EXCEPT,ALL SELECTED,CALCULATE,CALCULATE TABLE,EARLIER,EARLIEST,
• FILTER,KEEP FILTERS,LOOKUP VALUE,SELECTED VALUE

Information Functions

• CONTAINS,HASONEFILTER,HASONEVALUE,ISBLANK,ISCROSSFILTERED,ISEMPTY,ISERROR,ISFILTERED,
• SELECTEDMEASURE,USERNAME,USEROBJECTID,USERPRINCIPALNAME.  

Relationship Functions

• CROSSFILTER, RELATED, RELATEDTABLE, USERELATIONSHIP

Time Intelligence Functions

• CLOSINGBALANCEMONTH,CLOSINGBALANCEQUARTER,CLOSINGBALANCEYEAR,DATEADD,DATESBETWE
• EN,DATESINPERIOD,DATESMTD,DATESQTD,DATESYTD,ENDOFMONTH,ENDOFQUARTER,ENDOFYEAR,FIRS
• TDATE,FIRSTNONBLANK,LASTDATE,LASTNONBLANK,NEXTDAY,NEXTMONTH,NEXTQUARTER,NEXTYEAR,O
• PENINGBALANCEMONTH,OPENINGBALANCEQUARTER,OPENINGBALANCEYEAR,PARALLELPERIOD,PREVI
• OUSDAY,PREVIOUSMONTH,PREVIOUSQUARTER,PREVIOUSYEAR,SAMEPERIODLASTYEAR,
• STARTOFMONTH,STARTOFQUARTER,STARTOFYEAR,TOTALMTD,TOTALQTD,TOTALYTD