Microsoft business intelligence tools for excel analysts / / by Michael Alexander, Jared Decker, Bernard Wehbe |
Autore | Alexander Michael |
Edizione | [1st edition] |
Pubbl/distr/stampa | Hoboken, New Jersey : , : John Wiley & Sons, , 2014 |
Descrizione fisica | 1 online resource (385 p.) |
Disciplina | 005.54 |
Collana | Mr. Spreadsheet's bookshelf Microsoft business intelligence tools for Excel analysts |
Soggetto topico | Business intelligence |
Soggetto genere / forma | Electronic books. |
ISBN |
1-118-82156-4
1-118-82155-6 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
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; 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 |
Record Nr. | UNINA-9910453848103321 |
Alexander Michael | ||
Hoboken, New Jersey : , : John Wiley & Sons, , 2014 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Microsoft business intelligence tools for excel analysts / / by Michael Alexander, Jared Decker, Bernard Wehbe |
Autore | Alexander Michael |
Edizione | [1st edition] |
Pubbl/distr/stampa | Hoboken, New Jersey : , : John Wiley & Sons, , 2014 |
Descrizione fisica | 1 online resource (385 p.) |
Disciplina | 005.54 |
Collana | Mr. Spreadsheet's bookshelf Microsoft business intelligence tools for Excel analysts |
Soggetto topico | Business intelligence |
ISBN |
1-118-82156-4
1-118-82155-6 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
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; 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 |
Record Nr. | UNINA-9910790919703321 |
Alexander Michael | ||
Hoboken, New Jersey : , : John Wiley & Sons, , 2014 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Microsoft business intelligence tools for excel analysts / / by Michael Alexander, Jared Decker, Bernard Wehbe |
Autore | Alexander Michael |
Edizione | [1st edition] |
Pubbl/distr/stampa | Hoboken, New Jersey : , : John Wiley & Sons, , 2014 |
Descrizione fisica | 1 online resource (385 p.) |
Disciplina | 005.54 |
Collana | Mr. Spreadsheet's bookshelf Microsoft business intelligence tools for Excel analysts |
Soggetto topico | Business intelligence |
ISBN |
1-118-82156-4
1-118-82155-6 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
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; 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 |
Record Nr. | UNINA-9910819711403321 |
Alexander Michael | ||
Hoboken, New Jersey : , : John Wiley & Sons, , 2014 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|