COMP-3250  ·  Group 8  ·  University of Windsor
Due: Mar 29, 2026
Report: Mar 12, 2026

Visual Analytics of Gold Price Trends

A decade-spanning Power BI analytics project tracking XAU/USD movements, macroeconomic drivers, and volatility. Currently active in Phase 2: Technical Development.

0
Tasks Complete
0
Tasks Remaining
0
Team Members
Mar 29
Final Deadline
01 Project Phases 4 PHASES TOTAL
Phase 0
Project Launch & Compliance
Completed
Submit Project Proposal
GitHub Repo Init
Hive Workspace Setup
Power BI Certifications ×3
Completed by Mar 1, 2026
Phase 1
Discovery & Data Cleaning
Completed
Data Preprocessing & Validation
Key Event Research → Due Mar 13
Largely complete — Mar 8, 2026
Phase 2
Technical Development
In Progress
DAX & Custom Metrics
Visual Design & Layout → Due Mar 20
Active now — ends Mar 20, 2026
Phase 3
Final Deliverables
Upcoming
10-Page Narrative Report → Mar 24
Video Presentation → Mar 27 ⚠
Starts Mar 20 — due Mar 29, 2026
02 Dashboard Preview POWER BI · IN DEVELOPMENT
gold_historical_data_with_key_metrics · Power BI Desktop
Live Build
Power BI Dashboard — 30-Day Moving Avg and Daily Volatility
30-Day Moving Average & Daily Volatility — 2016 to 2026 · XAU/USD
DAX ✓ Moving Avg ✓ Volatility ✓ Slicer-ready ✓
03 Completed Tasks 7 OF 11
Complete & Submit Project Proposal
Full project scope, objectives, and methodology submitted on schedule.
Abhishek
GitHub Repository Initialization
Private repo with README.md, Power BI .gitignore; Maintainer access granted to all members; all proposal versions committed.
Aakanksha
Hive Workspace Architecture
Kanban board set up, team invited, all project tickets created and categorised across phases.
Aakanksha
Power BI DataCamp Certifications
All three team members completed Power BI certification training by Mar 1, 2026.
All Members
Data Preprocessing & Validation
Kaggle/Yahoo Finance CSV imported via Power Query. Null/outlier profiling done, dates standardised, redundant columns removed.
Aakanksha
DAX & Custom Metrics
Three slicer-responsive DAX measures: 30-Day Moving Average, YoY % Price Change, and Daily Volatility — all live in the dashboard.
Aakanksha
04 Upcoming Tasks 4 REMAINING
Key Event Research & Annotations
5 significant gold price spike/crash dates with one-paragraph explanations for dashboard annotations (e.g., 2020 COVID uncertainty).
Abhishek
Visual Design & Canvas Layout
Build Power BI canvas layout with primary 10-year time-series line chart and professional financial theme throughout.
Brett
10-Page Narrative Report
Times New Roman 12pt report including dashboard screenshots. Solution Statement and Analysis sections explaining gold's price behaviour.
Abhishek + Aakanksha
Video Presentation Recording
10-minute MP4. Brett: dashboard interactivity. Aakanksha: intro & methodology. Abhishek: business conclusions. Due Mar 27 — final deadline.
All Members
05 Team 3 CONTRIBUTORS
A
Aakanksha Mandal
Project Coordinator
  • Workspace & repo setup
  • Data preprocessing & DAX
  • Narrative report co-lead
  • Video: intro & methodology
Ab
Abhishek Chap.
Research & Analysis
  • Project proposal lead
  • Key event research
  • Narrative report co-lead
  • Video: business conclusions
B
Brett Adams
Visualization Lead
  • Canvas & chart layout
  • Financial theme design
  • Power BI certification
  • Video: interactivity demo
All members active and responsive. No blockers reported. Weekly sync via Hive. Repository current on GitHub.
Hive GitHub Power BI Power Query DAX Kaggle / Yahoo Finance
Aakanksha Mandal
Project Coordinator  ·  Group 8  ·  University of Windsor
SUBMITTED TO PROFESSOR
MARCH 12, 2026
COMP-3250 · PHASE 2 OF 3