Autore	Alexander Michael
Edizione	[2nd ed.]
Pubbl/distr/stampa	Indianapolis, Ind., : John Wiley & Sons, 2013
Descrizione fisica	1 online resource (433 p.)
Disciplina	658.40380285554
Collana	Mr. Spreadsheet's Bookshelf
Soggetto topico	Dashboards (Management information systems) Statistics Business report writing
ISBN	9781118491416 (Electronic Book)
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	pt. I. Getting started with excel dashboards -- pt. II. Introducing charts into your dashboards -- pt. III. Advanced dashboarding concepts -- pt. IV. Pivot table driven dashboards -- pt. V. Working with the outside world.
Record Nr.	UNINA-9910812228803321

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

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

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