Power Bi Online Training Contact Number: 9398511432


                            


                          Power BI Complete Introduction



Power BI Introduction

  1. Data Visualization, 
  2. Reporting
  3. Business Intelligence (BI)
  4. Flow of Work in Power BI Desktop
  5. Flow of Work in Report server Power BI Desktop
  6. Power BI Report Server, Power BI Service 
  7. Power BI Mobile
  8. Flow of Work in Power BI / Power BI Architecture
  9. A Brief History of Power BI

PBI Desktop Installation, PBI Desktop & Service Overview

  1. Power BI Desktop Installation
  2. Datasets, Visualizations,
  3. Reports, 
  4. Dashboards
  5. Power BI Desktop User Interface
  6. Fields Pane, 
  7. Visualizations pane, 
  8. Ribbon, 
  9. Views, 
  10. Pages Tab
  11. Overview of Power Query / Query Editor - Extract, Transform & Load Data
  12. Connecting to Data Sources, Establish connection to the Excel source, 
  13. notepad, 
  14. sql
  15. Importing Data into Power BI or Query Editor
  16. Transforming the Data using Power Query
  17. Creating New Measures and New Columns and tables using DAX – Data View
  18. Saving and Publishing the Visuals or Reports
  19. Logon to Power BI Service
  20. View the Reports in PBI Service and Share the reports

Power Query

 Introduction to Power Query – Extract, Transform & Load

  1. Data Transformation, 
  2. Benefits of Data Transformation
  3. Shape or Transform Data using Power Query
  4. Overview of Power Query / Query Editor, 
  5. Query Editor User Interface
  6. The Ribbon (Home, Transform, Add Column, View Tabs)
  7. The Queries Pane, The Data View / Results Pane, 
  8. The Query Settings Pane, 
  9. Formula Bar
  10. Advanced Editor – Complete ETL Code
  11. Saving Your Work – Appling ETL Changes – Loading into Power Pivot Model
  12. Power Query Conceptually

Datatypes and Filters in Power Query

  1. Datatypes, 
  2. Changing the Datatype of a Column
  3. Filters in Power Query
  4. Filter a Column using Text Filters
  5. Filter a Column using Number Filters
  6. Filter a Column using Date Filters
  7. Filter Multiple Columns

Inbuilt Column Transformations

  1. Remove Columns / Remove Other Columns
  2. Name / Rename a Column
  3. Reorder Columns or Sort Columns
  4. Add Column / Custom Column
  5. Split Columns
  6. Merge Column
  7. Transpose Columns
  8. Header Row or Use First Row as Headers
  9. Keep Top Rows, Keep Bottom Rows
  10. Keep Range of Rows
  11. Keep Duplicates, Keep Errors
  12. Remove Top Rows, Remove Bottom Rows, 
  13. Remove Alternative Rows
  14. Remove Duplicates, Remove Blank Rows, 
  15. Remove Errors
  16. Group By

Combine Queries (Append Queries & Merge Queries)

  1. Append Queries / Merge Queries
  2. Query Options
  3. Copy Query, Paste Query
  4. Delete Query, Rename Query
  5. Enable Load, Include in report Refresh
  6. Duplicate Query, Reference Query
  7. Move to Group, Move Up, Move Down

Power Pivot

  1. Power BI Data Modelling – Relationship View
  2. Data Modelling Introduction
  3. Relationship, 
  4. Need of Relationship
  5. Relationship Types / Cardinality in General
  6. One-to-One, One-to-Many (or Many-to-One), 
  7. Many-to-Many
  8. AutoDetect the relationship, 
  9. create a new relationship, 
  10. Edit existing relationships
  11. Make Relationship Active or Inactive
  12. Delete a relationship

Enhancing the Data Model – DAX

  1. What is DAX, 
  2.  Measures,
  3. DAX Table and Column Name Syntax,
  4. Creating Calculated Columns, 
  5. Creating Measures,
  6. Calculated Columns Vs Measures,
  7. DAX Syntax & Operators
  8. DAX Operators
  9. Types of Operators
  10. Arithmetic Operators, 
  11. Comparison Operators, 
  12. Text Concatenation Operator, 
  13. Logical Operators

 DAX Functions Categories

  1. Date and Time Functions
  2. Logical Functions
  3. Text Functions
  4. Math & Statistical Functions
  5. Filter Functions
  6. Time Intelligence Functions
  7. DAX Date & Time Functions
  8. Information Functions


  1. Date and Time Functions

  1. YEAR, 
  2. MONTH, 
  3. DAY
  4. WEEKDAY, 
  5. WEEKNUM
  6. FORMAT (Text Function) Month Name, 
  7. Weekday Name
  8. DATE, 
  9. TODAY, 
  10. NOW
  11. HOUR, 
  12. MINUTE, 
  13. SECOND, 
  14. TIME
  15. DATEDIFF, 
  16. CALENDAR
  17. DATEVALUE, 
  18. TIMEVALUE
  19. UTCNOW, 
  20. UTCTODAY

