Nidhi Meshram

Real Time Projects:

On-Time Performance for U.S. Airlines:

• The project was related to on-time performance of U.S. airlines.
• User should be able to find best time to travel, the flight with minimum delay, shortest path to reach the destination.

GroupM Colgate:

• The Project was related to the Media Advertising Domain where data for different Products and Brands falling under Colgate was collected from multiple platforms like Facebook, DV360, Google Adwords, Amazon Advertising etc. and this data was turned into meaningful visuals and charts to track the progress of each campaign all over the globe, like APAC, NA, LATAM, EU, and AED.
• The Business Intelligence tool used in this project is Datorama, which was used to implement the ETL, visualization, and reporting processes.
• Meaningful dashboards were created using widgets that consist of bar charts, pie charts, pivot tables, etc. These dashboards/reports were accessible to all global clients, could be shared easily, and could be updated easily if required.

GroupM Delve:

• The project was related to Delve Client, where data was collected from raw source files and reports, and this data was turned into meaningful visuals and charts to track the progress of each campaign all over the globe, like APAC, NA, LATAM, EU, and AED.
• The Business Intelligence tool used in this project is Datorama, which was used to implement the ETL, visualization, and reporting processes.
• Mainly worked on validating data, dashboards, and creating useful metrics.

APAC Global:

• files, SOQL databases, Google Spreadsheets, and reports, and this data was turned into meaningful visuals and charts to track the progress of each campaign.
• Developed dashboards with Datorama to monitor key performance indicators for platforms like Meta, Instagram, Twitter, TikTok, Xaxis, Sizmek, DV360, DV360 TrueView, Proteus, etc
• The project was in its 2.0 version, which was upgraded to 3.0, so it mostly worked on creating new datastreams, fields, and new dashboards by referring to the dashboards from 2.0.
• Worked with internal teams to understand business needs and changing strategies. Also worked on HTML and CSS for customized dashboard requirements.

Singapore Measure:

• The project was primarily based on Singaporean agencies, where the requirement was to set up a system to look for dashboards for different agencies using BigQuery, Adverity, and Power BI.
• Using the Adverity tool, the source files were extracted, datastreams and fields were created for different platforms , the data was then connected to BigQuery
• In Power BI, relationships between tables were established, and required visuals were created.