POWER BI

• POWER BI INTRODUCTION

• Power bi Features
• Data Warehousing Concepts
• Different tools available in Market
• Power Bi Capabilities
• Advantages and disadvantages with Power Bi
• Types of Certifications
• Power Bi Licenses types

Ø  POWER BI BASIC EXAMPLES

• Using Power BI Desktop Tool - Options
• Report Visuals, Fields, Pages and Filters
• Report, Data and Relationship Options
• Working with Visualizations and PBI Canvas
• Working with Enter Data, Get Data Options
• Get Data from DAT Files, Basic Reports
• Enter Data from Excel Files, Basic Reports
• Concept & Use of PBIX and PBIT Files
• Creating PBIX Files and Re-Using Reports
• Creating PBIT Files & Data Import Options
• Designing Simple / Basics Reports in PBI
• Visual Interactions in Power BI - Options
• Spotlight Options with Visuals, Real-time Use
• Slicer Visual in Power BI and Data Filters
• Reusing Slicer across multiple Report Pages
• Visual Sync Property, two directional Filters

Ø  HIERARCHIES & FILTERS

• Grouping and Binning with Fields
• Bin Size and Biz Limits (Max, Min)
• Creating Hierarchies. Drilldown Reports
• Drill Thru Reports and Conditional Filters
• Expand, Expand All Down, Go to Next Level
• Drill Up, Drill Down. Exclude & Include
• See Data, Export Data, See Records Options
• Filters : Types and Usage in Real-time
• Visual Filters, Page Filters, Report Filters
• Drill-thru Filters with Hierarchy Levels
• Basic, Advanced, TOP N Filters - Usage
• Filtering at Category Level, Summary Level
• OLTP and OLAP Databases with Power BI
• On-premise & Azure Cloud Database Access
• Import and Direct Query with Power BI
• Connect LIVE options with OLAP Databases

Ø  Power BI Visuals - Level 1

• Power BI Visualizations and Types
• Fields, Formats and Analytics Options
• Table Visuals & Properties, Filters
• Data Bar and Data Scaling Options
• Divergent Colors and Data Labelling
• Conditional Formatting, Grid Lines
• Matrix : Sub Totals, Grand Totals
• Drilldown Options : Row and Column
• Row Groups and Column Groups in Matrix
• Slicer Visual - Properties, Alignment
• Single Select and Show All Options
• Chart Reports - Types, Common Properties
• Axis, Legend, Value and Tooltip Options
• Stacked Bar Chart, Clustered Column Chart
• Stacked Bar Chart : Properties, Use
• Stacked Column Chart : Properties, Use
• Clustered Bar Chart : Properties, Use
• Clustered Column Chart : Properties
• 100% Stacked Bar and Column Charts
• Data Label Properties, Legend Properties
• Comparing Bar Charts and Column Charts

Ø  Power BI Visuals - Level 2

• Line Chart, Area Chart Properties, Usage
• Stacked Area Chart - Properties, Usage
• Line and Stacked Column Charts Usage
• Line and Clustered Column Chart Usage
• Visual Fields, Shared Axis, Legend
• Column Series and Column Axis in Lines
• Join Types, Lines: Round, Bevel & Miter
• Shapes and Markers in Power BI Visuals
• X Axis, Y Axis Properties, Plot Area
• Display Units, Data Colors, Shapes
• Series, Custom Series and Legends
• Ribbon Chart - Properties, Line Width
• Match Series and Plot Area Options
• Waterfall Chart - Sentiment Colors
• Breakdown Count - Decrease / Increase
• Scatter Chart - Play Area and Axes
• Axis Values, Colour Saturation, Legend
• Line and Donut Charts - Properties
• Inner Radius, Details and Values
• Data Point and Series Limitations

Ø  Power BI Visuals - Level 1

• Tree Map, Funnel and Gauge Reports
• Group and Values in Tree Map Visuals
• Max Values and Goal Indicators
• Single Row Card and Multi Row Cards
• Non-Interactive Visuals in MultiRow
• Callout Values in KPI Reports and Use
• Indicator, Trend and Target Goals in KPIs
• Map Reports and Filled Map Reports
• ArcGIS Maps - Latitudes and Longitudes
• Using Buttons, Images in Power BI Canvas
• Bookmarks in Power BI Desktop - Usage
• Using Bookmarks with Buttons, Actions
• Using Bookmarks for Visual Filters
• Using Bookmarks for Page Navigations
• Using Selection Pane with Bookmarks
• Buttons, Images in Power BI Desktop

