SQL for Data Analysis: Advanced Techniques for Transforming Data Into Insights (Paperback)

With the explosion of computing power, thanks to analytic databases and cloud data warehouses, SQL has become an even more robust and flexible tool for the savvy analyst or data scientist. This practical book reveals hidden ways to get the most out of your SQL workflow.

You'll learn how to use both common and exotic SQL functions such as joins, window functions, subqueries, and regular expressions in new, innovative ways-as well as how to combine SQL techniques to accomplish your goals faster, with more understandable code. If you work with SQL databases, this is a must-have reference.

SQL for Data Analysis covers useful applications such as:

• Cohort analysis
• Text analysis
• Anomaly detection
• Time series analysis
• Experiment analysis
• Creating complex datasets for further exploration in statistical and visualization tools
• And more

隨著分析資料庫和雲端資料倉儲的計算能力爆炸式增長，SQL已成為精明分析師或資料科學家更強大且靈活的工具。這本實用書揭示了如何從SQL工作流程中獲得最大效益的隱藏方法。

您將學習如何以新穎的方式使用常見和異常的SQL函數，例如連接、窗口函數、子查詢和正則表達式，以及如何結合SQL技巧以更快、更易理解的程式碼實現目標。如果您使用SQL資料庫，這是一本必備參考書。

《SQL資料分析》涵蓋了以下有用的應用領域：
- 族群分析
- 文本分析
- 異常檢測
- 時間序列分析
- 實驗分析
- 創建複雜資料集，以進一步在統計和可視化工具中進行探索
- 等等

Cathy Tanimura has a passion for connecting people and organizations to the data they need to make an impact. She has been analyzing data for over 20 years across a wide range of industries, from finance to B2B software to consumer services. She has experience analyzing data with SQL across most of the major proprietary and open source databases. She has built and managed data teams and data infrastructure at a number of leading tech companies. Cathy is also a frequent speaker at top conferences, on topics including building data cultures, data-driven product development, and inclusive data analysis.

Cathy Tanimura熱衷於將人們和組織與所需的數據連接起來，以實現影響力。她在金融、B2B軟體和消費者服務等各種行業中，已經有超過20年的數據分析經驗。她具備使用SQL分析各種主要專有和開源數據庫的經驗。她在多家領先的科技公司建立和管理數據團隊和數據基礎設施。Cathy也是頂尖會議的常客，演講主題包括建立數據文化、以數據驅動的產品開發和包容性數據分析。