<?php the_title_attribute(); ? data-src=
Admin bar avatar

Bodhi IT

 4.5 (5 Reviews)

Course Duration

40 hour

 

About Power – BI 

Power BI is a new tool in the Power BI portfolio to meet the needs of data visualization in the cloud. It is delivered as an all-in-one, SaaS-based product. It covers the needs of data visualization, budget planning, and predictive analytics. Power BI offers a complete solution when it comes to business intelligence. Accessible online in SaaS mode, Power BI is becoming increasingly important in the Power BI ecosystem. Eventually, it is destined to become the BI reference tool for the Power BI. BODHI IT provides best Power BI Online Training in Hyderabad and all over world.

 

Power - BI Curriculum

1. Power BI Complete Introduction
  • Power BIIntroduction
  • Data Visualization,Reporting
  • Business Intelligence(BI), Traditional BI, Self-ServicedBI
  • Cloud Based BI, On PremiseBI
  • Power BIProducts
  • Power BI Desktop (Power Query, Power Pivot, PowerView)
  • Flow of Work in Power BIDesktop
  • Power BI Report Server, Power BI Service, Power BIMobile
  • Flow of Work in Power BI / Power BIArchitecture
  • A Brief History of PowerBI

2. PBI Desktop Installation, PBI Desktop & Service Overview
  • Power BI Desktop Installation
  • Building Blocks of PowerBI
  • Datasets, Visualizations, Reports, Dashboards,Tiles
  • Power BI Desktop UserInterface
  • Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab,Canvas
  • Overview of Power Query / Query Editor – Extract, Transform & LoadData
  • Connecting to Data Sources, Establish connection to the Excelsource
  • Importing Data into Power BI or QueryEditor
  • Transforming the Data using PowerQuery
  • Model the Data using Power Pivot – RelationshipView
  • Creating New Measures and New Columns using DAX – DataView
  • Visualizing the Data using Power View and Power Maps – ReportView
  • Saving and Publishing the Visuals orReports
  • Logon to Power BIService
  • View the Reports in PBI Service and Share thereports

 


3. Introduction to Power Query – Extract, Transform & Load
  • Data Transformation, Benefits of DataTransformation
  • Shape or Transform Data using PowerQuery
  • Overview of Power Query / Query Editor, Query Editor UserInterface
  • The Ribbon (Home, Transform, Add Column, ViewTabs)
  • TheQueriesPane,TheDataView/ResultsPane,TheQuerySettingsPane,FormulaBar
  • Advanced Editor – Complete ETLCode
  • Saving Your Work – Appling ETL Changes – Loading into Power PivotModel
  • Power QueryConceptually

4. Inbuilt Column Transformations
  • Remove Columns / Remove OtherColumns
  • Name / Rename aColumn
  • Reorder Columns or SortColumns
  • Add Column / CustomColumn
  • SplitColumns
  • MergeColumns
  • PIVOT, UNPIVOTColumns
  • TransposeColumns

5. In built Row Transformations
  • Header Row or Use First Row asHeaders
  • Keep Top Rows, Keep BottomRows
  • Keep Range ofRows
  • Keep Duplicates, KeepErrors
  • Remove Top Rows, Remove Bottom Rows, Remove AlternativeRows
  • Remove Duplicates, Remove Blank Rows, RemoveErrors
  • Group Rows / GroupBy

6. Combine Queries (Append Queries & Merge Queries)
Append Queries / Union Queries
  • AppendQueries
  • Append Queries asNew
  • Append 2 or more files individually with different queries
  • Appending multiple files of same type from a folder using single query
  • QueryOptions
  • Copy Query, PasteQuery
  • Delete Query, RenameQuery
  • Enable Load, Include in reportRefresh
  • Duplicate Query, Reference Query
  • Move to Group, Move Up, MoveDown
