Portfolio - Shubham Gujar

PowerBI Project

Business-Insight-360

The AtliQ Hardware Business Insight 360 Power BI project aims to create an advanced business intelligence dashboard that offers a comprehensive view of key metrics and performance indicators for AtliQ Hardware. This dashboard enable stakeholders to gain insights and make data driven decision.

View Project
Engagement

View Project
on GitHUB

AtliQ Executive View ensures that decision-makers can swiftly grasp the pulse of the business, enabling agile and data-driven decision-making.

Data modeling of AtliQ Hardware involves structuring and organizing data for effective analysis and visualization within the Power BI environment.

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

Power BI Techniques Learned:

1.Data Import and Transformation
2.Data Modeling
3.DAX (Data Analysis Expressions)
4.Report Design
5.Dashboard Development
6.Power Query
7.Power BI Service
8.Data Analysis
9.Integration with Other Tools
10.Performance Optimization

Live Interactive Dashboard

Python Project

Medical Data Extraction

Health insurance companies often face challenges in processing claims efficiently due to the manual extraction of information from patient details and prescriptions. This project aims to automate the data extraction process using Python and various technologies.

View Project
Engagement

View Project
on GitHUB

The combination of pdf2image, opencv, pytesseract and regex enables comprehensive information extraction from pdf.

In order to ensure the reliability of our medical data extraction project, we leveraged postman as a powerful tool for API testing and validation

Project Details

Solution Approach:

Our solution involves the development of a Python-based program that automates the extraction of data from medical images. The system utilizes technologies such as pytesseract for OCR, Pdf2image for PDF support, OpenCV for image processing, and regular expressions for refining extracted data. The combination of automation and human validation ensures both speed and accuracy in the data extraction process.

Key Features

3.Automation: Extracts patient details and prescription information automatically from medical images.

2.Error Reduction: Human validation cross-checks and verifies the accuracy of the extracted data.

3.Efficiency: Meets the 24-hour data submission requirement through a faster and automated extraction process.

Project video

SQL Project

CodeX Food and Beverage Analysis

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.Their Marketing team is responsible for increasing brand awareness, market share, and product development.

View Project
Engagement

View Project
on GitHUB

To boost sales, focus on targeted online ads, given their success with 49% of the youth market. enhance visibility in supermarkets to increase sales.

Consumers inclination towards energy drinks with caffeine and natural ingredients, aligning with the demand for healthier options.

Project Details

Utilized Tech Stack:
I used MySQL for the in-depth querying of the dataset, extracting valuable information. Power BI to make charts and graphs.

Key Discoveries:

1.60% of CodeX's customer base is male, indicating a robust presence among male consumers.
Youthful Opportunity:
2.56% of respondents fall into the young age bracket, offering an excellent chance to connect with the youth demographic.
3.Online ads emerge as the most impactful and cost-efficient method to engage our target audience.
4.Consumers inclination towards energy drinks with caffeine and natural ingredients, aligning with the demand for healthier options.
5.Tier 2 cities exhibit promising potential for expansion, representing untapped markets.
6.45% favor purchasing from supermarkets, while 25% opt for online channels.
7.Consumers express a desire for healthier options, natural ingredient.

Project video

SQL Project

Consumer Goods Ad-hoc Insights

Atliq Hardware is enhancing its data analytics capabilities to make informed decisions. Tony Sharma, Head of Data Analytics, is conducting a SQL challenge for junior analysts. The tools include MySQL for database queries, Power BI for visualization, and Canva for presentations.

View Project
Engagement

View Project
on GitHUB

list of markets in which customer "Atliq Exclusive" operates its business in the APAC region.

Report of the Gross sales amount for the customer “Atliq Exclusive” for each month. This helps to get an idea of low and high-performing months.

Project Details

Objective:
Efficiently leverage data for strategic decision-making by strengthening the data analytics team's skills in MySQL and Power BI.

Key Skills:
1.MySQL: Joins, CTEs, Subqueries, Window functions.
2.PowerBI: DAX, Sunburst Charts, Bar Charts, Matrices, Line Charts, Maps, Donut Charts.
3.Presentation: Canva for creating engaging presentations.

Findings:
The focus is on extracting vital metrics like Gross Profit, Contribution %, Overall Amount Sold, Average Gross Sales, Average Manufacturing Cost, etc.

Solutions:
Upon identifying key metrics, the proposed solutions involve increasing the production rate. This includes implementing customer-centric strategies such as membership programs, gift certificates, bundled deals, student discounts, and other special offers.

Python Project

AtliQ Hotel Data Analysis

The objective of this data analysis was to gain valuable insights into the performance and trends of Atliq Hotel. Through a comprehensive examination of the provided dataset, the analysis aimed to uncover patterns, anomalies, and areas for improvement in the hotel's operations and customers.

View Project
Engagement

View Project
on GitHUB

The analysis revealed several noteworthy insights, including Highlight specific findings or trends uncovered during the analysis.

These recommendations, when tailored to the specific context of AtliQ Hotel, can contribute to sustained growth and success.

Project Details

The analysis was conducted using Jupyter notebook, a powerful interactive computing environment, primarily leveraging Python and popular data science libraries such as Pandas, NumPy, and Matplotlib. The following steps were taken:

◦Data Cleaning: The dataset was cleaned to handle missing values, outliers, and any inconsistencies that might affect the analysis.

◦Exploratory Data Analysis (EDA): Various visualizations and statistical methods were employed to explore the relationships between different variables, identify trends, and discover any significant patterns.

◦Data Transformation: Techniques such as handling missing values, encoding categorical variables, and scaling numerical features were applied meticulously.

◦Insights Generation: The analysis embarked on a journey of extracting actionable insights from the transformed AtliQ Hotel dataset. unveiled patterns, trends, and anomalies.

Hello, I am

Shubham Gujar

1

2

2

About

Key

My

Business-Insight-360

Medical Data Extraction

CodeX Food and Beverage Analysis

Consumer Goods Ad-hoc Insights

AtliQ Hotel Data Analysis

Contact Me

Email

Github

Linkedin

Call

Shubham Gujar

Download Resume