Portfolio - Sameer Shaik

Excel Project

Sales Analytics(FMCG)

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 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 Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

AtliQ Hardware is a consumer electronics company expanding rapidly but cannot compete with other companies using data as most of their reports still exist in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights

View Project
on GitHUB

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

User-empathetic landing page as a part of dashboard design

Data modeling involving 10+ tables

Project Details

This project aims to create one report that stakeholders from sales, marketing, finance, and executive teams could use. 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

AD-HOC Analysis

Presented Insights on 10 ad-hoc business requests to the executive management team, by querying the million rows database using SQL. The target audience of this dashboard is top-level management - hence I created a presentation to show the insights

View Project
on GitHUB

Provide the list of markets in which customer "Atliq Exclusive" operates its business in the APAC region.

What is the percentage of unique product increase in 2021 vs. 2020? The final output contains these fields,unique_products_2020, unique_products_2021

Project Details

This project provides Insights to the management in the 'Consumer Goods Domain'. SQL, Presentation, and PowerBI were used to make quick and smart data-informed decisions.

Python Project

Hotel Data Analysis

Hospitality data analyst skilled in operations, customer behavior, revenue, and market trends. Proficient in Python's Pandas for data cleaning, transformation, EDA, and visualization. Committed to leveraging insights for informed decisions and enhanced customer experiences.

View Project
on GitHUB

Imported Pandas in the Jupyter Notebook. Read the CSV files into the Jupyter Notebook and used head() function to print top 5 rows.

Used Value_counts() function to get the unique from "booking platoform" column and count them. Used the plot() function to print the bar graph.

Project Details

● Conducted thorough data analysis, revealing peak booking periods and operational improvements, providing valuable insights
for strategic decision-making.
● Presented findings to management, influencing business strategy with targeted improvements to enhance customer
satisfaction and streamline operations.
● It contributes to the company's goal of regaining market share and increasing revenue by leveraging data driven insights

Hello, I am

Sameer Shaik

1

1

1

1

About

Key

My

Sales Analytics(FMCG)

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

AD-HOC Analysis

Hotel Data Analysis

Contact Me

Email

Github

Linkedin

Call

Sameer Shaik

Download Resume