Microsoft Power BI For Dummies

Microsoft Power BI For Dummies

1. Aufl.

von: Jack A. Hyman

22,99 €

Verlag: Wiley
Format: EPUB
Veröffentl.: 05.01.2022
ISBN/EAN: 9781119824893
Sprache: englisch
Anzahl Seiten: 416

DRM-geschütztes eBook, Sie benötigen z.B. Adobe Digital Editions und eine Adobe ID zum Lesen.


<p><b>Reveal the insights behind your company&rsquo;s data with Microsoft Power BI&nbsp;</b></p> <p>Microsoft Power BI&nbsp;allows intuitive access to data that can power intelligent business decisions and insightful strategies.&nbsp;The question is, do you have the Power BI skills&nbsp;to make your organization&rsquo;s numbers spill their secrets?&nbsp;</p> <p>In&nbsp;<i>Microsoft Power BI For Dummies</i>, expert&nbsp;lecturer, consultant, and author Jack Hyman delivers a&nbsp;start-to-finish guide&nbsp;to applying the Power BI platform to your own firm&rsquo;s data. You&rsquo;ll discover how to start exploring your data sources, build data models, visualize your results, and create compelling reports&nbsp;that motivate decisive action.&nbsp;</p> <ul> <li>Tackle&nbsp;the basics of Microsoft Power BI and, when you&rsquo;re done with that, move on to advanced functions like accessing data with DAX and app integrations&nbsp;</li> <li>Guide your organization&rsquo;s direction and decisions with rock-solid conclusions&nbsp;based on real-world data&nbsp;</li> <li>Impress your&nbsp;bosses and confidently lead your direct reports with&nbsp;exciting&nbsp;insights drawn from&nbsp;Power BI&rsquo;s&nbsp;useful visualization tools&nbsp;</li> </ul> <p>It&rsquo;s one thing for&nbsp;your&nbsp;company to have data at&nbsp;its&nbsp;disposal. It&rsquo;s another thing entirely to know what to do with it.&nbsp;<i>Microsoft Power BI For Dummies</i>&nbsp;is the straightforward blueprint&nbsp;you need to apply one of the most powerful&nbsp;business intelligence tools&nbsp;on the market&nbsp;to&nbsp;your&nbsp;firm&rsquo;s existing data.&nbsp;&nbsp;</p>
<p><b>Introduction 1</b></p> <p>About This Book 2</p> <p>Foolish Assumptions 3</p> <p>Icons Used in This Book 4</p> <p>Beyond the Book 5</p> <p><b>Part 1: Put Your BI Thinking Caps On</b>&nbsp;<b>7</b></p> <p><b>Chapter 1: A Crash Course in Data Analytics Terms: Power BI Style&nbsp;9</b></p> <p>What Is Data, Really? 10</p> <p>Working with structured data 10</p> <p>Looking at unstructured data 11</p> <p>Adding semistructured data to the mix 11</p> <p>Looking Under the Power BI Hood 12</p> <p>Posing questions with Power Query 13</p> <p>Modeling with Power Pivot 14</p> <p>Visualizing with Power View 14</p> <p>Mapping data with Power Map 14</p> <p>Interpreting data with Power Q&amp;A 14</p> <p>Power BI Desktop 15</p> <p>Power BI Services 15</p> <p>Knowing Your Power BI Terminology 15</p> <p>Capacities 16</p> <p>Workspaces 16</p> <p>Reports 18</p> <p>Dashboards 19</p> <p>Navigation pane 20</p> <p>Business Intelligence (BI): The Definition 21</p> <p><b>Chapter 2: The Who, How, and What of Power BI</b>&nbsp;<b>23</b></p> <p>Highlighting the Who of Power BI 24</p> <p>Business analyst 24</p> <p>Data analyst 24</p> <p>Data engineer 25</p> <p>Data scientist 26</p> <p>Database administrator 26</p> <p>Understanding How Data Comes to Life 27</p> <p>Prepare 27</p> <p>Model 28</p> <p>Visualize 29</p> <p>Analyze 30</p> <p>Manage 30</p> <p>Examining the Various Types of Data Analytics 31</p> <p>Taking a Look at the Big Picture 32</p> <p><b>Chapter 3: Oh, the Choices: Power BI Versions</b>&nbsp;<b>33</b></p> <p>Why Power BI versus Excel? 33</p> <p>Power BI Products in a Nutshell 35</p> <p>Introducing the Power BI license options 35</p> <p>Looking at Desktop versus Services options 36</p> <p>Stacking Power BI Desktop against Power BI Free 38</p> <p>Examining the Details of the Licensing Options 38</p> <p>Seeing how content and collaboration drive licensing 39</p> <p>Starting with Power BI Desktop 40</p> <p>Adding a Power BI Free license 41</p> <p>Upgrading to a Power BI Pro license 42</p> <p>Going all in with a Power BI Premium license 43</p> <p>On the Road with Power BI Mobile 44</p> <p>Working with Power BI Report Server 45</p> <p>Linking Power BI and Azure 46</p> <p><b>Chapter 4: Power BI: The Highlights&nbsp;47</b></p> <p>Power BI Desktop: A Top-Down View 47</p> <p>Ingesting Data 49</p> <p>Files or databases? 49</p> <p>Building data models 52</p> <p>Analyzing data 53</p> <p>Creating and publishing items 54</p> <p>Services: Far and Wide 55</p> <p>Viewing and editing reports 56</p> <p>Working with dashboards 60</p> <p>Collaborating inside Power BI Services 61</p> <p>Refreshing data 62</p> <p><b>Part 2: It&rsquo;s Time to Have a Data Party</b>&nbsp;<b>65</b></p> <p><b>Chapter 5: Preparing Data Sources&nbsp;67</b></p> <p>Getting Data from the Source 67</p> <p>Managing Data Source Settings 72</p> <p>Working with Shared versus Local Datasets 73</p> <p>Storage Modes 76</p> <p>Dual mode 77</p> <p>Considering the Query 77</p> <p>Addressing and correcting performance 79</p> <p>Diagnosing queries 80</p> <p>Exporting Power BI Desktop Files and Leveraging XMLA 81</p> <p><b>Chapter 6: Getting Data from Dynamic Sources</b>&nbsp;<b>85</b></p> <p>Getting Data from Microsoft-Based File Systems 86</p> <p>Working with Relational Data Sources 87</p> <p>Importing data from a relational data source 89</p> <p>The good ol&rsquo; SQL query 91</p> <p>Importing Data from a Nonrelational Data Source 92</p> <p>Importing JSON File Data into Power BI 93</p> <p>Importing Data from Online Sources 95</p> <p>Creating Data Source Combos 97</p> <p>Connecting and importing data from Azure Analysis Services 98</p> <p>Accessing data with Connect Live 99</p> <p>Dealing with Modes for Dynamic Data 99</p> <p>Fixing Data Import Errors 100</p> <p>&ldquo;Time-out expired&rdquo; 100</p> <p>&ldquo;The data format is not valid&rdquo; 101</p> <p>&ldquo;Uh-oh &mdash; missing data files&rdquo; 101</p> <p>&ldquo;Transformation isn&rsquo;t always perfect&rdquo; 102</p> <p><b>Chapter 7: Cleansing, Transforming, and Loading Your Data</b>&nbsp;<b>103</b></p> <p>Engaging Your Detective Skills to Hunt Down Anomalies and Inconsistencies 104</p> <p>Checking those data structures and column properties 105</p> <p>Finding a little help from data statistics 106</p> <p>Stepping through the Data Lifecycle 107</p> <p>Resolving inconsistencies 108</p> <p>Evaluating and Transforming Column Data Types 111</p> <p>Finding and creating appropriate keys for joins 111</p> <p>Shaping your column data to meet Power Query requirements 113</p> <p>Combining queries 115</p> <p>Tweaking Power Query&rsquo;s M Code 121</p> <p>Configuring Queries for Data Loading 123</p> <p>Resolving Errors During Data Import 125</p> <p><b>Part 3: The Art and Science of Power Bi</b>&nbsp;<b>127</b></p> <p><b>Chapter 8: Crafting the Data Model</b>&nbsp;<b>129</b></p> <p>An Introduction to Data Models 129</p> <p>Working with data schemas 130</p> <p>Storing values with measures 134</p> <p>Working with dimensions and fact tables (yet again) 136</p> <p>Flattening hierarchies 137</p> <p>Dealing with Table and Column Properties 139</p> <p>Managing Cardinality and Direction 141</p> <p>Cardinality 142</p> <p>Cross-filter direction 142</p> <p>Data Granularity 144</p> <p><b>Chapter 9: Designing and Deploying Data Models&nbsp;145</b></p> <p>Creating a Data Model Masterpiece 145</p> <p>Working with Data view and Modeling view 146</p> <p>Importing queries 149</p> <p>Defining data types 150</p> <p>Handling formatting and data type properties 151</p> <p>Managing tables 153</p> <p>Adding and modifying data to imported, DirectQuery, and composite models 158</p> <p>Managing Relationships 159</p> <p>Creating automatic relationships 159</p> <p>Creating manual relationships 160</p> <p>Deleting relationships 160</p> <p>Classifying and codifying data in tables 161</p> <p>Arranging Data 162</p> <p>Sorting by and grouping by 162</p> <p>Hiding data 162</p> <p>Working with Extended Data Models 164</p> <p>Knowing the calculation types 164</p> <p>Working with column contents and joins 165</p> <p>Publishing Data Models 166</p> <p><b>Chapter 10: Perfecting the Data Model</b>&nbsp;<b>167</b></p> <p>Matching Queries with Capacity 168</p> <p>Deleting unnecessary columns and rows 168</p> <p>Swapping numeric columns with measures and variables 169</p> <p>Reducing cardinality 170</p> <p>Reducing queries 172</p> <p>Converting to a composite model 173</p> <p>Creating and managing aggregations 174</p> <p><b>Chapter 11: Visualizing Data</b>&nbsp;<b>183</b></p> <p>Looking at Report Fundamentals and Visualizations 183</p> <p>Creating visualizations 184</p> <p>Choosing a visualization 185</p> <p>Filtering data 185</p> <p>Working with Bar charts and Column charts 188</p> <p>Using basic Line charts and Area charts 193</p> <p>Combining Line charts and Bar charts 193</p> <p>Working with Ribbon charts 195</p> <p>Going with the flow with Waterfall charts 195</p> <p>Funneling with Funnel charts 197</p> <p>Scattering with Scatter charts 198</p> <p>Salivating with Pie charts and Donut charts 198</p> <p>Branching out with treemaps 199</p> <p>Mapping with maps 200</p> <p>Indicating with indicators 201</p> <p>Dealing with Table-Based and Complex Visualizations 205</p> <p>Slicing with slicers 205</p> <p>Tabling with table visualizations 205</p> <p>Combing through data with matrices 206</p> <p>Decomposing with decomposition trees 206</p> <p>Zooming in on key influencers 207</p> <p>Dabbling in Data Science 208</p> <p>Questions and Answers 210</p> <p><b>Chapter 12: Pumping Out Reports</b>&nbsp;<b>213</b></p> <p>Formatting and Configuring Report Visualizations 213</p> <p>Working with basic visualization configurations 215</p> <p>Applying conditional formatting 220</p> <p>Filtering and Sorting 221</p> <p>Configuring the Report Page 223</p> <p>Refreshing Data 224</p> <p>Working with reports 225</p> <p>Finding migrated data 226</p> <p>Exporting reports 228</p> <p>Perfecting reports for distribution 229</p> <p><b>Chapter 13: Diving into Dashboarding</b>&nbsp;<b>233</b></p> <p>Configuring Dashboards 234</p> <p>Creating a New Dashboard 234</p> <p>Enriching Your Dashboard with Content 236</p> <p>Pinning Reports 238</p> <p>Customizing with Themes 240</p> <p>Working with Dashboard Layouts 241</p> <p>Integrating Q&amp;A 243</p> <p>Setting Alerts 244</p> <p><b>Part 4: Oh, No! There&rsquo;s A Power Bi Programming Language!</b>&nbsp;<b>247</b></p> <p><b>Chapter 14: Digging Into DAX</b>&nbsp;<b>249</b></p> <p>Discovering DAX 249</p> <p>Peeking under the DAX hood 250</p> <p>Working with calculations 253</p> <p>Dealing with Data Types 258</p> <p>Operating with Operators 260</p> <p>Ordering operators 262</p> <p>Parentheses and order 262</p> <p>Making a Statement 263</p> <p>Ensuring Compatibility 263</p> <p><b>Chapter 15: Fun with DAX Functions</b>&nbsp;<b>265</b></p> <p>Working with DAX Parameters and Naming Conventions 265</p> <p>Prefixing parameter names 266</p> <p>Playing with parameters 267</p> <p>Using Formulas and Functions 267</p> <p>Aggregate functions 268</p> <p>Date-and-time functions 269</p> <p>Filter functions 271</p> <p>Financial functions 271</p> <p>Information functions 274</p> <p>Logical functions 276</p> <p>Mathematical and trigonometric functions 277</p> <p>Other functions 279</p> <p>Parent-child functions 279</p> <p>Relationship functions 280</p> <p>Statistical functions 280</p> <p>Table manipulation functions 283</p> <p>Text functions 285</p> <p>Time intelligence functions 286</p> <p><b>Chapter 16: Digging Deeper into DAX&nbsp;289</b></p> <p>Working with Variables 289</p> <p>Writing DAX Formulas 290</p> <p>Understanding DAX formulas in depth 290</p> <p>Extending formulas with measures 290</p> <p>Comparing measures and columns 296</p> <p>Syntax and context 296</p> <p>The syntax of an expression 297</p> <p>Best Practices for DAX Coding and Debugging in Power BI 297</p> <p>Using error functions properly 298</p> <p>Avoiding converting blanks to values 298</p> <p>Knowing the difference between operators and functions 300</p> <p>Getting specific 301</p> <p>Knowing what to COUNT 302</p> <p>Relationships matter 303</p> <p>Keeping up with the context 303</p> <p>Preferring measures over columns 303</p> <p>Seeing that structure matters 304</p> <p><b>Chapter 17: Sharing and the Power BI Workspace</b>&nbsp;<b>305</b></p> <p>Working Together in a Workspace 305</p> <p>Defining the types of workspaces 306</p> <p>Figuring out the nuts and bolts of workspaces 308</p> <p>Creating and Configuring Apps 313</p> <p>Slicing and Dicing Data 314</p> <p>Analyzing in Excel 316</p> <p>Benefiting from Quick Insights 316</p> <p>Using Usage Metric reports 317</p> <p>Working with paginated reports 318</p> <p>Troubleshooting the Use of Data Lineage 318</p> <p>Datasets, Dataflows, and Lineage 321</p> <p>Defending Your Data Turf 322</p> <p><b>Part 5: Enhancing Your Power Bi Experience&nbsp;325</b></p> <p><b>Chapter 18: Making Your Data Shine</b>&nbsp;<b>327</b></p> <p>Establishing a Schedule 327</p> <p>Rolling out the scheduled refresh 328</p> <p>Refreshing on-premises data 329</p> <p>Protecting the Data Fortress 331</p> <p>Configuring for group membership 331</p> <p>Making role assignments in Power BI Services 333</p> <p>Sharing the Data Love 334</p> <p>Refreshing Data in Baby Steps 335</p> <p>Creating RangeStart and RangeEnd parameters 335</p> <p>Filtering by RangeStart and RangeEnd 336</p> <p>Establishing the Incremental Refresh policy 338</p> <p>Treating Data Like Gold 339</p> <p>Configuring for Big Data 341</p> <p><b>Chapter 19: Extending the Power BI Experience</b>&nbsp;<b>343</b></p> <p>Linking Power Platform and Power BI 343</p> <p>Powering Up with Power Apps 344</p> <p>Creating Power App visuals with Power BI 346</p> <p>Acknowledging the limitations of Power Apps/Power BI integration 350</p> <p>Introducing the Power BI Mobile app 350</p> <p>Integrating OneDrive and Power BI 351</p> <p>Collaboration, SharePoint, and Power BI 354</p> <p>Differentiating between the classic and modern SharePoint experience 354</p> <p>Integrating Power BI into SharePoint 365 355</p> <p>Viewing Power BI reports in SharePoint 356</p> <p>Automating Workflows with Power BI 358</p> <p>Configuring prebuilt workflows for Power BI 359</p> <p>Using the Power Automate Visual with Power BI 362</p> <p>Unleashing Dynamics 365 for Data Analytics 364</p> <p><b>Part 6: The Part of Tens</b>&nbsp;<b>367</b></p> <p><b>Chapter 20: Ten Ways to Optimize DAX Using Power BI</b>&nbsp;<b>369</b></p> <p>Focusing on Logic 369</p> <p>Formatting Your Code 370</p> <p>Keeping the Structure Simple (KISS) 371</p> <p>Staying Clear of Certain Functions 372</p> <p>Making Your Measures Meaningful 373</p> <p>Filtering with a Purpose 374</p> <p>Transforming Data Purposefully 374</p> <p>Playing Hide-and-Seek with Your Columns 375</p> <p>Using All Those Fabulous Functions 376</p> <p>Rinse, Repeat, Recycle 376</p> <p><b>Chapter 21: Ten Ways to Make Compelling Reports Accessible and User-Friendly</b>&nbsp;<b>379</b></p> <p>Navigating the Keyboard 380</p> <p>Having a Screen Reader As Your Companion 380</p> <p>Standing Out with Contrast 380</p> <p>Recognizing Size Matters (with Focus Mode) 381</p> <p>Switching between Data Tables and Visualizations 382</p> <p>A Little Extra Text Goes a Long Way 383</p> <p>Setting Rank and Tab Order 384</p> <p>It&rsquo;s All About Titles and Labels 384</p> <p>Leaving Your Markers 386</p> <p>Keeping with a Theme 387</p> <p>Index 389</p>
<p><b>Jack Hyman</b> is Chief Executive Officer of HyerTek, an IT consulting firm specializing in Microsoft’s business platforms. He is Associate Professor in the Computer Information Sciences department at the University of the Cumberlands. He has written several books in the <i>For Dummies</i> series, as well as certification study guides for the Microsoft Azure technology.</p>
<p><b>Unlock your data’s potential with Power BI</b></p> <p>Does your organization have more data than you know what to do with but no way to make sense of it? Microsoft Power BI is a powerful and intuitive platform that transforms raw data into actionable insights without the need for extensive training or coding. In <i>Microsoft Power BI For Dummies</i>, you’ll discover how to explore your data sources, build data models, crunch the numbers, visualize your results, and craft compelling reports that motivate change. Start guiding your company with hard data today! <p><b>Inside… <ul><li>Connect to your data sources</li> <li>Organize and wrangle your data</li> <li>Build coherent data models</li> <li>Create attractive charts and graphs</li> <li>Draw powerful conclusions</li> <li>Master DAX, Power BI’s own language</li> <li>Create compelling reports</li> <li>Integrate Power BI with OneDrive and SharePoint</b></li></ul>

Diese Produkte könnten Sie auch interessieren:

Statistics for Microarrays
Statistics for Microarrays
von: Ernst Wit, John McClure
PDF ebook
84,99 €