Portfolio - Shailesh Tiwari

Shailesh Tiwari

Inspiring Data Analyst

Resume

1

Excel Project

1

PowerBI Project

1

SQL Project

About Me

As a data analyst I want to leverage my analytical skills and passion for data to drive informed decision making and
business growth. I aim to become proficient in statistical analysis and data visualization software techniques using
tools like (Excel, Power bi, SQL, Python) to extract insights from complex datasets. By collaborating with crossfunctional teams, I aspire to identify trends that lead to actionable recommendations, ultimately contributing to the
organization's success.

Key Skills

Python

ETL Tool

Communication Skill

MYSQL and DBMS

SQL

Data visualization

data extraction

data cleaning

data modelling

data mangement

My Projects

Sales Analytics

Business Insight's 360 Dashboard for ( Finance view , Sales view ,marketing view , Supply chain view & Executive View )

PIZZA_SALES_ANALYSIS

Domain/Function: Sales Domain

Awards & Certificate

Extract ,Transform & Load ( ETL TOOLS )

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/shailesh-tiwari-a038b1183

Call Me

+91 9369054140

Excel Project

Sales Analytics

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

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 created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

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.

PowerBI Project

Business Insight's 360 Dashboard for ( Finance view , Sales view ,marketing view , Supply chain view & Executive View )

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

View Project
Engagement

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

SQL Project

PIZZA_SALES_ANALYSIS

Domain/Function: Sales Domain

The objective of this analysis is to provide a comprehensive overview of sales performance of various pizza type and categories. The insights derived will strategic decision-making to optimize inventory management, enhanced customer satisfaction and derived sales revenue growth.

View Project
Engagement

View Project
on codebasics

Data Extraction process zip file to csv file and tables information.

Database design diagram

Project Details

Project data extraction process-
Download the pizza_sales.zip from Ayushi jain mam github account and extract zip files to unzip file & convert into a csv files.
this csv files contains the four different files such as
1-order_details.csv 2- Orders.csv 3-Pizza_type.csv 4- Pizzas
i am basically using the some SOL important concepts such as ( joins, aggregate function-count ,sum, min, max ,subquery, CTE , window function, rank ).Using of pizza sales data to analysis the sales trend and pattern and improved the business decisions & predict the company growths.