| Description |
1 online resource |
| Summary |
"Drive better, faster, more informed decision making across your organization using the expert tips and best practices featured in this hands-on guide. Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition, shows, step-by-step, how to distribute high-performance, custom analytics to users enterprise-wide. Discover how to build BI Semantic Models, create data marts and OLAP cubes, write MDX and DAX scripts, and share insights using Microsoft client tools. The book includes coverage of self-service business intelligence with Power BI"-- Provided by publisher |
| Contents |
Cover -- About the Author -- Title Page -- Copyright Page -- Dedication -- Contents at a Glance -- Contents -- Acknowledgments -- Part I Business Intelligence -- Chapter 1 Equipping the Organization for Effective Decision Making -- Effective Decision Making -- Who Is a Decision Maker? -- What Is an Effective Decision? -- Keys to Effective Decision Making -- Are We Going Hither or Yon? -- Is Your Map Upside-Down? -- Panicked Gossip, the Crow's Nest, or the Wireless -- Business Intelligence -- Business Intelligence and Microsoft SQL Server 2016 |
|
Chapter 2 Making the Most of What You've Got: Using Business Intelligence -- What Business Intelligence Can Do for You -- Types of Data Exploration -- Business Intelligence at Many Levels -- The Top of the Pyramid -- Mid-Level -- The Broad Base -- Maximum Miniatures, Inc. -- Business Needs -- Current Systems -- Building the Foundation -- Chapter 3 Seeking the Source: The Source of Business Intelligence -- Seeking the Source -- Transactional Data -- The Data Mart -- Features of a Data Mart -- Data Mart Structure -- Why Analysis Services? |
|
Chapter 4 Two, Two, Two Models in One: The BI Semantic Model -- Online Analytical Processing -- The BI Semantic Model -- Building OLAP Out of Cubes: The Multidimensional Model -- Features of a Multidimensional Model Implementation -- Architecture of a Multidimensional Model Implementation -- The Parts of a Multidimensional Model Implementation -- Building OLAP Out of Tables: The Tabular Model -- Features of a Tabular Model -- Architecture of a Tabular Model -- Choosing an Implementation Method -- Tools of the Trade -- Chapter 5 First Steps: Beginning the Development of Business Intelligence |
|
SQL Server Data Tools -- Visual Studio -- Installing SQL Server Data Tools -- Navigating SQL Server Data Tools -- SQL Server Data Tools Options -- SQL Server Management Studio -- Installing SQL Server Management Studio -- The SQL Server Management Studio User Interface -- Don Your Hardhat -- Part II Defining Business Intelligence Structures -- Chapter 6 Building Foundations: Creating Data Marts -- Data Mart -- Who Needs a Data Mart Anyway? -- Designing a Data Mart -- Decision Makers' Needs -- Available Data -- Data Mart Structures -- Creating a Data Mart Using the SQL Server Management Studio |
|
Creating a Data Mart Using SQL Server Data Tools -- Table Compression -- Types of Table Compression -- The Benefits of Integration -- Chapter 7 Transformers: Integration Services Structure and Components -- Integration Services -- Package Structure -- Package Items -- Control Flow -- Data Flow -- Getting Under the Sink -- Chapter 8 Fill 'er Up: Using Integration Services for Populating Data Marts -- Package Development Features -- Give It a Try -- Programming in Integration Services Packages -- Package Development Tools -- Change Data Capture -- Change Data Capture Architecture |
| Subject |
SQL server.
|
|
SQL server |
|
Business intelligence.
|
|
Client/server computing.
|
|
Architecture client-serveur (Informatique) |
|
Business intelligence |
|
Client/server computing |
| Other Form: |
Print version: Larson, Brian. Delivering business intelligence with Microsoft SQL server 2016. Fourth edition. New York : McGraw-Hill Education, [2017] 9781259641480 (DLC) 2016041674 |
| ISBN |
9781259641497 (ebook) |
|
125964149X (ebook) |
|
1259641481 |
|
9781259641480 |
|
(paperback) |
|
More Resources