Data Cleaning & Preparation
Transforming inconsistent, duplicate-ridden, or incomplete datasets into analysis-ready, structured data with documented quality checks.
Faridah Abubakar · Data Analyst · Power BI Developer · BI Specialist
I help businesses cut through the noise — cleaning messy data, building interactive dashboards, and translating numbers into strategies that actually move the needle.
I'm a Data Analyst and Business Intelligence Specialist with a strong foundation in transforming complex, raw datasets into clear, actionable insights. Whether it's a messy spreadsheet or a million-row database, I bring structure, clarity, and meaning to your data.
My work sits at the intersection of analytics and strategy — I don't just build dashboards, I build decision-making tools. From customer churn modeling to financial performance reporting, every project is driven by one question: what does this mean for the business?
A focused toolkit built for real-world data challenges — from raw ingestion to executive-level reporting.
Practical, high-impact data services designed to solve real business problems and support informed decision-making.
Transforming inconsistent, duplicate-ridden, or incomplete datasets into analysis-ready, structured data with documented quality checks.
End-to-end Power BI solutions — from data model design and DAX measures to visually compelling, drillable dashboards that non-technical stakeholders can navigate confidently.
Advanced Excel workbooks with pivot tables, dynamic charts, Power Query pipelines, and VBA/formula automation that save hours of manual work every week.
Translating complex analytical findings into clean, intuitive visuals — charts, heatmaps, and infographics that tell a story executives can act on immediately.
Designing the full BI stack: data source integration, dimensional modeling, KPI frameworks, and reporting infrastructure tailored to your organization's goals.
Deep-dive analyses into sales trends, customer behavior, operational efficiency, and financial metrics — surfacing the insight that changes how a business makes its next big call.
Real dashboards, real data, real decisions — across social media, finance, retail, and telecom.
Interactive Power BI dashboard analysing 1,001 posts — engagement rates, post types, time-of-day patterns, and category performance with spam filtering and verified-user segmentation.
Exploratory data analysis and machine learning pipeline built in Jupyter Notebook — covering quality distribution, feature correlation matrix, alcohol content analysis, and scatter plots across key chemical properties.
Full end-to-end pipeline — CSV ingested via Python into MySQL, cleaned with SQL, visualised in Power BI. Covers 505 stocks, 2T market volume, top performers, daily volatility and trading patterns across 497K records.
Retail analytics covering $274K total revenue, 199 unique customers, category performance, gender split, monthly trends and product-level breakdowns. Raw data structured in Excel, then modelled and visualised in Power BI.
End-to-end churn analysis on 7,000+ telecom customers. Raw data in Excel, analysed and visualised in Power BI — revealing that month-to-month contracts drive churn 7.35× more than annual contracts, with key influencer and high-value segment breakdowns.
End-to-end fraud analysis using SQL to query and uncover patterns across transaction types, geographic risk, merchant behaviour, and real-time hourly fraud signals. Findings published as an interactive HTML dashboard with live charts.
More projects currently in progress — check back soon for updates.
Formal credentials validating analytical expertise across tools, platforms, and methodologies.
★★★★★"Faridah delivered exactly what we needed — a Power BI dashboard that our whole management team could actually use. She cleaned years of messy sales data and turned it into something that now drives our weekly review meetings."
★★★★★"The churn analysis project was exceptional. Faridah identified patterns we hadn't considered and built a report that directly informed our retention strategy. We saw measurable results within the quarter."
★★★★★"Working with Faridah was a seamless experience. She automated our monthly reporting in Excel, cutting a 6-hour process down to under 20 minutes. Professional, thorough, and always on deadline."
Have a data challenge, a dashboard to build, or a business question that needs answering? Reach out — I'd love to hear about your project.