Muutke küpsiste eelistusi

E-raamat: Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition

4.11/5 (26 hinnangut Goodreads-ist)
  • Formaat: PDF+DRM
  • Ilmumisaeg: 04-Nov-2016
  • Kirjastus: McGraw-Hill Education
  • Keel: eng
  • ISBN-13: 9781259641497
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 57,10 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth EditionSuurem pilt
  • Formaat: PDF+DRM
  • Ilmumisaeg: 04-Nov-2016
  • Kirjastus: McGraw-Hill Education
  • Keel: eng
  • ISBN-13: 9781259641497
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Describes how to develop, customize, and disseminate information to users, covering such topics as building data marts, working with the MDX and DAX languages, and forcecasting.

Describes how to develop, customize and disseminate information to users, covering such topics as building data marts, working with the MDX and DAX languages, and forecasting. Original.

Master the powerful BI tools available in Microsoft SQL Server 2016

Enable informed, timely decision making across any type of organization using the expert tips and best practices contained in this hands-on guide. Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition, fully explains how to effectively develop, customize, and distribute meaningful information.

Thoroughly revised for Microsoft SQL Server 2016, the book shows, step-by-step, how to configure and populate databases, analyze the data, and deliver actionable business intelligence. You will discover how to build data marts, create BI Semantic Models, work with the MDX and DAX languages, and share insights using the latest Microsoft client tools. Microsoft BI Cloud, mobile client tools, and forecasting techniques are also covered in this comprehensive resource.

• Example scenarios place the BI concepts and tools in real-world contexts
• Sample code in the book is available for download though the companion website
• Written by a Microsoft Certified Partner and experienced author

