Portfolio - Dipeshkumar shah

Hello, I am

Dipeshkumar shah

Data Analyst

About Me.

With 2+ years of proven experience in data analysis, I specialize in leveraging tools like Power BI, SQL, Python, Advanced Excel and database technologies to deliver actionable insights and drive business performance. My expertise spans data warehousing, ETL processes, cloud platforms (AWS, Azure, GCP), and real-time analytics, empowering businesses to optimize operations and improve decision-making. Passionate about staying ahead of industry trends, I focus on creating data-driven solutions using the latest technologies and cloud tools to enhance business intelligence and scalability.

2

PowerBI Projects

1

Python Project

1

Excel Project

Skills.

Power BI

SQL

EXCEL

Python

AWS/Azure

Microsoft SQL Server

Projects.

My Experience.

Circle K, Toronto – Associate Data Analyst: Retail Operations

May 2024 - Apr 2024

=========================

Ecubix, Ahmedabad, IND – Data Analyst
May 2020 – Jun 2021

=========================

TMSG Marketing Group, Bengaluru, IND – Data Analyst Intern
Jul 2019 – Dec 2019

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

Entry Certificate for Business Analysis

Contact.

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]

Call Me

+1 6474079662

https://www.linkedin.com/in/shah-dipesh/

GitHub

https://github.com/Dipesh454

PowerBI Project

Business Insights 360

Domain/Function: Sales

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make in

Home Page of the project to access the different operations of the company.(Sales view, Finance view, Marketing View, Supply Chain, Executive View).

Screenshot showcasing a Snowflake schema design with normalized dimension tables and a central fact table for efficient data storage and reporting.

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

Business Performance Analysis: Goodcabs

Domain/Function: Operations

Goodcabs a cab service Company, who has established a strong base in top 10 tier 2 cities of India. How can they broader their range to reach the benchmark of 2024.

View Project
Engagement

Goodcabs, a cab service company established two years ago, has gained a strong foothold in the Indian market by focusing on tier-2 cities. Unlike othe

Tracking KPIs.

Project Details

Goodcabs, a cab service company established two years ago, has gained a strong foothold in the Indian market by focusing on tier-2 cities. Unlike other cab service providers, Goodcabs is committed to supporting local drivers, helping them make a sustainable living in their hometowns while ensuring excellent service to passengers. With operations in ten tier-2 cities across India, Goodcabs has set ambitious performance targets for 2024 to drive growth and improve passenger satisfaction.

As part of this initiative, the Goodcabs management team aims to assess the company’s performance across key metrics, including trip volume, passenger satisfaction, repeat passenger rate, trip distribution, and the balance between new and repeat passengers.

Project video

Live Interactive Dashboard

Python Project

Atliqo Telecom Industry

Domain/Function: Telecom Industry

After the 5G launch in May 2022, Wavecon's management noticed a decrease in active users and revenue growth. The director asked the analytics team for a comparison of KPIs pre and post-launch to make informed decisions for recovery. They're also exploring internet plan optimizations to increase acti

View Project
on GitHUB

Database modeling using STAR Schema.

Distribution of Average revenue per user.

Project Details

AtliQo is one of the leading telecom providers in India and launched its 5G plans in May 2022 along with other telecom providers.

However, the management noticed a decline in their active users and revenue growth post 5G launch in May 2022. AtliQo’s business director requested their analytics team to provide a comparison report of KPIs between pre and post-periods of the 5G launch. The management is keen to compare the performance between these periods and get insights that would enable them to make informed decisions to recover their active user rate and other key metrics. They also wonder if they can optimize their internet plans to get more active users. Peter Pandey, a junior data analyst, is assigned to this task.

Excel Project

Excel Sales Analytics

Domain/Function: Sales

This Excel project aims to deliver comprehensive analyses, including customer and market performance, product trends, and detailed profit and loss reports. These insights are essential for businesses to effectively monitor key performance indicators, financial performance, aid in decision making.

View Project
on GitHUB

P&L Report

Quarterly Gross Margin

Project Details

Created dynamic Excel reports to analyze AtliQ Hardware’s sales and financial data, uncovering key trends and profit drivers. These reports turn complex data into actionable insights, leveraging Excel’s powerful analytical capabilities. The comprehensive analyses include customer and market performance, product trends, and detailed profit and loss reports on a yearly and quarterly basis. This work supports AtliQ Hardware in making data-driven decisions that drive strategic business growth.