Главная
Study mode:
on
You
History
Saved
In progress 0 courses
compleat 0 courses
#Art & Design #Adobe #ChatGPT #GitHub

#Star Schema

Showing: 11 courses
ExcelIsFun

Excel Data Analysis - Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More

0 rewiews
Master Power Pivot and DAX formulas for advanced Excel data analysis. Learn data modeling, relationships, and visualization techniques to create powerful reports and dashboards.
Add to list
50 Lesons
1 hour 16 minutes
On-Demand
Free-Video
ExcelIsFun

Power Query Power BI - Transform 2 Fact Tables to Star Schema Data Model - Invoice Data

0 rewiews
Transform invoice data into a star schema using Power Query, creating a single fact table for improved reporting and analysis in Power BI Desktop.
Add to list
21 Lesons
26 minutes
On-Demand
Free-Video
Bryan Cafferky

Analysis Services - What Is the Difference Between Tabular and Multidimensional Models

0 rewiews
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.
Add to list
17 Lesons
36 minutes
On-Demand
Free-Video
Bryan Cafferky

Dimensional Modeling

0 rewiews
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.
Add to list
21 Lesons
54 minutes
On-Demand
Free-Video
ExcelIsFun

DAX Fundamentals in Power BI and Power Pivot - 2.5 Hour Course

0 rewiews
Comprehensive tutorial on DAX fundamentals in Power BI, covering calculated columns, measures, context, functions, and advanced techniques for efficient data analysis and reporting.
Add to list
64 Lesons
2 hours 32 minutes
On-Demand
Free-Video
PASS Data Community Summit

Beginners Guide to MDX

0 rewiews
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.
Add to list
27 Lesons
58 minutes
On-Demand
Free-Video
PASS Data Community Summit

Data Modeling and Prototyping in Power BI Desktop

0 rewiews
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.
Add to list
20 Lesons
1 hour 1 minute
On-Demand
Free-Video
Data Science Conference

Practical Kimball Data Patterns for Machine Learning Data Warehousing

0 rewiews
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.
Add to list
1 Lesons
31 minutes
On-Demand
Free-Video
SQLBits

Gathering Requirements for Your Star Schema

0 rewiews
Collaboratively design dimensional models with business users for effective star schema requirements gathering and data visualization.
Add to list
1 Lesons
50 minutes
On-Demand
Free-Video
SQLBits

Star Schema ALL the Things! But Why? - Practical Design Decisions in Data Modeling

0 rewiews
Explore practical star schema design, from source to model to report. Learn best practices, test methodologies, and assess performance impacts in data modeling.
Add to list
1 Lesons
50 minutes
On-Demand
Free-Video
Databricks

Drastically Reducing Processing Costs with Delta Lake

0 rewiews
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.
Add to list
1 Lesons
34 minutes
On-Demand
Free-Video