Sales and marketing Dashboard (يوضح المشروع المبيعات والارباح والتكلفه خلال السنين 2022 ,2023, 2024)

(Data Modeling and visualization ) in power BI

1) determine fact and dimension in Excel file

2)grouping same dimension together

3)create ID for each DIM IF not already present

4) merge DIM with fact table

5)get the scheme ( which star scheme)

6)get dashboard with the following detail ( determine measure ,chart describe measures )