1
SQL
Interrogate the data
Write evidence queries for revenue trend, customer concentration and overdue exposure.
PROOF TO PRODUCEKeep each query beside the business question it answers.
📈 CROSS-ACADEMY CAPSTONE · 600 XP
Business Intelligence Brief
Turn a fictional transaction dataset into SQL evidence, Python analysis and a verification-aware executive brief.
SQLPythonPrompting
WHAT TO FINISH FIRST
PROJECT RUNBOOK
Four stages. Four visible artifacts.
Use your own editor/notebook/tools. LearnCode gives the brief and records your self-check; it does not pretend to inspect files it cannot see.
2
PYTHON
Transform the evidence
Represent the query outputs as simple records and calculate one comparison or rate that is easier to interpret programmatically.
PROOF TO PRODUCEShow the input values and the derived value instead of only the final number.
3
PROMPTING
Design the analysis instruction
Create an executive-analysis prompt that separates supported findings, inference, missing evidence and verification steps.
PROOF TO PRODUCEThe prompt must tell the model what not to infer from the evidence.
4
SYNTHESIS
Write the decision brief
Produce a one-page recommendation with the strongest evidence, material risk and next verification action.
PROOF TO PRODUCEEvery material conclusion should trace back to one of your evidence artifacts.
FINAL SELF-REVIEW
What did you learn from combining the skills?
Write at least ~100 characters about the hardest tradeoff, one mistake you caught, and what you would improve next. This is a reflection gate, not automated grading.
0/4 artifacts self-checked · 0/100 reflection characters
Complete the required starter academies before self-checking or claiming capstone completion.