Project Portfolio - Kiran Sodheja

Projects Details   AtliQ Hardware is one of the leading computer hardware producers in India and well expanded in other countries too. However, the management noticed that they did not get enough insights to make quick and smart data-informed decisions. Hence, the company decided to conduct an SQL challenge. As part of the SQL Project Challenge, I successfully completed a project with the following key highlights: 1.SQL: Utilized advanced SQL concepts such as Subqueries, Multiple Joins, Common Table Expressions (CTE), and Window Functions to query the database effectively. 2. Power BI: Employed Power BI to visualize the extracted data, creating visuals like Bar Charts, Line Charts, and Donut Charts. These visuals were instrumental in clearly communicating insights derived from the data. Using my skills, I efficiently handled and analyzed database information. Applying these concepts, I turned raw data into useful insights, playing a key role in shaping the company's strategic de...

Project Details Tools Used: Data Visualization: Power BI Database: MS Excel Problem Statement: AtliQ Mart, a growing FMCG manufacturer in Gujarat, India, faces challenges in retaining key customers and aims to expand to other cities in the next two years. The company has identified service issues, leading to non-renewal of contracts by some key customers. To address this, the supply chain analytics team is tasked with tracking the 'On Time' and 'In Full' delivery service levels for all customers daily. The goal is to swiftly respond to issues and ensure customer satisfaction. Task: As the data analyst in the supply chain team, I was tasked to build a dashboard that measures 'On-Time Delivery (OT) %,' 'In-Full Delivery (IF) %,' and 'On-Time In Full (OTIF) %' against the target service levels for each customer. The objective is to provide insights and solutions to improve customer service. I have created relevant metrics, and a dashboard, and un...

 Project Details CodeX is a German beverage company that is aiming to make its mark in the Indian market. A few months ago, they launched their energy drink in 10 cities in India. I, a marketing data analyst was tasked to convert these survey results into meaningful insights that the team could use to drive actions. In my role as a Marketing Data Analyst, I worked on a survey with responses from 10,000 people across 10 cities. My task was to transform these survey results into valuable insights: Excel: I explored the data using Excel. Power BI: Another tool I used was Power BI to create clear and engaging charts and graphs. This aided the Marketing team in better understanding the data and making informed decisions. These insights played a key role in guiding smart decisions for the Marketing team. This project not only contributed to our data skills but also showcased how data influences important choices in the marketing world. Live Dashboard LinkedIn Post

  Project Details This Project was done as a part of the PwC's virtual case experience program. The task was to create a Power BI Dashboard for analyzing the call center trend of a telecom company. It reflects all relevant Key Performance Indicators (KPIs) and metrics in the dataset, like- 1. Overall Customer Satisfaction 2. Overall Calls Answered/Abandoned 3. Calls By Time 4. Average Speed Of Answer 5. Agent's Performance quadrant -> Average Handle Time (Talk Duration) vs Calls Answered. Live Dashboard