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 MSSQLServer 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.
Therefore the question is how do I create such report in MSSSRS using single FLAT table? Should I ask 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? How using SQL then HOW?