Portfolio - Uzair Shaikh

Hello, I am

Uzair Shaikh

Data Aspirant

Resume

1

Excel
Project

1

PowerBI
Project

About

Hey there! I'm Uzair, a data enthusiast diving into the world of numbers. Even though I got my degree in Commerce, the magic of data analysis stole my heart
I've used Excel, Power BI, and SQL. While I haven't officially worked in an office yet, take a look at my portfolio, and you'll find some cool projects I've worked on
But hey, life isn't just about work, right? Outside of my data adventures, I experiment with DIY projects and maybe even try my hand at some cooking experiments. Balance is key, and I believe in enjoying every bit of life.

I'm here to share what I learn. Join me on this journey, and together, we'll dive into the world of numbers, add a dash of creativity, and find joy in every data discovery. Ready for a fun ride? Let's do this!

Key

Skills

stakeholder Management

My

Projects

Sales Analytics(FMCG)

Made two helpful reports for the sales team. These reports show how well customers are doing and help the team understand how their market performance compares to their goals.

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

AtliQ hardware is growing fast but struggles against data-smart rivals because most reports are in Excel. I aim to use Power BI for better insights and smart decisions, helping the company in the competitive electronics market.

Contact Me

Email

[email protected]

https://www.linkedin.com/in/uzair-shaikh1/

Call

+91 7977437736

Uzair Shaikh

Data Aspirant

Download Resume

Resume

Excel Project

Sales Analytics(FMCG)

Made two helpful reports for the sales team. These reports show how well customers are doing and help the team understand how their market performance compares to their goals.

Customer Performance Report: Displays the net sales performance for individual customers over multiple 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 utilized Excel pivot tables to create a sales report, enabling businesses to identify effective customer discounts, streamline negotiations, and pinpoint potential expansion opportunities in promising countries. The resulting reports provide actionable insights and recommendations, empowering businesses to optimize sales strategies, enhance customer satisfaction, and maximize revenue.

Key Learnings:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Aesthetic Enhancement of Reports
6. Sales Domain Metrics
This project aims to equip businesses with essential tools and insights to monitor, evaluate, and enhance their sales activities. By delving into sales data analysis, businesses can uncover new opportunities, drive growth, and remain competitive in the dynamic market landscape.

PowerBI Project

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

View Project
Engagement

User-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 versatile report benefiting stakeholders in sales, marketing, finance, and the executive team. Emphasis is made on following :

1. Solid Data Modeling
2. User-Friendly Report Design
3. Drillable Insights

Key Learnings:

1. Power Query (Basic and Advanced Operations)
2. Basic and Advanced DAX Formulas
3. Handling 10+ Data Tables
4. Choosing Appropriate Visuals and Formatting
5. Principles of Dashboard Design
6. Utilizing Bookmarks
7. Deployment in Power BI Service
9. Implementing Stakeholder Feedback
10. Metrics in Sales, Marketing, Finance & Supply Chain

Hello, I am

Uzair Shaikh

1

1

About

Key

My

Sales Analytics(FMCG)

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

Contact Me

Email

Linkedin

Call

Uzair Shaikh

Download Resume