Powered by
Codebasics DA Bootcamp

Vishal Lohia

Data Analyst

+91 9013795816 [email protected]

Resume

Hello, I am

Vishal Lohia.

2

PowerBI Projects

1

Excel Project

About Me

I am an aspiring data analyst with a strong passion for transforming raw data into meaningful insights. Proficient in Excel, Power BI, SQL, and Python, I excel at uncovering patterns and narratives within data to aid informed decision-making. While I hold a Bachelor's degree in Computer Applications (BCA) and currently pursuing an MBA, my true passion lies in data analysis.

Combining technical skills with business knowledge, I approach data from both an analytical and strategic angle. I’m always eager to enhance my expertise, driven by a desire to understand the broader implications of data. Whether it’s creating dashboards, building data models, or solving complex challenges, I’m dedicated to helping organizations fully capitalize on their data.

I’m excited to apply my skills in a fast-paced, data-centric environment, and I look forward to collaborating with innovative teams and recruiters who share my vision for the future of data analytics.

Key Skills

SQL

EXCEL

Power BI

Data- Driven Decision

My Projects

My Experience

Internship

Data Analyst Intern – KultureHire
Aug 2024 – Oct 2024

As a Data Analyst Intern at KultureHire, I analyzed Gen Z's career aspirations through survey data, refining large datasets in Excel. Using Pivot Tables, I uncovered key trends and designed an interactive dashboard to visualize career preferences, industry interests, and skill demands. My insights supported data-driven decisions, enhancing my expertise in data visualization, statistical analysis, and Excel automation. This hands-on experience sharpened my analytical and problem-solving skills, preparing me for real-world challenges in data-driven industries.

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Accenture North America Data Analytics and Visualization Job Simulation on Forage

Accenture North America Data Analytics and Visualization Job Simulation on Forage

PwC Switzerland Power BI Job Simulation on Forage

PwC Switzerland Power BI Job Simulation on Forage

Data Visualisation: Empowering Business with Effective on Forage

Data Visualisation: Empowering Business with Effective on Forage

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.

[email protected]

https://www.linkedin.com/in/vishal-lohia-33b2a0313

+ 91 9013795816

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
Engagement

Sales Analytics (FMCG)

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

Sales Analytics (FMCG)

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 developed a comprehensive sales report using Excel pivot tables, providing businesses with valuable insights to refine their discount strategies, strengthen consumer negotiations, and uncover potential expansion opportunities in high-growth markets. These reports serve as a powerful tool to optimize sales strategies, improve customer satisfaction, and drive revenue growth.

Throughout the process, I gained hands-on experience in key analytical skills, including:

-Pivot Tables for dynamic data summarization
-Power Query for efficient data transformation
-DAX (Basics) for advanced calculations
-Conditional Formatting to highlight key trends
-Report Beautification for professional presentation
-Sales Domain Metrics to measure business performance

Ultimately, this project empowers businesses with data-driven decision-making capabilities, enabling them to track, evaluate, and enhance their sales performance.

PowerBI Project

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

Domain/Function: BI 360

AtliQ Hardwares, a fast-growing consumer electronics company, struggles to compete due to reliance on Excel for reports. My mission is to implement a cutting-edge Power BI analytics solution, empowering data-driven insights and smarter decision-making for a competitive edge.

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

User-empathetic landing page as a part of dashboard design

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

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

PowerBI Project

Blinkit

Domain/Function: Sales

Boosted total sales to $1.2M through targeted location strategies, with Tier 3 outlets contributing $472K (39% of total revenue) and Medium-sized outlets accounting for 42% of sales and Performed detailed product analysis to uncover high-performing categories such as Fruits and Snacks

View Project
Engagement

Boosted total sales to $1.2M through targeted location strategies, with Tier 3 outlets contributing $472K (39% of total revenue) and Medium-sized outl

The dashboard showcases key sales metrics, totaling $31.81K in revenue with an average sale of 149 across 214 items. Tier 2 outlets were the t

Project Details

In my previous project, I played a key role in increasing total sales to $1.2 million by implementing targeted location strategies that effectively capitalized on the unique strengths of various outlet tiers. This strategic approach helped optimize revenue generation across different regions. Through careful analysis and data-driven decision-making, I was able to identify and maximize the potential of Tier 3 and medium-sized outlets, which contributed significantly to the overall sales growth.

Tier 3 outlets alone accounted for $472,000, representing 39% of total sales, emphasizing their crucial role in the success of our sales strategy. Medium-sized outlets contributed 42% of overall revenue, showcasing the value of customizing our approach based on outlet size and location. This strategy enhanced market penetration, ultimately driving sales performance across key regions.

Live Interactive Dashboard