Mosaddek Hosen Sajeeb
Data Cleaning & Power BI Data Visualization Specialist
New to Contra
Mosaddek Hosen is building their profile!
🚀 Built a Fully Interactive Product Sales Analysis Dashboard using Google Sheets & Looker Studio
Not every business report requires complex tools or heavy infrastructure.
Sometimes, the fastest and smartest solution is combining Google Sheets with Looker Studio to create a powerful, automated, and real-time business intelligence system. 📊
For this project, I built a complete Product Sales Analysis Dashboard tracking:
💰 7.51M Total Revenue
📦 337 Total Orders
📈 Dynamic KPI Tracking
🎯 Interactive Filters & Slicers
🔄 Custom Transparent Reset Filter Button
But the real challenge wasn’t the dashboard itself — it was the data cleaning process behind it. 🛠️
The original dataset was extremely messy and inconsistent, so before visualization, I transformed and structured the data directly inside Google Sheets by:
✅ Automating date handling using formulas
✅ Creating data validation dropdown systems
✅ Building an automated Monthly Summary tracker
✅ Using conditional formatting to monitor sales targets instantly
✅ Organizing the backend into modular reporting tabs for scalable analysis
This project reminded me that strong data analytics is not about using the “biggest” tool — it’s about choosing the right workflow to deliver fast, actionable insights for decision-making.
Through projects like this, I continue improving my skills in:
📊 Data Analytics
📈 Dashboard Development
🧹 Data Cleaning
⚡ Automation
📂 Business Intelligence
📉 Data Visualization
I’m currently open to freelance projects and Data Analyst opportunities.
If your business needs help with:
Dashboard Development
Data Cleaning
Automated Reporting
Power BI / Excel / Google Sheets
SQL & Python-based analytics
feel free to connect with me.
🎥 Check out the 44-second walkthrough video below 👇
#DataAnalytics #DataAnalyst #GoogleSheets #LookerStudio #PowerBI #Excel #Dashboard #BusinessIntelligence #DataVisualization #DataCleaning #Analytics #FreelanceDataAnalyst #SQL #Python #Reporting #BusinessAnalytics
1
3
🚀 Built an Automated Power BI Dashboard with Real-Time File Refresh Workflow
Recently, I worked on a complete Power BI automation project where I transformed messy raw CSV data into a fully interactive business dashboard.
This project included:
✅ Data Cleaning with Power Query
✅ Handling messy and mixed date formats
✅ Data transformation & automation
✅ KPI Dashboard Creation
✅ Sales & Revenue Analysis
✅ Dynamic Visualizations
✅ Folder-Based Automated Refresh System
✅ Bangladesh Regional Map Integration
The most exciting part of this project was the automation workflow.
Instead of manually rebuilding reports every time new data arrives, I configured Power BI to automatically detect updated files from a folder source. Once new CSV files are added, the dashboard can refresh and update business insights instantly.
During the project, I also solved several real-world data problems like:
inconsistent date formats
null values
mixed discount scales
data type issues
automation refresh errors
This project helped me strengthen my skills in:
📊 Power BI
📈 Data Visualization
🧹 Data Cleaning
⚡ Automation Workflow
📂 Power Query
🐍 Data Analytics
As a Data Analyst, I enjoy building dashboards that are not only visually appealing but also practical for real business decision-making.
If you need help with:
Power BI Dashboards
Data Cleaning
Automated Reporting
Business Insights
Excel & CSV Data Processing
feel free to connect with me or knock me anytime.
#PowerBI #DataAnalytics #BusinessIntelligence #Dashboard #DataVisualization #PowerQuery #Automation #DataCleaning #Analytics #DataAnalyst #DataScience #CSV #Excel #Reporting #BusinessAnalytics
1
44
🚀 Built an Interactive Habit Tracker Dashboard using Excel Web!
Recently, I worked on creating a fully dynamic and visually interactive Habit Tracking Dashboard in Microsoft Excel Web to improve productivity tracking and data visualization skills.
📊 Features included in this project:
✅ Daily habit tracking system
✅ Dynamic progress calculations
✅ Interactive charts & analytics
✅ Monthly and yearly tracking
✅ Progress bars & KPI indicators
✅ Automated formulas and conditional formatting
✅ Clean dashboard UI design inside Excel Web
This project helped me practice:
• Excel Dashboard Design
• Data Visualization
• Spreadsheet Automation
• Data Analysis Techniques
• Productivity Analytics
• Interactive Reporting
I’m continuously exploring how Excel can be transformed into powerful analytical and business reporting tools — even without advanced software.
Would love to hear your feedback and suggestions! 👇
1
66
🚀 Just shared a quick Excel tutorial on how to combine multiple worksheets using the Consolidate Feature in Microsoft Excel.
In this video, I demonstrated how to:
✅ Merge data from multiple sheets
✅ Create a summary report automatically
✅ Save time without using complex formulas
✅ Organize datasets efficiently in Excel
As a Data Analyst, I believe mastering small but powerful Excel features can significantly improve workflow efficiency and reporting speed.
Excel is still one of the most essential tools in data analysis, business reporting, and dashboard preparation — and features like Consolidate make handling large datasets much easier.
🎥 Check out the video and let me know your thoughts!
2
54
Stop wasting time doing manual copy-paste work or struggling with rigid lookup formulas. 🛑 If you want to accelerate your data manipulation and build truly dynamic reports, you need to master the Excel OFFSET function.
Most professionals default to standard lookups, but they break the moment your data structure changes. Here is why the OFFSET formula is a game-changer for spreadsheet automation and advanced data analytics.
🚀 Why You Need the OFFSET Formula
Standard lookup functions only look for specific static values. OFFSET is different—it calculates a dynamic range on the fly. You should use it to:
Create Dynamic Dashboards: Automatically update charts and summary tables when new rows or columns are added.
Build Flexible Summaries: Extract specific blocks of data without hardcoding cell references.
Speed Up Workflows: Eliminate the need to manually drag, drop, or copy formulas across hundreds of cells.
🧠 How the OFFSET Logic Works (Grid Math)
Think of OFFSET like giving Excel a GPS coordinate map. It uses a simple coordinate system:
=OFFSET(reference, rows, cols, [height], [width])
The Anchor (reference): Your starting point on the spreadsheet (e.g., cell A1).
The Move (rows, cols): Tells Excel exactly how many steps to move from the anchor. For example, 1, 1 tells Excel to step 1 row down and 1 column right to find the data.
The Window (height, width): Instead of pulling just one cell, these numbers tell Excel the size of the block to grab. For example, 5, 7 commands Excel to instantly pull a block that is 5 rows high and 7 columns wide.
Thanks to modern Excel’s dynamic array features, the formula instantly "spills" that entire data block into your workspace. No manual adjustments required. 🎯
Mastering these advanced data modeling techniques is exactly how you turn raw datasets into efficient, automated workflows.
Check out the video breakdown below to see the grid math in action! 👇
#Excel #DataAnalytics #DataAnalysis #SpreadsheetAutomation #BusinessIntelligence #Productivity #AdvancedExcel #DataWorkflows
1
64
Nowadays, creating a portfolio feels like a piece of cake. You give a prompt to an AI, it generates the code, and your site is live for free. But what happens when that AI tool hits its daily limit? What if your site crashes or a link breaks and you don't know how to fix the code manually?
Every day, thousands of websites are created, but most are abandoned because they aren't maintained. I’m not just here to build; I’m here to ensure your digital presence is future-proof. I focus on the hard part: regular updates, clean manual coding, and professional maintenance so your site never fails you when a client is watching.
I built my own portfolio using a high-end AI workflow, then manually polished it to ensure it won’t crash and stays 100% under my control.
Check out my stable, professional portfolio here:
👉 sajeeb-the-analyst.vercel.app (http://sajeeb-the-analyst.vercel.app)
If you want a website that actually works and grows with you, let’s talk! 📊💻
1
56
Excel isn't just a spreadsheet—it's a BI powerhouse. 🚀
Most people believe you need expensive software subscriptions for high-end analytics. I’m here to prove that with advanced DAX, Power Pivot, and strategic design, Microsoft Excel can deliver world-class insights.
I recently completed this E-commerce Sales Analysis Dashboard, built 100% within Excel.
What I Delivered:
Dynamic Sales Intelligence: Real-time CY vs. PY comparisons with automated growth indicators.
Customer Behavior Tracking: Advanced metrics for loyalty, retention rates, and purchase patterns.
Executive UI/UX: A custom dark-mode interface designed for instant decision-making.
Scalable Data Architecture: A robust system that handles complex relationships and automated reporting.
The Result: A professional "Software-as-a-Service" experience within a tool your business already owns. No extra licenses—just clear, actionable data.
I specialize in Data Cleaning and Advanced Visualization. If you want to transform your numbers into a story that drives growth, let’s connect.
1
120
Think Excel is just for tables? Think again. 🚀
I built this fully interactive E-commerce Sales Dashboard 100% in Excel. No Power BI, no Tableau—just advanced DAX, Power Pivot, and strategic design.
The Reality:
Excel is "hard mode" for data viz. It’s more complicated to make it look this good, but it’s the one tool every business actually uses. Mastering it means being able to deliver insights in any environment.
What’s inside:
CY vs. PY Revenue Trends with dynamic indicators.
Customer Loyalty & Retention tracking.
Top Performance Deep-Dives by country and product.
Proof that you don’t need expensive subscriptions for high-end analytics—you just need the right architecture.
2
138
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.
0
129
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
209
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.
1
102
📊 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
216