Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction
- Survey of Power BI capabilities and architectural design
- Sophisticated utilities and data analytics within Power BI
Initial Setup
- Deployment of Power BI and associated components
- Process for structuring reports and dashboards
- Interface navigation overview
Power Query – Data Ingestion
- Connector types
- Query folding mechanisms
- Data extraction from diverse sources:
- Flat files
- Entire data folders
- Web-based sources
- Managing unstructured files
- Advanced Power Query methodologies
- Table merging and appending
- Data pivoting and un-pivoting
- Generating automated columns via examples
- Handling inconsistent table structures
- Table decomposition
- Best practices for text analysis
- M language fundamentals
Data Modelling – The Necessity
- Defining the data model
- Data model normalization techniques
- Two primary table types
- Relationship cardinality
- One-to-many
- One-to-one
- Many-to-many
- Filter flow – The underlying engine logic
- Creating hierarchies
- Best practices in data modelling
DAX – Optimizing Data Utility
- Understanding DAX and its strengths
- Distinguishing between measures and calculated columns; selecting the appropriate approach
- Filter context versus Row Context
- Constructing a measure table
- Variables within measures
- Variable creation process
- Rationale for using variables
- Error handling and debugging with variables
- Scalar functions
- Core aggregation functions
- Iterator functions
- The SWITCH function – An enhanced IF alternative
- Utilizing the COALESCE function
- Advanced CALCULATE applications:
- Modifier usage
- REMOVEFILTERS and KEEPSFILTERS functions with case studies
- Conceptual patterns
- Table and Filter functions
- Frequently used table functions
- Comparing VALUES and DISTINCT functions with examples
- Integrating SELECTEDVALUE into reports
- ALLEXCEPT
- ALLSELECTED
- Reasons to adopt SUMMARIZE
- Various methods for generating new report data
- Table joins:
- CROSSJOIN table implementation
- EXCEPT and INTERSECT with examples
- Leveraging the UNION function
- Relationship Functions:
- Differentiating physical and virtual relationships
- RELATED and RELATEDTABLE
- Applying USERELATIONSHIPS
- Advanced time intelligence concepts
- Setting up Fiscal and non-standard calendars for your model
Advanced Visualization Techniques:
- Developing custom color palettes for reports
- Building themes across all reports
- Designing effective slicer panels
- Crafting compelling graphs that maintain integrity
- Differentiating between effective, ineffective, and misleading visualizations
- Straightforward strategies for aesthetic report design
- Implementing Interactive Scenario Analysis for users
- Utilizing forecast and trend lines for enhanced data recognition
- Drill-up and drill-down capabilities
- The value of using parameters
- Leveraging Bookmarks in data visualization
Requirements
- A fundamental grasp of Power BI
- Prior practical experience with Power BI
14 Hours
Testimonials (2)
How to use relationships in Power BIand the differences between columns and measurements
LEUNG Chun Hei - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics
Method of training.
