Data Intelligence Portfolio

Shiv Gandhi

|

"Transforming Data into Actionable Business Insights"

Passionate Data Analyst skilled in SQL, Python, Power BI, Tableau, Excel, Forecasting, Dashboard Development, and Business Intelligence. Experienced in building forecasting systems, analytics dashboards, KPI frameworks, and data-driven reporting solutions.

SYSTEM ACTIVE // DATA RECRUITER MODE

Platform Activity Indicators

913K+
Records Analyzed
₹954M+
Revenue Insights
2,253+
Job Postings Analyzed
1,470+
Employee Records Analyzed
3+
Analytics Projects

About Me

analytics_pipeline.py
import pandas as pd import mysql.connector from prophet import Prophet df = pd.read_sql("SELECT * FROM sales", conn) model = Prophet(yearly_seasonality=True) model.fit(df)
Forecasting Model: FIT
BI Dashboard: SYNCED

Transforming Data into Actionable Insights

I am an aspiring Data Analyst with expertise in SQL, Python, Power BI, Tableau, Excel, Forecasting, Dashboard Development, and Business Intelligence.

My focus is transforming complex datasets into actionable business insights through analytics, reporting, visualization, and forecasting.

Bilimora, Gujarat, India gshiv1847@gmail.com

What I Can Do

Providing high-value business reporting and analytical support to enable strategic choices.

Dashboard Development

Designing interactive, executive-ready dashboards in Tableau and Power BI that simplify KPI visibility.

Business Reporting

Providing formatted, periodic reports tracking operational, sales, and organizational outcomes.

KPI Tracking

Structuring dynamic measures and custom query logic to track and evaluate essential targets.

SQL Analysis

Writing highly optimized CTEs, complex joins, and window functions to query relational databases.

Data Cleaning

Performing large-scale data cleansing, handling missing values, and formatting inputs in Python/SQL.

Data Visualization

Translating dry records into high-impact visual trends that present clear data stories to stakeholders.

Forecasting

Applying predictive modeling frameworks (like Prophet) to evaluate sales demand and seasonal trends.

Business Intelligence

Translating business objectives into logical analytical schemas that drive revenue and growth.

Core Technology Stack

Programming

SQL (CTEs, Joins, Window Functions)
Python (Pandas, NumPy, Matplotlib, Prophet)

Visualization

Power BI
Tableau
Microsoft Excel

Databases

MySQL
PostgreSQL
SQLite

Analytics & Methods

Power Query
DAX (Data Analysis Expressions)
Data Cleaning & Validation
Exploratory Data Analysis (EDA)
Statistical Analysis
Sales & Demand Forecasting

Version Control & Collaboration

Git
GitHub

Data Analytics Portfolio

Visual grid showcasing end-to-end analytics and BI dashboards built using Power BI, Tableau, SQL, and Python.

Retail Demand Forecasting & Inventory Intelligence Platform Dashboard
Predictive Analytics
Python SQL Tableau MySQL

Retail Demand Forecasting & Inventory Intelligence Platform

Project Overview

Developed an end-to-end retail analytics solution analyzing 913,000+ sales records across 10 stores and 50 products. Performed large-scale data cleaning, validation, and feature engineering using Python. Designed and implemented a MySQL database for analytical querying and KPI reporting. Built Tableau dashboards to monitor sales trends, store performance, and product demand. Implemented demand forecasting using Prophet to predict future sales trends and support inventory planning.

Business Impact

  • Generated business insights from ₹954M+ revenue data, identifying seasonal demand patterns and top-performing products.
  • Delivered inventory intelligence reports supporting stock optimization and business planning to prevent stockouts and overstock scenarios.
Job Market Analytics Dashboard
Market Intelligence
Power BI Power Query DAX Excel

Job Market Analytics Dashboard

Project Overview

Developed an interactive Power BI dashboard analyzing 2,253 Data Analyst job postings from 1,500+ companies. Performed complete data cleaning, modeling, and transformation using Power Query. Designed interactive visualizations to analyze salary trends, hiring demand, industry trends, and key technical skills.

Business Impact

  • Built KPI dashboards tracking Total Jobs, Average Salary, Average Company Rating, and Total Hiring Companies.
  • Created custom DAX measures for dynamic KPI calculations and reporting.
  • Identified SQL, Excel, and Python as the most demanded technical skills in Data Analyst roles, delivering actionable labor market insights.
HR Analytics Dashboard
Workforce Analytics
Power BI Power Query DAX

HR Analytics Dashboard

Project Overview

Developed an HR Analytics Dashboard using IBM HR Analytics data containing 1,470 employee records and 35+ workforce attributes. Built interactive analytics workspaces to analyze attrition across departments, job roles, age groups, education fields, and overtime categories. Utilized DAX measures and Power Query transformations to optimize loading times.

Business Impact

  • Built KPI metrics tracking Total Employees, Active Employees, Employees Left, Attrition Rate, Average Age, and Average Salary.
  • Identified an overall attrition rate of 16.12% and key workforce trends impacting employee retention.
  • Delivered actionable HR insights supporting workforce planning and retention strategies.

Education & Learning Journey

2024 - 2026

Master of Science

Computer Science & Information Technology

JAIN University — Bengaluru, Karnataka
CGPA: 8.30 / 10

Focused on advanced computational analytics, database structures, business data systems, and programming in data science.

2021 - 2024

Bachelor of Science

Information Technology

UKA Tarsadia University — Bardoli, Gujarat
CGPA: 7.02 / 10

Acquired core fundamentals of database modeling (SQL), algorithmic scripting, spreadsheet analytics, and software design systems.

Verified Certifications

Deloitte Data Analytics Job Simulation

Issued by Forage

Completed real-world analytics tasks involving data cleaning, dashboard development, business reporting, and insight generation. Developed data-driven recommendations based on business datasets.

Verify Certificate

Power BI Workshop

Issued by Office Master

Mastered dashboard design, complex data modeling, custom data transformation, writing advanced DAX queries, and implementing interactive UI features.

Verify Certificate

SQL with AI

Issued by AI For Techies

Learned advanced SQL querying, relational database design, joins, CTEs, window functions, and integrating AI techniques for writing optimized database code.

Verify Certificate

Resume

Data Analyst | Business Intelligence Analyst

View or download my latest professional resume.

Professional Resume

Data Analyst | Business Intelligence Analyst

Quick Highlights

SQL Python Power BI Tableau Forecasting Business Intelligence

Get In Touch

Have a project, job opening, or analytical challenge you need help with? Drop me a message and I'll get back to you promptly.

Contact Details

Feel free to reach out via email, phone, or connect with me directly on professional platforms.

Location Bilimora, Gujarat, India

Interested in Data-Driven Decision Making?

I am actively seeking opportunities in Data Analytics, Business Intelligence, and Reporting where I can apply SQL, Python, Power BI, Tableau, and analytical problem-solving skills to deliver business value.