Excel Data Analysis - Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More
Master Power Pivot and DAX formulas for advanced Excel data analysis. Learn data modeling, relationships, and visualization techniques to create powerful reports and dashboards.
Power Query Power BI - Transform 2 Fact Tables to Star Schema Data Model - Invoice Data
Transform invoice data into a star schema using Power Query, creating a single fact table for improved reporting and analysis in Power BI Desktop.
Analysis Services - What Is the Difference Between Tabular and Multidimensional Models
Explore the differences between Tabular and Multidimensional models in Microsoft Analysis Services, their use cases, and how to choose the right model for your data analysis needs.
Dimensional Modeling
Learn key concepts and practices of Dimensional Modeling using the Kimball Method. Explore star schemas, snowflake schemas, surrogate keys, and slowly changing dimensions for effective data warehouse design.
DAX Fundamentals in Power BI and Power Pivot - 2.5 Hour Course
Comprehensive tutorial on DAX fundamentals in Power BI, covering calculated columns, measures, context, functions, and advanced techniques for efficient data analysis and reporting.
Beginners Guide to MDX
Explore MDX fundamentals, including T-SQL queries, star schemas, and cube visualization. Learn key concepts like sets, tuples, and subcubes through demos and practical examples.
Data Modeling and Prototyping in Power BI Desktop
Explore rapid data modeling and prototyping using Power BI Desktop. Learn to connect, cleanse, and model data from various sources, creating quick reports for project approval without licensing costs.
Practical Kimball Data Patterns for Machine Learning Data Warehousing
Discover how dimensional modeling and Kimball patterns can streamline machine learning projects, reduce data preparation time, and improve ML model development through practical warehouse design techniques.
Gathering Requirements for Your Star Schema
Collaboratively design dimensional models with business users for effective star schema requirements gathering and data visualization.
Star Schema ALL the Things! But Why? - Practical Design Decisions in Data Modeling
Explore practical star schema design, from source to model to report. Learn best practices, test methodologies, and assess performance impacts in data modeling.
Drastically Reducing Processing Costs with Delta Lake
Optimize data pipelines using Delta Lake features on Databricks. Learn techniques to address read-write amplification, improve performance, and reduce costs in large-scale data processing.