Portfolio - Rishika R | Codebasics

Powered by
Codebasics DA Bootcamp

Hello, I am

Rishika R

Data Analyst

Resume

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

About

Me

Welcome to my world of data-driven insights! I'm Rishika, a passionate data analyst who excels at transforming raw data into meaningful narratives that drive informed decision-making. I combine technical skills with a creative mindset to uncover hidden patterns, trends, and stories that add value to businesses.

➔ Background: Transitioned from Electronics and Communication Engineering (ECE) into data analytics, blending technical expertise with a passion for data-driven solutions.

➔ Skills: Proficient in SQL, Power BI, Excel, and Python, with hands-on experience in diverse projects solving real-world challenges.

➔ Strengths: Dedication, problem-solving, adaptability, and a strong analytical mindset.

➔ Weakness: Perfectionism, but I’m actively working on balancing it to maintain efficiency.

➔ What’s Next?: If you're looking for a data analyst who brings a unique mix of expertise and creative thinking, let's unlock the potential of your data together!

Key

Skills

Sql

Python

Communication

Problem Solving

Attention To Detail

My

Projects

Sales Analytics

Sales Analytics

Domain/Function: 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

Awesome Chocolates Sales Analytics

Awesome Chocolates Sales Analytics

Domain/Function: Sales Insights

This project focuses on analyzing Awesome Chocolates' sales performance, profit margins, shipments, and operational efficiency using Power BI.The dashboard provides key insights into sales trends, top performers &shipment fluctuations, helping identify areas for improvement in marketing strategies

SQL- Consumer Goods Ad Hoc Insights

SQL- Consumer Goods Ad Hoc Insights

Domain/Function: CPG

This project was focused on leveraging SQL to solve complex, real-time business problems through the use of ad-hoc queries and advanced database management techniques.

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

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

CB Cert

SQL Beginner to Advanced For Data Professionals

Contact Me

Email

[email protected]

Github

https://github.com/rxshz37

Linkedin

https://www.linkedin.com/in/rishika-r-581350245?utm_source=share&utm_campaign=share_via&utm_content=profile&utm_medium=android_app

Call

+91 9566305387

Rishika R

Data Analyst

Download Resume

Resume

Excel Project

Sales Analytics

Domain/Function: 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

Sales Analytics

Customer Performance Report: Provides net sales performance of each customer across years

Sales Analytics

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
7. Establishing data model relationships with Power Pivot.

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

Awesome Chocolates Sales Analytics

Domain/Function: Sales Insights

This project focuses on analyzing Awesome Chocolates' sales performance, profit margins, shipments, and operational efficiency using Power BI.The dashboard provides key insights into sales trends, top performers &shipment fluctuations, helping identify areas for improvement in marketing strategies

View Project
on GitHUB

Awesome Chocolates Sales Analytics

Overall Dashboard

Awesome Chocolates Sales Analytics

Data Model

Project Details

In this project, I built a Power BI dashboard to analyze the sales data of Awesome Chocolates, which revealed critical insights like a 10.8% decline in sales and profit margins of $21M. By analyzing shipment trends and salesperson performance, the dashboard highlights areas for optimization.

What I Learned:
I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Sales & Marketing metrics
10. Merging and Appending

Tools & Skills Used:

1 .Power BI for data visualization and dashboard creation
2.DAX for custom calculations and measures
3.Data analysis techniques to assess sales performance, profit, and operational efficiency

Live Interactive Dashboard

SQL Project

SQL- Consumer Goods Ad Hoc Insights

Domain/Function: CPG

This project was focused on leveraging SQL to solve complex, real-time business problems through the use of ad-hoc queries and advanced database management techniques.

View Project
on GitHUB

SQL- Consumer Goods Ad Hoc Insights

STORED PROCEDURE - a reusable SQL script saved in the database to perform tasks like queries, updates, or logic.

SQL- Consumer Goods Ad Hoc Insights

VIEWS - a virtual table to optimize the system performance and fetch the data faster.

Project Details

I utilized SQL queries to extract and analyze data, ensuring accuracy and relevance. I implemented stored procedures to streamline the process, automating repetitive tasks and enhancing efficiency. Additionally, I used views to improve query performance by simplifying complex data retrieval and ensuring faster execution. This combination of SQL techniques allowed for better data management and reporting.

I have learned the following:

1. Data retrieval using SQL queries.
2. Entity Relationship Diagram.
3. Extract, Transform, Load.
4. OLTP and OLAP.
5.SQL functions.
6. Creation of a Database.
7. SQL Data types.
8. Automation with stored procedures.
9. Streamlining data management
10. Kanban - Project Management Methodology.

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their short-term goals. By leveraging data analysis, businesses can unlock new opportunities, drive growth, and stay competitive.