Portfolio - Sagar More | Codebasics

Powered by
Codebasics DA Bootcamp

Hello, I am

Sagar More

Data Aspirant

Resume

1

Excel
Project

1

PowerBI
Project

About

Me

Welcome to my portfolio! I am a Data Analyst with a passion for turning data into actionable insights. I am skilled in PowerBI, SQL and Excel, and thrive on the challenge of diving deep into data to uncover trends and insights that drive business success.

My journey into data analysis began while working for 3.5 yrs as a SAP UI5 Frontend Developer at Accenture, where I discovered my innate abilities in this field. There, I not only developed apps but also analyzed the data they generated, honing my analytical skills & helping my clients with crucial, data-driven business decisions.

Holding a Bachelor's degree in Electronics & Telecommunication, I bring a unique perspective to data analysis, blending technical proficiency with analytical acumen. This combined with my practical experience in data analysis, positions me uniquely to help organizations leverage their data for strategic business advantage.

Explore my portfolio to see how I can contribute to your team’s success!

Key

Skills

SQL

Statistical Analysis

Analytical Reasoning

Project Management

Stakeholder Mangement

My

Projects

AtliQ Sales & Finance Analysis

AtliQ Sales & Finance Analysis

Explored AtliQ Hardwares data regarding Customer, Product and Market performance and crafted key Sales and Finance Reports for strategic decision making using Excel.

Leveraged ETL methodologies, Data Modelling, DAX, Power Query and Power Pivot to design productive reports.

MeriSKILL Sales Analysis

MeriSKILL Sales Analysis

Delves into a comprehensive analysis of the Sales dataset provided by MeriSKILL. The dataset includes information about Product Sales, Quantities, Revenue and Geographic data that can be analyzed to offer valuable insights to optimize sales strategies and drive business growth.

Awards

& Certificate

HackerRank SQL 5 Star Gold Badge

HackerRank SQL 5 Star Gold Badge

Contact Me

Email

[email protected]

Github

https://github.com/5ifar

Linkedin

https://www.linkedin.com/in/sagarmorework/

Call

+91 8329843490

Sagar More

Data Aspirant

Download Resume

Resume

Excel Project

AtliQ Sales & Finance Analysis

Explored AtliQ Hardwares data regarding Customer, Product and Market performance and crafted key Sales and Finance Reports for strategic decision making using Excel. Leveraged ETL methodologies, Data Modelling, DAX, Power Query and Power Pivot to design productive reports.

View Project
Engagement

View Project
on GitHUB

AtliQ Sales & Finance Analysis

Comprehensive analysis of key Finance KPIs like Net Sales, Gross Margin, COGS and Gross Margin % in a P & L Report mapped by Fiscal Months.

AtliQ Sales & Finance Analysis

Optimized Star Schema Data Model connecting the Fact & Dimension Tables.

Project Details

This project involves designing Sales & Finance reports using Excel's powerful Pivot Tables. These reports empower businesses to monitor sales, optimize customer discounts, drive improvements, streamline negotiations and identify growth prospects in the new emerging market landscape.

Key Learning:
⦁ Harnessing Power Query to clean up data using ETL Process
⦁ Optimizing Data Models
⦁ Creating 10 + DAX formulas
⦁ Data Summarization using Pivot Table and Power Pivot
⦁ Enhancing data presentation with Conditional Formatting
⦁ Gained knowledge of crucial Sales & Finance KPIs like Net Sales, Gross Margin, COGS (Cost of Goods Sold), Gross Margin %, and Freight Cost.

All Report Images have been uploaded to my GitHub Repository.

PowerBI Project

MeriSKILL Sales Analysis

Delves into a comprehensive analysis of the Sales dataset provided by MeriSKILL. The dataset includes information about Product Sales, Quantities, Revenue and Geographic data that can be analyzed to offer valuable insights to optimize sales strategies and drive business growth.

View Project
Engagement

View Project
on GitHUB

MeriSKILL Sales Analysis

Sales Analysis of KPIs like Revenue, Avg Order value and Quantity Sold across various metrics like Date, State/City and Top/Bottom Products.

MeriSKILL Sales Analysis

Optimized Star Schema Data Model connecting the Fact & Dimension Tables. Custom Measures table was created.

Project Details

This project involved analysis of Sales data to identify trends, top-selling products and revenue metrics aimed at extracting valuable insights to facilitate strategic data-driven business decision making and optimizing sales strategies using Power BI.

Analysis Insights & Recommendations have been incorporated in the Dashboard Insights page.

Key Learning:
⦁ ETL with Power Query
⦁ Data Normalization
⦁ Custom Date Table
⦁ Revenue - Avg Order Value/Quantity Sold Toggle Button setup using Bookmarks
⦁ Gained knowledge of crucial Sales KPIs like Revenue & Average Order Value and their implications when designing Sales strategies.

Live Interactive Dashboard