Course: Power BI with DAX
Duration: 30 Hours
Topics:
POWER BI DESKTOP
Introduction to Power BI Desktop
Different data sources (excel, csv, SQL server, SSAS, web, Azure)
Data types and Categories
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
Modeling and Filters in Power BI
MERGING AND APPENDING QURIES
Data Modeling in Power BI
Cross filter direction in modeling
Bins and list in Grouping
Different Kind of Themes in Powerbi
How to import and use Custom visuals
Different kind of filters in Power BI Desktop
Report Level
Page Level
Visual Level
Drill through
Scatter chart by using play axis option
Word cloud
Slicer
ArcGIS 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
Different kind of licenses Free Pro and Premium
How to create workspace
How to create Dashboards
Delivery Methods of Dashboard
How to create powerBI Apps
What is Content Packs?
Data Gateways and schedule refresh
Row Level Security
Row Level Security in PowerBI Desktop
Row level security in Power BI Service
Row level security in powerBI dynamic
Power BI Reporting Services
Q&A Natural Language Processing option in PowerBI
Quick Insights
Dashboards and Pins - Real-time Usage
Dynamic Data Sources and Encryptions
Personal and Organizational Content Packs
Gateways, Subscriptions, Mobile Reports
How to Schedule Data Refresh
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
POWER BI DAX EXPRESSIONS
Purpose of Data Analysis Expressions (DAX)
Calculated Columns and Calculated Measures with 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
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
YTD, QTD, MTD Calculations with DAX
DAX Calculations and Measures
Using TOPN, RANKX
Computations using STDEV & VAR
SAMPLE Function, COUNTALL, ISERROR
ISTEXT, DATEFORMAT, TIMEFORMAT
Time Intelligence Functions with DAX
Data Analysis Expressions and Functions
DATESYTD, DATESQTD, DATESMTD
ENDOFYEAR, ENDOFQUARTER, ENDOFMONTH
FIRSTDATE, LASTDATE, DATESBETWEEN
Slicing and Dicing Options with Columns, Measures
DAX for Query Extraction, Data Mashup Operations
No comments:
Post a Comment