I’m a Data Analyst transitioning from Tech Recruitment into Data Analytics, combining business-facing experience with hands-on skills in data analysis, BI, and reporting.

I enjoy turning raw, messy datasets into structured insights, interactive dashboards, and business-ready recommendations — with a focus on understanding why something is happening, not just presenting the numbers.

• 🔎 Data Analysis — Explore datasets, identify trends, patterns, anomalies, and key business drivers
• 📈 Business Intelligence — Build interactive Power BI dashboards and KPI-driven reports
• 🧩 Data Modeling — Design structured models using Star Schema, relationships, DAX, and Power Pivot
• 🛠️ Data Preparation — Clean, transform, and prepare raw data using Power Query and Python
• 🗄️ SQL Analytics — Query relational databases using joins, subqueries, aggregations, and analytical logic
• 💡 Business Problem Solving — Translate analytical findings into clear and actionable business insights

BI & Visualization Power BI DAX Dashboard Development Report Development

Data Modeling & ETL Data Modeling Star Schema Power Query Power Pivot ETL Data Cleaning

SQL & Databases MySQL SQL Server Joins Subqueries CTEs Aggregations

Excel Advanced Excel XLOOKUP VLOOKUP Pivot Tables Conditional Formatting

Python Python Pandas Jupyter Notebook Data Cleaning Exploratory Data Analysis

Power BI | Excel | Power Query | DAX | Data Modeling

An interactive Retail Sales Analytics project focused on analysing sales performance, customer trends, product categories, and regional performance using data-driven insights.

The project demonstrates data cleaning, transformation, KPI development, and interactive dashboarding to convert raw retail data into meaningful business insights and support better decision-making.

Power BI | DAX | Power Query | Excel | Data Modeling

An PBI-focused credit analytics project designed to analyse customer segmentation, credit risk, loan characteristics, income groups, regions, and portfolio-level risk indicators.

Highlights:

• Customer segmentation by age, income, region, loan amount and tenure
• Risk scoring and risk categorisation
• KPI-driven MIS dashboard
• Interactive slicers and drill-down analysis
• Data transformation using Power Query
• DAX-based calculated measures
• Structured data model for reporting

🔗 Repository: https://github.com/impeccableashish25/Credit-data_analysis-PBI-report

Python | Pandas | MySQL | SQL | Data Analysis

An end-to-end analytics project using U.S. airline operational data to investigate flight delays, cancellations, route performance, carrier performance, aircraft utilization, and delay causes.

Key areas explored:

• Flight and operational performance
• Departure & arrival delays
• Cancellation and diversion patterns
• Carrier and route-level analysis
• Aircraft/tail-number performance
• Weather, NAS, carrier, security & late-aircraft delays
• SQL-based analytical reporting

🔗 Repository: Coming Soon

Raw Data → Clean Data → Structured Model → Analysis → Visualization → Business Insight

I believe a good dashboard is more than a collection of charts.

My approach is to:

1. Understand the business question ↓ 2. Explore and clean the data ↓ 3. Build a reliable data model ↓ 4. Develop analytical measures ↓ 5. Visualize the important patterns ↓ 6. Translate findings into actionable insights

I'm currently strengthening my analytics capabilities through hands-on projects involving:

• 🐍 Python & Pandas
• 🗄️ SQL & MySQL
• 📊 Power BI & DAX
• 🧠 Data Modeling & ETL
• 📈 Business & MIS Reporting
• ✈️ Operational / Flight Analytics
• 💼 Real-world business case analysis

My background in Tech Recruitment has given me experience working with business stakeholders, understanding requirements, analysing information, communicating insights, and working in a fast-paced professional environment.

I’m now combining that business perspective with data analytics and business intelligence skills to transition into a Data Analyst role.

My goal:

Bridge business problems and data-driven solutions.

I'm open to opportunities, collaborations, analytics projects, and conversations around Data Analytics, Business Intelligence, Power BI, SQL, and MIS Reporting.

📌 LinkedIn: https://www.linkedin.com/in/ashish-dubey09/ 📧 Email: dubeyashish117@gmail.com 💻 GitHub: You're already here 🙂

Analyse → Visualise → Create Impact