Ø  POWER Query - Level 1

• Power Query [M Language] - Purpose
• Power Query Usage & Operation Types
• Power Query Architecture and Usage
• QUERY Concept, Properties, Validations
• Power Query - Data Mash Up Operations
• Basic Data Types, Literals and Values
• Expressions, Primitives in M Language
• Structured Data Values in Power Query
• LIST, RECORD, TABLE in Power Query
• Power Query Connection Format Settings
• let, source, in statements in M Lang
• Functions, Parameters in Power Query
• INVOKE Functions & Execution Results
• Power BI Canvas: Edits, Applied Steps
• Frowns, Query Header Row Formatting

Ø  POWER query - Level 2

• Power Query Transformations Categories
• Query Combine & MERGE Transformations
• Join Options in Merge Transformation
• Truncate, Replace, Split, Reduce Rows
• Manage Columns, Hide / Show Columns
• Grouping, Aggregations, Column Formats
• Transpose, Reverse Rows Transformations
• Power Query - Row Count and Replace
• Data Type Detection - Scenarios, Use
• Data Type Conversions and Value Replace
• Fill Up and Fill Down, Rename Options
• PIVOT and UNPIVOT Transformations
• MOVE, FILTER and ConvertToList()
• SPLIT, FORMAT, MERGE Transformations
• EXTRACT, PARSE, NUMBER, COMBINE
• Working with Date, Time Transformations
• Deriving Year, Quarter, Month, Day

Ø  POWER Query - Level 3

• Intrinsic & Query Parameters, Usage
• Parameter Data Types, Default Value Lists
• Static Lists, Dynamic Lists For Parameters
• Creating Parameters in Data Set Queries
• Converting Columns to Lists in Power Query
• Dynamic Dropdowns, Multi Valued Parameters
• Data Conversions and toText() Functions
• FROWN and Token Comma Expression
• Applied Steps - Edits, New Steps
• DELETE and DELETE UNTIL END
• ENABLE LOAD and Grouping Queries
• .ELSE Conditions in Power Query
• Data Modelling Options - Custom Columns
• Columns From Examples, Indexed Column
• Conditional Column, Custom Functions
• Variables, Parameters - Power Query

Ø  DAX FUNCTIONS - LEVEL 1

• DAX : Importance and Real-time Usage
• DAX as library of Functions, Operators
• Real-world usage of DAX with Power BI
• Real-world usage of Excel, MSBI SSAS
• DAX Architecture and Entity Sets
• Formulation Rules for using DAX
• DAX Data Types and Working Options
• Syntax, Functions, Context Options
• Concept of Measures and Calculations
• ROW Context and Filter Context in DAX
• DAX Structures and Syntax Options
• DAX Functions and Types in Real-time
• Creating and Using Measures with DAX
• Creating and Using Columns with DAX
• Vertipaq Engine & Special Characters
• Operators in DAX - Real-time Usage
• DAX Formulas Limitations in Power BI

Ø  DAX FUNCTIONS - LEVEL 2

• Data Modelling Options in DAX
• Detecting & Adding Relations for DAX
• Power BI DAX Functions - Types, Usage
• Power BI DAX Functions - Cheat Sheet
• Power BI Reports - DAX Functionalities
• Calculated Columns, Aggregated Measures
• Quick Measures in DAX - Auto validations
• PowerPivot xVelocity & Vertipaq Store
• In-Memory Processing : DAX Performance
• Date and Time & Text Functions
• Time Intelligence Functions in DAX
• Logical & Mathematical Functions
• Data Modelling with DAX. Creating Roles
• SUM and DATEDIFF Examples in DAX
• TODAY, DATE, DAY Arguments with DAX
• DIVIDE, CALCULATE, Conditions
• Using Variables in DAX, Calculations
• .ELSE..THEN Statement in DAX
• SELECTEDVALUE, FORMAT Functions
• RELATED & COUNTROWS in DAX
• CALCULATE, SUM, ALL Functions

