Fabric & Power BI Expert | Data Agents, Real-Time, Fabric IQ
- $50k+
- Earned
- 2x
- Hired
- 5.0
- Rating
- 41
- Followers
Fabric & Power BI Expert | Data Agents, Real-Time, Fabric IQ
Business Analyst | Power BI Dashboard Expert | Excel Automat
- 12
- Followers
Business Analyst | Power BI Dashboard Expert | Excel Automat
AI-Powered Geopolitical & Supply Network Exposure Intelligence Dashboard
Global supply chains are complex. Understanding where your business is exposed shouldn’t be.
I designed Global Shield Analytics as an executive-level Power BI solution that connects geopolitical risk, supplier dependency, critical materials, operational disruption, recovery time, and financial exposure in one intelligent reporting environment.
Instead of simply showing what happened, the solution is designed to help leadership understand:
Where are we exposed? → What could be affected? → What could it cost? → How long could recovery take? → What should we investigate next?
What I Can Build for Your Business
Every organization has different data, KPIs, reporting processes, and decision-making requirements. I build the Power BI solution around your actual business needs, rather than forcing your data into a generic template.
Requirement Discovery
I understand your reporting challenges, business objectives, KPIs, stakeholders, existing reports, and required outcomes.
Data Preparation
I connect, clean, transform, and structure data from sources such as Excel, SQL, ERP, CRM, and other business systems using Power Query.
Data Modelling
I develop a scalable semantic model with relationships, dimensions, measures, and business logic designed around your reporting requirements.
DAX & KPI Development
I create the calculations required for your business — financial metrics, operational KPIs, supplier performance, risk indicators, trends, targets, and other decision metrics.
Power BI Dashboard Development
I transform the prepared data into a professional, interactive dashboard with executive KPIs, drill-down analysis, filters, trends, comparisons, risk views, and actionable insights.
Business Validation
I validate the calculations and outputs against the agreed requirements and source data so the final reporting solution is consistent and business-ready.
Performance Optimisation
I structure and optimise the model and report for better performance, usability, navigation, and scalability.
Final Delivery
I provide the completed Power BI solution with the agreed reporting structure, visuals, calculations, and handover documentation.
🔗 From Business Requirement to Final Intelligence
Requirement → Data → Power Query → Data Model → DAX → KPIs → Dashboard → Validation → Final Delivery
Whether your organization needs to replace manual Excel reporting, consolidate fragmented data, improve an existing Power BI environment, or build a new executive BI solution, the dashboard can be designed around the specific problem you need to solve.
The Business Value
The goal is not to create more charts.
The goal is to create a single, clear decision-support layer that helps teams understand complex business exposure faster and focus attention where it matters.
Power BI | Microsoft Fabric | SQL | Power Query | DAX | Data Modelling | Executive BI
📅 Dashboard Date: 17 September 2026
📊 Reporting Period: 01 January 2026 – 17 September 2026
🔄 Last Refresh: 17 September 2026, 17:20 IST
Have a Power BI or Business Intelligence requirement?
Share the business problem, reporting challenge, or data requirement. I can design and build the Power BI solution around it — from initial requirements through final delivery.
0
145
💎 Enterprise Value Realization Dashboard
Track Investments. Realize Benefits. Drive Business Impact.
The Enterprise Value Realization Dashboard is a professional Business Intelligence solution designed to measure whether business projects and investments are delivering their promised benefits. It provides a centralized view of planned benefits, realized benefits, value gaps, benefit realization rates, and investment impact, enabling leadership to understand where investments are creating value and where corrective action is required.
With interactive analytics, this dashboard helps organizations monitor project outcomes, identify benefit gaps, prioritize underperforming investments, and improve overall return on strategic initiatives.
📊 Key Metrics
Planned Benefits
Realized Benefits
Value Gap
Benefit Realization %
Investment Impact (ROI)
Overall Value Realization Score
📈 Dashboard Features
Executive Value Realization KPI Overview
Planned vs Realized Benefits Analysis
Benefit Realization Trend
Business Unit Value Gap Analysis
Project Benefit Performance
Investment Impact & ROI Analysis
Investment vs Realized Benefits
Executive Insights & Recommendations
💼 Business Value
This dashboard helps organizations:
Measure actual benefits against planned outcomes
Identify projects with significant value gaps
Track investment performance and ROI
Prioritize initiatives requiring corrective action
Improve benefit realization across business units
Support data-driven investment decisions
Designed by:
Srujana Reddy | Business Analyst
Transforming investment and project data into actionable insights that measure realized value, identify performance gaps, and improve strategic business outcomes.
💼 Client Note
Thank you for exploring my portfolio.
The Enterprise Value Realization Dashboard is a professional Power BI solution designed to help organizations measure whether strategic projects and investments are delivering their expected business benefits. It provides clear visibility into planned versus realized benefits, value gaps, benefit realization rates, and investment impact, enabling leadership to identify underperforming initiatives and focus resources where they can create the greatest value.
I specialize in developing modern, interactive Power BI dashboards that transform project, investment, and financial data into actionable insights for strategic decision-making.
Services I Offer
Enterprise Value Realization Dashboards
Investment & ROI Analytics
Project Portfolio Analytics
Strategic KPI Dashboards
Benefit Tracking & Performance Reporting
Interactive Power BI Reports
Advanced DAX & Data Modeling
Custom Business Intelligence Solutions
What You Can Expect
Executive-Level Dashboard Design
Interactive & User-Friendly Reports
Advanced DAX & Data Modeling
Real-Time Benefit & Investment KPI Monitoring
Business-Focused Visualizations
Customized Solutions Tailored to Your Business Needs
Every dashboard I develop is designed to measure realized business value, identify benefit gaps, evaluate investment performance, and provide leadership with clear insights for better resource allocation and strategic execution.
If you're looking for a custom Power BI Enterprise Value Realization Dashboard to measure project outcomes, track investment impact, and improve benefit realization, I'd be happy to collaborate on your next project.
Let's transform your investment data into actionable insights that maximize realized value, improve ROI, and drive measurable business outcomes.
0
239
🧠 Organizational Network Intelligence Dashboard
Understand Connections. Strengthen Collaboration. Reduce Organizational Risk.
The Organizational Network Intelligence Dashboard is a professional Business Intelligence solution designed to analyze how information, collaboration, and relationships flow across an organization. It provides a centralized view of collaboration density, key connectors, network centrality, collaboration gaps, and organizational risk, helping leadership understand communication patterns and identify areas that need stronger cross-functional collaboration.
With interactive network analytics, this dashboard helps organizations identify influential connectors, detect collaboration gaps, improve information flow, and reduce organizational dependency and communication risks.
📊 Key Metrics
Collaboration Density
Key Connectors
Network Centrality
Collaboration Gaps
Organizational Risk Score
Collaboration Health Score
📈 Dashboard Features
Executive Network KPI Overview
Interactive Organizational Network Map
Key Connector Analysis
Network Centrality Trends
Department Collaboration Gap Analysis
Collaboration Gap Heatmap
Organizational Risk Monitoring
Executive Insights & Recommendations
💼 Business Value
This dashboard helps organizations:
Understand collaboration patterns across teams
Identify key employees who connect different groups
Detect cross-department collaboration gaps
Improve information flow and knowledge sharing
Identify organizational network risks
Support data-driven organizational planning
Designed by:
Srujana Reddy | Business Analyst
Transforming organizational network data into actionable insights that strengthen collaboration, improve information flow, and build a more connected and resilient organization.
💼 Client Note
Thank you for exploring my portfolio.
The Organizational Network Intelligence Dashboard is a professional Power BI solution designed to help organizations understand collaboration patterns, information flow, and cross-functional relationships. It provides visibility into collaboration density, key connectors, network centrality, collaboration gaps, and organizational risk, helping leadership identify communication bottlenecks and strengthen collaboration across teams.
I specialize in developing modern, interactive Power BI dashboards that transform complex organizational data into actionable insights for better workforce planning, collaboration, and business decision-making.
Services I Offer
Organizational Network Intelligence Dashboards
Collaboration & Workforce Analytics
Executive KPI Dashboards
Cross-Department Performance Analytics
Organizational Risk Reporting
Interactive Power BI Reports
Advanced DAX & Data Modeling
Custom Business Intelligence Solutions
What You Can Expect
Executive-Level Dashboard Design
Interactive & User-Friendly Reports
Advanced DAX & Data Modeling
Collaboration & Network KPI Monitoring
Business-Focused Visualizations
Customized Solutions Tailored to Your Business Needs
Every dashboard I develop is designed to identify collaboration gaps, understand organizational connections, improve information flow, and provide leadership with actionable insights for stronger organizational performance.
If you're looking for a custom Power BI Organizational Network Intelligence Dashboard to analyze collaboration, identify network risks, and improve cross-functional connectivity, I'd be happy to collaborate on your next project.
Let's transform your organizational data into actionable insights that strengthen collaboration, reduce communication gaps, and drive better business outcomes. 🚀
1
344
🔗 Strategic Dependency Intelligence Dashboard
Understand Dependencies. Manage Risk. Protect Strategic Outcomes.
The Strategic Dependency Intelligence Dashboard is a professional Business Intelligence solution designed to help organizations identify how strategic initiatives depend on other teams, systems, projects, and business capabilities. It provides a centralized view of dependency relationships, critical dependencies, dependency risks, blocked initiatives, and overall impact scores.
With interactive analytics, this dashboard helps leadership identify high-risk dependencies early, reduce project delays, prioritize critical actions, and improve coordination across strategic initiatives.
📊 Key Metrics
Dependency Map
Critical Dependencies
Dependency Risk
Blocked Initiatives
Impact Score
Overall Dependency Health
📈 Dashboard Features
Executive Dependency KPI Overview
Interactive Dependency Network Map
Critical Dependency Analysis
Dependency Risk Trend Monitoring
Blocked Initiative Tracking
Impact Score Analysis
Initiative & Business Unit Comparison
Executive Insights & Recommendations
💼 Business Value
This dashboard helps organizations:
Identify critical dependencies early
Reduce initiative delays and blockers
Prioritize high-impact risks
Improve cross-team coordination
Understand dependency-driven business impact
Support data-driven strategic planning
Designed by:
Srujana Reddy | Business Analyst
Transforming dependency data into actionable insights that reduce strategic risk, remove blockers, and improve successful execution of enterprise initiatives.
💼 Client Note
Thank you for exploring my portfolio.
The Strategic Dependency Intelligence Dashboard is a professional Power BI solution designed to help organizations understand and manage dependencies across strategic initiatives, teams, systems, and projects. It provides clear visibility into critical dependencies, dependency risks, blocked initiatives, and impact scores, enabling leadership to identify potential delays and prioritize high-impact actions.
I specialize in building modern, interactive Power BI dashboards that transform complex business relationships and operational data into actionable insights for strategic decision-making.
Services I Offer
Strategic Dependency Dashboards
Project & Initiative Analytics
Risk & Impact Analysis
Executive KPI Dashboards
Portfolio Performance Reporting
Interactive Power BI Reports
Advanced DAX & Data Modeling
Custom Business Intelligence Solutions
What You Can Expect
Executive-Level Dashboard Design
Interactive & User-Friendly Reports
Advanced DAX & Data Modeling
Dependency & Risk KPI Monitoring
Business-Focused Visualizations
Customized Solutions Tailored to Your Business Needs
Every dashboard I develop is designed to identify critical dependencies, reduce blockers, improve cross-functional coordination, and provide leadership with clear insights for faster strategic execution.
If you're looking for a custom Power BI Strategic Dependency Dashboard to identify project dependencies, manage risks, and improve initiative execution, I'd be happy to collaborate on your next project.
Let's transform your dependency data into actionable insights that reduce strategic risk, remove bottlenecks, and drive successful business outcomes. 🚀
1
206
Senior Data Analyst | Business Intelligence Consultant
View more →
Data visualization engineer, Data Analyst, BI Expert
National Accident Statistics Dashboard in Google Looker Studio:
I built an interactive Looker Studio dashboard using Google Sheets as the data source to visualize national accident statistics. The report analyzes accidents by region, time, severity, and demographics. A scheduled data re:fresh every 15 minutes keeps the dashboard updated in real time. As a Data Visualization Expert, I combined automation and design to deliver a clean, insightful, and dynamic Looker Studio dashboard for data-driven decision-making.
🎉 💯 🎉
2
198
I build AI agents & internal tools that act on data
Superstore Sales Dashboard — 3-Page Power BI Report
Built an interactive 3-page Power BI dashboard using
the Superstore Sales dataset (9,994 orders across USA).
Page 1 — Sales Overview: KPI cards, monthly trend,
regional breakdown, category performance.
Page 2 — Product Performance: Top products, category
donut, profit analysis, sales vs profit scatter.
Page 3 — Customer & Shipping: Segment breakdown,
top 10 customers, monthly growth, ship mode distribution.
Tools: Power BI, DAX, Superstore Dataset
Theme: Dark professional with interactive year filter.
0
219
I’m a Data Analyst specializing in cleaning, structuring, and analyzing marketing and sales data using Python, Excel, SQL, and Power BI.
I help businesses fix broken data pipelines, resolve formatting issues, and turn raw data into accurate dashboards that support decision-making.
My work focuses on clarity, reliability, and scalability—ensuring reports remain consistent as data grows.
If you’re struggling with inconsistent data or dashboards that don’t reflect reality, I can help streamline the process end-to-end.
0
479
Sales, Customer & Marketing Analytics in Power BI
I built a complete 3-page Power BI dashboard to analyze Sales performance, Customer behavior, and Marketing ROI—all in one place.
🔍 Sales Overview
Revenue trends & top product categories
Total Sales, Orders & Average Order Value
Region-wise and payment method analysis
👥 Customer Insights
New vs Returning customers
Customer Lifetime Value (LTV) by region
Purchase frequency & repeat behavior using DAX
📈 Marketing Performance
Spend vs Revenue across Paid Ads, Social, Referral, Influencer/UGC, Email & Offline
Clear ROI comparison to identify winning and underperforming channels
🛠 Tools Used: Power BI, SQL, DAX, CSV
💡 Outcome:
This project shows how combining Sales, Customer, and Marketing data helps businesses make faster, smarter decisions.
0
344
Power BI Expert | Turning Raw Data into Actionable Insights
Power BI Expert | Turning Raw Data into Actionable Insights
Data Analytics Project | BlinkIT Grocery Sales Analysis
Excited to share my latest Data Analytics project ,where I analyzed BlinkIT Grocery Sales Data and delivery data to uncover meaningful business insights 📈
📊 What I worked on:
Analyzed sales performance across product categories, outlet types, sizes, and locations
Identified top-performing item categories and customer preferences
Studied the impact of outlet size, establishment year, and visibility on sales
Converted raw data into actionable insights and business recommendations
💡 Key Insights:
Fruits & Vegetables, Snack Foods, and Frozen Foods drive maximum sales
FOR FULL PROJECT VIST GIT HUB –( https://lnkd.in/d34sdAPz
)
1
91
I’m excited to share my latest Data Analytics project where I analyzed Customer Shopping Behavior to uncover trends in sales, demographics, and purchasing habits.This project was a great exercise in building a complete data pipeline.
The Tech Stack:
Python (Pandas & NumPy): Used in Jupyter Notebooks for initial data exploration and statistical analysis.
PostgreSQL: Utilized for rigorous data cleaning, querying, and structuring the dataset for analysis.
Power BI: Built an interactive dashboard to visualize key metrics like seasonal trends, subscription impacts, and category performance.
Project Highlights:
✅ Data Cleaning: Leveraged PostgreSQL and Pandas to handle missing values and standardize categorical data.
1
2
124
Venezuela’s Oil Reserves Analysis Dashboard 📊
I am excited to share my latest data analytics project focusing on the energy sector. Using a dataset covering 23 reservoirs, I designed a comprehensive dashboard to track production capacity and resource distribution in Venezuela.
Key Features: ✅ Real-time Metrics: Tracking the 390.50 Billion total barrels in reserve. ✅ Granular Analysis: Production capacity breakdown by reservoir name and oil grade (Extra Heavy to Light). ✅ Stakeholder Mapping: Visualizing the production sum by major operators.
Tools Used: [pandas(jupyter notebook)/mysql(for analysis and cleaning of data), Power BI / Excel(for building dashboard)]
I’d love to hear your thoughts or feedback on the dashboard design!
must visit my github for full project -( https://lnkd.in/dYKdZ8J2
)
0
106
Data Analytics Project | BlinkIT Grocery Sales Analysis
Excited to share my latest Data Analytics project ,where I analyzed BlinkIT Grocery Sales Data and delivery data to uncover meaningful business insights 📈
📊 What I worked on:
Analyzed sales performance across product categories, outlet types, sizes, and locations
Identified top-performing item categories and customer preferences
Studied the impact of outlet size, establishment year, and visibility on sales
Converted raw data into actionable insights and business recommendations
💡 Key Insights:
Fruits & Vegetables, Snack Foods, and Frozen Foods drive maximum sales
Medium-sized outlets outperform others in overall revenue
FOR FULL PROJECT VIST GIT HUB –( https://lnkd.in/d34sdAPz
)
Feedback and suggestions are always welcome!
1
1
121
Analytical, MIS and Expert in automating reports
Data Analyst & Power Platform Specialist
📍 Mumbai, India | 📞 +91 7021027927 | ✉️ maheshkheder329@gmail.com (mailto:maheshkheder199@gmail.com)
Analytical and results-driven Data & MIS Specialist with 5+ years of experience optimizing reporting frameworks, automating complex workflows, and designing business intelligence solutions in the financial and insurance sectors. Skilled in transforming raw data into actionable insights using Power BI, SQL, Advanced Excel (VBA), and Power Automate. Recognized for delivering end-to-end data pipelines, custom approval workflows, and robust financial models.
Core Capabilities & Technical Toolkit
Business Intelligence & Dashboards: Power BI (Expert DAX, Power Query, Dynamic RLS), SAP BO, Trend & P&L Analysis
Database & Data Architecture: SQL (Data Modeling, Query Optimization, Joins, Data Validation), Dataverse, SharePoint Lists
Process Automation: Excel VBA Macros, Power Automate (Multi-stage Approval Workflows, Data Integration)
Analytics : Data Cleaning, Data Reconciliation, Python (Data Processing & Visualization)
1
243
Integrating modern automation into daily business operations serves as a catalyst for eliminating repetitive manual overhead, drastically reducing human error, and accelerating critical decision-making cycles. By leveraging structured workflows through tools like SQL, Excel VBA macros, Power BI dashboards, and custom Python automation scripts, organizations can transform complex, fragmented datasets into dynamic, real-time reporting systems. Rather than spending valuable hours manually aggregating reports, cleansing raw data, or cross-referencing records across disparate databases, automated pipelines seamlessly process and visualize key metrics in real time. This operational shift not only enhances operational speed and analytical precision across functions like MIS and performance tracking, but it also frees up core team members to focus on high-impact strategic initiatives and proactive business growth.
Name - Mahesh Narendra Khedekar
Contact No -(+91) 7021027927 [fast responce Conntact with whatapp]
Email ID - maheshkhedekar329@gmail.com
1
160
Monthly Reinsurance Premium and Claim Register
The Monthly Reinsurance Premium and Claim Register is an advanced Excel-based reporting and administration engine tailored for insurance operations, treaty accounts, and claims management. Designed to handle high-volume bordereaux files, this solution automates premium allocations, cession calculations, and claims recovery tracking across complex reinsurance treaties.
By replacing manual spreadsheets with automated Power Query models, dynamic lookup formulas, and VBA macro pipelines, the system eliminates human calculation errors, prevents recovery leaks, and standardizes disparate insurance data streams into unified master logs. Key features include automated validation algorithms to flag cessions discrepancies, real-time tracking of paid versus pending claims, and interactive executive dashboards for audit readiness.
Whether processing proportional treaties, excess of loss accounts, or monthly bordereaux statements, this workflow cuts monthly closing timelines by up to 80%. It delivers complete, transparent data lineage, robust audit trails, and zero-error execution for finance, underwriting, and reinsurance operations teams.
1
198
Data Analyst & BI Dev | Dashboards, SQL, Python & ETL
Marketplace Profitability & P&L Engine
Overview
This project is an end-to-end E-commerce Marketplace Analytics solution built using MySQL, SQL, Power BI, and Excel.
The objective of this project is to analyze marketplace profitability across multiple sales channels by calculating revenue, product costs, marketplace commissions, shipping expenses, and net profit.
The project simulates a real-world marketplace operations environment where business teams need visibility into product performance, marketplace profitability, and operational KPIs.
Business Problem
E-commerce businesses often track revenue but fail to understand true profitability.
This project helps answer key business questions:
Which marketplace generates the highest profit?
Which products are most profitable?
How do commissions impact margins?
What is the overall profit margin?
How does shipping cost affect profitability?
Tech Stack
MySQL
SQL
Power BI
Microsoft Excel
Data Sources
Products
Contains SKU-level product information.
Fields:
SKU
Product Name
Category
Cost Price
Selling Price
Orders
Contains marketplace order transactions.
Fields:
Order ID
Order Date
Marketplace
SKU
Quantity
Marketplace Charges
Marketplace commission structure.
Fields:
Marketplace
Commission Percentage
Shipping Cost
Shipping cost by marketplace.
Fields:
Marketplace
Shipping Cost
Returns
Order return information.
Fields:
Order ID
Return Status
SQL Implementation
The project uses multiple SQL tables and joins to create a unified profitability dataset.
Key SQL Concepts Used:
CREATE TABLE
INNER JOIN
SQL Views
Aggregations
Calculated Metrics
A consolidated analytical view was created:
vw_marketplace_pnl
This view combines all business logic and serves as the primary source for Power BI reporting.
Profitability Metrics
Revenue
Revenue = Quantity × Selling Price
Product Cost
Product Cost = Quantity × Cost Price
Commission Cost
Commission Cost = Revenue × Marketplace Commission %
Shipping Cost
Shipping Cost = Quantity × Shipping Cost
Profit
Profit = Revenue − Product Cost − Commission Cost − Shipping Cost
Profit Margin %
Profit Margin % = Profit / Revenue
Power BI Dashboard
Executive Summary
KPIs:
Total Revenue
Total Profit
Total Orders
Profit Margin %
Marketplace Analysis
Revenue by Marketplace
Profit by Marketplace
Marketplace Performance Comparison
Product Analysis
Top Profitable Products
Product Revenue Analysis
Product Profitability Ranking
Trend Analysis
Revenue Trend
Profit Trend
Order Trend
Project Architecture
Excel → MySQL → SQL View → Power BI Dashboard
Key Outcomes
Built a scalable marketplace profitability model.
Centralized business logic using SQL Views.
Automated profitability calculations.
Delivered interactive executive dashboards for decision-making.
Simulated a real-world marketplace operations analytics workflow.
Skills Demonstrated
SQL
Data Modeling
Business Intelligence
Power BI
E-commerce Analytics
Marketplace Operations
Profitability Analysis
Data Visualization
Author
Sunny Mehta
Open to opportunities in:
E-commerce Operations
Marketplace Management
Business Analytics
Operations Analytics
Data Analytics
0
28
Netflix Movies Analysis Dashboard using Power BI
Project Overview
Interactive Power BI dashboard analyzing Netflix movie trends, popularity, ratings, genres, and language distribution.
KPIs
Total Movies
Total Votes
Total Popularity
Average Rating
Dashboard Features
Top 10 Movies by Popularity
Release Year Trend
Movies Distribution by Language
Genre Analysis
Popularity vs Vote Average
Tools Used
Power BI
Power Query
DAX
Data Modeling
3
122
Banking Data Analysis Dashboard
Develop a basic understanding of risk analytics in banking and financial services and understand how data is used to minimise the risk of losing money while lending to customers
Solution – With our dashboards which are created using Power BI latest tools helps the company to make a decision based on the applicant’s profile like if the applicant is likely to repay the loan then approving the loan otherwise not.
About Dataset – This dataset basically contains information about bank details ,various client details which consists of multiple tables which are interlinked with each other through keys like primary key and foreign key. The various tables are Banking Relationship, Client-Banking, Gender, Investment Advisor and Period.
KPI’S:
In which followings KPIS are present :
Total Clients :
Total Clients KPI represents total number of clients in banking.
Total Clients = DISTINCTCOUNT('Clients - Banking'[Client ID] )
Total Loan :
Total Loan gives you information about the bank loan + Business lending + credit cards balance of particular investor , gender.
Total Loan = [Bank Loan] + [Business Lending] + [Credit Cards Balance]
Bank Loan :
Bank Loan gives you information what is the loan amount of loan to be repaid by the client to bank.
Bank Loan = SUM('Clients - Banking'[Bank Loans] )
Business Lending : Business lending gives you information about the loan amount given to small business. Business Lending = SUM('Clients - Banking'[Business Lending] )
Total Deposit Total Deposit gives you information about the amount deposited by particular investors in bank Total Deposit = [Bank Deposit] + [Savings Account] + [Foreign Currency Account] + [Checking Accounts]
Total Fees : Total Fees is nothing but the amount charged by the bank for account set-up , maintenance charges etc. Total Fees = SUMX('Clients - Banking' , [Total Loan] * 'Clients - Banking'[Processing Fees] )
Bank Deposit : Bank deposit is the money put in the bank. Bank Deposit = SUM('Clients - Banking'[Bank Deposits] )
Checking Account Amount : Checking account amount is nothing but which offers easy access to your money for daily transactional needs. Checking Accounts = SUM('Clients - Banking'[Checking Accounts] )
Total CC Amount : Total CC Amount is a short-term source of financing for a company by a bank. Total CC Amount = SUM('Clients - Banking'[Amount of Credit Cards] )
Saving Account Amount : A savings account is an interest-bearing deposit account held at a bank. Savings Account = SUM('Clients - Banking'[Saving Accounts] )
Foreign Currency Amount : Foreign Currency Account means an account held in a currency that is not the currency of India or Bhutan or Nepal. Foreign Currency Account = SUM('Clients - Banking'[Foreign Currency Account] )
Engagement Account : Engagement Banking is nothing but puts the customer at the center and aims to deliver the digital experiences they expect. Engagment Length = SUM('Clients - Banking'[Engagment Days])
Credit Cards Balance : It is the total amount of money currently owned by a cardholder to their credit card bank. Credit Cards Balance = SUM('Clients - Banking'[Credit Card Balance] )
📊 Tools Used
Excel (Data Cleaning) SQL (Data Processing) Python (EDA) Power BI (Dashboard)
📈 Key Insights Private banks dominate loan distribution European segment shows highest deposits Low-income customers have high loan dependency
1
62
Blinkit-Sales-Dashboard
This project is an interactive Power BI dashboard developed to analyse Blinkit's sales performance, outlet operations, product distribution, and customer-related metrics. The dashboard converts raw retail sales data into meaningful business insights through visualisation and KPI tracking. The objective of this project is to monitor business performance, identify sales trends, evaluate outlet efficiency, and support data-driven decision-making.
Key KPIs
Total Sales: $1.20M
Average Sales: $140.99
Number of Items: 8,523
Average Rating: 3.9
Dashboard Features
Sales Analysis
Tracked total revenue and average sales performance to understand overall business growth.
Outlet Performance
Analysed outlet sales based on the following:
Outlet Size
Outlet Location Type
Outlet Establishment Year
Outlet Type
Product Category Analysis
Identified top-performing product categories contributing the highest revenue.
Customer & Product Insights
Compared low-fat and regular products to understand purchasing trends and monitored customer ratings for performance evaluation.
Interactive Filters
Added slicers for:
Outlet Location Type
Outlet Size
Item Type
Outlet Type
Outlet Identifier
These filters allow users to dynamically explore data and generate business insights.
Project Outcome
This project demonstrates practical skills in business intelligence, KPI reporting, analytical thinking, and dashboard development using Power BI. It highlights the ability to transform raw business data into business insights for decision-making.
Developed By
Sunny Mehta
1
73