Forum Discussion
Star model in Power BI
Hi
I'm stuck with star model implementation where we have multiple unrelated values inside an entity.
Most of samples use sales data which is not always applicable.
I'm looking to convert existing excel spreadsheets into star semantic model and use Power BI for reporting.
Currently users manually fill spreadsheet about corporate/tenants requests and number of signatures each corporate meeting, as well as number of responses done/received.
Metting are usually once or twice per month.
Simplified sample of the spreadsheet is below:
Currently data is summarized by year and season and presented in another spreadsheet similar to:
What is the best way to implement star model here?
Should I use corporate/tenants request/signature as dimentions?
Regards
1 Reply
- rajendraongole1
Super User
Hi SimpleDev2000 - To implement a star schema model for your corporate/tenant requests and signatures data, you’ll need to design the structure by separating your facts (measurable data) and dimensions (contextual data).
Example as per your above snapshots:
- Fact_Corporate_Meetings (Holds metrics)
- Dim_Date (Time-based analysis)
- Dim_Tenant (Tenant-based filtering)
- Dim_RequestType (Categorize types of requests)
- Dim_Meeting (Meeting details)
By following this structure, you’ll achieve a flexible model that supports different reporting scenarios, such as summarizing requests and signatures by year, quarter, or meeting, while keeping the system easy to manage.
Data Modeling (Star Schema 🌟) in Power BI – Creating Dimension Tables (youtube.com)
How to setup a Star Schema Data Model in Power BI - Easy guide (youtube.com)
hope this helps.
