POWER BI | Demo Vedio| Outline|Duration: 40 Hours |Class Room & Online Training

About POWER BI

Power BI is a cloud based data analysis, which can be used for reporting and data analysis from wide range of data source. Power BI is simple and user friendly enough that business analysts and power users can work with it and get benefits of it. On the other hand Power BI is powerful and mature enough that can be used in enterprise systems by BI developers for complex data mash-up and modelling scenarios.

Power BI Main Components

  • Power Query: Data mash up and transformation tool.
  • Power Pivot: In-memory tabular data modelling tool
  • Power View: Data visualization tool
  • Power Map: 3D Geo-spatial data visualization tool
  • Power Q&A: Natural language question and answering engine.
  • Power BI Desktop: A powerful companion development tool for Power BI
  • POWER BI COURSE OUTLINE:

    Power BI Desktop

    • Different data sources (Excel, Csv, Sql Server, SSAS, Web)
    • Direct Query And Import and Live connection
    • Parameters in power bi
    • Calculate Column Vs Calculated Measures
    • All Transformation Options in EDIT Query Window
    • How to create Customer Function
    • How to Invoke Custom Function
    • Templates in Power BI
    • Synonyms in Power BI
    • Hierarchies in Power BI
    • Import Excel workbook content
    • Modelling and Filters in Power BI
    • MERGING AND APPENDING QURIES
    • Cross filter direction in modelling
    • Bins and list in Grouping
    • Themes in power bi
    • Custom visuals
    • Filters(Visual Level, Report Level, Page Level, Drill through) in Power BI Desktop
    • Scatter chart by using play axis option
    • Word Cloud
    • Slicer
    • Archi maps enablement in power BI Desktop and service
    • Power BI publisher for Excel
    • Quick measures
    • Publish reports to Power BI Online

    Power BI Service(Online)

    • Introduction to Power BI Service
    • How to create Dashboards
    • Delivery Methods Of Dashboard
    • How to create power BI Apps
    • Data Gateways and schedule refresh
    • Row Level Security
    • Row Level Security in Power BI Desktop
    • Row level security in Power BI Service
    • Row level security in power BI dynamic
    • Power BI Reporting Services
    • Q&A Natural Language Processing option in Power BI
    • Quick Insights
    • Dashboards and Pins - Real-time Usage
    • Dynamic Data Sources and Encryptions
    • Personal and Organizational Content Packs
    • Gateways, Subscriptions, Mobile Reports
    • Data Refresh with Power BI Architecture
    • PBIX and PBIT Files with Power BI – Usage
    • Visual Data Imports and Visual Schemas
    • Cloud and On-Premise Data Sources
    • Relation between Dashboards to Reports
    • Relation between Datasets to Reports
    • Relation between Datasets to Dashboards
    • Page to Report - Mapping Options
    • Publish Options and Data Import Options
    • Need for PINS @ Visuals and PINS @ Reports

    Power BI DAX Expressions

    • Purpose of Data Analysis Expressions (DAX)
    • Scope of Usage with DAX. Usability Options
    • DAX Context : Row Context and Filter Context
    • DAX Entities : Calculated Columns and Measures
    • DAX Data Types : Numeric, Boolean, Variant, Currency
    • Date time Data Type with DAX. Comparison with Excel
    • DAX Operators & Symbols. Usage. Operator Priority
    • Parenthesis, Comparison, Arithmetic, Text, Logic
    • DAX Functions and Types: Table Valued Functions
    • Filter, Aggregation and Time Intelligence Functions
    • Information Functions, Logical, Parent-Child Functions
    • Statistical and Text Functions. Formulas and Queries
    • Syntax Requirements with DAX. Differences with Excel
    • Naming Conventions and DAX Format Representation
    • Working with Special Characters in Table Names
    • Attribute / Column Scope with DAX – Examples
    • Measure / Column Scope with DAX – Examples
    • YTD, QTD, MTD Calculations with DAX
    • DAX Calculations and Measures
    • Using TOPN, RANKX, RANK.EQ
    • Computations using STDEV & VAR
    • SAMPLE Function, COUNTALL, ISERROR
    • IS TEXT, DATE FORMAT, TIME FORMAT
    • Time Intelligence Functions with DAX
    • Data Analysis Expressions and Functions
    • DATE SYTD, DATE SQTD, DATE SMTD
    • END OF YEAR, END OF QUARTER,END OF MONTH
    • FIRST DATE, LAST DATE, DATES BETWEEN
    • CLOSING BALANCE YEAR, CLOSING BALANCE QTR
    • SAME PERIOD and PREVIOUS MONTH, QUARTER
    • KPIs with DAX. Vertipaq Queries in DAX
    • IF..ELSEIF.. Conditions with DAX
    • Slicing and Dicing Options with Columns, Measures
    • DAX for Query Extraction, Data Mashup Operations
    • Calculated Columns and Calculated Measures with DAX
    • Power BI Reporting Services with SSRS
    • R language integration with Power BI
    • M language in Power BI Desktop

    Courses We Offer


    Success!