Data-Driven Decision Making: Excel and SQL for Business Analysts

<p>Follow Renata Cruz, a newly promoted business analyst at Cobalt Bicycles, as her VP of Sales hands her a messy sales export and a blunt deadline. Across five hands-on lessons, Renata builds real Excel formulas and pivot tables to size up store and product performance, writes SQL queries against the company's sales database to answer bigger questions, learns to structure a numbers-heavy analysis into an actual recommendation, and catches the survivorship bias, correlation-causation mix-ups, and cherry-picked time windows that almost send leadership the wrong way.</p>

Tools: Excel Formulas (SUMIFS, XLOOKUP), Excel PivotTables, SQL (SELECT/JOIN/GROUP BY), Business Data Analysis, Data Storytelling