Some details
Technology Skill Set
- Microsoft ® Power BI Desktop Tool
- Microsoft ® Power BI O365 App
- Microsoft SQL Server 2014
- Azure Database SQL Server 2014
- Microsoft Excel
Technical Objectives
- Analyzing the excel report – Identifying the formulas and references in the report sheet, and identifying the inner calculations within the
PSSPL Solution
- PSSPL proposed to use PowerBI capabilities to which is powerful analyzing &, reporting tool.
- Recreated the data in the report using SQL queries &, prepared database objects that are similar to the sheets in the original workbook. These objects were imported to Power BI &, were processed further.
- Successfully replicated the complex excel report in the PowerBI &, added various visualization like the pie chart, bar chart, stacked bar charts
