Companion Guide

How to understand and extend the website

The project now uses multiple pages instead of one long scroll. This guide explains how each page is meant to be used and where to find the main technical assets.

Site Structure

What each page is for

Overview

The landing page explains the research problem, the data scope, and how the project is organized.

Analysis

This page contains the interactive dashboard with filters, KPI cards, charts, and repository spotlight views.

Data Model

This page explains the schema, SQL design choices, and how the two datasets fit together.

Findings

This page summarizes conclusions, challenges, and future work adapted from the final presentation.

Deliverables

This page gathers the SQL files, cleaned BI dataset, Power BI report, and documentation links.

Power BI

How it fits beside the built-in dashboard

Built-in website dashboard

Best for GitHub Pages, quick browsing, and keeping the project self-contained.

Formal Power BI report

Best for a standard BI deliverable, classroom presentation, and interviews where you want to show Power BI specifically.

Recommended setup

Use the website as the main project entry point and keep Power BI as a companion artifact linked from the Deliverables page.