Format:
1 Online-Ressource (xv, 348 Seiten)
,
Illustrationen, Karten
ISBN:
9781484225776
Content:
Contents at a Glance -- Contents -- About the Author -- About the Technical Reviewer -- Acknowledgments -- Introduction -- Part I: Building Models in Power Pivot -- Chapter 1: Introducing Power Pivot -- Why Use Power Pivot? -- The xVelocity In-memory Analytics Engine -- Enabling Power Pivot for Excel -- Exploring the Data Model Manager Interface -- Summary -- Chapter 2: Importing Data into Power Pivot -- Importing Data from Relational Databases -- Importing Data from Text Files -- Importing Data from a Data Feed -- Importing Data from an OLAP Cube -- Reusing Existing Connections to Update the Model -- Summary -- Chapter 3: Data Munging with Power Query -- Discovering and Importing Data -- Transforming, Cleansing, and Filtering Data -- Merging and Shaping Data -- Grouping and Aggregating Data -- Inserting Calculated Columns -- Summary -- Chapter 4: Creating the Data Model -- What Is a Data Model? -- Creating Table Relations -- Creating a Star Schema -- Understanding When to Denormalize the Data -- Creating Linked Tables -- Creating Hierarchies -- Making a User-Friendly Model -- Summary -- Chapter 5: Creating Calculations with DAX -- What Is DAX? -- Implementing DAX Operators -- Working with Text Functions -- Using DAX Date and Time Functions -- Using Informational and Logical Functions -- Getting Data from Related Tables -- Using Math, Trig, and Statistical Functions -- Tips for Creating Calculations in Power Pivot -- Summary -- Chapter 6: Creating Measures with DAX -- Measures vs. Attributes -- Creating Common Aggregates -- Mastering Data Context -- Altering the Query Context -- Using Filter Functions -- Creating KPIs -- Summary -- Chapter 7: Incorporating Time Intelligence -- Date-Based Analysis -- Creating a Date Table -- Time Period-Based Evaluations -- Shifting the Date Context -- Using Single Date Functions -- Creating Semi-Additive Measures
Content:
Summary -- Chapter 8: Data Analysis with Pivot Tables and Charts -- Pivot Table Fundamentals -- Slicing the Data -- Adding Visualizations to a Pivot Table -- Working with Pivot Charts -- Using Multiple Charts and Tables -- Using Cube Functions -- Summary -- Part II: Building Interactive Reports and Dashboards with Power BI Desktop -- Chapter 9: Introducing Power BI Desktop -- Setting Up the Power BI Environment -- Getting, Cleaning, and Shaping Data -- Creating Table Relationships -- Adding Calculations and Measures -- Incorporating Time-based Analysis -- Summary -- Chapter 10: Creating Reports with Power BI Desktop -- Creating Tables and Matrices -- Constructing Bar, Column, and Pie Charts -- Building Line and Scatter Charts -- Creating Map-Based Visualizations -- Linking Visualizations in Power BI -- Drilling Through Visualizations -- Summary -- Chapter 11: Publishing Reports and Creating Dashboards in the Power BI Portal -- Creating a User-Friendly Model -- Publishing Power BI Desktop Files to the Power BI Service -- Adding Tiles to a Dashboard -- Sharing Dashboards -- Refreshing Data in Published Reports -- Summary -- Chapter 12: Creating a Complete Solution -- Use Case 1: Reseller Sales Analysis -- Load the Data -- Create the Model -- Create Calculated Columns -- Create Measures -- Create the Dashboard -- Use Case 2: Sales Quota Analysis -- Load the Data -- Create the Model -- Create Measures -- Create the Report -- Use Case 3: Sensor Analysis -- Load the Data -- Summary -- Chapter 13: Advanced Topics in Power Query -- Writing Queries with M -- Creating and Using Parameters -- Creating and Using Functions -- Summary -- Chapter 14: Advanced Topics in Power BI -- Using Custom Visuals -- Implementing Geo-spatial Analysis -- Implementing Row-Based Security -- Creating Templates and Content Packs -- Summary -- Index
Additional Edition:
9781484225769
Additional Edition:
Erscheint auch als Druck-Ausgabe Beginning Power BI : A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop Berkeley, CA : Apress,c2017 9781484225769
Language:
English
Subjects:
Computer Science
Keywords:
Excel 2016
;
Business Intelligence
URL:
Volltext
(lizenzpflichtig)