Ø  DAX FUNCTIONS - LEVEL 3

• AVERAGEX and AVERAGE in DAX
• KEEPFILTERS, COUNTROWS, RELATED
• DIVIDE with FILTER, ALLSELECTED
• ALL, MAX DAX, PARALLELPERIOD, DATEDADD
• CALCULATE with PREVIOUSMONTH
• FILTER with ROWCOUNT, USERELATIONSHIP
• TOTALYTD , TOTALQTD, TOTALMTD
• Time Intelligence with DIVIDE Functions
• Time Intelligence with CALCULATE
• DATESINPERIOD and AVERAGEX
• DAX Variables, Time Type Dimensions
• HOUR, NOW, SWITCH, TRUE
• RETURN Values with DAX Functions
• DAX Modelling Components - use
• TABLES, COLUMNS, RELATIONS
• MEASURES and HIERARCHIES
• INTELLISENSE with DAX Editors
• Comments in DAX - Syntax Options
• DISTINCTCOUNT and DIVIDE
• SAMEPERIODLASTYEAR, IF, VARIANCE

Ø  POWER BI CLOUD - 1

• Power BI Service (Cloud) Registration
• Power BI Service (Cloud) Architecture
• App Workspace Creation in Real-time
• Publish Reports from Power BI Desktop
• Reports, Datasets in Power BI Cloud
• Deployment Verifications in Cloud
• Creating Dashboards and Real-time Use
• Pin Visuals and Pin LIVE Report Pages
• Dashboard Creation with Tiles, Media
• Tiles - Images, Web Content, Chapters
• Subscriptions, Insights and Refresh
• Metrics, Distribution Methods, Actions
• View Related & Featured Dashboards
• Favourites, Shares, Dashboard Themes
• Performance Inspector and QR Codes

Ø  POWER BI CLOUD - 2

• Dataset Operations @ Power BI Cloud
• Dataset Actions - Report Creation Options
• Power BI LIVE Report Edits, Downloads
• Quick Insights and PBIX Downloads
• Content Packs in PBI Cloud in Real-time
• Creating and Using Content Packs
• Organizational, Service Content Packs
• Publishing App Workspace, Updates
• Dataset Refresh Options with DataSource
• Power BI Data Gateway - Architecture
• Gateway Installation, Configuration
• Using Gateways in Power BI Cloud
• SSO - Single Sign On Security Options
• Kerberos Authentication, Refresh Modes
• Incremental Loads, Gateway Versions
• Data Gateway and Privacy Levels
• PBIEngw Service and ODG Logs, Audits

Ø  EXCEL, SECURITY & ALERTS

• Using Excel with Power BI Reports
• Using Excel Analyzer in Power BI
• Using Excel Publisher in PBI Cloud
• Creating Datasets in Excel, Office 365
• Cell Selection and PINS in Power BI
• Excel Online Service - Edits and Pins
• Excel ODC Connections - Power Pivot
• Excel Workbooks, Reports, Dashboards
• Import and Upload Options in Excel
• Power Pivot Reports in with Excel
• Security Levels in Power BI Cloud
• Dashboard Security, Report Security
• Dataset Security - Read and Reshare
• App Workspace Security Management
• Creating, Managing Alerts in Cloud
• Row Level Security (RLS) with DAX

Ø  REST API & CUSTOM VISUALS

• REST APIs with Power BI Cloud Service
• Streaming Datasets Creation in Power BI
• API : Usage. SubKeys and Channels
• Push and pubNub Datasets in Power BI
• Azure Stream for Real-time Data Reports
• Real-time Data Tracking Visuals in PBI
• Power BI Database @ Streaming Datasets
• Use Streaming Datasets in Tiles in Cloud
• Use Power BI Dashboards with REST API
• Power BI Datasets Usage in PBI Desktop
• Marketplace Visuals and PBIVIZ Files
• HeatMaps - Visual, Real-time Usage
• FlowMaps - Visual, Real-time Usage
• Table HeatMaps with Real-time Usage
• GanttChart - Visual, Real-time Usage
• Data Caching Options in Power BI
• Preview Features in Power BI Desktop
• Shape Visual, JSON and XML Option