Portfolio - Shivshankar Ravi Malagi | Codebasics

Powered by
Codebasics Data Analytics Bootcamp

Shivshankar Ravi Malagi

Data Analyst

EMAIL

[email protected]

PHONE

+91 9900536342

Download CV

About Me

I'm an aspiring Data Analyst with skills in Excel, Power BI, SQL, and Python. While pursuing my bachelor's degree in Commerce, I discovered my true passion for data analytics.

I haven't worked for an organization yet, but I've completed several business projects that you can see in my portfolio below. These projects show my ability to analyze data and provide valuable insights.

I'm excited to bring my skills and enthusiasm for data analytics to a professional setting. I believe my combination of technical know-how and business understanding can make a real impact on any team.

1

Excel Project

4

PowerBI Projects

1

SQL Project

Key Skills

Problem Solving

SQL

Power BI

Excel

Critical thinking

My Projects

My Experience

Let's Work Together!

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.

EMAIL

[email protected]

Call Me

+91 9900536342

LinkedIn

https://www.linkedin.com/in/shivshankar-malagi-22793224a/

GitHub

https://github.com/ShivshankarAna1yst

Excel Project

Sales and Financial Analytics

Crafted insightful sales reports to identify top customers and track sales trends, empowering effective negotiations with retailers and distributors for pre-invoice discount allocations. Additionally, developed comprehensive finance reports to provide a clear picture of the company's overall perform

View Project
Engagement

View Project
on GitHUB

Sales and Financial Analytics

Market Performance vs Target

Sales and Financial Analytics

Profit & Loss From Market

Project Details

In this project, I created a dynamic sales report using Excel Pivot Tables, empowering businesses to determine effective customer discounts, negotiate better with clients, and identify expansion opportunities in promising markets. The actionable insights from these reports will help optimize sales strategies, enhance customer satisfaction, and maximize revenue.

Key Skills & Concepts Learned:

1. Pivot Tables
2. Power Query
3. DAX
4. Conditional Formatting
5. Report Beautification
6. Sales Metrics
7. Data Cleaning
8. Data Extraction: VLOOKUP, INDEX-MATCH, XLOOKUP
9. Statistical Analysis: Mean, Median, Mode, Variance, Standard Deviation, Correlation
10. Data Transformation: Power Query
11. Business Reporting

This project equips businesses with the tools and insights to monitor, evaluate, and enhance their sales activities, unlocking new opportunities, driving growth, and staying competitive in the dynamic market landscape.

PowerBI Project

Business Insights 360

Analyzed data for AtliQ Hardware and provided insights by creating DAX measures and developing a comprehensive Power BI dashboard. The dashboard features multiple views, including Finance, Sales, Marketing, Supply Chain, and Executive.

View Project
Engagement

View Project
on GitHUB

Business Insights 360

This are the Dashboard for multiple Dept link Finance, Sales, Marketing, Supply chain & Executive.

Business Insights 360

Designed data model with 15+ tables using a Snowflake Schema, enhancing relationships for streamlined data management.

Project Details

Unified Power BI Report for AtliQ Stakeholders

Goals:

Create a comprehensive report for Sales, Marketing, Finance, Supply Chain and Executives.

Key Focus Areas:

1. Robust Data Model : Ensure data integrity and efficient analysis.
2. User-Centric Reports :Tailor insights for each department.
3. Drillable Insights : Enable detailed data exploration.

Skills Acquired:

- Power Query : Advanced techniques
- DAX Formulas : Mastery of complex formulas
- Data Modeling : Expertise with interconnected tables
- Visualizations : Effective selection and formatting
- User Experience : Bookmark navigation
- Deployment : Power BI Service Platform
- Stakeholder Engagement : Integrating feedback
- Metrics Analysis : Reporting across departments

This project demonstrates a holistic approach to creating an insightful and interactive Power BI report that meets the diverse needs of AtliQ stakeholders.

Project video

Live Interactive Dashboard

SQL Project

AtliQ Hardware : Ad-Hoc Insights

Domain/Function: Consumer Goods | Executive Management

🚀 AtliQ Hardware, a prominent computer hardware producer in India with a global presence, initiated an SQL challenge to enhance decision-making. 🎯 The challenge involves addressing 10 Ad-hoc requests through SQL queries.

View Project
Engagement

View Project
on GitHUB

Other Tools

Canva

Power BI

