Data Modelling Workout 01 - Star Schema

[kenyatta67]

@Greg

ing:
• a screenshot of the queries pane of the [Power Query Editor] with all groups expanded
• a screenshot of the star schema data model as displayed in the [Model View]

[annaneelu]

Answer :

[details=“Summary”]

Data Modelling Workout 01.pbix (239.9 KB)

This text will be blurred

[/details]This text will be blurred

[Jalil]

My first Workout

Summary

This text will be hidden
Data Modelling Workout 01.pbix (236.4 KB)

[danieldecaboriveiro]

My first workout!

Screenshots

Data Model

Power Panel

[nayeli.marcial]

Answer: Here is my final result! Thanks.

Data Modelling Workout 01.pbix (223.6 KB)

[sargeantleigh71]

ANSWER: Not pretty reporting and missed the exact modelling which Greg posted. Learned a bunch though for my 1st W/O… so on to the next!

Summary

WO1.pbix (234.7 KB)

[katie.garner]

Here is my submission!

Power BI Workouts - KG.pbix (248.7 KB)

Summary

This text will be hidden

[terrance.emard]

Here is my solution

Summary

This text will be hidden

Data Modelling Workout 01.pbix (208.6 KB)

[ywu]

Data Modeling Workout 01.pbix (231.9 KB)

[chitrakarki5541]

Work Out 1.pbix (232.8 KB)

[details="Summary"]
[spoiler]type or paste code here[/spoiler]
[/details]

[stuartdouglas79]

Enterprise DNA workout 1.pbix (592.1 KB)

[dennyldh74]

Thank you!

[Daoud_H]

Data Modelling Workout 01.pbix (199.5 KB)

[paul.fenwick]

Answer: First one so hopefully responded correctly

Data Modelling Workout 01.pbix (230.3 KB)

[wilmajnb26]

Summary

Data Modelling Workout 01 - Star Schema - Wilma.pbix (211.1 KB)

[tarati.lorenzo16]

![image|223x376](upload://47AiZ7jufkF8sMEUNBhYrUP4kZW.png)
![image|690x357](upload://aj04HVUP27ZoqFk48SR9pbq11lG.png)
[workout001.pbix|attachment](upload://5LiDU2TnC9IrsjFruNiU77uksrO.pbix) (203.7 KB)
![image|690x382](upload://l9Tld2JX0LaN8NoPdAQlzPjETMY.png)
![image|690x391](upload://9LHsJVdW8sb14oIjIRd6fE6LwAG.png)
![image|690x388](upload://5DZTwlaNGq1usb9o2AHNOSdzV4e.png)[spoiler]This text will be blurred[/spoiler]

[fjamcom94]

Why linking Country to Sales table prompts me for M-M instead of 1-M?

[Keith]

Hi @fjamcom94
Because you have many countries in Store table. You shouldn’t be using Country in the Store Table. You should be linking Store (store table) with Store (in the fact table)

I hope this helps.
Keith