Skip to content
View KNGBRYANT's full-sized avatar
๐Ÿ‘œ
Passionate About Data & Operations
๐Ÿ‘œ
Passionate About Data & Operations

Block or report KNGBRYANT

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please donโ€™t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this userโ€™s behavior. Learn more about reporting abuse.

Report abuse
KNGBRYANT/README.md

Hi ๐Ÿ‘‹ Iโ€™m Lawal Mayowa Bryant

Iโ€™m a Data Analyst who transforms raw data into clear, actionable insights that help teams make smarter, faster decisions. My Profile Photo

๐Ÿ’ซ About Me:

I bring a strong foundation in engineering operations, system diagnostics, and performance monitoring to every dataset I work with. During my Data Analyst internship at HNG, I cleaned, validated, and integrated 100,000+ data points, developed automated Power BI dashboards that improved reporting clarity by 35%, and streamlined workflows to save 10+ hours weekly.

I work with Python, SQL, Excel, and Power BI, translating complex operational and business data into actionable insights. I am continuously learning and building projects, from predictive maintenance dashboards to user behaviour analyses, focusing on insights that drive measurable business outcomes.

My goal is to blend data-driven problem solving with innovation, expanding skills in advanced analytics and machine learning, while delivering solutions that improve efficiency, decision-making, and operational performance.

๐Ÿ’ป Tech Stack:

SQL Excel Python Power BI Data Storytelling Data Cleaning Statistics Operational Data Predictive Analytics Problem Solving

๐Ÿ“‚ Projects

Mayomide Store Sales & Profit Analytics Dashboard

DashBoard Overview

Project Summary

Delivered a high-impact Power BI dashboard for Mayomide Store analyzing four years of e-commerce performance (2020โ€“2023) across Sales, Profit, Profit Margin, Quantity, and Average Discount. The solution revealed a 20.9% profit increase between 2020 and 2021, identified Europe as the top-performing market, and pinpointed the 20โ€“30 age group as the most profitable segment. Insights from product trends guided inventory and marketing strategies, enabling faster, data-driven decisions and improved operational visibility.

Tools: Power BI, DAX, Excel, Power Query Links: View Live Dashboard, Full Project Breakdown


E-commerce Performance Analysis & Executive Dashboard (2019โ€“2023)

Executive Dashboard

Project Summary

Developed a high-impact Power BI solution analyzing five years of e-commerce performance across revenue, orders, profit, and customer segments (2019โ€“2023). The dashboard automated KPI tracking, year-over-year comparisons, and category-level insights, replacing inefficient manual reporting. The analysis uncovered a 17% return rate reducing margins, the 35โ€“44 age group as the highest-profit segment, and payment behavior shifts driving a 38% rise in operational risk. The insights guided optimised product mix, return reduction strategies, and payment stability improvements, strengthening decision-making accuracy by 30%.

Tools: Power BI, DAX, Excel, Power Query Links: View Live Dashboard, Full Project Breakdown


๐Ÿ‘‰ Click here to view more projects ๐Ÿ“‚

Insurance Risk & Claims Analysis Dashboard

Project Summary

Developed a Power BI solution that transforms raw insurance claims data into a clear risk-intelligence dashboard. The system automates pattern detection, flags high-risk policies, and visualizes claim frequency and payout behavior across regions. The analysis exposed concentrated risk clusters, uneven claim intensities, and payout trends that directly impact portfolio stability. These insights enabled targeted audits, streamlined processing, and sharper risk-mitigation strategiesโ€”boosting overall risk-management effectiveness by 20%.

Tools: Power BI, DAX, Data Analysis, KPI Dashboard Design
Links: View Live Dashboard, Full Project Breakdown


SEO & Keyword Analytics in Nigerian Consumer Banking

Project Summary

Developed a streamlined Power BI solution that maps SEO visibility to profitability for major Nigerian consumer banks. Automated extraction of 85 industry-specific keywords via SerpApi, enriched the dataset with monthly search volumes, competition metrics, and profit (PAT), and built a unified dashboard revealing how search performance aligns with financial outcomes. The analysis highlights UBAโ€™s 32% dominance in visibility and uncovers a weak but meaningful positive correlation between SEO strength and profit. These insights support smarter content investment, improved conversion strategies for mismatched SEOโ€“PAT profiles, and consistent SERP monitoring to protect visibility ROI.

