INTRODUCTION FOR POWER BI ADVANCED DAX ANALYSIS
Power BI has changed the definition of business intelligence (BI) tools. Taking tools that were historically reserved for data scientists and making them easy to use and economically available to business analysts has enabled an entire culture of self-service BI. This training is doing the same for data access programming. It breaks complex concepts into simple, easy-to-understand steps and frames them in a business context that makes it easy for you to start learning the DAX language and helps you solve real-world business challenges on a daily basis.
COURSE OBJECTIVES
This training will enable candidates to: –
- Understand what is DAX and its usage
- work with common DAX functions
- apply scalar functions
- apply logic functions
- apply filter functions
- apply table functions
- use DAX results in creating Dashboard
PREREQUISTE
Participants need to be familiar with Power BI data cleaning data visualization techniques. Knowledge of Excel Formulas and functions is strongly encouraged.
COURSE CONTENT
MODULE 1: Connecting & Shaping Data a Review
- Data connectors
- Storage & import modes
- Query editing tools
- Table transformations
- Connecting to a database
- Text, numerical, date & time tools
- Rolling calendars
- Index & conditional columns
- Grouping & aggregating
- Pivoting & unpivoting
- Merging & appending queries
MODULE 2: Creating a Relational Data Model
- Database normalization
- Fact & dimension tables
- Primary & foreign keys
- Star & snowflake schemas
- Active & inactive relationships
- Relationship cardinality
- Filter context & flow
- Bi-directional filters
- Model layouts
- Hierarchies
MODULE 3: Adding Calculated Fields with DAX
- DAX vs. M
- Calculated columns & measures
- Implicit, explicit & quick measures
- Measure calculation steps
- DAX syntax & operators
Module 4: Scalar Functions
- Common scalar functions
- Aggregation Functions
- SUM & SUMX
- Rounding Functions
Module 5: Conditional & logical functions
- IF logic
- AND Logic
Module 6: CALCULATE Function
- CALCULATE syntax
- Modifiers
- REMOVEFILTERS
- KEEPFILTERS
Module 7: Table and filter function
- DISTINCT
- VALUES
- SELETEDVALUE
- ALLEXCEPT
Module 8: Misc. functions
- The SWITCH function
- Text functions
- Date & time functions
- Iterator (X) functions
MODULE 9: Visualizing Data with Reports
- Data viz best practices
- Dashboard design framework
- Cards & KPIs
- Common charts
- Table & matrix visuals
- Conditional formatting
- Top N filtering
- Drill up, drill down & drillthrough
- Report slicers & interactions
- Bookmarks & page navigation
- Numeric & fields parameters
