Case Studies Details


Data Analytics

Data Analytics
  • 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
  • Client: Cigars international
  • Location:Bethlehem
  • Technologies:Power BI  SSIS Tools  Google Analytics  
  • Completed:Oct 2020