capstone-activatework-2025

Two part data analytics capstone. Part 1 uses MySQL and Excel for data prep and analysis. Part 2 delivers a Power BI star schema with DAX measures and executive dashboards. Repo includes SQL scripts, walkthrough notes, and screenshots. No proprietary data.

Data Analytics Capstone — Budget vs Actual

This project shows practical analytics across MySQL, Excel, and Power BI.

Quick links

• Part 1 Excel: part1_excel_mysql/Brett_Thalacker_M336_Part1_ExcelProject.xlsx
• Part 1 SQL: part1_excel_mysql/sql/creditcard_capstone.sql
• Part 2 PBIX: part2_powerbi/dashboards/Brett_Thalacker_M336_Part2_PowerBI.pbix

Contents

• SQL scripts for schema, cleaning, and query steps
• Excel workbook with pivots that mirror SQL answers
• Power BI file with a clean star schema, DAX measures, and KPI cards
• Walkthrough notes so a reviewer can follow each step

Tech stack

MySQL • Excel • Power BI Desktop • DAX • Power Query

Versions

Power BI Desktop: 2.148.1226.0 • MySQL: 8.x • Excel: Microsoft 365

Reproduce

1. Part 1: open part1_excel_mysql/Brett_Thalacker_M336_Part1_ExcelProject.xlsx to view pivots and answers.
2. Part 1 optional: run part1_excel_mysql/sql/creditcard_capstone.sql in MySQL if you want to rebuild tables.
3. Part 2: open part2_powerbi/dashboards/Brett_Thalacker_M336_Part2_PowerBI.pbix. If prompted, browse to the four CSVs in data/processed/Part 2.

What this shows

• SQL data prep and business queries
• Excel analysis that mirrors SQL answers
• Power BI star schema with DAX measures, KPI cards, and a variance trend

Data

Sample files mirror the production schema. Safe to share. No proprietary data.

---

Questions or feedback? Open an Issue in this repo.