Star schema

Concept

Data model design with a central fact table surrounded by dimension tables; the recommended structure for fast, simple Power BI models.

Sessions on this topic (2)

• Become a Guardian of the Star Schema with Microsoft Fabric · Markus Ehrenmueller-Jensen · M365Con 2027
• Become a Guardian of the Star Schema with Microsoft Fabric · Markus Ehrenmueller-Jensen · M365Con 2027

Glossary

Related topics in brief

• Semantic model · Related to · Concept
  Business-friendly data model of tables, relationships and measures that Power BI reports and Copilot query; formerly called a dataset.
• Power BI · Related to · Product
  Microsoft's business intelligence tool for turning data into interactive reports and dashboards. Semantic models define the data and measures, and reports can be shared in the Power BI service or embedded in other apps.
• Microsoft Fabric · Related to · Platform
  An all-in-one analytics platform that combines data engineering, data warehousing, real-time analytics and Power BI on a shared storage layer called OneLake, billed through shared capacity.
• DAX · Related to · Concept
  Formula and query language for calculations in Power BI, Excel Power Pivot and Analysis Services semantic models.
• Markus Ehrenmueller-Jensen · Related to · Person
  Markus Ehrenmueller-Jensen is a speaker at M365Con 2026 and M365Con DACH 2026 and M365Con 2027 (BI Architect at Savory Data GmbH) with 3 sessions.

Experts and companies for this topic

Nobody has listed this topic yet. Add it to your profile.