{"product_id":"beginning-power-bi-for-business-users-isbn-9781394190294","title":"Beginning Power BI for Business Users","description":"\u003cp\u003e\u003cb\u003eDiscover the utility of your organization’s data with Microsoft Power BI\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIn \u003ci\u003eBeginning Power BI for Business Users: Learning to Turn Data into Insights\u003c\/i\u003e, accomplished data professional and business intelligence expert Paul Fuller delivers an intuitive and accessible handbook for professionals seeking to use Microsoft’s Power BI to access, analyze, understand, report, and act on the data available to their organizations. In the book, you’ll discover Power BI’s robust feature set, learn to ingest and model data, visualize and report on that data, and even use the DAX scripting language to unlock still more utility from Microsoft’s popular program.\u003c\/p\u003e \u003cp\u003eBeginning with general principles geared to readers with no or little experience with reporting or data analytics tools, the author walks you through how to manipulate common, publicly available data sources—including Excel files and relational databases. You’ll also learn to:\u003c\/p\u003e \u003cul\u003e \u003cli\u003eUse the included and tested sample code to work through the helpful examples included by the author\u003c\/li\u003e \u003cli\u003eConduct data orchestration and visualization to better understand and gain insights from your data\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eAn essential resource for business analysts and Excel power users reaching the limits of that program’s capabilities, \u003ci\u003eBeginning Power BI for Business Users \u003c\/i\u003ewill also benefit data analysts who seek to prepare reports for their organizations using Microsoft’s flexible and intuitive software.\u003c\/p\u003e \u003cp\u003eIntroduction xxi\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 1: Introduction\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Introducing Power BI 3\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is Power BI? 3\u003c\/p\u003e \u003cp\u003eWhy Would I Use Power BI? 7\u003c\/p\u003e \u003cp\u003eBut Why? 7\u003c\/p\u003e \u003cp\u003eDisconnected Data 8\u003c\/p\u003e \u003cp\u003eFixed Formulas 9\u003c\/p\u003e \u003cp\u003eTen Reasons Why Power BI Transforms Your Work 10\u003c\/p\u003e \u003cp\u003eWill I Still Use Excel? 12\u003c\/p\u003e \u003cp\u003eHow Much Is this Going to Cost? 14\u003c\/p\u003e \u003cp\u003eWhere Do We Go from Here? 16\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: From Data to Insight 17\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThree Guiding Principles 17\u003c\/p\u003e \u003cp\u003eDistinguishing Data, Information, and Knowledge 18\u003c\/p\u003e \u003cp\u003eFollow a Consistent, Proven Method 21\u003c\/p\u003e \u003cp\u003eData Sources 21\u003c\/p\u003e \u003cp\u003eFiles 21\u003c\/p\u003e \u003cp\u003eDatabases 22\u003c\/p\u003e \u003cp\u003eOnline Services 23\u003c\/p\u003e \u003cp\u003ePlan Ahead 23\u003c\/p\u003e \u003cp\u003eImport Data 25\u003c\/p\u003e \u003cp\u003ePrepare Data 26\u003c\/p\u003e \u003cp\u003eModel Data 28\u003c\/p\u003e \u003cp\u003eReport Data 29\u003c\/p\u003e \u003cp\u003eAnalyze Data 30\u003c\/p\u003e \u003cp\u003eUse Visualizations Well 31\u003c\/p\u003e \u003cp\u003eThree Ways to Ruin Visual Analytics 32\u003c\/p\u003e \u003cp\u003eUse as Many Cool Gadgets as You Can Find 32\u003c\/p\u003e \u003cp\u003eOverwhelm the User with Tons of Detail 32\u003c\/p\u003e \u003cp\u003ePick the Wrong Tool for the Job 34\u003c\/p\u003e \u003cp\u003eFour Ways to Improve Visual Analytics 35\u003c\/p\u003e \u003cp\u003eReduce the Nondata Pixels 35\u003c\/p\u003e \u003cp\u003eEnhance the Data Pixels 36\u003c\/p\u003e \u003cp\u003eConclusion 38\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 2: Power BI Guided Walk-Throughs\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Let’s Take a Flyover! 41\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGetting Connected 41\u003c\/p\u003e \u003cp\u003eA Quick Tour of the Power BI Service 42\u003c\/p\u003e \u003cp\u003eFrequented Hotspots of Power BI 42\u003c\/p\u003e \u003cp\u003eAdding Sample Content 43\u003c\/p\u003e \u003cp\u003eUnderstanding the Power BI Service Interface 44\u003c\/p\u003e \u003cp\u003eHighlighting 47\u003c\/p\u003e \u003cp\u003eSlicers 50\u003c\/p\u003e \u003cp\u003eFilters 52\u003c\/p\u003e \u003cp\u003eDrill-Down 54\u003c\/p\u003e \u003cp\u003eDashboards 55\u003c\/p\u003e \u003cp\u003eDrill-Through 58\u003c\/p\u003e \u003cp\u003eVisibility 59\u003c\/p\u003e \u003cp\u003eShow as Table 59\u003c\/p\u003e \u003cp\u003eSorting Visuals 60\u003c\/p\u003e \u003cp\u003eFiltering— One More Time 61\u003c\/p\u003e \u003cp\u003ePower BI Building Blocks 61\u003c\/p\u003e \u003cp\u003eFlyover of Power BI Desktop 62\u003c\/p\u003e \u003cp\u003eNavigating Power BI Desktop 63\u003c\/p\u003e \u003cp\u003eConclusion 65\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Building Your First Report 67\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eConnecting to a Data Source 67\u003c\/p\u003e \u003cp\u003eExamining the Data Model 68\u003c\/p\u003e \u003cp\u003eExploring the Data 75\u003c\/p\u003e \u003cp\u003eBuilding Your Report 85\u003c\/p\u003e \u003cp\u003eDesigning for Mobile Devices 101\u003c\/p\u003e \u003cp\u003eConclusion 102\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5: Preparing Data 103\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGDP Data 103\u003c\/p\u003e \u003cp\u003ePower Query Overview 105\u003c\/p\u003e \u003cp\u003eData Arrangement Steps 106\u003c\/p\u003e \u003cp\u003eRename Query 106\u003c\/p\u003e \u003cp\u003eRemove Rows 106\u003c\/p\u003e \u003cp\u003eRemove Columns 107\u003c\/p\u003e \u003cp\u003eApplied Steps So Far 107\u003c\/p\u003e \u003cp\u003ePromote Headers 108\u003c\/p\u003e \u003cp\u003eRenaming Columns 108\u003c\/p\u003e \u003cp\u003eEmpty Values 109\u003c\/p\u003e \u003cp\u003eHandling Aggregated Data 109\u003c\/p\u003e \u003cp\u003eFiltering Rows 110\u003c\/p\u003e \u003cp\u003eUnpivoting Data 110\u003c\/p\u003e \u003cp\u003eChange Column Data Type 112\u003c\/p\u003e \u003cp\u003eChanging Values in Columns 112\u003c\/p\u003e \u003cp\u003eDuplicating Columns 113\u003c\/p\u003e \u003cp\u003eMultiply by a Million 113\u003c\/p\u003e \u003cp\u003eRemoving Implicit Measures 114\u003c\/p\u003e \u003cp\u003eColumn Formatting 115\u003c\/p\u003e \u003cp\u003eCalculated Columns 115\u003c\/p\u003e \u003cp\u003eAdd Previous Year Column 116\u003c\/p\u003e \u003cp\u003eHiding Columns 117\u003c\/p\u003e \u003cp\u003eLOOKUPVALUE Function 118\u003c\/p\u003e \u003cp\u003eDIVIDE Function 119\u003c\/p\u003e \u003cp\u003eVisualize Our GDP Data 120\u003c\/p\u003e \u003cp\u003eWhere Are We? 121\u003c\/p\u003e \u003cp\u003eCleaning Messy Data 122\u003c\/p\u003e \u003cp\u003eHandle Many-to-Many Relationships 123\u003c\/p\u003e \u003cp\u003eDuplicate a Query 125\u003c\/p\u003e \u003cp\u003eSplit Column 125\u003c\/p\u003e \u003cp\u003eFormat Column 127\u003c\/p\u003e \u003cp\u003eRemove Duplicates 127\u003c\/p\u003e \u003cp\u003eIndex Column 128\u003c\/p\u003e \u003cp\u003eMerge Data 128\u003c\/p\u003e \u003cp\u003eApplying Changes 129\u003c\/p\u003e \u003cp\u003eFinding the Power Query Button 131\u003c\/p\u003e \u003cp\u003eSimple Cleanup Tasks 131\u003c\/p\u003e \u003cp\u003eReplacing Values 132\u003c\/p\u003e \u003cp\u003eCustom Columns 133\u003c\/p\u003e \u003cp\u003eMore Cleanup 135\u003c\/p\u003e \u003cp\u003eCleaning Date Columns 136\u003c\/p\u003e \u003cp\u003eConclusion 138\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6: Modeling Data 139\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDimensional Modeling 140\u003c\/p\u003e \u003cp\u003eWhy Does This Matter? 143\u003c\/p\u003e \u003cp\u003eMakes Sense to You 143\u003c\/p\u003e \u003cp\u003eCross-Business Process Analysis 144\u003c\/p\u003e \u003cp\u003eFlexible Grouping 144\u003c\/p\u003e \u003cp\u003ePerformance for Power BI 144\u003c\/p\u003e \u003cp\u003eFacts 145\u003c\/p\u003e \u003cp\u003eTypes of Facts 146\u003c\/p\u003e \u003cp\u003eGranularity 146\u003c\/p\u003e \u003cp\u003eRelationships Between Facts (Never!) 147\u003c\/p\u003e \u003cp\u003eDimensions 148\u003c\/p\u003e \u003cp\u003eUsing Integer Keys for Relationships 149\u003c\/p\u003e \u003cp\u003eHierarchies in Dimensions 149\u003c\/p\u003e \u003cp\u003eDate Dimensions 150\u003c\/p\u003e \u003cp\u003ePower Query and Data Modeling 151\u003c\/p\u003e \u003cp\u003eHow to Build a Date Dimension 152\u003c\/p\u003e \u003cp\u003eImport a Date Table from SQL Server Database 153\u003c\/p\u003e \u003cp\u003eCreate a Date Dimension with Power Query 155\u003c\/p\u003e \u003cp\u003eCreate a Date Dimension with DAX 158\u003c\/p\u003e \u003cp\u003eSort by Column 161\u003c\/p\u003e \u003cp\u003eMark It as a Date Table 161\u003c\/p\u003e \u003cp\u003eHow to Arrange into a Star- Schema 161\u003c\/p\u003e \u003cp\u003eCreate a State Dimension 162\u003c\/p\u003e \u003cp\u003eCreate a GDP Category Dimension 163\u003c\/p\u003e \u003cp\u003eAdd a New StateID Foreign Key to Our Fact Table 163\u003c\/p\u003e \u003cp\u003eUnpivot the GDP Year Values 164\u003c\/p\u003e \u003cp\u003ePutting It All into Action 166\u003c\/p\u003e \u003cp\u003eConclusion 167\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 3: Going Deeper Into Power BI\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7: Relationships and Filtering 171\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFiltering Through Relationships 171\u003c\/p\u003e \u003cp\u003eVisuals Interact Independently 174\u003c\/p\u003e \u003cp\u003eThe Direction of Relationships 176\u003c\/p\u003e \u003cp\u003eBidirectional Filtering 179\u003c\/p\u003e \u003cp\u003eReport Filter Types 181\u003c\/p\u003e \u003cp\u003eVisual Filters 181\u003c\/p\u003e \u003cp\u003eDate Filtering 182\u003c\/p\u003e \u003cp\u003eNumeric Filtering 182\u003c\/p\u003e \u003cp\u003eText Filtering 183\u003c\/p\u003e \u003cp\u003ePage and Report Filters 185\u003c\/p\u003e \u003cp\u003eControlling the Use of Filters 185\u003c\/p\u003e \u003cp\u003eConclusion 186\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8: Enhancing Your Report 187\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eConfiguring Drill- Down 187\u003c\/p\u003e \u003cp\u003eConfiguring Drill- Through 190\u003c\/p\u003e \u003cp\u003eButtons 193\u003c\/p\u003e \u003cp\u003eBookmarks 195\u003c\/p\u003e \u003cp\u003ePersonal Bookmarks vs. Report Bookmarks 199\u003c\/p\u003e \u003cp\u003eSelections and Visibility 201\u003c\/p\u003e \u003cp\u003eConclusion 205\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9: Refreshing, Sharing, and Collaborating 207\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eRefreshing Data 207\u003c\/p\u003e \u003cp\u003eConfiguring Data Source Credentials 210\u003c\/p\u003e \u003cp\u003ePower BI Data Gateway 213\u003c\/p\u003e \u003cp\u003eScheduling Refresh 214\u003c\/p\u003e \u003cp\u003eDataset Modes 216\u003c\/p\u003e \u003cp\u003eSharing and Collaborating 216\u003c\/p\u003e \u003cp\u003eWorkspaces 216\u003c\/p\u003e \u003cp\u003eCreating Workspaces 217\u003c\/p\u003e \u003cp\u003ePublishing 217\u003c\/p\u003e \u003cp\u003eSecurity and Permission Levels 219\u003c\/p\u003e \u003cp\u003ePower BI Apps 223\u003c\/p\u003e \u003cp\u003eSharing 230\u003c\/p\u003e \u003cp\u003eSummary 232\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10: Introducing Dax 233\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSetup 233\u003c\/p\u003e \u003cp\u003eCalculated Columns 235\u003c\/p\u003e \u003cp\u003eHow to Create a Calculated Column 236\u003c\/p\u003e \u003cp\u003eDAX Measures 240\u003c\/p\u003e \u003cp\u003eCOUNTROWS and DISTINCTCOUNT 244\u003c\/p\u003e \u003cp\u003eFilter Context 246\u003c\/p\u003e \u003cp\u003eCALCULATE Function 249\u003c\/p\u003e \u003cp\u003eConclusion 250\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11: Conclusion 251\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhere Does My Organization Begin? 251\u003c\/p\u003e \u003cp\u003eDelivery Strategy 251\u003c\/p\u003e \u003cp\u003eBusiness-Led Self-Service 252\u003c\/p\u003e \u003cp\u003eIT-Managed Self-Service 253\u003c\/p\u003e \u003cp\u003eCorporate BI 253\u003c\/p\u003e \u003cp\u003eWhich Delivery Strategy Is Right for My Organization? 253\u003c\/p\u003e \u003cp\u003eWhere Do I Go from Here? 254\u003c\/p\u003e \u003cp\u003eTop Gurus 254\u003c\/p\u003e \u003cp\u003eAdvice 254\u003c\/p\u003e \u003cp\u003eIndex 257\u003c\/p\u003e  \u003cp\u003e\u003cb\u003ePAUL D. FULLER\u003c\/b\u003e 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.   \u003c\/p\u003e\u003cp\u003e\u003cb\u003eUnlock the astonishing capabilities of Microsoft Power BI for your business\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eIn \u003ci\u003eBeginning Power BI for Business Users: Learning to Turn Data into Insights\u003c\/i\u003e, 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. \u003c\/p\u003e\u003cp\u003eStarting 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. \u003c\/p\u003e\u003cp\u003eA can’t-miss resource for business analysts and Excel power users reaching the limits of that program’s capabilities, \u003ci\u003eBeginning Power BI for Business Users\u003c\/i\u003e is the straightforward, hands-on guide to Power BI you’ve been waiting for.\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47988799111397,"sku":"NP9781394190294","price":55.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781394190294.jpg?v=1761781633","url":"https:\/\/k12savings.com\/products\/beginning-power-bi-for-business-users-isbn-9781394190294","provider":"K12savings","version":"1.0","type":"link"}