商品描述
Are you a reasonably competent Power BI user but still struggling to generate reports that truly tell the story of your data? Or do you simply want to extend your knowledge of Power BI by exploring more complex areas of visualizations, data modelling, DAX, and Power Query? If so, this book is for you. This book serves as a comprehensive resource for users to implement more challenging visuals, build better data models, use DAX with more confidence, and execute more complex queries so they can find and share important insights into their data.
The contents of the chapters are in a question-and-answer format that explore everyday data analysis scenarios in Power BI. These questions have been generated from the author's own client base and from commonly sought-for information from the Power BI community. They cover a wide and diverse range of topics that many Power BI users often struggle to get to grips with or don't fully understand. Examples of such questions are:- How can I generate dynamic titles for visuals?
- How can I control subtotals in a Matrix visual?
- Why do I need a date dimension?
- How can I show the previous N month's sales in a column chart? Why do I need a Star Schema?
- Why aren't my totals correct?
- How can I bin measures into numeric ranges?
- Can I import a Word document?
- Can I dynamically append data from different source files?
After working through this book, you will have extended your knowledge of Power BI to an expert level, alleviating your existing frustrations and so enabling you to design Power BI reports where you are no longer limited by your lack of knowledge or experience.
Who is This Book For:
Power BI users who can build reports and now want to extend their knowledge of Power BI.商品描述(中文翻譯)
你是一個相對熟練的Power BI使用者，但仍然在生成真正能夠完整呈現數據故事的報告方面遇到困難嗎？或者你只是想通過探索更複雜的可視化、數據建模、DAX和Power Query等領域來擴展你對Power BI的知識嗎？如果是的話，這本書就是為你而寫的。這本書是一個全面的資源，讓使用者能夠實現更具挑戰性的視覺化、建立更好的數據模型、更自信地使用DAX，以及執行更複雜的查詢，從而找到並分享對數據的重要洞察。
本書的章節內容以問答形式呈現，探討Power BI中的日常數據分析場景。這些問題來自作者自己的客戶群體，以及Power BI社區中常見的信息需求。它們涵蓋了許多Power BI使用者常常難以掌握或不完全理解的各種主題。這些問題的例子包括：
- 如何為視覺化生成動態標題？
- 如何在矩陣視覺化中控制小計？
- 為什麼需要日期維度？
- 如何在柱狀圖中顯示前N個月的銷售額？
- 為什麼需要星型模式？
- 為什麼我的總計不正確？
- 如何將度量值分組成數值範圍？
- 我可以導入Word文檔嗎？
- 我可以動態添加來自不同源文件的數據嗎？
這些問題的解決方案以非技術性和易於理解的解釋形式呈現，無需進行繁瑣和無效的“谷歌”搜索。書中還附有Power BI Desktop文件，展示了每個問題的答案，這樣你就可以跟隨書中的示例進行操作。
通過閱讀本書，你將能夠將你對Power BI的知識提升到專家級水平，減輕你現有的挫折感，從而設計出不再受限於知識或經驗不足的Power BI報告。
這本書適合已經能夠建立報告並希望擴展對Power BI知識的使用者。
作者簡介
Alison Box is a Director of Burningsuit Ltd, www.burningsuit.co.uk, and an IT trainer and consultant with over 30 years' experience of delivering computer applications training to all skill levels, from basic users to advanced technical experts. She is the author of Up and Running with DAX for Power BI and Introducing Charticulator for Power BI, both published by Apress.
Currently, she specializes in delivering training in Microsoft Power BI Service and Desktop, Data Modeling, DAX (Data Analysis Expressions), and Excel. Alison also works with organizations as a DAX and Data Analysis consultant. She was one of the first Excel trainers to move into delivering courses in Power Pivot and DAX, from where Power BI was born. Part of her job entails promoting Burningsuit as a knowledge base for Power BI and includes writing regular blog posts on all aspects of Power BI that are published on her website.
作者簡介(中文翻譯)
Alison Box是Burningsuit Ltd的董事，網址為www.burningsuit.co.uk，她是一位IT培訓師和顧問，擁有超過30年的計算機應用培訓經驗，涵蓋從基礎使用者到高級技術專家的各個技能層級。她是Apress出版的《Up and Running with DAX for Power BI》和《Introducing Charticulator for Power BI》的作者。
目前，她專注於提供Microsoft Power BI Service和Desktop、數據建模、DAX（數據分析表達式）和Excel的培訓。Alison還作為DAX和數據分析顧問與組織合作。她是最早開始提供Power Pivot和DAX課程的Excel培訓師之一，Power BI就是從這裡誕生的。她的工作之一是將Burningsuit推廣為Power BI的知識庫，並在她的網站上定期發表有關Power BI各個方面的博客文章。