Merge Queries / Join Queries
    • Merge Queries, Merge Queries asNew
    • Default Types of Joins / Join Kinds / MergeType
      • Left Outer (all from first, matching from second)
      • Right Outer (all from second, matching fromfirst)
      • Full Outer (all rows from both)
      • Inner (only matching rows)
      • Left Anti (rows only infirst)
      • Right Anti (rows only in second)
    • Cartesian Join or CrossJoin

7. Power BI Data Modeling – Relationship View
  • Data ModelingIntroduction
  • Relationship, Need ofRelationship
  • Relationship Types / Cardinality inGeneral
  • 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 ReferentialIntegrity

8. Enhancing the Data Model – DAX
  • What is DAX, Calculated Column,Measures
  • DAX Table and Column NameSyntax
  • Creating Calculated Columns, CreatingMeasures
  • Implicit Vs ExplicitMeasures
  • Calculated Columns VsMeasures
  • DAX Syntax & Operators
  • DAX Operators
  • Types ofOperators
  • Arithmetic Operators, Comparison Operators, Text Concatenation Operator, Logical Operators

9. DAX Functions Categories
  • Date and TimeFunctions
  • LogicalFunctions
  • TextFunctions
  • Math & Statistical Functions
  • FilterFunctions
  • Time IntelligenceFunctions

10. DAX Date & Time Functions
  • YEAR, MONTH,DAY
  • WEEKDAY, WEEKNUM
  • FORMAT (Text Function) 🡪Month Name, WeekdayName
  • DATE, TODAY,NOW
  • HOUR, MINUTE, SECOND,TIME
  • DATEDIFF, CALENDAR
  • Creating Date DimensionTable

11. DAX Text Functions
  • LEN, CONCATENATE(&)
  • LEFT, RIGHT,MID
  • UPPER,LOWER
  • TRIM, SUBSTITUTE,BLANK

12. 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

13. DAX Time Intelligence Functions
  • Time IntelligenceIntroduction
  • TOTALMTD, TOTALQTD,TOTALYTD
  • PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER,PREVIOUS YEAR
  • NEXTDAY, NEXT MONTH, NEXT QUARTER,NEXT YEAR
  • SAMEPERIODLASTYEAR
  • YOYGrowth
  • MOMGrowth

14. Report View / Power View
  • Report View UserInterface
  • Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab,Canvas
  • VisualInteractions
  • Interaction Type (Filter, Highlight,None)
  • Visual Interactions Default Behavior, Changing theInteraction

 


15. Report View / Power View
  • Report View UserInterface
  • Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab,Canvas
  • VisualInteractions
  • Interaction Type (Filter, Highlight,None)
  • Visual Interactions Default Behavior, Changing theInteraction

16. Filters in Power View
  • FilterTypes
  • Visual Level Filters, Page Level Filters, Report Level Filters, Drill ThroughFilters
  • Filter SubTypes
  • Basic Filtering, Advanced Filtering, Top N, Relative DateFiltering
  • Numeric field filters, Text field filters, Date and Time fieldFilters

 


17. Grouping, Binning & Sorting
  • Grouping and BinningIntroduction
  • Using grouping, Creating Groups on TextColumns
  • Using binning, Creating Bins on Number Column and DateColumns
  • Sorting Data inVisuals
  • Changing the Sort Column, Changing the SortOrder
  • Sort using column that is not used in theVisualization
  • Sort using the Sort by Columnbutton

18. Hierarchies and Drill-Down Reports
  • Hierarchy Introduction, Default DateHierarchy
  • Creating Hierarchy, Creating Custom DateHierarchy
  • Change HierarchyLevels
  • Drill-Up and Drill-DownReports
  • Data Actions, Drill Down, Drill Up, Show Next Level, Expand NextLevel
  • Drilling filters other visuals option

 


