Subair Olanrewaju

Intro

Welcome to my Data Analytics Portfolio. My name is Olanrewaju Subair. My mission is to translate complex datasets into actionable insights that drive Business Strategy.

With a background in the Food industry as a Quality Control Analyst, I bring a unique perspective to the data analytics field. My passion lies in applying a strategic, data-driven approach to complex business challenges. The collection of projects demonstrates my proficiency in tools such as Microsoft Excel, SEQUEL, Microsoft powerBI to analyze data, identify trends and communicate findings effectively and PowerPoint for Presentations.

Walmart Customer Purchases Analysis

The Project presents a comprehensive interactive dashboard built using PowerBI to analyze Walmart's sales performance between 2024 and 2025 with a raw input of 600,012 data entries in Excel format. The dashboard centralizes key sales data, allowing stakeholders to gain actionable insights into sales trend, product performance and customer behavior.

The Key features of the dashboard include: SALES PERFORMANCE over a given periodas this provide a high-lvel overview of total sales revenue for the 2024 to 2024 period with the ability to drilldown into monthly, quarterly or yearly performance; PRODUCT AND CATEGORY ANALYSIS which identifies top-performing product and indiviaul items, helping to optimize marketing efforts and inventory; CUSTOMER BEAVIOUR INSIGHTS which visualizes sales distribution by different customer attributes such as Age, Repeated customers and also sales in different location, helping to understand purchasing patterns.

Technologies used are EXCEL for cleaning and manipulation of the raw dataset; POWER QUERY for transforming the data; MICROSOFT POWERBI for visualizing the data.

Balaji FastFood Analysis

This is a robust sales analytics solution designed to uncover customer behavior, optimize operations, and drive data informed decisions for Balaji Fastfood business, with an entry of 10,100 data in Excel. It delivers a clear, interactive view of sales performance across multiple dimensions, helping stakeholders understand not just what is selling but when, how and to whom.

The dasboard tracks and visualizes the OVERALL SALES TREND over time period of 2022 to 2023; SALES MADE BY DAY OF THE WEEK to identify peak business days; SALES BY TIME OF THE DAY; QUANTITY OF ITEMS SOLD; PAYMENT METHODS used in transactions; GENDER DISTRIBUTION of customers to reveal demographic patterns.

The Tools and technologies employed in the course of this analysis include EXCEL used for inital data cleaning and manipulation; POWERBI QUERY EDITOR for data transformation and modeling; POWERBI for interactive visualizations and dashboard layout.

The Key features include TIME-BASED BREAKDOWNS to pinpoint high traffic periods, VISUAL COMPARISONS OF SALES by gender and payment method, INTERACTIVE FILTER for exploring specific time slots and a clean responsive design for intuitive navigation.I led the full development cycle from raw data preparation in Excel to advanced transformation in PowerBI Query Editor, culminating in a visually engaging dashboard built in PowerBI. My goal was to create a tool that not only looks great but deliver meaningful insights at a glance.

Netflix Userbase Analysis

This project involved designing a dynamic Excel dashboard to analyze and visualize key performance indicators (KPIs) related to Netflix’s userbase. With a dataset comprising over 2,500 rows and 45,000 data entries, the dashboard provides actionable insights into user behavior, revenue trends, and engagement patterns.

Key Features includes: Key Performance Indicators KPIs, Tracked Interactive Slicers, Visualization, Tools & Techniques used

KPIs Tracked: Sum of Total Revenue per User, Sum of Monthly Revenue, Sum of User IDs, Sum of Active Duration

Interactive Slicers: Join Date-Year, Quarter, Month

Visualization: Monthly Reenue by Country, Revenue Trend by Join Month, Average Revenue per User by Country, Total Revenue by Subscription Type, Monthly Revenue by Age

Tools & Techniques used: PivotTables and PivotCharts for dynamic data summarization, Slicers for enhanced interactivity, Conditional formatting to highlight trends and anomalies, Excel formulas for calculated metrics.

Impact: This dashboard serves as a strategic tool for understanding user engagement and monetization across different demographics and regions. It showcases my ability to transform raw data into meaningful insights using Excel’s advanced analytical features.

Chocolate Sales Analysis

This interactive dashboard analyzes chocolate sales data across multiple dimensions, offering rich insights for business decision-making. Built using a dataset of 1,094 rows and 8 columns, it includes key performance indicators and dynamic visualizations that highlight trends, performance, and product-level insights.

Key Features include KPI Cards, Time Analysis, Product Performance, Slicers for Visual Interaction.

This dashboard demonstrates my ability to transform raw data into actionable insights using clean design, intuitive visuals, and thoughtful interactivity.

About

Hello, I am Olanrewaju, a data analytics enthusiast with a sharp eye for patterns and a deep curiosity for uncovering insights that drive smarter decisions. I specialize in transforming raw data into meaningful insights using statistical analysis and visualization.

My core skills include Data Wrangling, Reporting, Building interactive dashboards and Visual Storytelling using tools such as PowerBI, Excel and SQL.

I focus on Business performance tracking, sales and financial analysis, KPI and reporting automation, Data modelling and Visualization for decision support. I am expanding my skills into cloud based data tools, integrating PowerBI with real time data sources. Always learning, always improving.

If you are working on a data-driven initiative or need help making sense of your numbers, I'd love to collaborate. I believe good data leads to great decisions-and I'm here to help make that happen.

Contact

• Twitter
• GitHub

Elements

i = 0;

while (!deck.isInOrder()) {
    print 'Iteration ' + i;
    deck.shuffle();
    i++;
}

print 'It took ' + i + ' iterations to sort the deck.';