Pavan Jalkote

Power BI Developer & Data Analyst

[email protected] +91 8669039559

Hello, I am

Pavan Jalkote.

4

PowerBI
Projects

About Me

Data-driven BI specialist with 5+ years’ experience (Excel, SQL, Python, Power BI) leading analytics projects to deliver clear business impact. Combining an analytical mindset (honed by a Civil Engineering degree) with strong leadership, I’ve led cross-functional projects that boost efficiency and inform strategy. Proficient in Excel, SQL, Python and Power BI, I turn raw data into interactive dashboards and reports that deliver measurable business outcomes. I focus on solving real-world problems and clearly communicating the impact of my work (for example, cost savings or faster decision-making), rather than just detailing technical steps. Adaptable and results-driven, I thrive on transforming complex challenges into data-driven solutions that drive growth.

Key Skills

Excel

Power BI

SQL

Python

Communication Skill

Project Management

Data Analysis

Microsoft Fabric

My Projects

BMC Switzerland Sales Analytics Dashboard

Domain/Function: Sales

Dune HR Analytics Dashboard

Domain/Function: HR

Laptop Sales Report

Domain/Function: Sales

Starbucks Coffee Dashboard

Domain/Function: Healthcare

My Experience

1] Kernshell Technologies Private Limited - Lead Power BI Developer

02/2024 – Present | Pune, India

Designed dynamic Power BI reports and dashboards, delivering tailored, interactive solutions to meet diverse business requirements.
Ensured 100% requirements gathering by capturing and analyzing key business needs for effective data visualization and analysis.
Collaborated on data transformation with data engineers to clean, transform, and optimize large datasets for reporting.
Implemented complex DAX calculations, creating advanced measures to enhance data insights and report interactivity.
Maintained data security and compliance by adhering to industry best practices to protect sensitive information.
Resolved Power BI issues within 24 hours, ensuring seamless report functionality through rapid troubleshooting.
Empowered end-user adoption by conducting training sessions and supporting selfservice analytics using Power BI tools.
Stayed updated with the latest trends, continuously advancing skills through monthly learning on Power BI updates and features.

2] Toyo Engineering India Private Limited - Assistant Project Engineer

02/2021 – 02/2024 | Mumbai, India

Reduced costs by 45-50% through Power BI dashboards and data-driven insights.
Developed financial reports, contributing to a ₹100 Crore revenue boost.
Automated reporting, cutting man-hour consumption by 50% and increasing profit margins.
Designed interactive Power BI reports for business intelligence and forecasting.
Ensured timely and quality delivery of Power BI solutions aligned with business goals

Awards & Certificate

Excel: Mother of Business Intelligence

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

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.

Mail Me

[email protected]

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

Call Me

+91 8669039559

PowerBI Project

BMC Switzerland Sales Analytics Dashboard

Domain/Function: Sales

Welcome to my BMC Switzerland Sales Analytics Dashboard. In this project, I'll show you how I transformed raw sales data into interactive business insights using Power BI, helping stakeholders monitor KPIs, identify trends, track performance, and make smarter decisions.

View Project
Engagement

Other Tools

SQL Server

Excel

Landing Page of the dashboard

Product Summary Page

Project Details

Developed an interactive Power BI Sales Analytics Dashboard for BMC Switzerland to analyse sales data from 2020–2022.
Built executive dashboards to monitor key business KPIs, including Revenue, Profit, Cost, Orders, Returns, and Return Rate.
Created interactive visuals to analyse sales by category, subcategory, product, region, and country.
Designed customer insights based on age group, gender, occupation, and income level.
Added monthly and weekly trend analysis to track sales, profit, orders, and returns.
Compared actual performance with business targets using KPI and gauge visuals.
Implemented interactive slicers, filters, and navigation for seamless data exploration and faster business decision-making.

Live Interactive Dashboard

PowerBI Project

Dune HR Analytics Dashboard

Domain/Function: HR

Welcome to my HR Analytics Dashboard. In this project, I'll show you how I transformed HR data into meaningful insights using Power BI, helping HR teams monitor workforce trends, employee attrition, satisfaction, demographics, and overall workforce performance for better decision-making.

Other Tools

Azure SQL Server

Excel

Landing Report Page

Employee Satisfaction Report Page

Project Details

Developed an interactive HR Analytics Dashboard in Power BI to analyse employee data and support data-driven HR decisions.
Built executive KPI cards to track Total Employees, Active Employees, Gender Distribution, Departments, and Job Roles.
Analysed employee attrition by department, job role, age, and education to identify workforce retention trends.
Created workforce insights using education, age, marital status, department, and monthly income analysis.
Monitored job satisfaction, work-life balance, environment satisfaction, and manager performance ratings across different job roles.
Implemented interactive slicers, filters, and navigation for seamless report exploration and faster HR decision-making.

Live Interactive Dashboard

PowerBI Project

Laptop Sales Report

Domain/Function: Sales

Welcome to my Laptop Sales Analytics Dashboard. In this project, I'll walk you through how I transformed laptop sales data into interactive business insights using Power BI, enabling businesses to monitor revenue, pricing, discounts, brand performance, and product trends for smarter decisions.

View Project
Engagement

Other Tools

SQL Server

Excel

Landing Page

Category Details Page

Project Details

Developed an interactive Laptop Sales Analytics Dashboard in Power BI to analyse sales performance across multiple brands and product categories.
Built executive KPI cards to track Total Revenue, MRP, Discount Percentage, and Month-over-Month performance.
Created interactive visuals to analyse daily, weekly, and monthly sales trends, helping identify revenue patterns over time.
Designed brand-level insights to compare revenue contribution and average selling price across leading laptop brands.
Analysed product-wise revenue, discount trends, and revenue per item (RPI) to identify top-performing products and pricing opportunities.
Implemented dynamic slicers, filters, bookmarks, and intuitive navigation to deliver an engaging and user-friendly reporting experience.

Live Interactive Dashboard

PowerBI Project

Starbucks Coffee Dashboard

Domain/Function: Healthcare

Welcome to my Starbucks Nutrition Analytics Dashboard. In this project, I'll show you how I transformed beverage nutrition data into interactive insights using Power BI, helping customers compare drinks, understand nutritional values, and make healthier beverage choices with confidence.

View Project
Engagement

Other Tools

Excel

Folders

CSV Files

Landing Page

Insights Page

Project Details

Developed an interactive Starbucks Nutrition Analytics Dashboard in Power BI to analyse the nutritional value of beverages across different categories.
Built intuitive visuals to compare calories, carbohydrates, protein, fat, caffeine, vitamins, and sugar across drinks and preparation types.
Identified the best beverages for caffeine, protein, and vitamin content, helping users choose drinks based on their nutritional needs.
Created detailed nutritional tables with drill-down capabilities for beverage categories and ingredient variations.
Analyzed trans fat content and highlighted healthier drink options with informative visuals and nutritional insights.
Designed a modern, interactive report with seamless navigation, bookmarks, and filters to deliver an engaging and user-friendly experience.