19. Power BI Visualizations
  • Visualizing Data, WhyVisualizations
  • Visualization types, Field Wells
  • Visuals for Filtering, Visualizing Categorical Data, Visualizing TrendData
  • Visualizing KPI Data, Visualizing Tabular Data, Visualizing GeographicalData
  • Leveraging Power BI CustomVisuals

 


20. Visuals for Filtering
  • Slicer Visualization
  • When to use aSlicer
  • Create and format SlicerVisualization
  • Hierarchy Slicer (CustomVisualization)
  • When to use a HierarchySlicer
  • Create and format HierarchySlicer
  • Advantages of HierarchySlicer

21. Visualizing Categorical Data
  • Create and Format Bar and ColumnCharts
  • Create and Format Stacked Bar Chart Stacked ColumnChart
  • Create and Format Clustered Bar Chart, Clustered ColumnChart
  • Create and Format 100% Stacked Bar Chart, 100% Stacked ColumnChart
  • Create and Format Pie and DonutCharts
  • Create and Format the Tree MapVisual
  • Create and Format ScatterCharts

22. Visualizing Trend Data
  • Line and AreaCharts
  • Create and Format Line Chart, Area Chart, Stacked AreaChart
  • ComboCharts
  • Create and Format Line and Stacked Column Chart, Line and Clustered ColumnChart
  • Create and Format Ribbon Chart, Waterfall Chart, FunnelChart

 


23. Visualizing KPI Data
  • Create and Format Gauge Visual, KPIVisual
  • Create and Format Card Visualization, Multi RowCard

 


24. Visualizing Tabular Data, Geographical Data & R Script Visual
  • Create and Format Table Visual, MatrixVisualization
  • Create and Format Map Visual, Filled Map Visual, Arc GIS MapsVisual
  • Create and Format R ScriptVisual

25. Power BI Service Introduction
  • Power BI Service Introduction, Power BI CloudArchitecture
  • Creating Power BI Service Account, SIGN IN to Power BI ServiceAccount
  • Publishing Reports to the Power BI service, Import / Getting the Report to PBIService
  • My Workspace / App WorkspacesTabs
  • DATASETS, WORKBOOKS, REPORTS,DASHBOARDS
  • Working with Datasets, Creating Reports in Cloud using PublishedDatasets
  • Power BI Datasets Live Connection usingDesktop
  • Working with Workbooks, working with Reports, SharingReports

 


26. Dashboards Development
  • CreatingDashboards
  • Pin Visuals and Pin LIVE Report Pages toDashboard
  • Advantages ofDashboards
  • Interacting withDashboards
  • Adding Tiles toDashboards
  • Web Content, Image, Text Box, Video
  • FormattingDashboard
  • SharingDashboard

27. Data Gateways
  • Introduction to DataGateways
  • How Data Gateways Work
  • Connect to an on premise Data Source by using a DataGateway
  • Download DataGateway
  • Installing a DataGateway
  • Types ofGateways
  • On-premises Data Gateway, On-premises Data Gateway (personal mode)
  • Manage DataGateway
  • Add and RemoveAdministrators
  • Add Data Source, Add or Remove Users to a DataSource
  • Refresh On PremiseData
  • Configuring Automatic Refresh usingSchedules

28. Collaboration in Power BI using App Workspace
  • Introduction to AppWorkspaces
  • Create an AppWorkspace
  • Add Members to App Workspace toCollaborate
  • App WorkspaceAccess
  • Admin, Member,Contributor

29. Sharing Power BI Content using Apps and Content Packs
  • Introduction toApp
  • Publish anApp
  • Update a PublishedApp
  • Manage Content inApp
  • Include in App, Exclude inApp
  • SharingApp
  • Entire Organization, Specific individuals or group
  • Un publishing anApp
  • Content PackIntroduction
  • Create ContentPack
  • Sharing ContentPacks
  • Specific Groups, My Entire Organization
  • Selecting the Content / Items to Publish orShare

