EXPLORE

(2 reviews)

Gunjan S.

@gunjan1711

5.0

1.0

100%

AI/ML Engineer | Data Scientist

$15 USD / Hour

・

India (5:40 PM)

・

Joined on September 22, 2024

$15 USD / Hour

・

Machine Learning and Data Analytics professional with expertise in: - Predictive Analysis - Time-Series Forecasting - Regression - Clustering using Skills and tools: - Python - R - PostgreSQL/MySQL - Power BI - Tableau Skilled in Data Cleaning, Data Transformation and Visualization, I create actionable insights through Power BI and Tableau dashboards. With an MBA in Digital Transformation, I bring both technical depth and business acumen to deliver AI-driven, data-backed solutions. CERTIFICATIONS: • PWC- Power BI Job Simulation (Forage) • TATA- Data Visualization: Empowering Business with Effective Insights (Forage)

Verifications

On time

100%

On budget

100%

Accept rate

100%

Repeat hire rate

50%

See all Data Visualization Experts in India

Portfolio

• Extracted sales data through APIs and automated data refresh processes.
• Cleaned, transformed, and prepared datasets using Power Query.
• Built optimized data models and relationships for accurate reporting.
• Created DAX measures and KPIs to analyze sales trends and performance.
• Designed interactive dashboards with filters and drill-down features.
• Delivered actionable insights to support business decision-making.

Power BI Dashboard connected by API

- Cleaned and prepared large datasets using Python and MySQL to ensure accuracy and consistency.
- Handled missing values, corrected anomalies, and standardized formats for reliable analysis.
- Structured the cleaned data into organized tables to support smooth modeling workflows.
- Built visual dashboards in Tableau and Power BI to highlight trends and key performance indicators.
- Visualized zone-wise and category-wise sales patterns to identify growth and decline areas.
- Used time-series analysis techniques in Python to study past trends and seasonal behaviors.
- Applied NeuralProphet and forecasting models to predict future sales across different regions.
- Generated demand forecasts using the cleaned data to support planning and strategic decisions.
- Delivered actionable insights by combining predictive modeling with clear visual reports.

Predictive Analysis and Forecasting

Analysis of Sales data of a company was done to find patterns using various types of graphs/charts.
Calculated Revenue and Sales Quantity by particular markets and predicting future trends over the years.
Web analysis techniques were used to resolve problem statements.
Used the calculated results to extract KPIs and USPs by analyzing top selling products and top customers.

Data Analysis using Power BI

An interactive story in Tableau was created using dashboards and visualizations to analyze the sales data of an organization. The data was preprocessed using Tableau functions, MySQL, and Python to ensure accuracy and consistency before being structured for analysis.

Once cleaned, dynamic dashboards were designed to present key sales trends, revenue patterns, and customer behavior. Interactive graphs, filters, and KPIs were included to allow stakeholders to explore the data in real-time.

Forecasting techniques and trend analysis were applied within Tableau to generate predictive insights, identifying potential growth opportunities and areas for improvement. The visualizations were then used to enable data-driven decision-making, allowing sales strategies to be optimized, revenue forecasting to be improved, and overall business performance to be enhanced.

This project showcased how Tableau’s analytics, combined with Python and MySQL, could be leveraged for effective data storytelling

Sales Dashboard of an organization

- Developed a Patient Summary Dashboard using Power BI for hospital patient data analysis.
- The dataset included key patient details such as basic details, admission records, diagnoses, and lifestyle information.
- Added a slicer for Admission Number, enabling selection of individual patients to display their specific information.
- Upon selecting a patient, the dashboard shows a detailed summary including:
- Age and gender
- Diagnosis and treatment history
- Lifestyle indicators like smoking status
- Created additional visuals to depict broader trends, such as:
- Disease distribution across the patient population
- Behavior patterns (e.g., smoker vs. non-smoker statistics)
- The dashboard enhances data visibility for healthcare professionals.
- Supports better decision-making through interactive and easily interpretable visual analytics.
- Designed with a user-friendly interface for quick navigation and effective use in clinical or administrative setting

Patient Summary Dashboard on PowerBI

- Performed regular sales data analysis for an FMCG company using Python, Pandas, Tableau, and Selenium.
- Created trend analysis line graphs to visualize sales performance over time.
- Compared year-over-year sales to identify growth patterns and anomalies.
- Used bar charts to display monthly target vs. achievement clearly.
- Mapped regional sales performance using geospatial visualizations.
- Identified best-performing SKUs and top-selling products.
- Analyzed sales trends across zones and subzones with detailed breakdowns.
- Built top charts to highlight leading zones, subzones, and SKUs.
- Delivered ad-hoc insights to support business decisions.
- Designed sales KPI cards showing annual figures for quick reference.
- Developed interactive dashboards combining relevant visuals and metrics.
- Predicted daily sales for the next month by region and monthly totals using Python and Selenium.

Sales Analysis of an FMCG Company

Power BI Dashboard connected by API

Predictive Analysis and Forecasting

Data Analysis using Power BI

Sales Dashboard of an organization

Patient Summary Dashboard on PowerBI

Sales Analysis of an FMCG Company

5.0 · 2 Reviews

2 Reviews

I want fixed on powerBI ERROR

Quality of the work great Communication so fast hire Gunjan S. again

Artificial Intelligence

Data Analytics

Data Visualization

Data Analysis

+1 more

Power BI API Dashboard Build connected API

Quality of the work good hire Gunjan S. again

JSON

Business Intelligence

Data Visualization

Data Analysis

Data Integration

+4 more

Executive - Business Transformation and Data Analytics

Mar, 2025 - Sep, 2025

•

5 months, 30 days

Lahori Zeera (Archian Foods Pvt. Ltd.)

Mar, 2025 - Sep, 2025

•

5 months, 30 days

- Handled Big Data (Master & Company Outlet Data for comparison) using Python, MySQL & Excel (Cleaned anomalies, filled missing data, transformed & ensured integrity for modeling and analysis). - Did Predictive Analysis on zone-wise sales using Python (NeuralProphet/Selenium). - Built interactive Tableau & Power BI dashboards to track sales by Category/SKUs & Zones. - Monitored Target vs. Actual Sales to flag growth or underperformance. - Delivered ad hoc reports to guide data-driven decisions.

Mohali, Punjab, India

Mar, 2025 - Sep, 2025

•

5 months, 30 days

Symbiosis International University

2022 - 2024

•

2 years

MBA Digital Transformation

India

2022 - 2024

•

2 years