相關主題
商品描述
This book addresses an important gap in data analytics education: the interplay between complex query-making and storytelling. While many resources cover the fundamentals of SQL queries and the technical skills required to manipulate data, few also explore moving beyond the numbers and figures to tell stories that drive strategic business decisions. By weaving together both SQL and narrative mechanics, author Hamed Tabrizchi has assembled a powerful tool for data analysts, aspiring database professionals, and business intelligence specialists.
A strong foundation is laid in the first part of the book, which examines the technical skills necessary to access and manipulate data. You'll explore foundational SQL commands, advanced querying techniques, data manipulation, data integrity, and optimization of queries for performance. The second half moves from the "how" of SQL to the "why," examining the meaning-making practices we can apply to data, and the stories data can tell. You'll learn how SQL queries can be interpreted, how to prepare data for visualization, and most importantly, how to convey the findings in a way that engages and informs the audience. In each chapter, practical exercises reinforce the techniques learned and help you apply them in real-world situations. In addition to strengthening technical skills, these exercises encourage readers to take a critical view of the data they are studying, considering the larger story it represents.
Upon completing this book, you will not only be proficient in SQL, but also possess the key skill of converting data into narratives that can influence strategic direction and operational decisions in the modern workplace.
What You Will Learn
- Advanced SQL Techniques: Master data manipulation and retrieval skills using advanced SQL queries
- Data Analysis Proficiency: Develop analytical skills to uncover key insights and understand significant data patterns
- Storytelling with Data: Learn to translate data analytics into compelling narratives for effective stakeholder communication
- Complex Querying Skills: Understand advanced SQL concepts such as common table expressions (CTEs), subqueries, and window functions
- Query Optimization: Optimize query execution time, resource usage, and scalability by mastering Indexes and Views
- Practical Application of Techniques: Gain hands-on experience with practical examples of advanced SQL techniques in real-world data analysis scenarios
- Effective Data Presentation: Discover strategies for visually presenting data stories to enhance engagement and understanding among diverse audiences
Who This Book Is For
Data analysts and business analysts, SQL developers, data-driven managers and executives and academics and students looking to enhance advanced querying and narrative building skills to better interpret and convey data.
商品描述(中文翻譯)
這本書填補了數據分析教育中的一個重要空白：複雜查詢製作與故事講述之間的相互作用。雖然許多資源涵蓋了 SQL 查詢的基本原理以及操作數據所需的技術技能，但很少有資源探討如何超越數字和數據，講述能夠推動戰略商業決策的故事。作者 Hamed Tabrizchi 將 SQL 和敘事機制結合在一起，為數據分析師、渴望成為數據庫專業人士以及商業智慧專家提供了一個強大的工具。
本書的第一部分奠定了堅實的基礎，探討了訪問和操作數據所需的技術技能。您將探索基本的 SQL 命令、高級查詢技術、數據操作、數據完整性以及查詢性能的優化。第二部分則從 SQL 的「如何」轉向「為什麼」，檢視我們可以應用於數據的意義建構實踐，以及數據所能講述的故事。您將學習如何解釋 SQL 查詢、如何準備數據以進行可視化，最重要的是，如何以吸引並告知觀眾的方式傳達發現。在每一章中，實用的練習加強所學的技術，並幫助您在現實情境中應用這些技術。除了增強技術技能外，這些練習還鼓勵讀者對所研究的數據採取批判性的觀點，考慮它所代表的更大故事。
完成本書後，您不僅能熟練掌握 SQL，還將具備將數據轉化為敘事的關鍵技能，這些敘事能夠影響現代工作場所的戰略方向和操作決策。
您將學到的內容：
- 高級 SQL 技術：掌握使用高級 SQL 查詢進行數據操作和檢索的技能
- 數據分析能力：發展分析技能以揭示關鍵見解並理解重要的數據模式
- 數據故事講述：學習如何將數據分析轉化為引人入勝的敘事，以有效地與利益相關者溝通
- 複雜查詢技能：理解高級 SQL 概念，如公共表達式 (CTEs)、子查詢和窗口函數
- 查詢優化：通過掌握索引和視圖來優化查詢執行時間、資源使用和可擴展性
- 技術的實際應用：在現實數據分析情境中獲得高級 SQL 技術的實用範例的實踐經驗
- 有效的數據呈現：發現視覺呈現數據故事的策略，以增強不同觀眾之間的參與感和理解
本書適合對象：
數據分析師和商業分析師、SQL 開發人員、數據驅動的經理和高管，以及希望提升高級查詢和敘事構建技能以更好地解釋和傳達數據的學術界人士和學生。
作者簡介
Hamed Tabrizchi is an experienced data analyst and engaging storyteller who has more than five years of experience turning complex data into compelling narratives. Passionate about educating others, Hamed lectures at universities, leads workshops, and contributes to leading scientific journals. As a result of his observations in the professional community, he decided to write this book to fill a void he observed: the need for a resource that weaves SQL technicalities with narrative to empower analysts in delivering insights that resonate and drive action.
作者簡介(中文翻譯)
哈梅德·塔布里茲奇是一位經驗豐富的數據分析師和引人入勝的故事講述者，擁有超過五年的經驗，將複雜的數據轉化為引人注目的敘事。哈梅德熱衷於教育他人，於大學授課、主持工作坊，並為領先的科學期刊撰寫文章。基於他在專業社群中的觀察，他決定撰寫這本書，以填補他所觀察到的空白：需要一個將SQL技術細節與敘事結合的資源，以幫助分析師提供能引起共鳴並推動行動的見解。
