Vishal Dubey

Lead Analyst - Learner Success

[email protected] +91 7768912960

Resume

Hello, I am

Vishal Dubey.

1

Excel
Project

4

PowerBI
Projects

About Me

Hello! Thanks for taking an interest in knowing about me!

I’m a passionate individual who loves data analytics, automation, and AI to create impactful solutions that enhance user experiences.

I like to take full ownership of my work and proactively lead initiatives from concept to execution.

With expertise in tools like Power BI, Excel, MySQL, Power Automate, Konnect Insights, Manychats, and N8n, I’ve developed solutions that streamline workflows, automate repetitive tasks, and use AI to make my work efficient.

A lifelong learner with a growth mindset, I’m always exploring new ways to improve and share knowledge with the LinkedIn community.

Let’s connect if you’re excited about data analytics, AI, automation, or making processes more efficient!

Key Skills

MySQL

Effective Communication

Simplifying Complex Insights

Stakeholder Management

Data Storytelling

Business Acumen

My Projects

Codex's Marketing Strategy For India

AtliQ Sales Perfomance Report

AtliQ Hardware 360 Insights

Behind The Numbers: AtliQ Mart's Promotional Impact

Revenue Insights in the Hospitality Industry

My Experience

❖ Built a WhatsApp chatbot integrated with Power BI to handle learner inquiries, displaying key metrics like conversion rates and query volume. This reduced resolution time and provided actionable insights to support continuous improvement.

❖ Created four end-to-end Power BI dashboards, collaborating with stakeholders to deliver solutions that improved decision-making.

❖ Led a team to win the Codebasics Vision Most Innovative Award.

Awards & Certificate

Codebasics Resume Project Challenge Winner

Alteryx Micro-Credential

HackerRank Advanced SQL

IBM Data Science Specializations

Google Business Intelligence Specializations

Google Data Analytics Specializations

ChatGPT For Data Analytics

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.

Mail Me

[email protected]

https://www.linkedin.com/in/vishaldubeydataanalyst/

Call Me

+91 7768912960

GitHub

https://github.com/Vishal7684

PowerBI Project

Codex's Marketing Strategy For India

Analyzed survey data for CodeX using MySQL and Power BI, revealing a strong male consumer base, youth market potential, and effective online ad strategies. Recommended collaborations with influencers, product enhancements, and strategic pricing.

View Project
Engagement

View Project
on GitHUB

60% of CodeX's customers are male, indicating a strong male consumer base. 56% of respondents were young people, presenting an excellent opportunity

Virat Kohli, a popular cricketer, as a brand ambassador to leverage his appeal among the youth and fitness enthusiasts.

Project Details

In the codebasics Resume Project Challenge, I analyzed survey data for CodeX using MySQL, Power BI, and Canva. Key findings revealed a strong male consumer base, a significant youth demographic, and the effectiveness of online ads.
Consumers favored energy drinks with caffeine and natural ingredients, with potential for expansion in Tier 2 cities.

Actionable recommendations included collaborating with online influencers, enhancing products with natural alternatives, and strategic pricing for different city tiers. Strengthening partnerships with supermarkets and considering Virat Kohli as a brand ambassador were suggested for brand enhancement.

This project honed my data analysis skills, providing valuable insights for CodeX's marketing strategies.

Project video

Live Interactive Dashboard

Excel Project

AtliQ Sales Perfomance Report

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.

Showed yearly net sales performance of each customer

Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I crafted a sales report using Excel pivot tables to help businesses effectively determine customer discounts, ease negotiations, and spot opportunities for expansion in promising countries. The reports provide actionable insights, allowing businesses to optimize sales strategies, improve customer satisfaction, and maximize revenue.

Throughout this project, I acquired skills in:

Pivot tables
Power Query
DAX (Basics)
Conditional Formatting
Report Beautification
Sales Domain Metrics
The overall goal of this project is to equip businesses with the tools and insights needed to monitor, evaluate, and enhance their sales activities. Through the analysis of sales data, businesses can uncover new opportunities, foster growth, and maintain competitiveness in the ever-changing market landscape.

PowerBI Project

AtliQ Hardware 360 Insights

AtliQ Hardwares is growing fast in electronics, but it's falling behind because it relies on Excel for reports. I aim to set up a smart data system using Power BI. This will help the company understand things better and make smart choices for the future.

empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the aim is to create a single report for sales, marketing, finance, and the executive team. We're focusing on:

Making the data strong and reliable
Designing reports that are easy for users
Providing detailed insights that users can explore
I've learned a lot during this project:

Power Query for basic and advanced tasks
Creating simple and complex formulas in DAX
Working with more than 10 data tables
Choosing the right visuals and making things look good
Principles for designing dashboards
Using bookmarks for better navigation
Deploying the report on Power BI service
Taking feedback from stakeholders and making improvements
Understanding metrics for sales, marketing, finance, and supply chain.

Live Interactive Dashboard

PowerBI Project

Behind The Numbers: AtliQ Mart's Promotional Impact

Cracked the code at AtliQ Mart! Examined Diwali & Sankranti promos at 50 stores, found Mysore's impact, Grocery & Staples' boost, and the win of BOGOF and ₹500 Cashback. Shared growth plans.

View Project
Engagement

View Project
on GitHUB

For this project, I implemented a Star Schema

A Dashboard For Our Sales Director.

Project Details

Hey there! So, I dived into this cool project at AtliQ Mart, checking out their Diwali & Sankranti promos in 50 stores. Found some neat stuff: Mysore rocked the sales, Grocery & Staples did awesome post-promos, and BOGOF plus ₹500 Cashback were big hits.

I used tools like MySQL, PowerBI, Canva, and Google & ChatGPT.

I've given the actionable recommendations chatting up with store teams, trying out "Combo Meal Deals," tweaking prices, and maybe opening up in Mysore.

Please, Check out the live visuals, Video Presentation and GitHub to know more.

Thanks.

Project video

Live Interactive Dashboard

PowerBI Project

Revenue Insights in the Hospitality Industry

Revolutionized AtliQ Grands using data insights! Crafted an interactive Power BI dashboard, delving into RevPAR, ADR, and beyond. Dive into the dashboard and project specifics on GitHub.

View Project
on GitHUB

Data Modeling

The Dashboard

Project Details

Teaming up with AtliQ Grands, a fancy hotel chain, I used smart "Business and Data Intelligence" tricks to boost their success. My big job was creating a cool Power BI dashboard to understand their past data better.

What I did:

Made a fun Power BI dashboard to quickly look at data.
Used important hotel numbers like RevPAR, ADR, DBRN, DSRN, and DURN.
Checked old data to find ways to make more money.
Shared smart ideas about pricing and how many rooms to fill.
I learned cool stuff during this project:

Got really good at using Power BI for looking at data.
Figured out important hotel numbers and how they work.
Used data to make smart choices about pricing and rooms.
Got good at showing data to help make good decisions.

Check out more about this in the live dashboard!