AnalyticAlchemist

Mubarak Lawal

I'm a

Dedicated to transforming complex raw data into clear, actionable insights. I design robust business intelligence solutions and visually compelling dashboards that empower organizations to make informed, data-driven decisions that drive growth.

View My Work Get In Touch
Alexander Chen
Profile Image

Mubarak Lawal

Data Analyst & BI Analyst

lawalademola71@gmail.com Book a Call Remote | Lagos, Nigeria
Get to Know Me

Passionate About Transforming Raw Data Into Actionable Business insights

I specialize in demystifying complex datasets and building intuitive analytical tools. My goal is to bridge the gap between data and strategy, crafting compelling dashboards and reports that not only answer critical business questions but also reveal new opportunities for innovation and improvement.

10+
Projects Completed
3+
Certifications
5+
Technologies
Specialization Data Analysis & Business Intelligence
Availability Immediately
Education Certified AAT, Institute of Chartered Accountants of Nigeria (ICAN) B.Sc Economics, Obafemi Awolowo University, Ile-Ife
Languages English, Arabic, Yoruba
View Resume (PDF) Let's Talk

Projects Delivered

Dashboards and Reports

Hours Of Analytics

Clients / Collaborations

Skills

My expertise lies in using data to solve business problems. I manage the full data lifecycle from cleaning and structuring raw data to building and deploying interactive dashboards that provide key insights and drive revenue.

Data Analysis and Visualisation

Excel

Strong proficiency with pivot tables, Power Query, VLOOKUP/XLOOKUP, and developing automated reports for business insights.

Power BI

Advanced in building interactive dashboards, writing DAX measures, creating robust data models, and managing reports in Power BI Service.

Exploratory Data Analysis

Proficient in performing Exploratory Data Analysis (EDA) to uncover trends, outliers, and patterns. Skilled in utilizing statistical summaries and data visualization techniques to prepare data for modeling and to derive actionable insights.

Data Storytelling

Skilled in translating complex data into clear, compelling visuals and narratives for diverse business stakeholders.

Data Preparation and Scripting

SQL

Proficient in advanced SQL, including CTEs, CTAS, and window functions. Competent in writing complex SELECT queries, JOINs, filters, aggregations, and subqueries for efficient data extraction and manipulation.

Python (Pandas, NumPy, Matplotlib)

Proficient in using Python for data cleaning, transformation, analysis, and visualization within Jupyter Notebooks.

ETL / Data Cleaning

Experienced in Extract, Transform, Load (ETL) processes and using tools like Power Query and Python to clean and shape raw data from various sources.

Version Control (Git/GitHub)

Familiar with Git workflows for collaborative data projects, including pushing code, tracking changes, and repository management on GitHub.

Resume

My professional journey as a Data Analyst and BI Developer is marked by the consistent application of strong analytical techniques and essential business intelligence tools. Explore my experience in delivering data-driven solutions that solve real-world challenges.

Profile

Professional Summary

Data Analyst with a strong foundation in data analytics, dedicated to building impactful solutions. I am passionate about leveraging cutting-edge technologies to solve complex business challenges, transforming data into clear, compelling dashboards and reports that empower organizations to make informed, data-driven decisions and reveal new opportunities for innovation.

Contact Information

Technical Skills

SQL
Power BI
Excel (Power Query)
Python(Pandas, NumPy, Matplotlib)
Data Modeling

Soft & Business Skills

Data Storytelling
Business Acumen
Problem Solving
Project Management
Communication & Collaboration

Practical Experience

Social Media Analytics and Strategy

Sep 2024 - Jan 2025

Accenture North America (Job Simulation)

  • Partnered with a social media client to analyze seven diverse datasets, identifying key user trends and behavioral patterns.
  • Utilized Excel and SQL to clean, model, and aggregate data, providing a robust foundation for strategic content and platform decisions.
  • Developed a compelling data narrative, presenting key insights and actionable recommendations through a professional PowerPoint deck and video presentation.

Sales Performance Dashboard & Automation

April 2025 - June 2025

Self-Directed Project

  • Addressed inefficiencies in manual sales reporting by building an end-to-end automated BI solution.
  • Led data extraction, transformation, and visualization efforts from disparate source files.
  • Utilized SQL for data aggregation and Power Query for robust data cleaning and transformation.
  • Designed and deployed an interactive Power BI dashboard that provided real-time sales insights and simulated a 20% improvement in report delivery efficiency.

Customer Churn Prediction Analysis

July 2025 - Aug 2025

