相關主題
商品描述
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 的知識提升到專家級別，減輕您現有的挫折感，從而使您能夠設計 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.
作者簡介(中文翻譯)
艾莉森·博克斯是Burningsuit Ltd的董事，網站為www.burningsuit.co.uk，擁有超過30年的經驗，專注於為各種技能水平的用戶提供電腦應用程式培訓，從基本用戶到高級技術專家。她是Up and Running with DAX for Power BI和Introducing Charticulator for Power BI的作者，這兩本書均由Apress出版。
目前，她專注於提供Microsoft Power BI Service和Desktop、數據建模、DAX（數據分析表達式）以及Excel的培訓。艾莉森還作為DAX和數據分析顧問與組織合作。她是第一批將Excel培訓轉向Power Pivot和DAX課程的培訓師之一，這也是Power BI的起源。她的工作部分包括推廣Burningsuit作為Power BI的知識庫，並定期在她的網站上撰寫有關Power BI各個方面的博客文章。
