Akshay M

Data Analyst turning raw, messy datasets into decision-ready dashboards — SQL for data cleaning & modeling, Power BI & DAX for reporting, Python for analysis, Excel for the day-to-day.

Technical Skills

A. Data & Reporting Tools

SQL ServerQUERIES · JOINS · CTEs
Power BIDASHBOARDS · KPI
DAXSUM · DIVIDE · CALCULATE
Power QueryETL · TRANSFORM
PythonPANDAS · NUMPY · MATPLOTLIB
Microsoft ExcelVLOOKUP · PIVOT

B. Analytical Practice

Data CleaningPROFILING · QA
Data ModelingRELATIONSHIPS
Data VisualizationREPORT DESIGN
Exploratory AnalysisEDA · INSIGHTS
Problem SolvingROOT-CAUSE
CollaborationTEAM SUPPORT

Professional Experience

Data Analytics Intern
Zeralytics
Jun 2026 — Aug 2026
  • Completed a 2-month Data Analytics internship applying Excel, SQL, Power BI and Python to business datasets.
  • Performed data cleaning, analysis and dashboard reporting to convert raw data into actionable insights.
Process Executive
Cognizant Technology Solutions
May 2024 — May 2026
  • Validated product attributes against SOPs for Walmart, ensuring compliance and data accuracy at scale.
  • Inspected post-production quality output and maintained high standards of data accuracy.
  • Prepared daily productivity and accuracy reports in Microsoft Excel for team-level review.
  • Maintained query trackers and resolved process-related issues efficiently.
  • Led team huddles and monitored monthly performance metrics to drive team output.
  • Trained new associates and implemented quality-control checks for consistent results.

Featured Projects

01 Cafe Sales Performance Dashboard
SQL SERVER · POWER BI · DAX

Took a raw, messy cafe sales dataset through a complete end-to-end analytics workflow — profiling, cleaning, modeling and visualizing raw transaction logs into dynamic business insights.

Cafe Sales Performance Power BI dashboard showing total revenue, transactions, monthly revenue trend, payment method distribution, order type split, revenue by item and top-selling items by quantity
Live report view — Power BI Desktop
₹88.95KTotal Revenue
10KTotal Transactions
30KTotal Quantity Sold
  • Data Cleaning & Validation (SQL): Profiled raw tables to locate NULL and error values while preserving raw source tables separately; recovered missing Total Spent by back-calculating from Quantity × Price Per Unit, and validated transaction timestamps for duplicates.
  • Data Modeling & DAX (Power BI): Built a dedicated Date Table on a 1-to-many relationship with sales records, then authored DAX measures for Total Revenue, Total Transactions and Total Quantity Sold with interactive Date, Month and Quarter slicers.
  • Dashboard Visualizations: Designed visuals tracking monthly revenue trends, item-wise sales, payment-method distribution (Cash, Credit Card, Wallet) and Order Type split (In-store vs Takeaway).
02 Gym Sales & Membership Analytics Dashboard
POWER BI · DAX · POWER QUERY · EXCEL

Analyzed membership trends, revenue performance, customer behavior and payment patterns across 5 gym branches to support business decision-making.

Gym Sales and Membership Analytics Power BI dashboard showing total members, total sales, membership category, gender split, walk-in count by branch, revenue trend, branch revenue performance, best-selling membership plans, payment insights and payment status
Live report view — Power BI Desktop
₹9.13MRevenue, 2025–26
600+Members
5Branches
91.3%Payment Paid Status
  • Data Preparation (Power Query): Removed duplicate Membership IDs, handled missing fee values, and filtered out non-returning customers to focus strictly on active member records.
  • Data Analysis & DAX Measures: Formulated DAX metrics (SUM, DIVIDE, CALCULATE) for total sales, branch-wise revenue breakdowns, and KPI tracking.
  • Consolidated Dashboard View: Interactive reporting covering revenue trends, branch performance (Kodambakkam, Arumbakkam, Virugambakkam, Valasaravakkam, Saligramam), best-selling membership plans (1, 3, 6, 12 months), payment status, and gender distribution.

Certifications & Training

Bolt Academy Certificate of Training Completion — 3-Months Data Analytics Training Program, issued 08/09/2026
Data Analytics Training Program
3 Months · Sep 2026
Bolt Academy
  • Microsoft ExcelData cleaning, PivotTables and dashboards for fast, accurate business reporting.
  • Power BIDAX, data modeling and interactive dashboards for KPI tracking and data storytelling.
  • SQLJoins, subqueries and aggregations to extract and transform data from relational databases.
  • PythonPandas, NumPy and Matplotlib for data cleaning, exploratory data analysis (EDA) and visualization.
Zeralytics Internship Certificate — 2-month Data Analytics Intern, 06-06-2026 to 05-08-2026
Data Analytics Internship
2 Months · Jun–Aug 2026
Zeralytics

Completed a 2-month internship as a Data Analytics Intern, applying Excel, SQL, Power BI and Python to business datasets — from data cleaning to dashboard reporting.

Let's talk data.

Open to Data Analyst opportunities where SQL, Power BI, Python and clean reporting can drive real decisions.