- Identified the source systems from which we generate the data
- Understood the manual process of copy pasting data in raw formats
- Applying respective formulas across all the spread sheets
- Automate the Copy paste manual work
- Process the data through SSIS packages
- Extract the processed data and import the data to Power BI
- Click refresh to populate the Visualizations & Graphs
- Entire process is automated and the overall time for reports generation is brought down by more than 50 % of the actual time taken
Data Analytics
Working along with our esteemed Client Cigars International, we have discovered that there are having oceanic data which is being generated from various source systems.