Bitscape is a leading IT consulting and solutions provider company which has for more than a decade now, helped organisations of small, medium and large sizes to make prudent investments in technology so as to fulfil their goal of optimizing their business efficacy.
Herewith we are sharing one of our approaches to a business challenge faced by one of our client’s and the solution we proposed.
Analysis and Design:Defining the scope – Started with one subject area within one business unit, Secure development/deployment environment i.e. Server, software, Identified sources, Identified outputs – reports (what types – analytical, transactional, excel), Assisted client in understanding MS-SQL technologies, Created logical system design, logical database design and logical data models.
Designed and created tables:Established naming standards (or adhere to existing standards if existent), Designed staging tables – operational data layer, Designed dimensions with appropriate attributes, Discussed how data changes can be tracked, Introduced change tracking attributes (start date, end date, current indicator, and inferred member indicator), Designed fact table to include all measures relevant to reporting requirements, Loaded data into staging, Used the fastest method for loading, Created SSIS packages for dimension and fact loads, Loaded data into dimensions and fact.
Created key reports and dashboard:Created OLAP- SSAS, created reports (SSRS, Power View, Excel, and PowerPivot), Created PerformancePoint Dashboard with analytical views, Included three analytical reports of different type and one scorecard (with KPI), Integrated SSRS, Excel, and PowerPivot into the dashboard.
- More flexible reporting including self-determined decisions on what, when and how to analyses data.
- The quicker turnaround of reporting requests.
- Highly integrated toolset.
- Targeted information delivered using push reporting.
- Ability to easily enhance and extend the reporting environment.
- The simple user interface has enabled quick solution adoption.