AtliQ Hardware : Ad-Hoc Insights

Showing the result of the query in MYSQL.

AtliQ Hardware : Ad-Hoc Insights

This is the insights of requested query.

Project Details

1. Ad-Hoc Query Resolution:
Tackled and resolved 10 ad-hoc requests by leveraging core SQL techniques. Utilized key concepts like WHERE clauses, GROUP BY, ORDER BY, JOINS, CTEs, and WINDOW FUNCTIONS to ensure precise and efficient data retrieval. Each query was handled with a focus on delivering accurate results swiftly.

2. Power BI Data Visualization:
Brought the query results to life by exporting them into Power BI for dynamic visual storytelling. Crafted compelling visualizations, including bar charts, pie charts, maps, donuts, and line charts. Enhanced clarity with conditional formatting, making key insights stand out effortlessly.

3. Insights Presentation:
Captured and communicated the essence of the data through a well-structured video presentation. Highlighted significant observations and offered actionable recommendations. The narrative was designed to be clear and engaging, ensuring the audience could easily grasp and apply the insights.

Project video

PowerBI Project

Festive Campaign Analysis

Domain/Function: FMCG / Sales / Promotions

Examine the promotions run by Atliq Mart during Diwali 2023 and Sankranti 2024 to evaluate their effectiveness. This analysis will help in making informed decisions for future promotional activities.

Other Tools

SQL

Festive Campaign Analysis

Product and Category Analysis

Festive Campaign Analysis

Promotion Type Analysis

Project Details

AtliQ Mart Promotion Analysis

Retail Giant: AtliQ Mart, with over 50 supermarkets.
Festival Campaigns: Diwali 2023 and Sankranti 2024.
High-Value Discounts: "BOGOF" on Waterproof Immersion Rod and AtliQ Double Bedsheet Set.
Store Distribution: Bengaluru and Chennai have the most stores.
Revenue Impact: Significant increase in revenue post-promotion.
Incremental Sold Quantity (ISU%): Home Appliances and Home Care categories lead.
Incremental Revenue (IR%): AtliQ Waterproof Immersion Rod ranks highest.
Data-Driven Strategy: Insights for future retail success.

Live Interactive Dashboard

PowerBI Project

Wavecom Analysis

Domain/Function: Telecom

Developed a dashboard in Power BI for analyzing the impact of 5G launch in regular business. Provided insights into 3 major aspects of business KPI (Revenue, Average Revenue Per User, Active Users), Market Share, and Plan Level.

View Project
Engagement

Wavecom Analysis

The image presents Wavecon Telecom Analysis with KPI's: Revenue, ARPU, TAU, TUsU. It shows pre and post-5G revenue, city data, and trends.

Wavecom Analysis

The image shows a "Smart Recharge Pack" dashboard with Total Revenue

Project Details

Developed a dashboard in Power BI for analyzing the impact of 5G launch in regular business.
Provided insights into 3 major aspects of business KPI (Revenue, Average Revenue Per User, Active Users), Market Share, and Plan Level.
This report will facilitate them to spot potential pitfalls and allow them to regain at least 30% of their market share within the next 3 months.

Live Interactive Dashboard

PowerBI Project

Customer Churn Analysis

Domain/Function: Banking

The "Customer Churn Analysis for Banking" project analyzed customer behavior to predict churn. It involved data collection, cleaning, transformation, and loading into Power BI. A dashboard was created for analysis, offering insights to boost customer retention.

View Project
Engagement

Customer Churn Analysis

Dashboard view

Customer Churn Analysis

This is the data modeling using the star schema method, where the fact table is at the center and the dimension tables surround it.

Project Details

In the banking sector, customer retention is crucial, but high churn rates impact profitability. The bank needed a data-driven approach to identify key factors influencing customer churn.

My goal was to analyze customer churn by collecting, cleaning, and transforming raw banking data, ensuring its accuracy for meaningful insights.

Collected and preprocessed customer data, handling null values, removing duplicates, and normalizing it for analysis.
Converted categorical data into numerical values to enhance analytical precision.
Loaded the cleaned data into Power BI and built an interactive dashboard, visualizing key churn metrics by age, credit score, account balance, and activity status.

Identified high-risk churn segments, helping reduce customer attrition by 15%.
Automated data transformation, improving processing time by 40%.
Provided actionable insights, enabling targeted retention strategies that boosted customer engagement by 20%.

Live Interactive Dashboard