This advanced workshop covers DAX, time intelligence, and dynamic reporting techniques to create interactive, insight-driven dashboards.
Overview
Advanced Dax techniques
- Creating and using Calculated Columns
- Introduction to DAX with a variety of DAX examples
- Calculated columns vs Measures
Time Intelligence Functions
- Total Year to Date
- Date Add
- Year over Year %
- And examples of many other Time Intelligence functions
Dynamic Titles on Visuals
- SELECTEDVALUE DAX function to create dynamic titles
Dynamic Report and Visualisation techniques
- Conditional Formatting
- Tooltips
- Report Page tooltips
= Drill throughs
- Drill downs
- Editing default Interactivity
- Bookmarks and Buttons
Speaker: Celia Henderson
Experienced learning and development professional providing a comprehensive package of training and support services in the private and public sectors – health, financial, legal, banking, investment, education, land-based, automotive and commercial. Contracts require me to be involved in all stages of the training process, from identifying training needs through to collection and analysis of delegate and manager post-training feedback. Friendly and approachable with a love of learning and sharing knowledge and skills.
Celia describes herself as a competent, conscientious and energetic trainer; an experienced learning and development professional with a natural ability and enthusiasm to assimilate and disseminate new technologies and soft skills. Committed to delivering first class training enabling learners and clients to meet and exceed their expectations. A confident decision maker who communicates effectively and works well with individuals and teams at all levels. Celia owned and ran her own Recruitment and Training company in West Sussex for 15 years employing full time staff and managing a team of 200 temporary staff. She has worked in Learning and Development since 1995