Portfolio - Ashish Dubey

Ashish Dubey

Data Analyst

Resume

1

Excel Project

2

PowerBI Projects

About Me

Welcome to my portfolio! I am an aspiring Data Analyst with a B.Pharma background. I switched paths after realizing I enjoy working with data more than pharmacy — analyzing it, finding patterns, and drawing conclusions that inform decisions. I'm proficient in Excel and Power BI for data analysis and visualization, and I'm currently learning SQL and Python to round out my technical skill set. I don't have professional work experience yet, but I've completed several independent business analysis projects, which you can see in my portfolio below. These reflect my actual working style — how I approach a problem, structure an analysis, and present findings. I'm looking for an entry-level opportunity where I can apply what I know, keep learning, and contribute to real decision-making with data.

Key Skills

Excel

PowerBI

Effective Communication

Stakeholder Management

Problem Solving

Critical Thinking

Statistical Analysis

Data Cleaning and Preprocessing

My Projects

Atliq Hospitality Analysis

Domain/Function: Hospitality

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Sales, Finance, Supply Chain and Maketig

Sales Analytics(FMCG)

Domain/Function: Sales

My Experience

Medical Scribe / Data & Records Associate | IDS Infotech, Noida | 2024 – 2025

● Managed and organized clinical and patient data with 100% adherence to confidentiality and regulatory

compliance standards

● Refined and resolved data discrepancies to improve record reliability; streamlined documentation workflows,

cutting report preparation time to under 20 minutes per report

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/ashish-dubey-16a7452a2/

Call Me

+91 9993189015

GitHub

https://github.com/dashboard

PowerBI Project

Atliq Hospitality Analysis

Domain/Function: Hospitality

AtliQ Grands owns multiple five-star hotels across India and have been in the hospitality industry for 20 years. AtliQ Grands are losing its market share and revenue in the luxury hotels. As a strategic move, AtliQ Grands has incorporated data analytics to regain their market share and revenue.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

A revenue view created for the revenue team to get insight on their business w.r.t. different KPIs and metrics.

Data model used in the desgin of the dashboard.

Project Details

This dashboard is created as a part of Atliq's strategic move to incroporate "business and data intelligence" in order to regain their market share and revenue. These are the following task that this dashboard accomplishes:

1)Create the metrics according to the metric list.
2)Create a dashboard according to the mock-up provided by stakeholders.
3)Create relevant insights that are not provided in the metric list/mock-up dashboard.

Here's what I learnt:
1)ained knowledge about the hospitality domain, it's functioning and some useful KPIs.
2)KPIs like RevPAR, ADR, DBRN, DSRN, and DURN
3)Use of the similar color pallette throughout the report
4)Using bookmarks and page navigation
5)Application of cancellation policies and revenue generation

Live Interactive Dashboard

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Sales, Finance, Supply Chain and Maketig

AtliQ Hardwares, a fast-growing consumer electronics company, struggles to compete on data since most reports are still in Excel. My goal: implement an advanced Power BI analytics solution to help them gain insights and make informed decisions.

View Project
Engagement

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

Excel Project

Sales Analytics(FMCG)

Domain/Function: Sales

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I built a sales report in Excel using pivot tables to help businesses make data-backed decisions on customer discounts and negotiation strategies. The report also highlights countries with strong potential for business expansion. Overall, it gives businesses clear insights to improve their sales approach, keep customers satisfied, and increase revenue.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

Already have an account? Sign in