unit-5.md

Unit V: Data-driven Decision-making

Learning Objectives

Build a tool to automate the process of visualizing raw sales data to support business management and decision-making capabilities.

Discussions and Notes

• Metrics, Reporting
• Data Visualization
• VBA Programming:
  • Opening and Closing Workbooks
  • Selecting Files to Open
  • Copying Ranges
• MS Excel:
  • Pivot Tables
  • Charts

Exercises and Activities

• "Processing Spreadsheet Files" Exercise
• "Executive Dashboard" Project