Applied microsoft business intelligence / / Patrick LeBlanc [and three others] |
Autore | Leblanc Patrick |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, Indiana : , : Wiley, , 2015 |
Descrizione fisica | 1 online resource (432 p.) |
Disciplina | 658.47028 |
Soggetto topico |
Business intelligence - Computer programs
Business planning |
ISBN |
1-118-96178-1
1-118-96179-X |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Title Page; Copyright; Contents; Introduction; Part I Overview of the Microsoft Business Intelligence Toolset; Chapter 1 Which Analysis and Reporting Tools Do You Need?; Selecting a SQL Server Database Engine; Building a Data Warehouse; Selecting an RDBMS; Selecting SQL Server Analysis Services; Working with SQL Server Reporting Services; Understanding Operational Reports; Understanding Ad Hoc Reporting; Working with SharePoint; Working with Performance Point; Using Excel for Business Intelligence; What Is Power Query?; What Is Power Pivot?; What Is Power View?; Power Map
Which Development Tools Do You Need?Using SQL Server Data Tools; Using SQL Management Studio; Using Dashboard Designer; Using Report Builder; Summary; Chapter 2 Designing an Effective Business Intelligence Architecture; Identifying the Audience and Goal of the Business Intelligence Solution; Who's the Audience?; What Is the Goal(s)?; What Are the Data Sources?; Using Internal Data Sources; Using External Data Sources; Using a Data Warehouse (or Not); Implementing and Enforcing Data Governance; Planning an Analytical Model; Planning the Business Intelligence Delivery Solution Considering Performance Considering Availability; Summary; Chapter 3 Selecting the Data Architecture that Fits Your Organization; Why Is Data Architecture Selection Important?; Challenges; Benefits; How Do You Pick the Right Data Architecture?; Understanding Architecture Options; Understanding Research Selection Factors; Interviewing Key Stakeholders; Completing the Selection Form; Finalizing and Approving the Architecture; Summary; Part II Business Intelligence for Analysis; Chapter 4 Searching and Combining Data with Power Query; Downloading and Installing Power Query; Importing Data Importing from a Database Importing from the Web; Importing from a File; Transforming Data; Combining Data from Multiple Sources; Splitting Data; Aggregating Data; Introducing M Programming; A Glance at the M Language; Adding and Removing Columns Using M; Summary; Chapter 5 Choosing the Right Business Intelligence Semantic Model; Understanding the Business Intelligence Semantic Model Architecture; Understanding the Data Access Layer; Using Power Pivot; Using the Multidimensional Model; Using the Tabular Model; Implementing Query Languages and the Business Logic Layer Data Analytics Expressions (DAX)Multidimensional Expressions (MDX); Direct Query and ROLAP; Data Model Layer; Comparing the Different Types of Models; Which Model Fits Your Organization?; Departmental; Team; Organizational; Summary; Chapter 6 Discovering and Analyzing Data with Power Pivot; Understanding Hardware and Software Requirements; Enabling Power Pivot; Designing an Optimal Power Pivot Model; Importing Only What You Need; Understanding Why Data Types Matter; Working with Columns or DAX Calculated Measures; Optimizing the Power Pivot Model for Reporting Understanding Power Pivot Model Basics |
Record Nr. | UNINA-9910131265603321 |
Leblanc Patrick
![]() |
||
Indianapolis, Indiana : , : Wiley, , 2015 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Applied microsoft business intelligence / / Patrick LeBlanc [and three others] |
Autore | Leblanc Patrick |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, Indiana : , : Wiley, , 2015 |
Descrizione fisica | 1 online resource (432 p.) |
Disciplina | 658.47028 |
Soggetto topico |
Business intelligence - Computer programs
Business planning |
ISBN |
1-118-96178-1
1-118-96179-X |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Title Page; Copyright; Contents; Introduction; Part I Overview of the Microsoft Business Intelligence Toolset; Chapter 1 Which Analysis and Reporting Tools Do You Need?; Selecting a SQL Server Database Engine; Building a Data Warehouse; Selecting an RDBMS; Selecting SQL Server Analysis Services; Working with SQL Server Reporting Services; Understanding Operational Reports; Understanding Ad Hoc Reporting; Working with SharePoint; Working with Performance Point; Using Excel for Business Intelligence; What Is Power Query?; What Is Power Pivot?; What Is Power View?; Power Map
Which Development Tools Do You Need?Using SQL Server Data Tools; Using SQL Management Studio; Using Dashboard Designer; Using Report Builder; Summary; Chapter 2 Designing an Effective Business Intelligence Architecture; Identifying the Audience and Goal of the Business Intelligence Solution; Who's the Audience?; What Is the Goal(s)?; What Are the Data Sources?; Using Internal Data Sources; Using External Data Sources; Using a Data Warehouse (or Not); Implementing and Enforcing Data Governance; Planning an Analytical Model; Planning the Business Intelligence Delivery Solution Considering Performance Considering Availability; Summary; Chapter 3 Selecting the Data Architecture that Fits Your Organization; Why Is Data Architecture Selection Important?; Challenges; Benefits; How Do You Pick the Right Data Architecture?; Understanding Architecture Options; Understanding Research Selection Factors; Interviewing Key Stakeholders; Completing the Selection Form; Finalizing and Approving the Architecture; Summary; Part II Business Intelligence for Analysis; Chapter 4 Searching and Combining Data with Power Query; Downloading and Installing Power Query; Importing Data Importing from a Database Importing from the Web; Importing from a File; Transforming Data; Combining Data from Multiple Sources; Splitting Data; Aggregating Data; Introducing M Programming; A Glance at the M Language; Adding and Removing Columns Using M; Summary; Chapter 5 Choosing the Right Business Intelligence Semantic Model; Understanding the Business Intelligence Semantic Model Architecture; Understanding the Data Access Layer; Using Power Pivot; Using the Multidimensional Model; Using the Tabular Model; Implementing Query Languages and the Business Logic Layer Data Analytics Expressions (DAX)Multidimensional Expressions (MDX); Direct Query and ROLAP; Data Model Layer; Comparing the Different Types of Models; Which Model Fits Your Organization?; Departmental; Team; Organizational; Summary; Chapter 6 Discovering and Analyzing Data with Power Pivot; Understanding Hardware and Software Requirements; Enabling Power Pivot; Designing an Optimal Power Pivot Model; Importing Only What You Need; Understanding Why Data Types Matter; Working with Columns or DAX Calculated Measures; Optimizing the Power Pivot Model for Reporting Understanding Power Pivot Model Basics |
Record Nr. | UNINA-9910821915403321 |
Leblanc Patrick
![]() |
||
Indianapolis, Indiana : , : Wiley, , 2015 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Data warehouse designs : achieving ROI with market basket analysis and time variance / / Fon Silvers |
Autore | Silvers Fon |
Edizione | [1st edition] |
Pubbl/distr/stampa | Boca Raton, Fla. : , : CRC Press, , 2012 |
Descrizione fisica | 1 online resource (286 p.) |
Disciplina |
005.74
005.745 |
Soggetto topico |
Business intelligence - Computer programs
Data warehousing |
Soggetto genere / forma | Electronic books. |
ISBN |
0-429-10803-6
1-4665-1666-6 1-283-59614-8 9786613908599 1-4398-7077-2 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Front Cover; Dedication; Contents; Preface; Acknowledgments; The Author; Chapter 1: Data Warehouse ROI; Chapter 2: What Is Market Basket Analysis?; Chapter 3: How Does Market Basket Analysis Produce ROI?; Chapter 4: Why Is Market Basket Analysis Difficult?; Chapter 5: Market Basket Analysis Solution Definition; Chapter 6: Market Basket Architecture and Database Design; Chapter 7: ETL into a Market Basket Datamart; Chapter 8: What Is Time Variance?; Chapter 9: How Does Time Variance Produce ROI?; Chapter 10: Why Is Time Variance Difficult?; Chapter 11: Time Variant Solution Definition
Chapter 12: Time Variant Database DefinitionChapter 13: ETL into a Time Variant Data Warehouse; Chapter 14: Market Basket Analysis in a Time Variant Data Warehouse; References |
Record Nr. | UNINA-9910457444503321 |
Silvers Fon
![]() |
||
Boca Raton, Fla. : , : CRC Press, , 2012 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Data warehouse designs : achieving ROI with market basket analysis and time variance / / Fon Silvers |
Autore | Silvers Fon |
Edizione | [1st edition] |
Pubbl/distr/stampa | Boca Raton, Fla. : , : CRC Press, , 2012 |
Descrizione fisica | 1 online resource (286 p.) |
Disciplina |
005.74
005.745 |
Soggetto topico |
Business intelligence - Computer programs
Data warehousing |
ISBN |
0-429-10803-6
1-4665-1666-6 1-283-59614-8 9786613908599 1-4398-7077-2 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Front Cover; Dedication; Contents; Preface; Acknowledgments; The Author; Chapter 1: Data Warehouse ROI; Chapter 2: What Is Market Basket Analysis?; Chapter 3: How Does Market Basket Analysis Produce ROI?; Chapter 4: Why Is Market Basket Analysis Difficult?; Chapter 5: Market Basket Analysis Solution Definition; Chapter 6: Market Basket Architecture and Database Design; Chapter 7: ETL into a Market Basket Datamart; Chapter 8: What Is Time Variance?; Chapter 9: How Does Time Variance Produce ROI?; Chapter 10: Why Is Time Variance Difficult?; Chapter 11: Time Variant Solution Definition
Chapter 12: Time Variant Database DefinitionChapter 13: ETL into a Time Variant Data Warehouse; Chapter 14: Market Basket Analysis in a Time Variant Data Warehouse; References |
Record Nr. | UNINA-9910778816003321 |
Silvers Fon
![]() |
||
Boca Raton, Fla. : , : CRC Press, , 2012 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Data warehouse designs : achieving ROI with market basket analysis and time variance / / Fon Silvers |
Autore | Silvers Fon |
Edizione | [1st edition] |
Pubbl/distr/stampa | Boca Raton, Fla. : , : CRC Press, , 2012 |
Descrizione fisica | 1 online resource (286 p.) |
Disciplina |
005.74
005.745 |
Soggetto topico |
Business intelligence - Computer programs
Data warehousing |
ISBN |
0-429-10803-6
1-4665-1666-6 1-283-59614-8 9786613908599 1-4398-7077-2 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Front Cover; Dedication; Contents; Preface; Acknowledgments; The Author; Chapter 1: Data Warehouse ROI; Chapter 2: What Is Market Basket Analysis?; Chapter 3: How Does Market Basket Analysis Produce ROI?; Chapter 4: Why Is Market Basket Analysis Difficult?; Chapter 5: Market Basket Analysis Solution Definition; Chapter 6: Market Basket Architecture and Database Design; Chapter 7: ETL into a Market Basket Datamart; Chapter 8: What Is Time Variance?; Chapter 9: How Does Time Variance Produce ROI?; Chapter 10: Why Is Time Variance Difficult?; Chapter 11: Time Variant Solution Definition
Chapter 12: Time Variant Database DefinitionChapter 13: ETL into a Time Variant Data Warehouse; Chapter 14: Market Basket Analysis in a Time Variant Data Warehouse; References |
Record Nr. | UNINA-9910800098903321 |
Silvers Fon
![]() |
||
Boca Raton, Fla. : , : CRC Press, , 2012 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Data warehouse designs : achieving ROI with market basket analysis and time variance / / Fon Silvers |
Autore | Silvers Fon |
Edizione | [1st edition] |
Pubbl/distr/stampa | Boca Raton, Fla. : , : CRC Press, , 2012 |
Descrizione fisica | 1 online resource (286 p.) |
Disciplina |
005.74
005.745 |
Soggetto topico |
Business intelligence - Computer programs
Data warehousing |
ISBN |
0-429-10803-6
1-4665-1666-6 1-283-59614-8 9786613908599 1-4398-7077-2 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Front Cover; Dedication; Contents; Preface; Acknowledgments; The Author; Chapter 1: Data Warehouse ROI; Chapter 2: What Is Market Basket Analysis?; Chapter 3: How Does Market Basket Analysis Produce ROI?; Chapter 4: Why Is Market Basket Analysis Difficult?; Chapter 5: Market Basket Analysis Solution Definition; Chapter 6: Market Basket Architecture and Database Design; Chapter 7: ETL into a Market Basket Datamart; Chapter 8: What Is Time Variance?; Chapter 9: How Does Time Variance Produce ROI?; Chapter 10: Why Is Time Variance Difficult?; Chapter 11: Time Variant Solution Definition
Chapter 12: Time Variant Database DefinitionChapter 13: ETL into a Time Variant Data Warehouse; Chapter 14: Market Basket Analysis in a Time Variant Data Warehouse; References |
Record Nr. | UNINA-9910819658003321 |
Silvers Fon
![]() |
||
Boca Raton, Fla. : , : CRC Press, , 2012 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
DAX formulas for PowerPivot [[electronic resource] ] : the Excel pro's guide to mastering DAX / / Rob Collie |
Autore | Collie Rob |
Pubbl/distr/stampa | Uniontown, OH, : Holy Macro! Books, c2013 |
Descrizione fisica | 1 online resource (255 p.) |
Soggetto topico | Business intelligence - Computer programs |
Soggetto genere / forma | Electronic books. |
ISBN |
1-61547-112-X
1-61547-212-6 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910453819303321 |
Collie Rob
![]() |
||
Uniontown, OH, : Holy Macro! Books, c2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
DAX formulas for PowerPivot [[electronic resource] ] : the Excel pro's guide to mastering DAX / / Rob Collie |
Autore | Collie Rob |
Pubbl/distr/stampa | Uniontown, OH, : Holy Macro! Books, c2013 |
Descrizione fisica | 1 online resource (255 p.) |
Soggetto topico | Business intelligence - Computer programs |
ISBN |
1-61547-112-X
1-61547-212-6 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910790510403321 |
Collie Rob
![]() |
||
Uniontown, OH, : Holy Macro! Books, c2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
DAX formulas for PowerPivot : the Excel pro's guide to mastering DAX / / Rob Collie |
Autore | Collie Rob |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Uniontown, OH, : Holy Macro! Books, c2013 |
Descrizione fisica | 1 online resource (255 p.) |
Disciplina | 005.54 |
Soggetto topico | Business intelligence - Computer programs |
ISBN |
1-61547-112-X
1-61547-212-6 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Intro -- _GoBack -- Preface/Forward/Intro -- First Chapter -- Copyright page -- Index -- Acknowledgements -- Supporting Workbooks and Data Sets -- A Note on Hyperlinks -- Introduction -- 1- A Revolution Built on YOU -- 2- What Version of PowerPivot Should You Use? -- 3- Learning PowerPivot "The Excel Way" -- 4- Loading Data Into PowerPivot -- 5- Intro to Calculated Columns -- 6- Introduction to DAX Measures -- 7- The "Golden Rules" of DAX Measures -- 8- CALCULATE() - Your New Favorite Function -- 9- ALL() - The "Remove a Filter" Function -- 10- Thinking in Multiple Tables -- 11- "Intermission" - Taking Stock of Your New Powers -- 12- Disconnected Tables -- 13- Introducing the FILTER() Function, and Disconnected Tables Continued -- 14- Introduction to Time Intelligence -- 15- IF(), SWITCH(), BLANK(), and Other Conditional Fun -- 16- SUMX() and Other X ("Iterator") Functions -- 17- Multiple Data Tables -- 18- Time Intelligence with Custom Calendars: Advanced Use of FILTER() -- 19- Performance: How to keep things running fast. -- 20- Advanced Calculated Columns -- 21- The Final Transformation: One Click That Will Change Your Life Forever -- A1- Further Proof That the Game is Changing -- A2- So Much Power, So Little Space: Further Capabilities -- A3- Four Common Error Messages -- A4- People: The Most Powerful Feature of PowerPivot -- Index. |
Record Nr. | UNINA-9910810319403321 |
Collie Rob
![]() |
||
Uniontown, OH, : Holy Macro! Books, c2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Hands-on dashboard development with QlikView : practical guide to creating interactive and user-friendly business intelligence dashboards / / Abhishek Agarwal |
Autore | Agarwal Abhishek |
Edizione | [1st edition] |
Pubbl/distr/stampa | Birmingham ; ; Mumbai : , : Packt Publishing Ltd, , 2019 |
Descrizione fisica | 1 online resource (147 pages) |
Disciplina | 658.4038011 |
Soggetto topico | Business intelligence - Computer programs |
Soggetto genere / forma | Electronic books. |
ISBN | 1-83864-499-7 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910493665403321 |
Agarwal Abhishek
![]() |
||
Birmingham ; ; Mumbai : , : Packt Publishing Ltd, , 2019 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|