I recently came across the star schema and its advantages. I am new to Power BI and Database modeling.
I am making a Power BI Report.
I planned hours for all my members in my team for each Project and thus calculated the hours spent with their hourly rate and got the budget for every Project for the year. This is my first table. I have EmployeeName, Hours, Date, ProjectName, TotalCost
I get the monthly timesheet from SAP after they include their hours. The fields are the same. EMployeeNAme, PostingDate, Hours, Cost, ProjectName.
Now, I need to make a report where I see the difference between what was planned and what I get from my Timesheet. And how much budget is remaining for the next two months.
I should be able to filter this for each employee, each project and between any month.
I do not know what do I make Fact Table and what will be my Dimensions Table.
How do I use StarSchema in this?