Lawal Jamiu

Data Analyst | Power BI Developer | Turning Data into Insights Across Health & Business

About Me

Your Name

I am a data professional and Public Health student passionate about transforming complex data into meaningful insights that drive informed decision-making. I specialize in building interactive dashboards and data-driven stories that make information accessible, actionable, and impactful.

With expertise in Power BI, SQL, and data modeling, I design comprehensive analytical solutions that uncover hidden patterns, reveal trends, and support strategic planning across diverse sectors. My approach combines technical precision with clear storytelling to ensure data is not just analyzed but understood.

As a Public Health student, I bring an evidence-based and community-focused perspective to my work. I am particularly interested in leveraging data analytics to address real-world challenges, improve health outcomes, and support sustainable development initiatives.

I believe data has the power to create change when it is translated into insight and I am committed to turning data into decisions that matter.

My Projects

Project Seven Preview

California Infectious Disease Surveillance

The California Infectious Disease Surveillance Dashboard delivers a comprehensive analysis of a decade’s worth of public health data (2014–2023), built in Microsoft Power BI using Power Query for data transformation and DAX for incidence rate calculations to convert over 610,000 case records into a high-impact diagnostic tool for epidemiological trends. By visualizing the critical shift from raw case counts to population-adjusted incidence rates, the dashboard identifies regional hotspots such as the high-burden Kern County and reveals how environmental factors drive gender-specific disparities in diseases like Coccidioidomycosis. This project provides a sophisticated, data-driven roadmap for public health officials to optimize resource allocation and strengthen community intervention strategies across California.

Documentation View Dashboard
Project Seven Preview

Sentix Insights

The Sentix Insights Dashboard delivers a concise overview of brand perception and audience engagement across major social media platforms. Built in Microsoft Power BI using Power Query, DAX measures, and dynamic heatmaps, it transforms over 700 records into clear, actionable business intelligence regarding public sentiment and posting efficiency. By visualizing real-time trends such as the growth in positive engagement and peak activity periods—this dashboard provides a data-driven roadmap for optimizing communication strategies and strengthening community relationships.

Documentation View Dashboard
Project Seven Preview

Call Center

The Call Center Performance Analysis Dashboard provides a comprehensive view of operational efficiency and customer sentiment across 32,941 calls. Developed using Power BI and Power Query, it integrates high-level KPIs like response time and call duration with granular geographic and sentiment data. By highlighting key drivers such as Billing Questions and identifying volume peaks in cities like Los Angeles, the dashboard turns complex telecommunications data into actionable strategies for staffing and service improvement.

Documentation View Dashboard
Project Seven Preview

Pizza Sales Report

The Pizza Sales Analysis Dashboard provides an end-to-end look at a year’s worth of transactional data to uncover key performance drivers. Built using SQL for data cleaning and Microsoft Power BI for visualization, it transforms over 21,000 orders into actionable business intelligence. By analyzing trends and product performance such as the revenue-leading Thai Chicken Pizza and the underperforming Brie Carre. This dashboard delivers critical insights to optimize menu strategy and operational efficiency.

Documentation View Dashboard
Project Seven Preview

Coffee Shop Sales

This project features a high-performance dashboard analyzing 6 months of coffee shop transactions. Using SQL for deep-dive exploration and Power BI for interactive storytelling, I transformed raw data into operational insights. Key findings include identifying a 30% MoM growth peak in March and pinpointing the "Golden Hours" (8 AM – 10 AM) for staffing optimization. This tool bridges the gap between complex SQL logic and actionable business strategy.

Documentation View Dashboard
Project Seven Preview

HR Analytics

The HR Analytics Dashboard delivers a concise overview of critical workforce metrics, including total employee count, attrition rates, active employee levels, and job satisfaction ratings. Built in Microsoft Power BI using Power Query, DAX measures, and dynamic KPI cards, it transforms data from 1,470 records into clear, actionable business intelligence regarding departmental turnover and demographic trends.

Documentation View Dashboard
Project Seven Preview

