Mosaddek Hosen Sajeeb
Data Analyst | BI Developer | AI Automation | Python
New to Contra
Mosaddek Hosen is building their profile!
Case Study: Strategic Financial Intelligence Dashboard
Goal: To transform fragmented financial data into an executive-level decision-making tool.
The Work:
Data Engineering: Cleaned and reconciled 10,948 transactions from disconnected P&L and Balance Sheet sources using SQL, Python, and Power BI.
Advanced Analytics: Developed custom DAX models to track WCR (Working Capital Requirement), Debt-to-Equity ratios, and Net Income trends.
Visualization: Built a dynamic dashboard featuring risk gauges, WCR waterfall charts, and Month-over-Month (MoM) performance tracking.
The Impact:
Profitability: Confirmed a 15.3% net margin with a $2.1 Million net income on $13.7 Million in revenue.
Risk Management: Identified that 92% of revenue is concentrated in just two divisions, flagging a major strategic vulnerability.
Liquidity: Discovered $4.1 Million in outstanding AR, creating a plan to unlock $1.3 Million in working capital.
Cost Efficiency: Highlighted that Job Materials ($9.3M) drive 87% of expenses, providing a roadmap for margin improvement.
1
41
Ever stared at a spreadsheet and thought... there's got to be a better way?
That's where I come in. I'm a Power BI specialist who transforms raw financial data into interactive dashboards.
This company had 6 months of unorganized data. No idea which divisions were profitable. Four million dollars stuck in unpaid invoices.
I cleaned the data, built an interactive dashboard, created advanced metrics using DAX, and delivered a full strategic analysis.
Result? They found 1.3 million dollars in working capital they didn't know they had.
That's the power of business intelligence. If you need financial dashboards, data integration, or strategic analysis... I'm your person.
2
2
46
Telecom Customer Churn & Retention Analysis
Description:
This project involved analyzing a dataset of 7,043 customers to identify key drivers of churn and develop actionable retention strategies. I built an end-to-end Power BI dashboard that transforms raw service data into high-level business intelligence.
Key Features & Insights:
Churn Risk Identification: Developed DAX measures to track 1,869 "Risk Customers," revealing that 26.54% of the user base was at risk of leaving.
Service Impact Analysis: Identified that customers without Online Security had a significantly higher churn rate (31.3%) compared to other segments.
Behavioral Segmentation: Analyzed churn by contract type and payment method, finding that senior citizens showed a 48.3% early-leaving rate.
Technical Stack: Utilized PostgreSQL for data querying and Power BI for advanced data modeling, DAX calculations, and interactive visualization.
Business Impact:
By identifying high-churn segments (like those without tech support or security services), this dashboard allows telecom managers to target specific groups with retention offers, potentially saving a portion of the $16.1M in total charges at risk.
0
59
š Power BI Dashboard for Clear Business Insights
Many businesses have data but struggle to understand it.
In this video, Iām showing how I turn raw and messy data into a clean, interactive Power BI dashboard with clear KPIs and insights.
I help with:
ā¢ Data cleaning (Excel / SQL)
ā¢ Data analysis
ā¢ Power BI dashboard development
ā¢ KPI tracking and reporting
My goal is simple ā make your data easy to understand and useful for decision-making.
If you need help with data cleaning or building a Power BI dashboard, feel free to message me.
#PowerBI #DataAnalytics #Excel #SQL #Dashboard #DataCleaning
1
3
175