My end user gave an Excel spreadsheet with 15 columns and 50K rows out of which 5 columns are calculated and 10 are not.
My data modeler has converted Excel into a single TABLE on Microsoft SQL Server platform.
Now I am being asked to create a report that let my end users view calculated columns/numbers/FACTS by Department, By Employee working for those departments, By Geography, By Service Lines, etc.
How do I create such a report in SQL Server Reporting Services using a single FLAT table?
Should I ask the modeler to create a Star-schema model?
How can he convert Excel into Star-schema model?
Is there a need to create such Star-schema model or I can handle it with complex but maintainable SQL code? If so, how?