Available for Data Analyst opportunities

Hello, I'm Ankit

TurningDataInto Decisions.

Data Analyst focused on transforming complex datasets into reliable insights, automated reporting, and business-ready dashboards using SQL, Python, Power BI, and Excel.

SQLPythonPower BIExcelETL

Explore My Work View Resume Let's Connect

Analytics × Technology

Current focus

Data Analytics & Business Intelligence

Dashboarding

Power BI + DAX

Data

SQL + Python

Reporting

Excel + ETL

Analytics Impact

98%+

Classification accuracy

Product data

10K+

SKUs processed weekly

E-commerce data

100K+

Records analyzed

Sales analytics

30% faster business reporting35% faster report processing6–7 hrs saved per dataset

About Me

I turn data into useful decisions.

I'm a Data Analyst focused on turning complex datasets into reliable insights, automated workflows, and business-ready reporting. My work sits at the intersection of data analysis, automation, and business intelligence.

My approach

From messy data to measurable outcomes.

I focus on understanding the problem first, preparing and validating the data, analysing the right metrics, and then presenting the result in a way that is useful for the people making decisions.

01Analyze02Validate03Automate04Visualize

Data Analysis

Transforming raw and complex datasets into structured insights that support business decisions.

SQL · Python

Business Intelligence

Building decision-ready dashboards and reports that make trends, KPIs, and performance easier to understand.

Power BI · DAX · Excel

Data Automation

Automating repetitive data workflows, reporting processes, and data preparation to reduce manual effort.

Python · SQL · ETL

Data Quality & Insights

Working with messy, inconsistent, and large datasets to improve reliability and uncover useful patterns.

ETL · Validation · Analysis

SQL & relational data analysisPython-based data processingPower BI dashboards & DAXExcel reporting & automationETL and data pipeline workflowsBusiness-focused analytics

Experience

Experience built around data and impact.

Hands-on experience across data analytics, reporting automation, e-commerce data, and software development in fast-moving environments.

01Data Analytics

Trailytics AI

Data Analyst

Jan 2025 — Present

Working with large-scale e-commerce product data to improve data accuracy, completeness, reporting, and digital shelf insights.

98%+

classification accuracy

Processed e-commerce product data across categories, brands, and availability.

10K+

SKUs processed weekly

Delivered structured product insights across e-commerce and quick-commerce platforms.

15%

data completeness improvement

Created and maintained structured product datasets while reducing data gaps.

10%

less manual rework

Improved data workflows and reduced repetitive manual effort.

PythonSQLExcelPower BIPandasNumPyBeautifulSoupSeleniumWeb Scraping & AutomationRequestsAPIsETL

02Analytics & Development

TurnPike Analyst

Freelance / Contract

Jun 2023 — Jul 2024

Automated ride-usage reporting and contributed to the development of a ride-sharing web application in a startup environment.

Pandas

reporting automation

Automated ride usage and analytics reports using Pandas and NumPy.

Python

application development

Contributed to backend development of a ride-sharing web application.

JSON

dynamic configuration

Worked with JSON configurations for dynamic application behavior and notifications.

Cross-functional

startup environment

Worked across analytics and development responsibilities within the team.

PythonPandasNumPyDjangoMySql

Projects

Analytics projects built around real outcomes.

A selection of data pipelines, e-commerce extraction workflows, and business intelligence projects focused on automation, analysis, and measurable impact.

01 / 04

DATA PIPELINE · ETL

Smart PDF Data Pipeline

Automated parsing of 150+ page PDFs into structured JSON to minimize manual data extraction.

35%

faster report processing

6–7 hrs saved per dataset

PythonPyPDF2RegexETL

WEB SCRAPING · AUTOMATION

E-Commerce Product Data Extraction

Scraped 100+ Flipkart laptop pages with dynamic pagination and exported structured product data for analysis.

100+

product pages extracted

Excel & CSV output

BeautifulSoupRequestsPandasOpenPyXL

POWER BI · SALES ANALYTICS

Mobile Sales Analytics Dashboard

Developed an interactive Power BI dashboard with dynamic filters and DAX-based measures for sales performance and customer insights.

100K+

records modeled

30% faster business reporting

Power BIDAXData ModelingExcel

POWER BI · DATA ANALYTICS

Netflix Insights Dashboard

Python-based data analysis project featuring interactive visualizations of Netflix movies and TV shows. Includes content distribution, ratings analysis, duration trends, and geographical insights.

Netflix

content insights

Interactive business intelligence dashboard

PythonPandasMatplotlibSeaborn

Auto rotating · Hover to pauseSwipe or use arrows

Skills

Tools I use to turn data into decisions.

A practical toolkit across data analysis, business intelligence, automation, reporting, and visualization.

Programming

Data processing & scripting

PythonPandasNumPyMatplotlib

Data & SQL

Querying & data transformation

SQLData CleaningETLData Analysis

Business Intelligence

Dashboards & decision support

Power BIDAXData ModelingKPI Reporting

Excel & Reporting

Analysis & business reporting

Advanced ExcelPivot TablesVLOOKUPReporting

Automation

Web data & workflow automation

BeautifulSoupSeleniumRequestsWeb Scraping

Visualization

Insights through visual storytelling

MatplotlibPower BIChartsData Storytelling

Contact

Let's turn data into impact.

Have a project, analytics challenge, or opportunity in mind? I'm always open to meaningful conversations around data, automation, and business intelligence.

Get in touch

Let's connect professionally

GitHub

Explore my projects

Instagram

Follow my journey

Chat with me