DAX Text Functions

  1. LEN, 
  2. CONCATENATE,
  3. LEFT, 
  4. RIGHT, 
  5. MID
  6. UPPER, 
  7. LOWER
  8. TRIM, 
  9. SUBSTITUTE, 
  10. BLANK
  11. CODE, 
  12. EXACT
  13. FIND, 
  14. FIXED
  15. TRIM, 
  16. UNICHAR
  17. SEARCH, 
  18. VALUE, 
  19. FORMAT

DAX Logical Functions

  1. IF, 
  2. TRUE, 
  3. FALSE
  4. IFERROR,
  5.  IN
  6. SWITCH, 
  7. AND, 
  8. NOT

DAX Math and Statistical Functions

  1. CURRENCY, 
  2. RAND
  3. INT, 
  4. ABS
  5. ROUND, 
  6. ROUNDUP, 
  7. ROUNDDOWN,
  8. RAND BETWEEN, 
  9. DIVIDE
  10. EVEN, 
  11. ODD
  12. SQRT, 
  13. FACT
  14. SUM, 
  15. SUMX
  16. MIN, 
  17. MINX
  18. COUNT, 
  19. COUNTX
  20. AVERAGE, 
  21. AVERAGEX
  22. COUNTROWS, 
  23. COUNTBLANK
  24. CROSSJOIN, 
  25. DISTINCTCOUNT
  26. MEDIAN, 
  27. RANKX, 
  28. TOPN

Other Functions

  1. CONVERET, 
  2. DATATABLE
  3. GENERATESERIES, 
  4. GROUPBY
  5. UNION, 
  6. VAR

DAX Filter Functions

  1. CALCULATE, 
  2. ALLXECPT
  3. ALL,  
  4. DISTINCTCOUNT
  5. FILTER
  6. SELECTEDVALUE

DAX Time Intelligence Functions

Time Intelligence Introduction
  1. CLOSINGBALANCEMONTH, 
  2. DATEADD
  3. DATESBETWEEN,
  4.  DATESINPERIOD
  5. DATESMTD, 
  6. DATESYTD,
  7. TOTALMTD, 
  8. TOTALYTD
  9. ENDOFMONTH, 
  10. FIRSTDATE
  11. LASTDATE, 
  12. STARTOFMONTH, 
  13. SAMEPERIODLASTYEAR

Information Functions

  1. CONTAINS, 
  2. ISBLANK
  3. ISERROR,
  4. ISEVEN
  5. ISNONTEXT, 
  6. ISTEXT
  7. ISODD, 
  8. ISNUMBER
  9. USERNAME

Power Bi Desktop

Tool Tips

  1. Felid level tool tips, 
  2. Default tool tips
  3. Page level tool tips, 
  4. Text level tool tips
  5. Visual header tool tips

Conditional Formatting 

  1. Text conditional formatting
  2. Border conditional formatting
  3. Background conditional formatting
  4. Font conditional formatting
  5. Data bars conditional formatting
  6. Conditional formatting icons

Other Options

  1. Buttons, 
  2. shapes
  3. Images, 
  4. New parameter
  5. What if parameter, 
  6. Gridlines
  7. Lock objects, 
  8. Bookmarks,
  9. Selection, 
  10. Performance analyser,
  11. Sync slicers, 
  12. edit interactions
  13. Enter data, 
  14. recent sources, 
  15. refresh
  16. Data grouping, 
  17. visual analysing

·         Visualizations

  1. Stacked bar chart, 
  2. Stacked column chart
  3. Clustered bar chart, 
  4. Clustered column chart
  5. 100% stacked bar chart, 
  6. 100% stacked column chart
  7. Line chart, Area chart
  8. Stacked area chart, 
  9. Line and stacked column chart
  10. Line and clustered column chart, 
  11. Ribbon chart
  12. Waterfall chart, 
  13. Scatter chart
  14. Pie chart, 
  15. Donut chart
  16. Treemap, 
  17. Filled map
  18. map, Funnel

