Powered by
Codebasics Data Analytics Bootcamp

Rajesh Kundu

Power BI Developer

[email protected]

Resume

Hello, I am

Rajesh Kundu.

2

PowerBI Projects

1

Excel Project

About Me

Welcome! I’m Rajesh Kundu, a certified Power BI Data Analyst with a passion for transforming data into actionable insights. I specialize in building dynamic, visually compelling dashboards and reports that drive real business impact. With expertise in data modeling, DAX, and Power Query, I ensure seamless integration of diverse data sources for optimal solutions.

Having completed over 15 successful projects across finance, healthcare, and retail, I thrive on delivering solutions that exceed expectations. I’ve also trained 50+ users, empowering teams to make data-driven decisions with confidence.

Let’s talk if you’re looking to elevate your business intelligence capabilities or simply want to exchange ideas on the latest in data visualization. I'm always excited about new opportunities!

Key Skills

Effective Communication

Problem Solving

Data Analysis

Data Visualization

Data Modelling

My Projects

My Experience

-Advanced development of Power BI dashboards and reports
-Expertise in data modeling and transformation using Power Query and DAX
-Skilled in connecting, integrating, and managing diverse data sources
-Implementing row-level security to safeguard data integrity
-Collaborating with stakeholders to design and deliver impactful solutions

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Microsoft Certified: Power BI Data Analyst Associate

Microsoft Certified: Power BI Data Analyst Associate

Let's Connect

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 protected]

https://www.linkedin.com/in/rajesh-kundu-0326261a9

https://github.com/Rajesh10001

PowerBI Project

Business Insights 360

AtliQ Hardware, a consumer electronics giant, currently relies on Excel for data analysis, hampering competitiveness. I aim to elevate their analytics game by implementing a robust Power BI solution, enabling the company to gain crucial insights for smarter decision-making.

View Project
Engagement

View Project
on GitHUB

Business Insights 360

Explore P&L dynamics, spotlighting top performers for strategic decisions.

Business Insights 360

Navigate performance trends, optimizing sales for maximum revenue.

Project Details

The primary objective of this project is to implement a centralized solution that provides interactive Key Performance Indicator (KPI) visuals and reports for Finance, Sales, Marketing, and Supply Chain views.

Throughout the project, I acquired the following skills and knowledge:

1. Data Modeling: Designed a comprehensive data model with over 10 interconnected tables, proficiently addressing intricate data relationships and dependencies
2. DAX: Mastered both basic and complex DAX formulas for effective data manipulation, creating tailored calculations, aggregations, and metrics.
3.Visuals: Selected visuals adeptly to convey information intuitively and implemented formatting techniques for visually appealing and clear reports.
4. Power BI Deployment: Successfully deployed the solution on Power BI, ensuring wider accessibility.

Live Interactive Dashboard

Excel Project

Sales and Finance Analytics

Created dynamic Excel reports analyzing sales trends and key profits, aiding smart choices. Project digs into money matters and market position using easy reports like "Customer Net Sales Performance" and "Market Performance vs. Target," making data simple for savvy moves.

View Project
Engagement

View Project
on GitHUB

Sales and Finance Analytics

The Customer Performance Report displays the yearly net sales performance for each customer.

Sales and Finance Analytics

This report allows stakeholders to evaluate the country's performance over multiple years and compare it to the established targets.

Project Details

Crafted a powerful Customer Performance report using Excel's Power Pivot and Pivot Tables, breaking down net sales year-wise to reveal growth trends. Explored Market Performance vs. Target, analyzing net sales country-wise for strategic improvements. Dived into Financial Analysis, covering Net Sales, COGS, Profit, and Profit Percentage quarterly, offering a holistic view of the financial landscape.

Skills Applied:

1. Cleaned and loaded data for a solid foundation.
2.Created robust data models for meaningful insights.
3.Crafted custom measures for nuanced analysis.
4.Built Pivot Tables for actionable insights.
5.Enhanced reports for visual appeal and clarity.

PowerBI Project

Pizza Sales Analysis

Uncover pizza sales dynamics with my Power BI report. Real-time analysis reveals trends, top varieties, and customer segments. Integrated data sources offer a holistic view, empowering stakeholders to drive growth in the competitive pizza industry.

View Project
on GitHUB

Pizza Sales Analysis

Unveils insights on busiest days, sales performance, and key KPIs, including total revenue.

Pizza Sales Analysis

Reveals best and worst-selling pizzas by taking parameters like revenue to total orders.

Project Details

Dynamic Power BI report that takes a deep dive into the world of pizza sales. Leveraging real-time data analysis, this report becomes a treasure trove of insights, unraveling sales trends, customer preferences, and crucial performance metrics.

Key Features:

Comprehensive Sales Analysis: Uncover revenue trends over time and regional sales performance for a 360-degree view.
Visualized Pizza Insights: Presenting top-selling varieties and popular toppings visually to guide strategic menu decisions.
Customer Segmentation: Analyzing customer demographics to tailor marketing strategies and target the right audience effectively.
Integrated Data Sources: Enriching analysis with external data for a holistic view of the pizza market landscape.

Key Learnings:
This project delved deep into Power BI's capabilities, honing my skills in real-time data analysis, dynamic report creation, and integrating external data for a comprehensive perspective.

Live Interactive Dashboard