Road Accident Analysis

The Road Accident Analysis Dashboard delivers a concise overview of critical safety metrics including total casualties, accident volume, casualty severity, and geographical distribution. Built in Microsoft Power BI using Power Query, DAX measures, and dynamic KPI cards, it transforms over 195,000 casualty records across various road types and light conditions into clear, actionable business intelligence to improve public safety.

Documentation View Dashboard
Project Seven Preview

BlinkIT Grocery

The Blinkit Sales Performance Dashboard delivers a concise overview of critical retail metrics including total sales, average sales, item volume, customer ratings, and outlet-level performance. Built in Microsoft Power BI using Power Query, DAX measures, and dynamic KPI cards, it transforms 9,000+ product records and $1.20M in revenue across multiple outlet types and regional tiers into clear, actionable business intelligence.

Documentation View Dashboard
Project Six Preview

Bikes Sales

The Bike Sales Analysis Dashboard provides a concise overview of key sales metrics such as total revenue, total cost, total units sold, profit margin, and customer volume. Built in Microsoft Power BI using Power Query, DAX measures, interactive charts, and KPI cards, it transforms 113,036 customer records and $85.27M in revenue across five international markets into clear, actionable insights for informed decision-making.

Documentation View Dashboard
Project Five Preview

Dataslide Sales

This Dataslide Sales Dashboard delivers a comprehensive and visually intuitive overview of key business performance metrics, including total sales, revenue, total quantity, year-over-year revenue trends, regional revenue distribution, and top 5 company revenue by employee ID. Designed to support informed decision-making, the dashboard enables users to quickly identify patterns, compare performance across regions and time periods, and extract actionable insights. It was developed using Microsoft Power BI, utilizing dynamic visuals, bar charts, pie charts, slicers, and KPI cards to create a fully interactive and professional analytical experience.

Documentation View Dashboard
Project One Preview

Adidas Sales

This Adidas Sales Dashboard provides a comprehensive overview of performance metrics including total revenue, profit, orders, sales by region, product category, retailer, and time period, enabling quick business insights and data-driven decision-making. It was created using Microsoft Excel, leveraging pivot tables, charts, slicers, and KPI cards for interactive analysis.

Documentation View Dashboard
Project Two Preview

Dataslid Metropolican Medical Center

The Dataslid Metropolitan Medical Center Dashboard provides a concise overview of key healthcare metrics such as total revenue, patient volume, average length of stay, and admissions by condition. Built in Microsoft Excel using pivot tables, charts, slicers, and KPI cards, it transforms 55,000+ patient records and $1.4B in revenue into clear, actionable insights for informed decision-making.

Documentation View Dashboard
Project Three Preview

Maximum Commerce Ltd

The Maximum Commerce Ltd Sales Performance Dashboard provides a concise overview of key business metrics, including total revenue, profit, category performance, and geographic distribution. Built in Microsoft Excel using pivot tables, charts, slicers, and KPI cards, it transforms four years of transactional data (2021–2024) into clear, actionable insights—highlighting 9.68M in revenue, 247.96K in profit, seasonal sales trends, and top-performing products to support strategic decision-making.

Documentation View Dashboard
Project Four Preview

Sunshine Phone Sales

The Sunshine Intel Phone Sales Performance Dashboard provides a concise overview of key business metrics, including total revenue, profit, brand performance, and geographic distribution. Built in Microsoft Excel using pivot tables, charts, slicers, and KPI cards, it transforms four years of transactional data into clear, actionable insights highlighting 127.2M in revenue, 44.4M in profit, seasonal sales trends, and top-performing partners like Apple and Tuenti to support strategic decision-making.

Documentation View Dashboard

Technical Skillset

Data Visualization

  • Power BI
  • Excel Dashboards

Data Analysis

  • SQL
  • Advanced Excel
  • Google Sheets

Data Modeling & ETL

  • Power Query
  • DAX

Send me a message

Interested in collaborating or have questions about my work? I'd love to hear from you!