30. Row Level Security in Power BI
  • Introduction to Row LevelSecurity
  • Row Level Security (RLS) withDAX
  • Manage Roles, Creating Roles, TestingRoles
  • Adding Members to Roles in Power BIService
  • Dynamic Row LevelSecurity
  • Creating Users Table and Adding to theModel
  • Capturing users using UserName () or UserPrincipalName () DAXFunctions

31. ADD ON
  • Real-time ProjectHands On.
  • ResumePreparation
  • Interview QuestionsDiscussions
  • MockInterviews

    Power - BI Curriculum

    • Power BIIntroduction
    • Data Visualization,Reporting
    • Business Intelligence(BI), Traditional BI, Self-ServicedBI
    • Cloud Based BI, On PremiseBI
    • Power BIProducts
    • Power BI Desktop (Power Query, Power Pivot, PowerView)
    • Flow of Work in Power BIDesktop
    • Power BI Report Server, Power BI Service, Power BIMobile
    • Flow of Work in Power BI / Power BIArchitecture
    • A Brief History of PowerBI

    • Power BI Desktop Installation
    • Building Blocks of PowerBI
    • Datasets, Visualizations, Reports, Dashboards,Tiles
    • Power BI Desktop UserInterface
    • Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab,Canvas
    • Overview of Power Query / Query Editor – Extract, Transform & LoadData
    • Connecting to Data Sources, Establish connection to the Excelsource
    • Importing Data into Power BI or QueryEditor
    • Transforming the Data using PowerQuery
    • Model the Data using Power Pivot – RelationshipView
    • Creating New Measures and New Columns using DAX – DataView
    • Visualizing the Data using Power View and Power Maps – ReportView
    • Saving and Publishing the Visuals orReports
    • Logon to Power BIService
    • View the Reports in PBI Service and Share thereports

     

    • Data Transformation, Benefits of DataTransformation
    • Shape or Transform Data using PowerQuery
    • Overview of Power Query / Query Editor, Query Editor UserInterface
    • The Ribbon (Home, Transform, Add Column, ViewTabs)
    • TheQueriesPane,TheDataView/ResultsPane,TheQuerySettingsPane,FormulaBar
    • Advanced Editor – Complete ETLCode
    • Saving Your Work – Appling ETL Changes – Loading into Power PivotModel
    • Power QueryConceptually

    • Remove Columns / Remove OtherColumns
    • Name / Rename aColumn
    • Reorder Columns or SortColumns
    • Add Column / CustomColumn
    • SplitColumns
    • MergeColumns
    • PIVOT, UNPIVOTColumns
    • TransposeColumns

    • Header Row or Use First Row asHeaders
    • Keep Top Rows, Keep BottomRows
    • Keep Range ofRows
    • Keep Duplicates, KeepErrors
    • Remove Top Rows, Remove Bottom Rows, Remove AlternativeRows
    • Remove Duplicates, Remove Blank Rows, RemoveErrors
    • Group Rows / GroupBy

    Append Queries / Union Queries
    • AppendQueries
    • Append Queries asNew
    • Append 2 or more files individually with different queries
    • Appending multiple files of same type from a folder using single query
    • QueryOptions
    • Copy Query, PasteQuery
    • Delete Query, RenameQuery
    • Enable Load, Include in reportRefresh
    • Duplicate Query, Reference Query
    • Move to Group, Move Up, MoveDown
    Merge Queries / Join Queries
      • Merge Queries, Merge Queries asNew
      • Default Types of Joins / Join Kinds / MergeType
        • Left Outer (all from first, matching from second)
        • Right Outer (all from second, matching fromfirst)
        • Full Outer (all rows from both)
        • Inner (only matching rows)
        • Left Anti (rows only infirst)
        • Right Anti (rows only in second)
      • Cartesian Join or CrossJoin

    • Data ModelingIntroduction
    • Relationship, Need ofRelationship
    • Relationship Types / Cardinality inGeneral
    • 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 ReferentialIntegrity

    • What is DAX, Calculated Column,Measures
    • DAX Table and Column NameSyntax
    • Creating Calculated Columns, CreatingMeasures
    • Implicit Vs ExplicitMeasures
    • Calculated Columns VsMeasures
    • DAX Syntax & Operators
    • DAX Operators
    • Types ofOperators
    • Arithmetic Operators, Comparison Operators, Text Concatenation Operator, Logical Operators

    • Date and TimeFunctions
    • LogicalFunctions
    • TextFunctions
    • Math & Statistical Functions
    • FilterFunctions
    • Time IntelligenceFunctions

    • YEAR, MONTH,DAY
    • WEEKDAY, WEEKNUM
    • FORMAT (Text Function) 🡪Month Name, WeekdayName
    • DATE, TODAY,NOW
    • HOUR, MINUTE, SECOND,TIME
    • DATEDIFF, CALENDAR
    • Creating Date DimensionTable

    • LEN, CONCATENATE(&)
    • LEFT, RIGHT,MID
    • UPPER,LOWER
    • TRIM, SUBSTITUTE,BLANK

    • INT
    • ROUND, ROUNDUP,ROUNDDOWN
    • DIVIDE
    • EVEN,ODD
    • POWER, SIGN
    • SQRT, FACT
    • SUM, SUMX
    • MIN,MINX
    • MAX, MAXX
    • COUNT, COUNTX
    • AVERAGE, AVERAGEX
    • COUNTROWS,COUNTBLANK

    • Time IntelligenceIntroduction
    • TOTALMTD, TOTALQTD,TOTALYTD
    • PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER,PREVIOUS YEAR
    • NEXTDAY, NEXT MONTH, NEXT QUARTER,NEXT YEAR
    • SAMEPERIODLASTYEAR
    • YOYGrowth
    • MOMGrowth

    • Report View UserInterface
    • Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab,Canvas
    • VisualInteractions
    • Interaction Type (Filter, Highlight,None)
    • Visual Interactions Default Behavior, Changing theInteraction

     

    • Report View UserInterface
    • Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab,Canvas
    • VisualInteractions
    • Interaction Type (Filter, Highlight,None)
    • Visual Interactions Default Behavior, Changing theInteraction

    • FilterTypes
    • Visual Level Filters, Page Level Filters, Report Level Filters, Drill ThroughFilters
    • Filter SubTypes
    • Basic Filtering, Advanced Filtering, Top N, Relative DateFiltering
    • Numeric field filters, Text field filters, Date and Time fieldFilters

     

    • Grouping and BinningIntroduction
    • Using grouping, Creating Groups on TextColumns
    • Using binning, Creating Bins on Number Column and DateColumns
    • Sorting Data inVisuals
    • Changing the Sort Column, Changing the SortOrder
    • Sort using column that is not used in theVisualization
    • Sort using the Sort by Columnbutton

    • Hierarchy Introduction, Default DateHierarchy
    • Creating Hierarchy, Creating Custom DateHierarchy
    • Change HierarchyLevels
    • Drill-Up and Drill-DownReports
    • Data Actions, Drill Down, Drill Up, Show Next Level, Expand NextLevel
    • Drilling filters other visuals option

     

    • Visualizing Data, WhyVisualizations
    • Visualization types, Field Wells
    • Visuals for Filtering, Visualizing Categorical Data, Visualizing TrendData
    • Visualizing KPI Data, Visualizing Tabular Data, Visualizing GeographicalData
    • Leveraging Power BI CustomVisuals

     

    • Slicer Visualization
    • When to use aSlicer
    • Create and format SlicerVisualization
    • Hierarchy Slicer (CustomVisualization)
    • When to use a HierarchySlicer
    • Create and format HierarchySlicer
    • Advantages of HierarchySlicer

    • Create and Format Bar and ColumnCharts
    • Create and Format Stacked Bar Chart Stacked ColumnChart
    • Create and Format Clustered Bar Chart, Clustered ColumnChart
    • Create and Format 100% Stacked Bar Chart, 100% Stacked ColumnChart
    • Create and Format Pie and DonutCharts
    • Create and Format the Tree MapVisual
    • Create and Format ScatterCharts

    • Line and AreaCharts
    • Create and Format Line Chart, Area Chart, Stacked AreaChart
    • ComboCharts
    • Create and Format Line and Stacked Column Chart, Line and Clustered ColumnChart
    • Create and Format Ribbon Chart, Waterfall Chart, FunnelChart

     

    • Create and Format Gauge Visual, KPIVisual
    • Create and Format Card Visualization, Multi RowCard

     

    • Create and Format Table Visual, MatrixVisualization
    • Create and Format Map Visual, Filled Map Visual, Arc GIS MapsVisual
    • Create and Format R ScriptVisual

    • Power BI Service Introduction, Power BI CloudArchitecture
    • Creating Power BI Service Account, SIGN IN to Power BI ServiceAccount
    • Publishing Reports to the Power BI service, Import / Getting the Report to PBIService
    • My Workspace / App WorkspacesTabs
    • DATASETS, WORKBOOKS, REPORTS,DASHBOARDS
    • Working with Datasets, Creating Reports in Cloud using PublishedDatasets
    • Power BI Datasets Live Connection usingDesktop
    • Working with Workbooks, working with Reports, SharingReports

     

    • CreatingDashboards
    • Pin Visuals and Pin LIVE Report Pages toDashboard
    • Advantages ofDashboards
    • Interacting withDashboards
    • Adding Tiles toDashboards
    • Web Content, Image, Text Box, Video
    • FormattingDashboard
    • SharingDashboard

    • Introduction to DataGateways
    • How Data Gateways Work
    • Connect to an on premise Data Source by using a DataGateway
    • Download DataGateway
    • Installing a DataGateway
    • Types ofGateways
    • On-premises Data Gateway, On-premises Data Gateway (personal mode)
    • Manage DataGateway
    • Add and RemoveAdministrators
    • Add Data Source, Add or Remove Users to a DataSource
    • Refresh On PremiseData
    • Configuring Automatic Refresh usingSchedules

    • Introduction to AppWorkspaces
    • Create an AppWorkspace
    • Add Members to App Workspace toCollaborate
    • App WorkspaceAccess
    • Admin, Member,Contributor

    • Introduction toApp
    • Publish anApp
    • Update a PublishedApp
    • Manage Content inApp
    • Include in App, Exclude inApp
    • SharingApp
    • Entire Organization, Specific individuals or group
    • Un publishing anApp
    • Content PackIntroduction
    • Create ContentPack
    • Sharing ContentPacks
    • Specific Groups, My Entire Organization
    • Selecting the Content / Items to Publish orShare

    • Introduction to Row LevelSecurity
    • Row Level Security (RLS) withDAX
    • Manage Roles, Creating Roles, TestingRoles
    • Adding Members to Roles in Power BIService
    • Dynamic Row LevelSecurity
    • Creating Users Table and Adding to theModel
    • Capturing users using UserName () or UserPrincipalName () DAXFunctions

    • Real-time ProjectHands On.
    • ResumePreparation
    • Interview QuestionsDiscussions
    • MockInterviews

0.0
0 total
5
0
4
0
3
0
2
0
1
0

Course Features

  • Students Limited
  • Certificate Yes
  • Skill Advance
  • Category Instrumentation

Request for Free Demo

    Training Features

    Live Online Training

    Live online training session will be given by our trainers and are available to answer your queries.

    Time flexibility

    We conduct classes in most of the day. We are flexible to train you according to your schedule.

    Real time scenario

    All of our trainers are come from different industry they are experts in explaining scenarios that are happening in real time.

    Best IT Leading Software Training Institute

    Talk with Bodh IT