Project Details

Created a Customer Performance Report by analyzing sales data and evaluating net sales across 2019-2021. Compare Market Performance to Sales Targets, identifying countries meeting goals for strategic insights. Sales Analytics empowers businesses to monitor and evaluate activities for sustainable growth. Analyzing sales data is crucial for identifying patterns and tracking KPIs, driving business success. Reports play a vital role in determining customer discounts, facilitating negotiations, and identifying expansion opportunities. This comprehensive approach fosters informed decision-making and strategic business development.

Project Details

Mitron Bank, a well-established financial institution headquartered in Hyderabad, is keen on introducing a new line of credit cards with the objective of expanding its product portfolio and market presence in the financial industry.

Upon discovering this initiative through an internal channel, AtliQ Data Services proposed the implementation of this project to Mitron Bank. However, Mr. Bashnir Rover, the Strategy Director at Mitron Bank, expressed skepticism and requested a pilot project using sample data before considering the complete project implementation. The bank supplied a dataset comprising information on 4000 customers across five cities, encompassing details about their online spending and other relevant metrics.

Live Interactive Dashboard

Project Details

🎯 Project Objectives:
1️⃣ Generate Reports to Answer Business Inquiries:
Create actionable insights by addressing specific business inquiries through comprehensive reports.
📋 Tasks:
1️⃣ Top 10 Products by Percentage Increase in Net Sales (2020 to 2021):
Identify and rank the top 10 products based on the percentage increase in net sales from 2020 to 2021.
2️⃣ Division Report for Net Sales (2020 and 2021) with Growth Percentage:
Generate a "Division" report showcasing net sales data for 2020 and 2021.
3️⃣ Top 5 and Bottom 5 Products by Quantity Sold:
Analyze quantity sold data to determine the top 5 and bottom 5 products.
4️⃣ Identify New Products Introduced in 2021:
Explore the "21 vs 20" column for rows with a 0% increase, indicating new products in 2021.
5️⃣ Top 5 Countries by Net Sales in 2021:
Analyze net sales data to identify and rank the top 5 countries in 2021.

Project Details

Atliq Hardwares, a leading computer hardware producer, tackled market challenges with our 'Consumer Goods Analytics' project. Leveraging SQL, Excel, and PowerPoint, we provided rapid, data-driven insights. Key findings included a significant rise in unique products (334 in 2021), the dominance of the 'Notebook' segment (129 distinct items), and the pivotal role of the 'Retailer' channel (73.22% of gross sales). These insights empowered strategic decision-makers, offering a competitive edge in the dynamic consumer goods market. 🏭📈

Project Details

Embark on a cricketing journey with my Microsoft Power BI dashboard, unraveling the highlights of the exhilarating Cricket World Cup 2023. Sourced from Kaggle, the dataset breathes life into three dynamic dashboards, each a visual feast of statistics.
The 1st Dashboard paints a comprehensive picture: from the run machines and batting maestros to the wicket-taking wizards, showcasing the essence of every team's journey. Dive into team dynamics, economy rates, and the thrilling race for the Table Topper spot.
The 2nd Dashboard delves into the batting arena, offering a team-specific slicer for personalized insights. Explore individual brilliance with metrics like strike rate, fours, sixes, and the coveted top scorer lists. Witness players who dominated with flair, resilience, and record-breaking feats, etching their names in cricketing history.
Switch gears to the 3rd Dashboard, dedicated to bowling prowess. Team-specific insights, best economy rates, and wicket-taking sagas.

Live Interactive Dashboard