Acknowledgments xvii
Part I Business Intelligence
Chapter 1 Equipping the Organization for Effective Decision Making
3(10)
Effective Decision Making
4(2)
Who Is a Decision Maker?
4(1)
What Is an Effective Decision?
5(1)
Keys to Effective Decision Making
6(5)
Are We Going Hither or Yon?
6(2)
Is Your Map Upside-Down?
8(1)
Panicked Gossip, the Crow's Nest, or the Wireless
9(2)
Business Intelligence
11(2)
Business Intelligence and Microsoft SQL Server 2016
12(1)
Chapter 2 Making the Most of What You've Got: Using Business Intelligence
13(10)
What Business Intelligence Can Do for You
14(1)
Types of Data Exploration
14(1)
Business Intelligence at Many Levels
15(4)
The Top of the Pyramid
16(2)
Mid-Level
18(1)
The Broad Base
18(1)
Maximum Miniatures, Inc
19(2)
Business Needs
19(1)
Current Systems
20(1)
Building the Foundation
21(2)
Chapter 3 Seeking the Source: The Source of Business Intelligence
23(18)
Seeking the Source
24(3)
Transactional Data
24(3)
The Data Mart
27(13)
Features of a Data Mart
28(2)
Data Mart Structure
30(10)
Why Analysis Services?
40(1)
Chapter 4 Two, Two, Two Models in One: The BI Semantic Model
41(18)
Online Analytical Processing
42(1)
The BI Semantic Model
43(1)
Building OLAP Out of Cubes: The Multidimensional Model
43(13)
Features of a Multidimensional Model Implementation
46(3)
Architecture of a Multidimensional Model Implementation
49(1)
The Parts of a Multidimensional Model Implementation
50(6)
Building OLAP Out of Tables: The Tabular Model
56(2)
Features of a Tabular Model
56(1)
Architecture of a Tabular Model
57(1)
Choosing an Implementation Method
58(1)
Tools of the Trade
58(1)
Chapter 5 First Steps: Beginning the Development of Business Intelligence
59(28)
SQL Server Data Tools
60(19)
Visual Studio
60(1)
Installing SQL Server Data Tools
61(1)
Navigating SQL Server Data Tools
62(14)
SQL Server Data Tools Options
76(3)
SQL Server Management Studio
79(5)
Installing SQL Server Management Studio
79(1)
The SQL Server Management Studio User Interface
79(5)
Don Your Hardhat
84(3)
Part II Defining Business Intelligence Structures
Chapter 6 Building Foundations: Creating Data Marts
87(46)
Data Mart
88(3)
Who Needs a Data Mart Anyway?
88(3)
Designing a Data Mart
91(38)
Decision Makers' Needs
92(1)
Available Data
93(1)
Data Mart Structures
93(13)
Creating a Data Mart Using the SQL Server Management Studio
106(8)
Creating a Data Mart Using SQL Server Data Tools
114(15)
Table Compression
129(3)
Types of Table Compression
129(3)
The Benefits of Integration
132(1)
Chapter 7 Transformers: Integration Services Structure and Components
133(116)
Integration Services
134(12)
Package Structure
134(12)
Package Items
146(102)
Control Flow
146(42)
Data Flow
188(60)
Getting Under the Sink
248(1)
Chapter 8 Filler Up: Using Integration Services for Populating Data Marts
249(86)
Package Development Features
250(32)
Give It a Try
250(11)
Programming in Integration Services Packages
261(10)
Package Development Tools
271(11)
Change Data Capture
282(9)
Change Data Capture Architecture
283(4)
Loading a Data Mart Table from a Change Data Capture Change Table
287(4)
Loading a Fact Table
291(16)
Putting Integration Services Packages into Production
307(24)
Parameters
308(2)
The Integration Services Catalog
310(13)
Managing Packages in the Integration Services Catalog
323(6)
Executing Packages from the SSIS Catalog
329(2)
Meanwhile, Back at the BI Semantic Model
331(4)
Part Ill Working with a Tabular BI Semantic Model
Chapter 9 Setting the Table: Creating a Tabular BI Semantic Model
335(46)
Preparation for Creating Tabular Models
336(4)
SQL Server Analysis Services Tabular Instance
336(1)
Managing the Workspace Database
337(3)
Creating a Tabular Model
340(23)
Data Sources for Our Tabular Models
340(11)
Measures in a Tabular Model
351(2)
Manually Creating a Time Table
353(4)
Relationships and Hierarchies
357(4)
Validating the Model Using the Analyze in Excel Feature
361(2)
A Second Tabular Model
363(17)
Data Persistence
363(7)
Calculated Columns
370(2)
Hierarchies Spanning Multiple Tables
372(8)
Putting More on the Table
380(1)
Chapter 10 A Fancy Table: Tabular BI Semantic Model Advanced Features
381(66)
Enhancing Our Tabular Model
382(15)
Table and Column Properties
382(1)
Adding Images to a Tabular Model
383(4)
Advanced Relationships and Filtering
387(1)
Parent/Child Relationships
387(4)
Multiple Relationships Between the Same Tables
391(3)
Partitions
394(1)
Perspectives
394(3)
DAX Expressions
397(36)
DAX Operators
397(2)
The Context for Measures and Calculated Columns
399(2)
Filtering Aggregates
401(7)
Table-Valued Functions
408(3)
Aggregate Functions
411(5)
DAX Functions for Time Analytics
416(6)
Additional DAX Functions
422(1)
Putting DAX Functions to Use
423(10)
Variables in the Tabular Model
433(1)
Declaring DAX Variables and Assigning a Value
433(1)
Using a DAX Variable
434(1)
Using Return in a Measure
434(1)
Deploying a Tabular Model
434(9)
Deploying from SQL Server Data Tools
435(1)
Completing the Deployment
436(1)
Deploying from the Analysis
Services Deployment Wizard
437(6)
Another Model Awaits
443(4)
Part IV Working with a Multidimensional BI Semantic Model
Chapter 11 Cubism: Measures and Dimensions
447(34)
Building a Multidimensional BI Semantic Model
448(5)
Creating a Cube
448(5)
Measures
453(12)
Measure Groups
454(2)
Made-Up Facts: Calculated Measures
456(3)
It Doesn't Add Up: Measure Aggregates Other Than Sum
459(6)
Dimensions
465(15)
Managing Dimensions
465(6)
Relating Dimensions to Measure Groups
471(2)
Types of Dimensions
473(3)
Slowly Changing Dimensions
476(4)
You Are Special
480(1)
Chapter 12 Bells and Whistles: Special Features of OLAP Cubes
481(58)
Where No Cube Has Gone Before
482(18)
Deploying and Processing
483(1)
Deploying from SQL Server Data Tools
483(7)
Deploying from the Analysis Services
Deployment Wizard
490(10)
Additional Cube Features
500(37)
Linked Objects
501(2)
The Business Intelligence Wizard
503(1)
Key Performance Indicators
504(7)
Actions
511(3)
Partitions
514(16)
Aggregation Design
530(3)
Perspectives
533(3)
Translations
536(1)
Creating Translations
536(1)
More Sophisticated Scripting
537(2)
Chapter 13 Writing a New Script: MDX Scripting
539(44)
Terms and Concepts
540(27)
Where Are We?
540(19)
Getting There from Here
559(8)
Putting MDX Scripting to Work
567(15)
Cube Security
567(9)
This Year-to-Last Year Comparisons and Year-to-Date Rollups
576(6)
Extracting Data from Cubes
582(1)
Chapter 14 Pulling It Out and Building It Up: MDX Queries
583(38)
The MDX SELECT Statement
584(27)
The Basic MDX SELECT Statement
585(13)
Additional Tools for Querying
598(11)
Additional Dimensions
609(2)
Additional MDX Syntax
611(7)
Operators
611(3)
Functions
614(4)
Feel the Power
618(3)
Part V Modeling and Visualizing with Power BI
Chapter 15 Power to the People: Loading Data with Power BI
621(64)
The Power BI Architecture
622(4)
Many Manifestations
622(1)
Power BI Desktop
623(1)
PowerBl.com
623(1)
Power BI Content on Premises
624(1)
Power BI Mobile
625(1)
Constant Improvement
625(1)
Obtaining the Power BI Desktop Software
625(1)
The Power BI Data Engine
625(1)
Getting Started with Power BI: Gathering Data
626(19)
The Start Dialog Box
626(1)
Get Data
627(3)
Creating Your First Power BI Content
630(8)
Using Live Connection
638(5)
Connection Types and Direct Query
643(2)
Transforming Data During the Data Import
645(32)
The Power BI Query Editor
646(2)
A New Sample: World Population
648(6)
Transformations
654(17)
Advanced Editor and Power Query Formula Language
671(6)
Parameters
677(7)
Putting Parameters to Use
678(6)
Delivering the Power
684(1)
Chapter 16 I Can See Clearly Now: Data Visualization with Power BI Reporting
685(56)
Enhancing Power BI Data Models
686(18)
Relationships and Intermediate Tables
686(9)
Formatting and Categories
695(7)
Hierarchies
702(2)
Power BI Data Visualizations
704(18)
Basic Visualization
704(8)
High Interactivity
712(6)
Mapping
718(2)
Additional Visualization Elements
720(2)
DAX Calculations
722(7)
Calculated Column: Order Weight
722(2)
Time Analytics
724(3)
Context Override: Percent of Total
727(2)
Additional Power BI Features
729(4)
Roles
729(2)
Synonyms
731(1)
Import and Export
732(1)
PowerBI.com
733(4)
Signing In to PowerBl.com
733(1)
Publishing
733(2)
Refreshing Data Online
735(2)
On-premises Power BI Publishing
737(1)
Special Delivery
737(4)
Part VI Delivering
Chapter 17 Special Delivery: Microsoft Business Intelligence Client Tools
741(78)
Front-End BI Tools from Microsoft
742(3)
Selecting a Front-End BI Tool
743(2)
A Bit of Knowledge Is a Big Help
745(1)
Reporting Services
745(1)
Reporting Services Paginated Reports
745(40)
Paginated Report Structure
746(2)
Paginated Report Delivery
748(2)
Data Regions
750(2)
Creating a Reporting Services Paginated Report
752(12)
Reporting Services Mobile Reports
764(2)
Creating a Reporting Services Mobile Report
766(12)
Reporting Services Key Performance Indicators
778(2)
Creating a Reporting Services Key Performance Indicator
780(5)
Excel
785(13)
Creating Pivot Tables and Pivot Charts
786(8)
Pivot Chart
794(4)
PerformancePoint Services in SharePoint
798(19)
Creating a Site Collection Using the Business Intelligence Center Template
799(2)
Creating a Dashboard Using PerformancePoint Services
801(16)
Putting It All Together
817(2)
Chapter 18 Let's Get Together: Integrating Business Intelligence with Your Applications
819(24)
ADOMD.NET
820(9)
ADOMD.NET Structure
820(2)
ADOMD.NET Example
822(7)
Integrating a Reporting Services Report with an Application
829(11)
Report Server
829(1)
Folders
830(1)
The Web Portal
830(1)
Deploying Reports Using SQL Server Data Tools
830(4)
Web Service Access
834(6)
Great Capabilities, Great Opportunities
840(3)
Index 843
Brian Larson (Arden Hills, MN) served as a contract member of the Reporting Services development team and contributed to the code base. He has contributed to SQL Server Magazine and is the Chief of Technology for Superior Consulting Services. With over 18 years of experience in the computer industry, and 14 years as a software development consultant, Brian is an MCSD as well as an MCDBA, and has authored and delivered training curriculum for SQL Server 2000 and C#.NET as well as numerous custom applications.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97812596414972e.html
Märksõnad: