Available for hire · 2026

Himanshu Pathak

Data Analyst · Power BI Developer · Workflow Automation Builder

I turn raw data into actionable insight and build automation systems that actually work — packaged in clean, premium digital experiences.

View Projects →Hire Me↓ Resume
⬡GitHubinLinkedIn✉Email

About Me

I build things that matter.

Hi! I'm Himanshu — an Data Analyst and freelance automation developer focused on turning raw data into actionable insights and smart workflow solutions. I work with Power BI, SQL, Python, Excel, and automation tools like n8n to build interactive dashboards, automate repetitive tasks, and improve reporting efficiency.

I enjoy solving real-world business problems through analytics, automation, and modern digital solutions. My experience includes projects related to Finance, E-commerce, HR, and Marketing analytics, where I combine data storytelling with clean and user-friendly design to create impactful digital experiences.

Get in TouchDownload CV
📊

Power BI & Data Viz

Interactive dashboards, custom DAX measures, real-time reporting and visual storytelling.

🗄️

SQL & Python Analytics

Complex queries, CTEs, predictive modeling, EDA with Pandas, Matplotlib and Scikit-learn.

🤖

AI & Automation

Copilot, PandasAI, workflow automation and AI-assisted data storytelling to reduce manual work.

Tech Stack

Tools I work with

A curated set of technologies I use to analyse data, ship automation, and build products.

📊Data Analytics & Business Intelligence
Power BITableauLooker StudioExcelGoogle SheetsDashboard DevelopmentKPI ReportingBusiness IntelligenceData Visualization
🐍Python, SQL & Data Engineering
PythonPandasNumPyMatplotlibSeabornMySQLPostgreSQLSQLData CleaningEDA
🤖AI, Automation & Workflow Systems
n8nPower AutomateOpenAIClaude AICodexPrompt EngineeringAPI IntegrationsAutomation WorkflowsProcess Automation
🚀Business Domains & Creative Tools
Financial AnalysisHR AnalyticsE-commerce AnalyticsMarketing AnalyticsFigmaUI/UX DesignBusiness ReportingRisk AssessmentVisual Storytelling

15+

Projects Completed

8+

Dashboards Built

10+

Automation Workflows

100K+

Rows Analyzed

Portfolio

Selected Projects

Real-world projects with measurable outcomes — from data pipelines to production web apps.

🎵→

Digital Music Store Data Analysis

Optimised revenue streams for a digital music store using PostgreSQL. Identified that the top 5% of users generate 30% of total revenue, enabling targeted retention strategies.

✓ Est. 10% sales boost through targeted retention
PostgreSQLSQLAnalytics
🔍→

Exploratory Data Analysis with Python

Uncovered customer purchasing patterns using Pandas and Matplotlib. Identified a 25% underperformance in weekend sales, informing new promotional campaigns.

✓ Data foundation for weekend promo campaigns
PythonPandasMatplotlibSeabornEDA
🏥→

Hospital Facility Data Analytics

Built an end-to-end interactive Power BI solution for hospital operations, identifying key capacity issues and delivering 100% data visibility across the facility.

✓ 100% data visibility & operational efficiency
Power BISQLPythonFigma
📈→

Sales Forecast — Time Series Analysis

Developed ARIMA models to forecast retail sales, identifying strong Q4 seasonal trends and enhancing inventory planning accuracy by 18%.

✓ Inventory planning accuracy improved by 18%
PythonScikit-learnARIMAMLTime Series
👥→

Customer Segmentation Model

Applied K-Means clustering and PCA to segment customers into 3 distinct persona clusters, increasing recommendation CTR by 22%.

✓ Designed strategy to increase CTR by 22%
PythonK-MeansPCAMLClustering

Background

Experience & Education

💼 Work

Data Analyst Intern & Team Lead

Analytics Career Connect (ACC)

Feb 2026 – Present
  • ▹Leading interns to deliver high-impact data solutions with 100% data consistency across Insurance and Retail domains.
  • ▹Developed interactive Power BI dashboards with custom DAX measures, reducing reporting cycle by 40%.
  • ▹Optimised complex SQL queries using Joins and CTEs, reducing manual retrieval time by 50%.
💼 Work

Founder's Office Intern

Analytics Career Connect (ACC)

Feb 2026 – Present
  • ▹Automating business workflows and job search data collection using Python and APIs.
  • ▹End-to-end market analysis of the Indian EdTech market for identifying growth opportunities.
  • ▹Built predictive models (Logistic Regression) achieving an 88% AUC score.
🎓 Education

Bachelor of Commerce (B.Com)

Delhi University

2024 – 2027
  • ▹Currently pursuing — bridging finance and technology through data analytics.
  • ▹Specialising in financial analysis, business intelligence, and digital marketing domains.
  • ▹Applying academic knowledge directly to real-world internship projects at ACC.
🎓 Education

Senior Secondary — Class 12th (CBSE)

G.B.S.S.S No 4 Sarojini Nagar

2022 – 2024
  • ▹Completed senior secondary education under the CBSE board.
  • ▹Built a strong foundation in commerce and mathematics.

Contact

Let's Work Together

Available for freelance, contract, and full-time opportunities. Drop me a message — I reply within 24 hours.

✉

Email

himanshu.data.acc@gmail.com

in

LinkedIn

linkedin.com/in/himanshu-pathak-33680b340

⬡

GitHub

github.com/himanshupathak8830-blip

Available for new projects — May 2026