Excel Power Pivot & Power Query For Dummies. Michael Alexander
Читать онлайн книгу.
href="#ub6f3d2da-6652-5b99-b46b-fd21e3d2092f">Chapter 5: Working Directly with the Internal Data Model Directly Feeding the Internal Data Model Managing Relationships in the Internal Data Model Managing Queries and Connections Creating a New Pivot Table Using the Internal Data Model Filling the Internal Data Model with Multiple External Data Tables Chapter 6: Adding Formulas to Power Pivot Enhancing Power Pivot Data with Calculated Columns Utilizing DAX to Create Calculated Columns Understanding Calculated Measures Free Your Data with Cube Functions Chapter 7: Diving into DAX DAX Language Fundamentals Understanding Filter Context
6 Part 2: Wrangling Data with Power Query Chapter 8: Introducing Power Query Power Query Basics Understanding Column-Level Actions Understanding Table Actions Chapter 9: Power Query Connection Types Importing Data from Files Importing Data from Database Systems Managing Data Source Settings Data Profiling with Power Query Chapter 10: Transforming Your Way to Better Data Completing Common Transformation Tasks Creating Custom Columns Grouping and Aggregating Data Working with Custom Data Types Chapter 11: Making Queries Work Together Reusing Query Steps Understanding the Append Feature Understanding the Merge Feature Understanding Fuzzy Match Chapter 12: Extending Power Query with Custom Functions Creating and Using a Basic Custom Function Creating a Function to Merge Data from Multiple Excel Files Creating Parameter Queries
7 Part 3: The Part of Tens Chapter 13: Ten Ways to Improve Power Pivot Performance Limit the Number of Rows and Columns in Your Data Model Tables Use Views Instead of Tables Avoid Multi-Level Relationships Let the Back-End Database Servers Do the Crunching Beware of Columns with Many Unique Values Limit the Number of Slicers in a Report Create Slicers Only on Dimension Fields Disable the Cross-Filter Behavior for Certain Slicers Use Calculated Measures Instead of Calculated Columns Upgrade to 64-Bit Excel Chapter 14: Ten Tips for Working with Power Query Getting Quick Information from the Queries & Connections Pane Organizing Queries in Groups Selecting Columns in Queries Faster Renaming Query Steps Quickly Creating Reference Tables Viewing Query Dependencies Setting a Default Load Behavior Preventing Automatic Data Type Changes Disabling Privacy Settings to Improve Performance Disabling Relationship Detection
8 Index
List of Tables
1 Chapter 2TABLE 2-1 Limitations of the Internal Data Model
2 Chapter 7TABLE 7-1 DAX Operators
3 Chapter 8TABLE 8-1 Column-Level ActionsTABLE 8-2 Table-Level Actions
4 Chapter 10TABLE 10-1 Common Conversion FunctionsTABLE 10-2 Useful Transformation Functions
List of Illustrations
1 Chapter 1FIGURE 1-1: Data is stored in an Excel spreadsheet using a