|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNINA9910453848103321 |
|
|
Autore |
Alexander Michael |
|
|
Titolo |
Microsoft business intelligence tools for excel analysts / / by Michael Alexander, Jared Decker, Bernard Wehbe |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Hoboken, New Jersey : , : John Wiley & Sons, , 2014 |
|
©2014 |
|
|
|
|
|
|
|
|
|
ISBN |
|
1-118-82156-4 |
1-118-82155-6 |
|
|
|
|
|
|
|
|
Edizione |
[1st edition] |
|
|
|
|
|
Descrizione fisica |
|
1 online resource (385 p.) |
|
|
|
|
|
|
Collana |
|
Mr. Spreadsheet's bookshelf Microsoft business intelligence tools for Excel analysts |
|
|
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
Business intelligence |
Electronic books. |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
|
|
|
|
|
Nota di contenuto |
|
Title Page; Copyright Page; About the Authors; Contents at a Glance; 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 PivotCreating Relationships Among Your Power Pivot Tables; Creating 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; |
|
|
|
|