Hi, I'm ANANDAKRISHNAN

Data Analyst | Business Intelligence Expert

I turn raw, unstructured data into clean analytical models, automated reports, and dashboards that support decision-making

Profile Photo

About Me

My primary focus is data analytics, with an emphasis on data preparation, analysis, and reporting. I work with Excel, SQL, and Power BI to clean and structure datasets, define relevant metrics, and develop dashboards that support accurate and consistent decision-making.

I follow a disciplined approach to analytics, prioritizing data quality, clarity of logic, and repeatable workflows. I continue to strengthen my technical skills by building and documenting real-world analytics projects.

Role

Data Analyst

I’m a Data Analyst with strong experience in Excel, SQL, and Power BI, focused on data preparation, KPI definition, and reporting automation.

My work emphasizes clean data models, reproducible logic, and dashboards that answer real business questions. I enjoy working on end-to-end analytics problems—from raw data to decision-ready insights.

Projects

A collection of end-to-end data analytics projects focused on modeling, reporting, and insight generation.

Weather Analytics Dashboard

🌦️ Real-Time Weather Analytics Dashboard

An API-driven Power BI dashboard that transforms live JSON weather data into structured insights using Power Query, DAX, and a clean data model. Focused on real-time KPIs, AQI monitoring, and multi-city analysis.

Ola Ride Analytics

🚖 Ola Ride Operations Analytics

An end-to-end analytics project using SQL and Power BI to analyze ride performance, cancellations, revenue trends, and customer behavior. Emphasizes data cleaning, SQL views, and interactive operational dashboards.

HR Analytics Dashboard

👥 HR Analytics – Employee Presence & Capacity Planning

A Power BI solution that converts raw attendance data into actionable HR insights. Uses Power Query for transformation and DAX for presence, WFH, and wellness metrics to support workforce planning decisions.

Skills

Excel

Excel

Power Query

Power Query

SQL

SQL

DAX

DAX

Power BI

Power BI

VBA Macro

VBA Macro

Contact

Phone

+91 9400613520

Email

anand.k.100@outlook.com