DevOpsForge
K
K
Free

Platform

Home

Tracks

OverviewLearning Path

Tools

LabsTroubleshootingInterview PrepTemplatesCheat SheetsRoadmapsChallengesProjects

Community

AI MentorSettings
Free
BI & Business Intelligence track

Data Modeling

Star models in BI tools, relationships, grain and modeling errors.

6 concepts4 labs2 challenges
0%
0% complete
Keep going!
Concepts

Start learning

Work through the concepts in order, or jump to what you need.

1

Data Modeling Overview

Concept · Hands-on lab included

2

Relationships and Grain

Concept · Hands-on lab included

3

Normalization vs Denormalization

Concept · Hands-on lab included

4

Snowflake Schemas

Concept · Hands-on lab included

5

Conforming Dimensions and Data Conformance

Concept · Hands-on lab included

6

Modeling for Performance

Concept · Hands-on lab included

Practice

Hands-on labs

Apply what you've learned in guided, production-style environments.

Browse all labs

Build and Probe a Fact/Dimension Model

45 min · beginner · Data Modeling Overview

Prove Relationship-and-Grain Bugs in SQL

45 min · intermediate · Relationships and Grain

Measure Star vs Snowflake Query Cost

40 min · intermediate · Snowflake Schemas

Prove the Performance Rules with Data

45 min · advanced · Modeling for Performance

Continue

Next modules

Keep your learning streak going with related modules.

0%

BI Fundamentals

What BI is, the BI stack, and the analyst-to-executive reporting chain.

0%

Business Metrics

KPIs, metric definitions and the business context behind dashboards.

0%

SQL

The SQL BI professionals need — ETL views, joins and time-series queries.

DevOpsForge - BI & Business Intelligence · Data Modeling
DocumentationSupport