Finally wrapped up the Power BI dashboard for my House Sales Analysis project π π
After cleaning and exploring the data with Python and writing SQL queries, I used Power BI to turn the analysis into an interactive dashboard.
In the dashboard, I explored:
House price trends
Property size and pricing
House grades
Waterfront vs non-waterfront properties
Location-wise pricing
Bedrooms and other property features
I also worked with DAX measures, slicers, interactive visuals, and KPIs to make the dashboard more useful for exploring the data.
This project helped me practice the complete data analytics workflow:
Python β Data Cleaning & EDA β SQL β Power BI
Still learning and improving with every project. π
#PowerBI #DataAnalyst #DataAnalytics #SQL #Python #EDA #DataCleaning #DAX #BusinessIntelligence #DataVisualization #PowerBIDashboard #PortfolioProject #DataAnalysis
0
68
Cyber Security Analytics Dashboard ππ
Cybersecurity is more than detecting threatsβit's about turning security data into actionable insights.
In this Power BI dashboard, I analyzed cybersecurity data to monitor security incidents, attack patterns, threat severity, affected systems, and overall security KPIs. The interactive dashboard helps organizations identify risks, improve monitoring, and support faster, data-driven security decisions.
Tools Used:
Power BI
SQL
Python (Data Cleaning & Analysis)
Key Skills:
Cyber Security Analytics | Threat Analysis | Security Dashboard | Risk Analysis | Incident Monitoring | Data Visualization | Business Intelligence | SQL | Python | Power BI | Data Analytics
#PowerBI #CyberSecurity #CyberSecurityAnalytics #ThreatIntelligence #DataAnalytics #BusinessIntelligence #DashboardDesign #SQL #Python #DataVisualization #DataAnalyst #PortfolioProject #SecurityAnalytics
0
94
Supply Chain Performance Dashboard π¦π
Efficient supply chains drive better business outcomes. This dashboard transforms operational data into actionable insights for inventory, logistics, and fulfillment performance.
Using Power BI, I analyzed key supply chain metrics such as order status, inventory levels, shipping performance, supplier efficiency, delivery timelines, and overall operational KPIs. The interactive dashboard helps identify bottlenecks, optimize inventory, and support data-driven decision-making.
Tools Used:
Power BI
SQL
Python (Data Cleaning & Analysis)
Key Skills:
Supply Chain Analytics | Inventory Analysis | Logistics Analytics | KPI Dashboard | Business Intelligence | Data Visualization | Data Cleaning | SQL | Power BI | Python | Business Analytics
#PowerBI #SupplyChain #SupplyChainAnalytics #Logistics #InventoryManagement #BusinessIntelligence #DataAnalytics #DashboardDesign #SQL #Python #DataVisualization #BusinessAnalytics #PortfolioProject #DataAnalyst
0
93
Telecom Customer Churn Analysis Dashboard π
Understanding why customers leave is essential for improving retention and business growth.
In this Power BI dashboard, I analyzed a telecom customer churn dataset to identify key churn drivers, customer demographics, contract types, monthly charges, payment methods, and tenure patterns. The dashboard provides interactive KPIs and visual insights that help businesses make data-driven decisions to reduce customer churn.
Tools Used:
β’ Power BI
β’ SQL
β’ Python (Data Cleaning & Analysis)
Key Skills:
Customer Churn Analysis | Data Cleaning | Data Visualization | KPI Dashboard | Business Intelligence | Interactive Reports | Data Analytics | Business Insights
#PowerBI #DataAnalytics #BusinessIntelligence #CustomerChurn #DashboardDesign #SQL #Python #DataVisualization #BusinessAnalytics #DataAnalyst #PortfolioProject #DataDrivenDecisionMaking
I fix warehouse chaos SOPs, SAP & Excel system for ops team
5.0
Rating
8
Followers
I fix warehouse chaos SOPs, SAP & Excel system for ops team
Stop defending Excel. It's costing you more than SAP ever would.
I've seen it too many times.
A warehouse running 3 locations off a shared spreadsheet. 4 versions of the same file. Nobody knows which one is real.
That's not a tool problem. That's a liability.
SAP isn't for everyone β but if your Excel sheet has more than 10 tabs and 3 people editing it, you've already outgrown it.
Here's the honest breakdown:
Excel is fine until:
β Two people overwrite each other's data
β A formula breaks and nobody notices for 3 weeks
β Your auditor asks for a trail and you have nothing
SAP makes sense when:
β Your ops span multiple sites or entities
β Finance, procurement, and warehouse need the same data
β Mistakes have a real cost
The question isn't which is better. It's which one matches where you actually are.
Which one are you using β and are you being honest about whether it's still working?
0
126
Why ERP systems like SAP, Oracle, and Odoo won't save your business β and what will
After years in FMCG warehouse operations and now working as a freelance supply chain consultant, I keep seeing the same mistake in local industries across Pakistan.
Every business owner, every operations manager, every CEO believes the same thing:
"If we get SAP, everything will be fixed."
It won't. Here's why β and what actually will.
The misconception
ERP systems β SAP, Oracle, Odoo, Microsoft Dynamics β are seen as the solution to every operational problem. Inventory inaccurate? Get an ERP. Deliveries delayed? Get an ERP. Team making mistakes? Get an ERP.
But this thinking gets it completely backwards.
ERP systems are tools. Powerful ones. But they are only as good as the humans using them β and humans, trained or untrained, make mistakes every single day in every single company.
What I saw firsthand
I consulted with a company that had spent millions implementing SAP.
Six months after go-live, their inventory data was still wrong.
The reason? Nobody had agreed on what a "received" delivery actually meant.
Was it received when the truck arrived? When the goods were scanned? When they were inspected? When they were put away in the correct location?
No SOP. No definition. No standard.
Every operator decided for themselves. The ERP logged whatever they entered.
Garbage in. Garbage out.
SAP didn't cause the problem. The missing process did. SAP just made it faster and more expensive.
The truth about AI
Now everyone is talking about AI as the next fix.
AI will not save you either.
AI works on specific, structured, accurate knowledge. If your fundamentals are missing β if your SOPs don't exist, your processes aren't documented, your data isn't clean β AI has nothing meaningful to work with.
I've seen this firsthand too. A business tried to use AI-powered demand forecasting on inventory data that hadn't been accurately recorded for 18 months. The AI produced confident, detailed forecasts. Every single one was wrong β because the underlying data was wrong.
The AI wasn't the problem. The missing process was.
What actually holds a company together
The backbone of every thriving operation is not its software. It's its systems and fundamentals:
β SOPs β documented, followed, and updated regularly
β Work processes β clear steps that any trained team member can follow
β SLAs β defined expectations between teams, suppliers, and customers
β Data standards β everyone agrees on what "received", "dispatched", and "completed" actually mean
Get these right first.
Then your ERP becomes powerful β because it's recording accurate, consistent data.
Then your AI becomes useful β because it has clean data to learn from.
Then your team stops making the same mistakes every quarter β because there's a standard to follow.
The formula
Software is the amplifier. Your fundamentals are the signal.
If the signal is broken, no amplifier in the world will fix it.
What this means for your business
Before your next software investment, ask these questions:
Do we have documented SOPs for our core processes?
Does every team member know what "done" means for their task?
Are our SLAs defined and measured?
Is our data accurate enough to trust?
If the answer to any of these is no β fix that first. The software can wait.
Need help with this?
This is exactly what my Warehouse SOP Audit service covers. In 5 days I'll review your current processes, identify where your fundamentals are missing, and give you a prioritised action plan β before you spend another rupee on software.
π Book a discovery call or view my services below.
https://contra.com/tabish_khan_r5d8g4t1/services?r=tabish_khan_r5d8g4t1
0
87
Most warehouse audits I've seen focus on the wrong things first. Neat labels, clean floors, a binder full of SOPs nobody's opened in months β all of it can look great and still sit on top of a warehouse that's quietly bleeding money.
And the SOP binder is usually worse than just outdated. Somewhere along the way, the actual process changed β someone found a faster way to do something, or worked around a problem β and that change lived in their head, not in the document. Everyone just adapts and moves on. Then that person leaves, and suddenly nobody can explain why the process works the way it does, because the only place it was ever really "written down" walked out the door.
If I only had fifteen minutes to walk a warehouse, here's honestly what I'd check.
I'd skip the month-end accuracy report and ask what's mismatched right now, today. A clean number at month-end really just tells you how good someone is at patching things up before a deadline. Asking about today tells you whether the process actually holds up when nobody's paying special attention to it.
Then I'd go find one picker and just watch them complete one real order, start to finish β not a demo, an actual order in the middle of a shift. You learn more in five minutes of watching someone walk a pick path than you do in an hour of reading reports. How far they're walking, how often they double back, how many times they have to stop and ask someone where something actually is.
I'd also want to know how long stock sits between receiving and put-away. Not how fast it gets scanned in β how long it physically sits on the dock before it's properly stored. That gap, more than almost anything else, is where damage, shrinkage, and "we can't find it" problems quietly start.
And I'd ask a warehouse worker why something's done a certain way β not a supervisor. If the answer is "that's just how we've always done it," that's usually a process nobody's questioned in years, or worse, a workaround that only exists in that one person's head.
Last thing, I'd look at what's actually sitting near the exit versus what's actually fast-moving. Layouts get set once and almost never revisited. More often than you'd think, the stuff people grab constantly is buried in the back, and something nobody's touched in months is sitting right up front for reasons nobody remembers anymore.
None of this needs a clipboard or a formal audit template. It just needs fifteen minutes and being willing to ask "why" one more time than feels comfortable β because the answer might only exist in one person's head, and that's the real audit finding.
0
108
Why your SAP data is inaccurate β and it's not SAP's fault.
Every time someone tells me "our SAP data is a mess," I ask a few questions, and almost every single time, the answer has nothing to do with SAP. The system did exactly what it was told, exactly when it was told. If the number on screen doesn't match what's actually on the shelf, something happened on the floor that never made it into the system β or it made it in late, or someone found a shortcut because doing it properly during a busy shift felt like a luxury nobody had time for.
Picture this: the shelf says 40. SAP says 42. Nobody's lying β the count on screen is just repeating something that was entered wrong, or late, or never corrected.
I've seen the same handful of patterns show up again and again, at different sites, with completely different teams.
Someone unloads a truck, and the goods receipt doesn't get posted until hours later because paperwork felt like it could wait until things calmed down. By the time it's finally entered, nobody actually remembers if it was 40 units or 42 β so whatever gets typed in is really just a best guess dressed up as data.
Or transactions get batched at the end of a shift instead of logged as they happen. The timestamps look fine, but the actual sequence of events is gone, which means when something doesn't match later, there's no way to trace back what caused it.
Or someone just overrides the number to make it "correct" for now, without asking why it was wrong in the first place. That fixes the symptom for exactly one day. The actual cause is still sitting there, waiting to cause the same problem next week.
And honestly, a lot of training doesn't help either β people get taught which buttons to press, but nobody explains why the timing or the order of steps actually matters. So they follow the steps, but they have no idea what breaks the moment one gets skipped.
None of this ever shows up as a system error. It just shows up as "SAP's wrong again," which is usually the one explanation that isn't actually true.
The fix is almost never a system change. It's a behavior change β closing the gap between the moment something physically happens and the moment it gets recorded, and making the right way to log it the easy way instead of the slow one.
If your numbers keep drifting from reality, the system isn't lying to you. It's just repeating exactly what it was told.
PROFESSIONAL SQL & MYSQL DATA ANALYTICS SERVICES AVAILABLE
Turn Your Business Data into Valuable Insights with SQL!
Are you looking for a SQL Data Analyst to analyze business data, write efficient SQL queries, and generate meaningful reports
I provide professional SQL & MySQL Data Analytics services to help businesses understand their data and make smarter decisions.
My SQL Data Analytics Services:
SQL Queries & Database Analysis
MySQL Database Management
Data Cleaning & Transformation
SQL Joins, Subqueries & CTEs
Sales, Revenue & Profit Analysis
Customer Behavior & Retention Analysis
Business Intelligence & KPI Reporting
SQL Data Extraction & Reporting
Database Tables & Relationships
Aggregate Functions & Window Functions
Business Trends & Performance Analysis
#SQL #MySQL #DataAnalytics #SQLDeveloper #DataAnalyst #DatabaseManagement #BusinessIntelligence #DataAnalysis
Data Analyst | Power BI, SQL, Python | From data to decision
Data Analyst | Power BI, SQL, Python | From data to decision
Built an interactive Power BI dashboard to analyze emergency room performance tracking patient flow, wait times, satisfaction scores, and department referrals in real time.
The dashboard helps hospital teams identify bottlenecks, manage resources efficiently, and improve overall patient experience through clear, data-driven insights.
This project highlights how healthcare data can be transformed into actionable intelligence that supports faster decisions and better care outcomes.
1
72
Spotify Analysis Dashboard
Turned raw Spotify streaming data into a clear, interactive dashboard that reveals how listeners actually engage with music.
Built in Power BI using SQL and DAX, this project explores user behavior across devices, identifies skip patterns, and highlights top-performing artists and tracks.
With dynamic visuals powered by key metrics like reason_start, reason_end, platform, and ms_played, the dashboard uncovers:
β’ Why users skip songs or stop playback
β’ Which platforms drive the most engagement
β’ Which artists and albums perform best by time and device
Perfect for music analysts, record labels, or streaming teams who want actionable insights into listener habits and engagement trends.
1
86
Turned Uberβs trip data into an interactive Power BI dashboard that uncovers real time booking trends, revenue performance, and demand patterns across cities.
By combining SQL, DAX, and dynamic visuals, the dashboard helps identify peak hours, optimize pricing, and improve operational efficiency.
This project showcases how clear data storytelling can transform raw trip data into actionable insights helping teams make faster, smarter business decisions
1
127
Transformed complex real estate data into an interactive Power BI dashboard that gives agencies full visibility from live sales and leads to agent performance, all in one view.
Built using SQL and DAX, it tracks top performing regions, client pipelines, and conversion trends in real time.
Designed to help real estate teams make faster, smarter decisions from their data without getting lost in spreadsheets.