Tools: Power BI, Google Apps Script, SerpApi, Excel/Google Sheets, SQL
Links: View Live Dashboard, Full Project Breakdown


Iโ€™m gradually curating more projects to showcase here(greatness takes time). In the meantime, you can explore my full repository here.

Project 6

Coming soon
View Full Project

Project 7

Coming soon
View Full Project

Services I Offer

Data Analysis & Business Intelligence
  • Power BI dashboard development
  • Executive KPI reporting
  • Excel automation (Power Query, pivots, formulas)
  • SQL-based analysis for business decisions
  • Exploratory Data Analysis (EDA)
  • Financial, operational, and market insights
Data Cleaning & Preparation
  • Cleaning and restructuring large datasets
  • Handling missing values and outliers
  • Data normalization and transformation
  • Merging multiple data sources
  • ETL workflows using SQL or Python
Dashboard & Automation Solutions
  • Interactive dashboards (Power BI, Streamlit)
  • Automated reporting systems
  • Real-time business monitoring tools
  • Custom mini-analytics apps for organizations
Machine Learning & Predictive Insights
  • Predictive modeling (sales, churn, demand, risk)
  • Customer segmentation and profiling
  • Time-series forecasting
  • NLP for text insights (reviews, complaints, chats)
  • Deployment of models into simple applications
AI & Prompt Engineering
  • AI-powered automation solutions
  • Prompt design and optimization
  • Integrating AI into business workflows
  • Custom AI assistants and chatbot setups
  • Evaluation and quality control of AI outputs

Click on each service above to expand and see details.

๐ŸŽ“ Training & Certifications

  • Power BI Essentials โ€“ Data visualization, DAX, dashboards
  • Python for Data Analysis โ€“ Pandas, NumPy, Matplotlib
  • SQL for Data Analysis โ€“ Data querying and management
  • AI & Machine Learning Basics โ€“ Intro to predictive modeling
  • Microsoft Excel for Data Analysis โ€“ PivotTables, formulas, charts, and data modeling
  • Data Analytics Job Simulation โ€“ Hands-on project-based learning

๐Ÿค Behind every project is a problem to solve and a story to tell. Thanks for stopping by, letโ€™s create something impactful together.

HIRE ME

I turn complex data into clarity, insight, and tools that help organizations make smarter decisions.

Available For

  • Remote contract work
  • Freelance projects
  • Dashboard development
  • Data analysis & reporting
  • Machine learning solutions

Contact Me
Tap any link below to connect

๐Ÿ“ง Email | ๐Ÿ’ผ LinkedIn | ๐ŸŒ Portfolio | ๐Ÿ™ GitHub

Popular repositories Loading

  1. ai-youtube-scripts ai-youtube-scripts Public

    A collection of YouTube-style educational scripts created using AI (ChatGPT + Claude + Perplexity) for topics spanning Engineering, Data Analytics, Predictive Maintenance, and Career Development. Eโ€ฆ

    1

  2. EPL-Dashboard EPL-Dashboard Public

    Premier League Player Stats Dashboard in Power BI.

    1

  3. SQL_Project_Data_Job_Analysis SQL_Project_Data_Job_Analysis Public

    SQL project analyzing data analyst job market trends, including top-paying roles, in-demand skills, and salary insights.

    1

  4. -Insurance-Risk-Claims-Analysis-Power-BI-Project -Insurance-Risk-Claims-Analysis-Power-BI-Project Public

    Power BI dashboard analyzing insurance claims, highlighting risks, trends, and high-claim regions.

    1

  5. MovieLens-Exploratory-Dashboard MovieLens-Exploratory-Dashboard Public

    Jupyter Notebook 1

  6. HNG-Ride-Analytics-SQL-Report HNG-Ride-Analytics-SQL-Report Public

    Ride-sharing data analysis using SQL โ€” cleaned, queried, and transformed raw trip records (2021โ€“2024) into actionable business insights. Focused on performance trends, driver analysis, and revenue โ€ฆ

    1