Microsoft Business Intelligence Tools for Excel Analysts

Intro -- Title Page -- Copyright Page -- Table of Contents -- Introduction -- Chapter 1: Important Database Concepts -- Traditional Limits of Excel and How Databases Help -- Scalability -- Transparency of analytical processes -- Separation of data and presentation -- Database Terminology -- Databases -- Tables -- Records, fields, and values -- Queries -- How Databases Are Designed -- Step 1: The overall design - from concept to reality -- Step 2: Report design -- Step 3: Data design -- Step 4: Table design -- Chapter 2: PivotTable Fundamentals -- Introducing the PivotTable -- Anatomy of a PivotTable -- Creating the basic PivotTable -- Customizing Your PivotTable -- Changing the PivotTable layout -- Renaming the fields -- Formatting numbers -- Changing summary calculations -- Suppressing subtotals -- Hiding and showing data items -- Hiding or showing items without data -- Sorting your PivotTable -- Understanding Slicers -- Creating a standard slicer -- Formatting slicers -- Controlling multiple PivotTables with one slicer -- Creating a Timeline Slicer -- Understanding the Internal Data Model -- Building out your first Data Model -- Using your Data Model in a PivotTable -- Chapter 3: Introduction to Power Pivot -- Understanding the Power Pivot Internal Data Model -- Linking Excel Tables to Power Pivot -- Preparing your Excel tables -- Adding your Excel tables to the Data Model -- Creating Relationships Among Your Power Pivot Tables -- Creating a PivotTable from Power Pivot Data -- Enhancing Power Pivot Data with Calculated Columns -- Creating a calculated column -- Formatting your calculated columns -- Referencing calculated columns in other calculations -- Hiding calculated columns from end users -- Utilizing DAX to Create Calculated Columns -- Identifying DAX functions that are safe for calculated columns -- Building DAX-driven calculated columns.