Details

<p>Introduction xxi</p> <p><b>Part 1: Introduction</b></p> <p><b>Chapter 1: Introducing Power BI 3</b></p> <p>What Is Power BI? 3</p> <p>Why Would I Use Power BI? 7</p> <p>But Why? 7</p> <p>Disconnected Data 8</p> <p>Fixed Formulas 9</p> <p>Ten Reasons Why Power BI Transforms Your Work 10</p> <p>Will I Still Use Excel? 12</p> <p>How Much Is this Going to Cost? 14</p> <p>Where Do We Go from Here? 16</p> <p><b>Chapter 2: From Data to Insight 17</b></p> <p>Three Guiding Principles 17</p> <p>Distinguishing Data, Information, and Knowledge 18</p> <p>Follow a Consistent, Proven Method 21</p> <p>Data Sources 21</p> <p>Files 21</p> <p>Databases 22</p> <p>Online Services 23</p> <p>Plan Ahead 23</p> <p>Import Data 25</p> <p>Prepare Data 26</p> <p>Model Data 28</p> <p>Report Data 29</p> <p>Analyze Data 30</p> <p>Use Visualizations Well 31</p> <p>Three Ways to Ruin Visual Analytics 32</p> <p>Use as Many Cool Gadgets as You Can Find 32</p> <p>Overwhelm the User with Tons of Detail 32</p> <p>Pick the Wrong Tool for the Job 34</p> <p>Four Ways to Improve Visual Analytics 35</p> <p>Reduce the Nondata Pixels 35</p> <p>Enhance the Data Pixels 36</p> <p>Conclusion 38</p> <p><b>Part 2: Power BI Guided Walk-Throughs</b></p> <p><b>Chapter 3: Let’s Take a Flyover! 41</b></p> <p>Getting Connected 41</p> <p>A Quick Tour of the Power BI Service 42</p> <p>Frequented Hotspots of Power BI 42</p> <p>Adding Sample Content 43</p> <p>Understanding the Power BI Service Interface 44</p> <p>Highlighting 47</p> <p>Slicers 50</p> <p>Filters 52</p> <p>Drill-Down 54</p> <p>Dashboards 55</p> <p>Drill-Through 58</p> <p>Visibility 59</p> <p>Show as Table 59</p> <p>Sorting Visuals 60</p> <p>Filtering— One More Time 61</p> <p>Power BI Building Blocks 61</p> <p>Flyover of Power BI Desktop 62</p> <p>Navigating Power BI Desktop 63</p> <p>Conclusion 65</p> <p><b>Chapter 4: Building Your First Report 67</b></p> <p>Connecting to a Data Source 67</p> <p>Examining the Data Model 68</p> <p>Exploring the Data 75</p> <p>Building Your Report 85</p> <p>Designing for Mobile Devices 101</p> <p>Conclusion 102</p> <p><b>Chapter 5: Preparing Data 103</b></p> <p>GDP Data 103</p> <p>Power Query Overview 105</p> <p>Data Arrangement Steps 106</p> <p>Rename Query 106</p> <p>Remove Rows 106</p> <p>Remove Columns 107</p> <p>Applied Steps So Far 107</p> <p>Promote Headers 108</p> <p>Renaming Columns 108</p> <p>Empty Values 109</p> <p>Handling Aggregated Data 109</p> <p>Filtering Rows 110</p> <p>Unpivoting Data 110</p> <p>Change Column Data Type 112</p> <p>Changing Values in Columns 112</p> <p>Duplicating Columns 113</p> <p>Multiply by a Million 113</p> <p>Removing Implicit Measures 114</p> <p>Column Formatting 115</p> <p>Calculated Columns 115</p> <p>Add Previous Year Column 116</p> <p>Hiding Columns 117</p> <p>LOOKUPVALUE Function 118</p> <p>DIVIDE Function 119</p> <p>Visualize Our GDP Data 120</p> <p>Where Are We? 121</p> <p>Cleaning Messy Data 122</p> <p>Handle Many-to-Many Relationships 123</p> <p>Duplicate a Query 125</p> <p>Split Column 125</p> <p>Format Column 127</p> <p>Remove Duplicates 127</p> <p>Index Column 128</p> <p>Merge Data 128</p> <p>Applying Changes 129</p> <p>Finding the Power Query Button 131</p> <p>Simple Cleanup Tasks 131</p> <p>Replacing Values 132</p> <p>Custom Columns 133</p> <p>More Cleanup 135</p> <p>Cleaning Date Columns 136</p> <p>Conclusion 138</p> <p><b>Chapter 6: Modeling Data 139</b></p> <p>Dimensional Modeling 140</p> <p>Why Does This Matter? 143</p> <p>Makes Sense to You 143</p> <p>Cross-Business Process Analysis 144</p> <p>Flexible Grouping 144</p> <p>Performance for Power BI 144</p> <p>Facts 145</p> <p>Types of Facts 146</p> <p>Granularity 146</p> <p>Relationships Between Facts (Never!) 147</p> <p>Dimensions 148</p> <p>Using Integer Keys for Relationships 149</p> <p>Hierarchies in Dimensions 149</p> <p>Date Dimensions 150</p> <p>Power Query and Data Modeling 151</p> <p>How to Build a Date Dimension 152</p> <p>Import a Date Table from SQL Server Database 153</p> <p>Create a Date Dimension with Power Query 155</p> <p>Create a Date Dimension with DAX 158</p> <p>Sort by Column 161</p> <p>Mark It as a Date Table 161</p> <p>How to Arrange into a Star- Schema 161</p> <p>Create a State Dimension 162</p> <p>Create a GDP Category Dimension 163</p> <p>Add a New StateID Foreign Key to Our Fact Table 163</p> <p>Unpivot the GDP Year Values 164</p> <p>Putting It All into Action 166</p> <p>Conclusion 167</p> <p><b>Part 3: Going Deeper Into Power BI</b></p> <p><b>Chapter 7: Relationships and Filtering 171</b></p> <p>Filtering Through Relationships 171</p> <p>Visuals Interact Independently 174</p> <p>The Direction of Relationships 176</p> <p>Bidirectional Filtering 179</p> <p>Report Filter Types 181</p> <p>Visual Filters 181</p> <p>Date Filtering 182</p> <p>Numeric Filtering 182</p> <p>Text Filtering 183</p> <p>Page and Report Filters 185</p> <p>Controlling the Use of Filters 185</p> <p>Conclusion 186</p> <p><b>Chapter 8: Enhancing Your Report 187</b></p> <p>Configuring Drill- Down 187</p> <p>Configuring Drill- Through 190</p> <p>Buttons 193</p> <p>Bookmarks 195</p> <p>Personal Bookmarks vs. Report Bookmarks 199</p> <p>Selections and Visibility 201</p> <p>Conclusion 205</p> <p><b>Chapter 9: Refreshing, Sharing, and Collaborating 207</b></p> <p>Refreshing Data 207</p> <p>Configuring Data Source Credentials 210</p> <p>Power BI Data Gateway 213</p> <p>Scheduling Refresh 214</p> <p>Dataset Modes 216</p> <p>Sharing and Collaborating 216</p> <p>Workspaces 216</p> <p>Creating Workspaces 217</p> <p>Publishing 217</p> <p>Security and Permission Levels 219</p> <p>Power BI Apps 223</p> <p>Sharing 230</p> <p>Summary 232</p> <p><b>Chapter 10: Introducing Dax 233</b></p> <p>Setup 233</p> <p>Calculated Columns 235</p> <p>How to Create a Calculated Column 236</p> <p>DAX Measures 240</p> <p>COUNTROWS and DISTINCTCOUNT 244</p> <p>Filter Context 246</p> <p>CALCULATE Function 249</p> <p>Conclusion 250</p> <p><b>Chapter 11: Conclusion 251</b></p> <p>Where Does My Organization Begin? 251</p> <p>Delivery Strategy 251</p> <p>Business-Led Self-Service 252</p> <p>IT-Managed Self-Service 253</p> <p>Corporate BI 253</p> <p>Which Delivery Strategy Is Right for My Organization? 253</p> <p>Where Do I Go from Here? 254</p> <p>Top Gurus 254</p> <p>Advice 254</p> <p>Index 257</p>

<p><b>PAUL D. FULLER</b> has over 25 years’ experience in app development, business intelligence, and data warehousing. He offers technical leadership and delivery oversight for complex and challenging data platform projects. He is an expert in Power BI, dimensional data modeling, and data warehousing.

<p><b>Unlock the astonishing capabilities of Microsoft Power BI for your business</b> <p>In <i>Beginning Power BI for Business Users: Learning to Turn Data into Insights</i>, veteran business intelligence and data professional Paul Fuller delivers a uniquely practical take on using the latest version of Microsoft Power BI to analyze, understand, report, and act on the data available to your organization. You’ll explore Power BI’s huge and robust feature set and learn how to ingest and model data, how to conduct orchestration and visualization, and how to use the DAX language to extract even more utility from Microsoft’s powerful program. <p>Starting from general principles appropriate for readers without experience in reporting or data analytics tools, the author walks you through every relevant Power BI feature you need to manipulate common, publicly available data sources, including Excel files and relational databases. The book includes working and tested sample code you can use to work through the helpful examples provided within. <p>A can’t-miss resource for business analysts and Excel power users reaching the limits of that program’s capabilities, <i>Beginning Power BI for Business Users</i> is the straightforward, hands-on guide to Power BI you’ve been waiting for.

US