Skip to content
View Bheki0987's full-sized avatar
💭
Available
💭
Available

Block or report Bheki0987

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 supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Bheki0987/README.md

👋 Hi, I’m Bheki Mogola

📊 Aspiring Data & Business Intelligence Analyst🎓 Information Systems Graduate🧠 Logical Problem Solver

LinkedIn Email Portfolio


📌 About Me

I am a recent BCom Information Systems graduate from North-West University with a passion for turning "messy" data into clear, actionable business insights. I’m focused on building a career where I can bridge the gap between technical data and business needs.

I enjoy the challenge of finding patterns in data and using those findings to help businesses make better decisions. I also actively use Generative AI (ChatGPT, Google Gemini) to speed up my coding, improve my project documentation, and learn new analytical techniques faster.

This GitHub profile is a collection of my hands-on projects, showing how I handle data from start to finish, from data cleaning and SQL modeling to statistical analysis and BI dashboarding that tell a story.


🔍 What I Bring to the Table

📊 Data & BI Analysis

  • Exploratory Data Analysis (EDA): Digging into datasets to find trends, risks, and opportunities.
  • Visual Storytelling: Creating dashboards that make complex numbers easy for anyone to understand.
  • KPI Focused: Understanding that data is only useful if it helps measure and achieve business goals.

🧠 Business Analysis Skills

  • Problem-to-Data Translation: Taking a business question and figuring out exactly what data is needed to answer it.
  • Requirements Gathering: Working to understand what stakeholders actually need from a report or tool.
  • Logical Thinking: Ensuring data models follow clear business rules and provide accurate results.

🧮 Quantitative Foundation

  • Statistical Inference: Applying hypothesis testing, p-values, and confidence intervals to validate findings.
  • Probability & Risk: Using probability distributions to model business uncertainty and risks.
  • Linear Algebra & Calculus: Leveraging mathematical foundations for data transformation, optimization, and understanding machine learning logic.

⚙️ Data Preparation

  • Data Cleaning: Using Python and SQL to fix inconsistencies and prepare datasets for analysis.
  • SQL Queries: Comfortable writing joins, aggregations, and subqueries to pull the right information.

🛠️ Tools & Technologies

📂 Analytics & Programming

  • Python: Pandas, NumPy, Matplotlib, Seaborn (For analysis and visualization).
  • SQL: MySQL / PostgreSQL (Relational modeling and analytical queries).
  • Excel: Advanced formulas, Pivot Tables, and Power Query.

🤖 AI for Productivity

  • GenAI Tools: Using ChatGPT and Gemini for prompt engineering, debugging code, and drafting clear reports.

📈 Visualization & Reporting

  • BI Tools: Tableau & Oracle Analytics Cloud (Designing interactive dashboards).
  • Workflow: Git/GitHub, Jupyter Notebooks, and VS Code.

⚙️ My Project Workflow

When I tackle a project, I follow a simple, logical process:

  1. Define the Goal: What business question am I trying to answer?
  2. Get & Clean Data: Pulling data with SQL and cleaning it with Python/Excel.
  3. Validate: Apply Statistical Inference to ensure data integrity and significance.
  4. Analyze: Finding the "why" behind the numbers.
  5. Enhance with AI: Using AI to double-check my logic, optimize my code, and document my work.
  6. Visualize: Building a dashboard or report that shows the solution clearly.

🎯 Career Focus

I’m looking for opportunities to grow and contribute as a:

  • Junior Data Analyst
  • Business Intelligence Analyst
  • Junior Business Analyst

💡 “Data creates insight. AI accelerates understanding. Decisions create value.”


Learning every day. Building one project at a time.

Pinned Loading

  1. Ubuntu-National-Bank-UNB-Data-Analytics-Project Ubuntu-National-Bank-UNB-Data-Analytics-Project Public

    🏦 An end-to-end banking data analytics project simulating a real-world financial environment (Ubuntu National Bank). Features advanced MySQL architecture, immutable transaction modeling, reconcilia…

    1

  2. Metroville-Municipal-Financial-Performance-Dashboard Metroville-Municipal-Financial-Performance-Dashboard Public

    🏛️ A strategic financial analytics dashboard designed to monitor municipal fiscal health. Tracks budget variance, revenue collection efficiency, and debt trends to drive executive decision-making.

  3. Inventory-Optimization-Dashboard Inventory-Optimization-Dashboard Public

    📦 A dynamic Excel Dashboard for Inventory Optimization. Tracks stock levels, calculates restocking needs automatically, and visualizes inventory value by category.

  4. Amanzi-Ordering-System Amanzi-Ordering-System Public

    💧 A comprehensive water ordering system designed for NWU Mahikeng students. Streamlines delivery logistics with automated invoicing, analytics, and seamless payments.

    JavaScript

  5. Street-Smart-Digital-Permit-System Street-Smart-Digital-Permit-System Public

    An end-to-end Business Analysis portfolio case study designing a digital permit system for informal traders. Features full SDLC artifacts including BRD, SRS, ERD, Process Flows, and UAT strategies.

  6. E-Commerce-OTIF-Perfect-Order-Analytics E-Commerce-OTIF-Perfect-Order-Analytics Public

    An end-to-end analytics solution that translates supply chain failures into financial impact. Using **Python** for ETL and **Tableau** for visualization, this project identifies exactly where reven…

    Jupyter Notebook