Pratik Shewale

Project: ARIA

• The ARIA IT Ticket Analysis Power BI project provides a comprehensive and interactive dashboard that visualizes the lifecycle and performance of IT support tickets raised via ARIA, the internal AI-powered chatbot. ARIA is the primary interface used by employees to raise technical issues and service requests, streamlining IT support operations.
• Monitor trends in ticket volume over time, segmented by department, location, or category.
• Visual breakdown of Open, In Progress, and Closed tickets, with filter options by Assignee or Department.
• Dashboard visualizing workload distribution, pending tickets, and average resolution time per support agent.
• Evaluate SLA compliance with visuals on breached vs. Met SLAs, resolution time buckets, and priority-based performance.
• Analyze how often and effectively ARIA is being used across teams, including ticket creation trends by channel.

Project: DIAGEO

• This project manages global media and advertising data for DIAGEO. We collect delivery data from multiple sources, including APIs, client-uploaded files, manual inputs, and GCP Buckets across various workspaces. Planned media data from clients is integrated with delivery data to create a unified dataset. Using Datorama and Power Automate, we build dashboards and automate workflows to deliver real-time insights, enabling DIAGEO to track and optimize media performance across markets.
• Working on assembly, understanding and document detailed business requirements using tools and techniques.
• We receive data from Google Analytics, Google Marketing Platform (Google Ads, DV360), Facebook Business Manager, Twitter Ads, etc. Bringing data together such multiple platforms, building easy-to-understand visualizations, and translating data into insights.
• Responsible for implementation and support of Datorama solutions and technologies.
• Creating API-based solutions, Total Connect integrations, Generic Data Streams, Data Stream templates, calculated dimensions, measurements, data load rules, pivot tables, reports, and workflows based on specific requirements.

Project: DELVE

• This project focuses on managing media and advertising data for Dell. We collect delivery data from various sources, including APIs, manual client uploads, GCP BigQuery, and GCP Buckets across different workspaces. Planned media data provided by the client is integrated with delivery data to establish meaningful connections. The combined data is then visualized using Datorama and Power BI, enabling Dell to track media performance and optimize campaign effectiveness across regions.
• Working on assembly, understanding, and documenting detailed business requirements using appropriate tools and techniques, and designing and developing the module assigned by the leads.
• Follows standard procedure problems, designing workflows, creating data streams, calculating measurements and dimensions, and working on the data stream creation for different APIs, total connect, and Lite Connect data streams.
• Created data load rules, goals, workflows, and data fusions.
• Worked on creations or reports for different data streams, as well as for clients. Seamlessly handled client communication for requirements and bug resolution.
• Worked on creating interactive dashboards for clients.

Project: US AIRLINE

• This project is based on the on-time performance of US Airlines. We have pulled data from different sources like Excel files, GCP (Big Query). We have created dashboards for 1. to show the Weather effect, Cascading flights effect on delayed. 2.Shortest path/longest path/More delayed path. 3. People fly over different location change over time and Covid - 19 Effect.
• Following Standards procedure problem, Design and submissions Designed different types of Reports like Drill down, Drill through, Matrix Reports.
• Utilized Power Bl features such as Bookmark, Tooltip, Drill Through for reports.
• Worked on all types of filters, Sync Slicer.
• Apply Edit interaction options in reports.