Analyze the Data
Once the company story and the business cycles are clear, this section becomes the place where students work with the data. Students can run SQL, rebuild evidence in Excel, read reports, follow guided cases, or browse reusable queries.
For a first assignment, start with SQL Guide, Excel Guide, Reports Hub, or a foundation case. Query Library is useful after students know what kind of question they are trying to answer.
What Students Do Here
| Subsection | What it is for | Start here |
|---|---|---|
| SQL Guide | Open SQLite, run one query, and learn how to read SQL output | when the class begins in SQL |
| Excel Guide | Use the workbook for pivots, filters, charts, and simple reconstruction | when the class begins in Excel |
| Reports Hub | Read finished reports before trying to reproduce them | when students need summary views first |
| Cases | Follow a structured assignment with required student output | when students need guided practice |
| Query Library | Browse reusable SQL by objective, output grain, and source tables | after students know the question they are answering |
How the Subsections Fit Together
Use this order when students are new to the analytics layer:
- start with SQL Guide or Excel Guide to establish the working method
- read a report in Reports Hub to see what a finished result looks like
- use a foundation case in Cases to connect business context, SQL, and interpretation
- open Query Library when students need more reusable Financial, Managerial, or Audit SQL
Choosing the First Entry Point
| If the class needs... | Start with |
|---|---|
| query workflow and starter logic | SQL Guide |
| workbook-based reconstruction | Excel Guide |
| management-style interpretation | Reports Hub |
| guided assignment flow | Cases |
| reusable query inventory | Query Library |
Each subsection should stay focused on its own job. SQL Guide explains SQL workflow. Excel Guide explains workbook workflow. Query Library organizes reusable SQL. Reports Hub explains reports and perspectives. Cases explains guided assignments.
Next Steps
- Start with SQL Guide or Excel Guide when students need the working method first.
- Use Reports Hub when students need to read finished outputs before reproducing them.
- Use Cases when students are ready for a guided investigation.
- Open Query Library when students need reusable Financial, Managerial, Audit, or case-support SQL.
Notice a mistake?Report an error on this page