Self-Directed Project

  • Investigated key factors contributing to customer churn for a simulated e-commerce business.
  • Performed Exploratory Data Analysis (EDA) and developed a basic predictive model.
  • Presented findings in a concise report, outlining potential customer segments at high risk of churn and suggesting targeted retention strategies
  • Provided actionable insights that could potentially reduce customer churn by 65%

Education

Certified AAT

June 2024

Institute of Chartered Accountants Nigeria

Bachelor of Science in Economics

2022 - 2026

Obafemi Awolowo University

Specialized in Econometrics and Applied Economics, with a focus on Data Analysis and Business Intelligence.

Certifications

Data Analyst and visualization - 3mtt Nigeria

Aug 2025

Data Analytics and Visualization Job Simulation - North America Accenture

Jan 2025

Certified Data Analyst - DataCamp

Sep 2024

Portfolio

Welcome to my portfolio. Here, I transform complex data into actionable business intelligence. Explore my projects, which showcase a blend of technical depth and strategic clarity, from SQL data modeling and Python analytics to interactive Power BI dashboards and Excel-based financial analysis. Each project tells a unique story, demonstrating how I turn raw data into valuable insights.

  • All Projects
  • Power BI
  • Excel
  • SQL
  • Python
Portfolio Image
Power BI

Alchemist Retail Dashboard

Portfolio Image
Excel

Bike Purchase Dashboard

Portfolio Image
SQL

ShopSmart Project

Portfolio Image
Python

Agrisense Dashboard

Portfolio Image
Power BI

Sales and Profitability Analysis

Portfolio Image
Excel

Crime Activity Analysis Report

Services

Necessitatibus eius consequatur ex aliquid fuga eum quidem sint consectetur velit

Innovative business
performance solutions

We integrate forward-thinking strategies, creative approaches, and state-of-the-art technologies to deliver exceptional customer experiences that drive growth and engage target markets.

View All Services

Creative branding

Nulla facilisi. Maecenas eget magna neque. Suspendisse potenti. Curabitur eleifend nisi non magna vulputate, vel condimentum libero tempus. Proin consectetur feugiat diam.

Design systems

Praesent euismod varius tellus, vel bibendum nunc interdum at. Donec vehicula diam vel metus venenatis convallis. Aliquam erat volutpat. Etiam viverra magna sit amet.

Marketing strategies

Vivamus tempor velit id magna dictum, sed fermentum nisi faucibus. Integer nec pretium sapien. Fusce tincidunt ligula et purus consequat, ac pellentesque nulla eleifend.

Digital platforms

Cras fermentum odio eu feugiat malesuada. Vestibulum ante ipsum primis in faucibus orci luctus et accumsan cursus. Morbi placerat nulla vel nunc viverra accumsan.

Growth acceleration

Aenean vel augue vel nisi bibendum posuere. Phasellus in lacus quis urna sodales dignissim. Duis aliquam libero eget risus facilisis. Quisque eget libero vel nisl fringilla.

Media solutions

Etiam efficitur lacus in diam finibus, nec ultrices est sagittis. Maecenas elementum magna sed risus faucibus, nec commodo purus facilisis. Vestibulum accumsan magna.

Testimonials

Necessitatibus eius consequatur ex aliquid fuga eum quidem sint consectetur velit

Implementing innovative strategies has revolutionized our approach to market challenges and competitive positioning.

Client

Rachel Bennett

Strategy Director

Exceptional service delivery and innovative solutions have transformed our business operations, leading to remarkable growth and enhanced customer satisfaction across all touchpoints.

Client

Daniel Morgan

Chief Innovation Officer

Strategic partnership has enabled seamless digital transformation and operational excellence.

Client

Emma Thompson

Digital Lead

Professional expertise and dedication have significantly improved our project delivery timelines and quality metrics.

Client

Christopher Lee

Technical Director

Collaborative approach and industry expertise have revolutionized our product development cycle, resulting in faster time-to-market and increased customer engagement levels.

Client

Olivia Carter

Product Manager

Innovative approach to user experience design has significantly enhanced our platform's engagement metrics and customer retention rates.

Client

Nathan Brooks

UX Director

Contact

Remote | Lagos, Nigeria

Contact Info

I collaborate with teams across time zones to deliver actionable, business-ready analytics.

Availability

Remote | Lagos, Nigeria

Engagements

Freelance · Contract · Part-time · Remote

Response time

Usually within 24 hours.

Email

Show email

Book a Call

Get In Touch

Ready to transform your data into actionable insights? Send a message and I’ll reply via email.

Book a Call Instead
Thanks! Your message has been sent. I’ll get back to you shortly.
Something went wrong. Please try again or email me at .