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.
Duration 14 hours
Course Outline
Introduction
- Summary of Power BI capabilities and structural architecture
- Utilizing advanced tools for deep data analysis
Foundations
- Setup of Power BI and associated components
- Workflows for developing reports and dashboards
- Interface navigation and overview
Power Query – Data Acquisition
- Connector types and variations
- Concept of query folding
- Data extraction from diverse sources:
- Flat file formats
- Complete data directories
- Web-based sources
- Handling unstructured data files
- Advanced Power Query methodologies
- Merging and appending datasets
- Pivoting and unpivoting data structures
- Generating columns via example patterns
- Managing inconsistent tabular data
- Decomposing complex tables
- Optimal strategies for text analysis
- Introductory M language syntax
Data Modeling – Essential Necessity
- Definition and purpose of data models
- Normalization of data structures
- The two primary table categories
- Relationship cardinality types
- One-to-many associations
- One-to-one associations
- Many-to-many associations
- Filter propagation logic
- Constructing hierarchies
- Best practices in data modeling
DAX – Maximizing Data Utility
- Understanding DAX and its advantages
- Distinguishing between measures and calculated columns
- Differences between filter context and row context
- Creating measure tables
- Utilizing variables within measures
- Variable creation process
- Benefits of employing variables
- Error handling and debugging using variables
- Scalar functions
- Core aggregation functions
- Iterator functions
- SWITCH function as a superior alternative to IF
- Application of the COALESCE function
- Advanced CALCULATE applications:
- Understanding modifiers
- Practical use of REMOVEFILTERS and KEEPSFILTERS
- Concept of patterns
- Table and filter functions
- Frequently used table functions
- Comparing VALUES and DISTINCT functions with examples
- Integrating SELECTEDVALUE into reports
- Utilization of ALLEXCEPT
- Utilization of ALLSELECTED
- Rationale for using SUMMARIZE
- Methods for generating new datasets
- Table joins:
- Executing CROSSJOIN operations
- Using EXCEPT and INTERSECT with examples
- Applying the UNION function
- Relationship functions:
- Differences between physical and virtual relationships
- Using RELATED and RELATEDTABLE
- Implementing USERELATIONSHIPS
- Advanced time intelligence concepts
- Configuring fiscal and non-standard calendars
Sophisticated Visualization Methods
- Customizing color palettes for reports
- Developing consistent themes across reports
- Designing effective slicer panels
- Crafting honest and compelling visualizations
- Differentiating between effective, ineffective, and misleading visuals
- Simple principles for report aesthetics
- Implementing interactive scenario analysis
- Adding forecast and trend lines for pattern recognition
- Utilizing drill-through and drill-up features
- The value of using parameters
- Leveraging bookmarks for navigation and interaction
Requirements
- Familiarity with Power BI concepts
- Practical experience operating Power BI
Testimonials (2)
The most valuable takeaway was learning how to apply the concepts in real-world scenarios and understanding the tools and processes.
Marcel Tansae - DB Technology
Course - Microsoft Power Automate
How to use relationships in Power BIand the differences between columns and measurements
