Comprehensive Data Management & Visualization Project

Project that includes database design, MS Access queries, Excel analytics, and Power BI visualizations.

Scope:

Database Design (No software)
Design 5 relational tables (customers, sales, products, employees, loyalty)
Define attributes, primary keys, foreign keys
Brief explanation of field requirements and purpose of data
MS Access Work
Use provided .accdb file
Check relationships between tables
Create queries:
Total sales per customer
Employee email username generator
Monthly sales
Highest average sales customer
Employee commission (3.5%)
Provide screenshots of results
Excel Analytics
Use provided dataset
Calculate Altman Z-score (5 ratios)
Create histogram (distress / grey / safe)
Provide screenshots
Power BI
Create:
Stacked column chart
Pie chart
Line chart (monthly trend)
Provide screenshots
Short theory answers
Blockchain in accounting (150 words)
AI impact (100 words)
Generative AI task + evaluation

Deliverables:

Final Word document with all screenshots and answers
PDF version
Editable files (Access, Excel, Power BI)