Portfolio - Umang Vataliya | Codebasics

Powered by
Codebasics Bootcamp

Hello, I am

Umang Vataliya

Data Analyst

1

Excel
Project

1

PowerBI
Project

About

Me

Welcome to my portfolio! I am an aspiring Data Analyst with a passion for transforming raw data into actionable insights. I have a knack for digging into data and finding valuable insights using tools like Excel, Power BI, SQL, and Python. My educational background includes a Bachelor's degree in Computer Application and Information Technology (B.Sc. IT). It's where I laid the foundation for my passion for data analysis and honed my skills in technology. Although I haven't yet had the opportunity to work in a formal organizational setting, I've been actively engaged in several dynamic business projects. You can explore these projects further in my portfolio below. I'm always keen to improve and use data to make smart choices. If you need someone who's ready to learn and make a difference as a Data Analyst, I'm here for you.

Thank you for visiting my portfolio, and I look forward to connecting with recruiters who appreciate the power of data and are ready to leverage it for success.

Technical

Skills

Excel

PowerBI

Statistical analysis

My

Projects

Sales Analytics(FMCG)

Sales Analytics(FMCG)

Developed 2 concise sales reports to evaluate customer and market performance against targets. These reports empower the sales team with actionable insights for informed decision-making and strategic planning.

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

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

AtliQ Hardware, an expanding consumer electronics company, is lagging behind competitors due to its reliance on Excel reports. My objective is to introduce an advanced analytics solution using Power BI. This solution will equip the company with valuable insights.

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

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

Google Data Analytics Capstone: Complete a Case Study

Cisco Data Analytics Essentials

Contact Me

Email

[email protected]

Github

https://github.com/01UvCoder

Linkedin

https://www.linkedin.com/in/umang-vataliya-76a342283/

Call

+91 8141305679

Umang Vataliya

Data Analyst

Download Resume

Resume

Excel Project

Sales Analytics(FMCG)

Developed 2 concise sales reports to evaluate customer and market performance against targets. These reports empower the sales team with actionable insights for informed decision-making and strategic planning.

View Project
on GitHUB

Sales Analytics(FMCG)

Customer Performance Report: Delivers insights into individual customer net sales performance across multiple years.

Sales Analytics(FMCG)

Market Performance vs. Target Report: Empowers stakeholders to evaluate country performance against predefined targets across multiple years.

Project Details

In this project, I crafted a sales report using Excel pivot tables. This report helps businesses figure out the best customer discounts, negotiate with customers, and spot growth chances in promising countries. The reports I made give clear insights and suggestions for businesses to improve their sales strategies, make customers happier, and earn more money.

Here's what I learned:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to give businesses the tools and insights they need to watch, assess, and boost their sales activities. By analyzing sales data, businesses can find new opportunities, grow, and stay competitive in the changing market.

PowerBI Project

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

AtliQ Hardware, an expanding consumer electronics company, is lagging behind competitors due to its reliance on Excel reports. My objective is to introduce an advanced analytics solution using Power BI. This solution will equip the company with valuable insights.

View Project
Engagement

View Project
on GitHUB

Other Tools

SQL

Excel

DAX Studio

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

Creating a user-friendly landing page as part of dashboard design, prioritizing the needs and experience of the users.

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

Data modelling involving 10+ tables

Project Details

This project aims to create a single report that serves stakeholders from sales, marketing, finance, and the executive team. Key focuses include following

1. Creating a strong data model.
2. Designing user-friendly reports.
3. Providing detailed, drillable insights.

Through this project, I've gained expertise in:

1. Basic and advanced Power Query operations.
2. Basic and complex DAX formulas
3. Data modeling involving 10+ tables
4. Selecting appropriate visuals and formatting.
5. Dashboard designing principles
6. Using Bookmarks to switch between two visuals
7. Deploying reports in Power BI service.
8. Incorporating stakeholder feedback.
9. Understanding metrics from various departments.
10.Setting up auto-refresh of data using personal gateway.

Live Interactive Dashboard