SQL for Business Analysts: 100 Real-World Queries for Finance, Marketing, and Operations (The Business Analytics Library) (en Inglés)
Reseña del libro "SQL for Business Analysts: 100 Real-World Queries for Finance, Marketing, and Operations (The Business Analytics Library) (en Inglés)"
Stop reporting numbers you can’t defend. Most SQL books teach you syntax. This one teaches you to answer the questions your finance, marketing, and operations colleagues actually ask. It also shows you why the query that runs perfectly can still hand you the wrong number. SQL for Business Analysts works through 100 real-world queries on one realistic company database. Each one has a business question, ready-to-run PostgreSQL code, a plain-language explanation, an Analyst trap, and a reading of what the result does and does not prove. Inside you’ll find: Finance: revenue and margin, budget variance, receivables aging, DSO, collections, break-even Marketing: lead funnels, conversion, cost per lead, customer acquisition cost, campaign ROI, retention and lifetime value Operations: on-time delivery, inventory turnover and stockouts, supplier performance, freight cost, perfect-order rate Advanced analytics: rankings, running totals, cohorts, price/volume/mix, outlier detection Executive scorecards: KPI snapshots, RAG status, working-capital views and contribution analysis A playbook: a validation checklist, a SQL style guide, how to present results, and a PostgreSQL-to-other-databases guide You also get: Eleven fixed business rules so “revenue”, “active”, and “overdue” mean the same thing in every query A 30-exercise practice set with solutions A SQL cheat sheet, a KPI dictionary, a full data dictionary, and a glossary Every result and figure generated by running the printed query on the book’s database (a download is described in Chapter 3) Written for analysts, finance professionals, and managers who already use Excel or BI tools and want SQL that stands up in front of a CFO. The examples use PostgreSQL. A guide to other databases is included, but those examples were not run. All companies, customers, and figures are fictional.