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.
LEARNING OBJECTIVE
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
WHO SHOULD ATTEND
- Hands-on learning with real-world scenarios
- Expert-led training sessions
- Practical exercises to reinforce learning
- Step-by-step guidance on DAX applications
- Immediate application of skills in Power BI
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 & drill through
- Report slicers & interactions
- Bookmarks & page navigation
- Numeric & fields parameters
“Unlock new opportunities by joining our training. Sign up now and invest in your future!“