Introduction to office 365

  1. What is office 365
  2. Download custom visuals

Custom Visuals

  1. Bar chart, 
  2. Chartaccentbarchart
  3. Hierarchy slicer, 
  4. Linedotchart
  5. Multi slicer, 
  6. Pivotslicer table heatmap
  7. Tornado chart

Filters in Power View

Filter Types

  1. Visual Level Filters, 
  2. Page Level Filters, 
  3. Report Level Filters, 
  4. Drill Through Filters
  5. Filter Sub Types
  6. Basic Filtering, 
  7. Advanced Filtering, 
  8. Top N, 
  9. Relative Date Filtering
  10. Numeric field filters, 
  11. Text field filters, 
  12. Date and Time field Filters

Hierarchies and Drill-Down Reports

  1. Hierarchy Introduction,
  2. Default Date Hierarchy,
  3. Creating Hierarchy,
  4. Creating Custom Date Hierarchy
  5. Change Hierarchy Levels
  6. Drill-Up and Drill-Down Reports,
  7. Drill Down, 
  8. Drill Up, 
  9. Show Next Level, 
  10. Expand Next Level
  11. Drilling filters other visuals option

Visualizing KPI Data

  1. Create and Format Gauge Visual, 
  2. KPI Visual
  3. Create and Format Card Visualization, 
  4. Multi Row Card
  5. Create and Format Table Visual, 
  6. Matrix Visualization
  7. Create and Format Map Visual, 
  8. Filled Map Visual

Power BI Service

  1. Power BI Service Introduction 
  2. Power BI Cloud Architecture
  3. Creating Power BI Service Account, 
  4. SIGN IN to Power BI Service Account
  5. Publishing Reports to the Power BI service, 
  6. Import / Getting the Report to PBI Service
  7. My Workspace / App Workspaces Tabs
  8. DATASETS, 
  9. REPORTS, 
  10. DASHBOARDS
  11. Creating Reports in Cloud using Published Datasets
  12. Power BI Datasets Live Connection using Desktop
  13. working with Reports, 
  14. Sharing Reports
  15. Creating new reports in services
  16. Embedding to web, 
  17. share report link

Dashboards Development

  1. Creating Dashboards Pin Visuals and Pin LIVE Report Pages to Dashboard
  2. Advantages of Dashboards
  3. Interacting with Dashboards
  4. Formatting Dashboard
  5. Sharing Dashboard

Data Gateways

  1. Introduction to Data Gateways
  2. How Data Gateways work
  3. Connect to an on-premise Data Source by using a Data Gateway
  4. Download Data Gateway
  5. Installing a Data Gateway
  6. Types of Gateways
  7. On-premises Data Gateway, On-premises Data Gateway (personal mode)
  8. Manage Data Gateway
  9. Refresh on Premise Data

Configuring Automatic Refresh using Schedules

  1. Collaboration in Power BI using App Workspace
  2. Introduction to App Workspaces
  3. Create an App Workspace
  4. Add Members to App Workspace to Collaborate
  5. App Workspace Access
  6. Admin, Member,
  7. Contributor

Sharing Power BI Content using Apps and Content Packs

  1. Introduction to App
  2. Publish an App
  3. Update a Published App
  4. Manage Content in App
  5. Entire Organization, 
  6. Specific individuals or group
  7. Content Pack Introduction
  8. Create Content Pack
  9. Sharing Content Packs
  10. Specific Groups, 
  11. My Entire Organization
  12. Selecting the Content / Items to Publish or Share
  13. Row Level Security in Power BI
  14. Introduction to Row Level Security

ADD ON

  1. Resume Preparation
  2. Interview Questions
  3. 10 Real time DAX Query’s preparation 


2 comments:

  1. Hafsa shaikhJune 15, 2021 at 11:41 PM

    Power BI Custom Visuals Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info.

    ReplyDelete
  2. SharaMay 27, 2022 at 10:37 PM

    Thanks for sharing Information.Nice Blog
    Power Bi Online Training in Hyderabad
    Power BI Training in Ameerpet

    ReplyDelete

Subscribe to: Posts (Atom)