|
|
|
|
LEADER |
05260nmm a2200661 u 4500 |
001 |
EB001921569 |
003 |
EBX01000000000000001084471 |
005 |
00000000000000.0 |
007 |
cr||||||||||||||||||||| |
008 |
210123 ||| eng |
020 |
|
|
|a 9781430233251
|
050 |
|
4 |
|a QA76.73.S67
|
100 |
1 |
|
|a Fouché, Guy
|
245 |
0 |
0 |
|a Foundations of SQL Server 2008 R2 business intelligence
|c Guy Fouché, Lynn Langit
|
250 |
|
|
|a 2nd edition
|
260 |
|
|
|a [New York]
|b Apress
|c 2011
|
300 |
|
|
|a 1 online resoure (xv, 427 pages)
|b illustrations
|
505 |
0 |
|
|a Reviewing MeasuresReviewing Dimensions: Attributes; Reviewing Dimensions: Hierarchies; Creating Attribute Relationships; Other Parts of the Dimension Structure Tab; Dimension Properties; Offline vs. Online Mode in BIDS; Other Types of Modeling; Summary; Chapter 4: Intermediate OLAP Modeling with SSAS; Adding Key Performance Indicators (KPls); Implementing KPls in SSAS; Implementing KPls in SSMS; Using Perspectives and Translations; Perspectives; Translations; Localizing Measure Values; Using Actions; Creating Actions in SSAS; Creating Actions in SSMS; Summary
|
505 |
0 |
|
|a Title Page; Copyright Page; Contents at a Glance; Table of Contents; About the Authors; About the Technical Reviewer; Acknowledgments; Chapter 1: What Is Business Intelligence?; Just What Is Business Intelligence?; Defining BI Using Microsoft's Tools; What Microsoft Products Are Involved?; BI Languages; Understanding BI from an End User's Perspective; Building the First Sample-Using AdventureWorks; Deploying the Standard Edition Version of the Sample Cube; How to Connect to the Sample Cube Using Excel; Understanding BI Through the Sample; Understanding the Business Problems That BI Addresses
|
505 |
0 |
|
|a Chapter 5: Advanced OLAP Modeling with SSASMultiple Fact Tables in a Single Cube; Nulls; Nonstar Dimensions; Snowflake Dimensions; Degenerate Dimensions; Parent-Child Dimensions; Many-to-Many Dimensions; Role-Playing Dimensions; Writeback Dimensions; Dimensions That Change; Error Handling for Dimension Attribute Loads; Using the Business Intelligence Wizard; Summary; Chapter 6: Cube Storage and Aggregation; Using the Default Storage: MOLAP; XML for Analysis; Aggregations; MOLAP as Default in SSAS; Adding Aggregations; The Aggregation Design Wizard; The Usage-Based Optimization Wizard
|
505 |
0 |
|
|a Reasons to Switch to Microsoft's BI ToolsSummary; Chapter 2: OLAP Modeling Concepts; Modeling OLAP Source Schemas-Stars; Understanding the Star Schema; Understanding a Dimension Table; Attributes; Why Create Star Schemas?; Effectively Creating Star Schema Models Using Grain Statements; Tools for Creating Your OLAP Model; Modeling Source Schemas-Snowflakes and Other Variations; Understanding the Snowflake Schema; Knowing When to Use Snowflakes; Considering Other Possible Variations; Choosing Whether to Use Views Against the Relational Data Sources; Understanding Unified Dimensional Modeling
|
505 |
0 |
|
|a Using the UDMThe Slowly Changing Dimension (SCD); Type 1, 2, 3 SCD Solutions; The Rapidly Changing Dimension (RCD); Writeback Dimension; Understanding Fact (Measure) Modeling; An Example; Calculated Measure vs. Derived Measure; Other Types of Modeling; Data Mining; Key Performance Indicators; Actions, Perspectives, Translations; Source Control and Other Documentation Standards; Summary; Chapter 3: Introducing OLAP Modeling with SSAS; Using BIDS to Build a Cube; Defining Your First Cube; Adding Dimension Attributes; Defining Hierarchies; Building Your First Cube; Refining Your Cube
|
653 |
|
|
|a Relational databases / cct
|
653 |
|
|
|a Architecture client-serveur (Informatique)
|
653 |
|
|
|a SQL server / fast
|
653 |
|
|
|a Relational databases / http://id.loc.gov/authorities/subjects/sh86007768
|
653 |
|
|
|a Client/server computing / http://id.loc.gov/authorities/subjects/sh93000502
|
653 |
|
|
|a OLAP technology / cct
|
653 |
|
|
|a COMPUTERS / Client-Server Computing / bisacsh
|
653 |
|
|
|a OLAP technology / http://id.loc.gov/authorities/subjects/sh99002794
|
653 |
|
|
|a SQL server / blmlsh
|
653 |
|
|
|a Business intelligence / http://id.loc.gov/authorities/subjects/sh85018300
|
653 |
|
|
|a COMPUTERS / Programming Languages / SQL. / bisacsh
|
653 |
|
|
|a Business intelligence / fast
|
653 |
|
|
|a Client/server computing / fast
|
653 |
|
|
|a Bases de données relationnelles
|
653 |
|
|
|a OLAP, Technologie
|
653 |
|
|
|a Relational databases / fast
|
653 |
|
|
|a SQL server / cct
|
653 |
|
|
|a Client/server computing / cct
|
653 |
|
|
|a SQL server / http://id.loc.gov/authorities/names/n90684343
|
653 |
|
|
|a Informatique / eclas
|
653 |
|
|
|a Business intelligence / cct
|
653 |
|
|
|a OLAP technology / fast
|
700 |
1 |
|
|a Langit, Lynn
|
041 |
0 |
7 |
|a eng
|2 ISO 639-2
|
989 |
|
|
|b OREILLY
|a O'Reilly
|
490 |
0 |
|
|a The expert's voice in SQL server
|
500 |
|
|
|a "Books for professionals by professionals."
|
024 |
8 |
|
|a 10.1007/978-1-4302-3325-1
|
776 |
|
|
|z 9781430233244
|
776 |
|
|
|z 1430233257
|
776 |
|
|
|z 1430233249
|
776 |
|
|
|z 9781430233251
|
856 |
4 |
0 |
|u https://learning.oreilly.com/library/view/~/9781430233244/?ar
|x Verlag
|3 Volltext
|
082 |
0 |
|
|a 005.7565
|
082 |
0 |
|
|a 330
|
520 |
|
|
|a Annotation
|