Custom cover image
Microsoft Business Intelligence Tools for Excel Analysts / Michael Alexander
Resource type: Ressourcentyp: Buch (Online)Book (Online)Language: English Publisher: Somerset : John Wiley & Sons, Incorporated, 2014Copyright date: ©2014Description: Online-RessourceISBN:- 1306685125
- 9781306685122
- 9781118821558
- 005.54
- HF5548.4.M523
- HF5548.4 .M523
Contents:
Summary: 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.PPN: PPN: 811906965Package identifier: Produktsigel: ZDB-26-MYL | ZDB-38-EBR | ZDB-30-PAD | ZDB-30-PBE | ZDB-30-PQE
Title Page; About the Authors; Table of Contents; Introduction; Part I: Leveraging Excel for Business Intelligence; Chapter 1: Important Database Concepts; Chapter 2: PivotTable Fundamentals; Chapter 3: Introduction to Power Pivot; Chapter 4: Loading External Data into Power Pivot; Chapter 5: Creating Dashboards with Power View; Chapter 6: Adding Location Intelligence with Power Map; Chapter 7: Using the Power Query Add-In; Part II: Leveraging SQL for Business Intelligence; Chapter 8: Essential SQL Server Concepts; Chapter 9: Introduction to SQL; Chapter 10: Creating and Managing SQL Scripts
Chapter 11: Calling Views and Stored Procedures from ExcelChapter 12: Understanding Reporting Services; Chapter 13: Browsing Analysis Services OLAP Cubes with Excel; Chapter 14: Using the Data Mining Add-In for Microsoft Office; Part III: Delivering Business Intelligence with SharePoint and Excel Services; Chapter 15: Publishing Your BI Tools to SharePoint; Chapter 16: Leveraging PerformancePoint Services; Part IV: Appendixes; Appendix A: Understanding the Big Data Toolset; Appendix B: Considerations for Delivering Mobile BI; End User License Agreement
Contents at a Glance; About the Authors; Table of Contents; Introduction; Part I: Leveraging Excel for Business Intelligence; Chapter 1: Important Database Concepts; Traditional Limits of Excel and How Databases Help; Database Terminology; How Databases Are Designed; Chapter 2: PivotTable Fundamentals; Introducing the PivotTable; Customizing Your PivotTable; Understanding Slicers; Creating a Timeline Slicer; Understanding the Internal Data Model; Chapter 3: Introduction to Power Pivot; Understanding the Power Pivot Internal Data Model; Linking Excel Tables to Power Pivot
Creating Relationships Among Your Power Pivot TablesCreating a PivotTable from Power Pivot Data; Enhancing Power Pivot Data with Calculated Columns; Utilizing DAX to Create Calculated Columns; Understanding Calculated Fields; Chapter 4: Loading External Data into Power Pivot; Loading Data from Relational Databases; Loading Data from Flat Files; Loading Data from Other Data Sources; Refreshing and Managing External Data Connections; Chapter 5: Creating Dashboards with Power View; Activating the Power View Add-In; Creating a Power View Dashboard
Chapter 6: Adding Location Intelligence with Power MapInstalling and Activating the Power Map Add-In; Loading Data into Power Map; Managing and Modifying Map Visualizations; Adding Custom Components; Customizing and Managing Power Map Tours; Chapter 7: Using the Power Query Add-In; Installing and Activating the Power Query Add-In; Power Query Basics; Understanding Column and Table Actions; Power Query Connection Types; Creating and Using Power Query Functions; Part II: Leveraging SQL for Business Intelligence; Chapter 8: Essential SQL Server Concepts; SQL Server Components
Connecting to a Database ServiceSQL Server Security; Working with Databases; Working with Tables and Views; Data Importing and Exporting; Chapter 9: Introduction to SQL; SQL Basics; Advanced SQL Concepts; Chapter 10: Creating and Managing SQL Scripts; Design Concepts; Working with SQL Scripts; Indexing and Performance Considerations; SQL Solutions to Common Analytics Problems; Chapter 11: Calling Views and Stored Procedures from Excel; Importing Data from SQL Server; Passing Your Own SQL Statements to External Databases; Creating a Data Model with Multiple SQL Data Objects
Calling Stored Procedures Directly from Power PivotChapter 12: Understanding Reporting Services; Reporting Services Overview; Developing a Reporting Services Report; Deploying Reports; Managing Subscriptions; Chapter 13: Browsing Analysis Services OLAP Cubes with Excel; What Is an OLAP Database and What Can It Do?; Understanding OLAP Cubes; Connecting to an OLAP Data Source; Understanding the Limitations of OLAP PivotTables; Creating Offline Cubes; Using Cube Functions; Adding Calculations to Your OLAP PivotTables; Chapter 14: Using the Data Mining Add-In for Microsoft Office
Installing and Activating the Data Mining Add-In
No physical items for this record