Skip to content
View samuel-wahinya's full-sized avatar

Block or report samuel-wahinya

Report abuse

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

Report abuse
samuel-wahinya/README.md

Samuel Wahinya

I'm a Data Warehouse Engineer, SQL Data Analyst, Tableau dashboard developer, and a Notion Productivity Enthusiast. I use SQL, Tableau & Excel to transform raw data into actionable insights and reccomendattions, building engaging visualizations, and creating systems that enhance efficiency and productivity.

🚀 What I Do

🏗️ Data Engineering

  • Design and implement scalable data pipelines using SQL Server and Medallion Architecture (Bronze → Silver → Gold).
  • Build reliable data warehouses to support fast and accurate reporting.
  • Automate data workflows to minimize manual effort and enhance data freshness.

📊 Data Analysis

  • Perform in-depth analysis using advanced SQL techniques to uncover trends, patterns, and insights.
  • Develop data models and KPIs to support business decision-making.
  • Create audit-ready datasets with robust data quality checks and validation logic.

🎨 Data Visualization

  • Build interactive dashboards in Tableau to translate complex data into clear, actionable stories.
  • Design visual solutions for executives and operational teams with dynamic filters and KPIs.
  • Simplify reporting using intuitive and user-friendly interfaces.

🧩 Portfolio

VelociMart BI Project VelociMart Sales Dashboard

Developed a sales dashboard to support VelociMart’s Chief Revenue Officer in tracking year-over-year sales and profit growth. The solution answered key business questions on seasonal sales trends, peak and low-performing months, and sales target performance. The dashboard enabled strategic decisions that optimized product timing.

Havenhill BI Project Havenhill Regional Hospital Flu Dashboard

Developed a Flu Shot dashboard that enabled Havenhill Regional Hospital to monitor flu shot compliance across demographics and counties. This tool became a key asset for medical directors and outreach teams, directly supporting targeted vaccination efforts and contributing to an overall 81.4% patient immunization rate in 2022.

🛠 Languages & Tools

SQL Microsoft SQL Server Tableau Notion Microsoft Excel Microsoft Access

Let's analyze, visualize, and optimize. 🚀

Popular repositories Loading

  1. samuel-wahinya samuel-wahinya Public

  2. VelociMart-Sales-Dashboard VelociMart-Sales-Dashboard Public

    This project showcases how i helped VelociMart shift from Excel-based reporting to a robust data infrastructure using SQL Server and Tableau. Built around Sales, Customers, and Products Data Marts,…

    TSQL

  3. Havenhill-Regional-Hospital-Flu-Shot-Dashboard Havenhill-Regional-Hospital-Flu-Shot-Dashboard Public

    This project presents a comprehensive flu shot compliance analysis at Havenhill Regional Hospital, focusing on patients who were active in 2022. As a Healthcare Data Analyst, I developed a data pip…

    TSQL

  4. fhir-server fhir-server Public

    Forked from microsoft/fhir-server

    A service that implements the FHIR standard

    TSQL

  5. augur augur Public

    Forked from chaoss/augur

    Python library and web service for Open Source Software Health and Sustainability metrics & data collection. You can find our documentation and new contributor information easily here: https://oss-…

    Python

  6. JetStar JetStar Public

    A complete end-to-end aviation analytics project — from realistic dataset creation to building a data warehouse using the Medallion Architecture (Bronze, Silver, Gold). The project covers data engi…

    TSQL