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

πŸ“Š Data Analyst Β β€’Β  πŸ“ˆ Business Analyst Β β€’Β  🧠 Insight-Driven Problem Solver

LinkedIn Email


πŸ“Œ About Me

I’m an Information Systems graduate with a strong focus on Data Analytics and Business Analysis. I specialize in transforming raw, complex data into clear, actionable insights that support business decision-making.

In addition to traditional analytics, I actively leverage Generative AI tools (ChatGPT, Google Gemini) to enhance analytical workflows, improve documentation quality, accelerate insight generation, and support stakeholder communication.

This GitHub profile showcases end-to-end analytics projects, from data collection and cleaning to analysis, visualization, and insight delivery.


πŸ” What I Do

  • πŸ“Š Data Analysis & Visualization β€” exploratory data analysis (EDA), dashboards, trend analysis, and insight generation
  • 🧠 Business Analysis β€” requirements gathering, KPI definition, business rules, and problem-to-data translation
  • βš™οΈ Data Cleaning & Preparation β€” data validation, transformation, feature engineering, and structured datasets
  • πŸ“ˆ Data Storytelling β€” clear reports and presentations for technical and non-technical stakeholders
  • πŸ—„οΈ SQL & Data Modeling β€” relational modeling, joins, aggregations, and analytical queries
  • πŸ€– Generative AI–Assisted Analytics β€” prompt engineering, AI-assisted analysis, documentation, and automation support

πŸ› οΈ Tools & Technologies

πŸ“Š Data & Analytics

  • Python: Pandas, NumPy, scikit-learn, Matplotlib, Seaborn
  • SQL: MySQL / PostgreSQL, complex queries, views, analytics logic
  • Excel: Pivot tables, dashboards, advanced formulas

πŸ€– Generative AI & Productivity

  • ChatGPT (analytics workflows, prompt engineering, documentation)
  • Google Gemini (documentation, image generation, communication)
  • AI-assisted reporting and insight summarization

πŸ“ˆ Visualization & Reporting

  • Tableau (projects & concepts)
  • Matplotlib / Seaborn
  • Business-focused dashboards and reports

πŸ”§ Workflow & Tools

  • Git & GitHub
  • Jupyter Notebooks
  • VS Code

βš™οΈ How I Work

  1. Define business objectives and KPIs
  2. Translate problems into data and analytical requirements
  3. Perform exploratory data analysis to understand patterns and risks
  4. Clean, transform, and model data for analysis
  5. Use Generative AI responsibly to enhance reasoning, documentation, and communication
  6. Validate insights against business logic
  7. Deliver actionable insights via dashboards, reports, or presentations

🎯 Career Focus

I’m actively pursuing opportunities in:

  • Data Analyst
  • Business Analyst
  • Junior Data Scientist
  • Analytics / Tech Graduate Programmes

I value clarity, continuous learning, and using data + AI to solve real-world business problems.

πŸ’‘ β€œData creates insight. AI accelerates understanding. Decisions create value.”

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…

  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. Infinity-Tech-Expense-Tracker Infinity-Tech-Expense-Tracker Public

    πŸ“Š A Corporate Expense Tracker built in Excel. Features CapEx vs. OpEx analysis, vendor concentration risk assessment, and quarterly trend visualization for financial decision-making.

  5. Employees-Attrition-Analytics-Dashboard Employees-Attrition-Analytics-Dashboard Public

    πŸ“Š An interactive HR Analytics Dashboard built in Excel to analyze employee attrition, identify retention risks, and visualize workforce trends using the IBM dataset.

  6. 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