Skip to main content

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

SubsectionWhat it is forStart here
SQL GuideOpen SQLite, run one query, and learn how to read SQL outputwhen the class begins in SQL
Excel GuideUse the workbook for pivots, filters, charts, and simple reconstructionwhen the class begins in Excel
Reports HubRead finished reports before trying to reproduce themwhen students need summary views first
CasesFollow a structured assignment with required student outputwhen students need guided practice
Query LibraryBrowse reusable SQL by objective, output grain, and source tablesafter students know the question they are answering

How the Subsections Fit Together

Use this order when students are new to the analytics layer:

  1. start with SQL Guide or Excel Guide to establish the working method
  2. read a report in Reports Hub to see what a finished result looks like
  3. use a foundation case in Cases to connect business context, SQL, and interpretation
  4. 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 logicSQL Guide
workbook-based reconstructionExcel Guide
management-style interpretationReports Hub
guided assignment flowCases
reusable query inventoryQuery 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

  1. Start with SQL Guide or Excel Guide when students need the working method first.
  2. Use Reports Hub when students need to read finished outputs before reproducing them.
  3. Use Cases when students are ready for a guided investigation.
  4. Open Query Library when students need reusable Financial, Managerial, Audit, or case-support SQL.