Benutzerdefiniertes Cover
Benutzerdefiniertes Cover
Normale Ansicht MARC-Ansicht ISBD

Knight's Microsoft business intelligence 24-hour trainer : leveraging Microsoft SQL server integration, analysis, and reporting services with Excel and SharePoint / Brian Knight ... [et al.]

Mitwirkende(r): Resource type: Ressourcentyp: Buch (Online)Buch (Online)Sprache: Englisch Reihen: Wrox guidesVerlag: Indianapolis, Ind : Wiley Pub., Inc, c2010Auflage: Online-AusgBeschreibung: Online-Ressource (1 online resource (xxix, 394 p.)) : illISBN:
  • 0470944374
  • 9780470944370
  • 9781282783478
  • 1282783475
  • 0470889632
  • 9780470889633
Weitere Titel:
  • Microsoft business intelligence 24-hour trainer
  • Knight's Microsoft business intelligence twenty-four-hour trainer
  • Microsoft business intelligence twenty-four-hour trainer
Schlagwörter: Andere physische Formen: 9780470889633 | Erscheint auch als: Knight's Microsoft business intelligence 24-hour trainer Druck-Ausgabe | Erscheint auch als: Knight's Microsoft business intelligence 24-hour trainer. Druck-Ausgabe. Indianapolis, IN : Wiley Pub, 2010. XXIX, 394 S.DDC-Klassifikation:
  • 658.4038011
  • 658.4/038011 22
  • 658.47028;658.470285536
  • 658.47028
  • 658.470285536
LOC-Klassifikation:
  • HD38.7
  • HF5548.4
Online-Ressourcen:
Inhalte:
section 1. Data warehousing and business intelligencesection 2. SQL Server integration services -- section 3. SQL Server analysis services -- section 4. SQL Server reporting services -- section 5. Containers -- section 6. SharePoint.
Knight's Microsoft Business Intelligence 24-Hour Trainer; About the Authors; About the Technical Editor; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need to Use This Book; Instructional Videos on DVD; Conventions; Supporting Packages and Code; Errata; p2p.wrox.com; Section I: Data Warehousing and Business Intelligence; Chapter 1: Why Business Intelligence?; How Intelligent Is Your Organization?; Try It; Chapter 2: Dimensional Modeling; Key Dimensional Modeling Elements; How Does Dimensional Modeling Work?; Try It
Chapter 3: Fact Table ModelingTry It; Section II: SQL Server Integration Services; Chapter 4: Understanding SSIS; Business Intelligence Development Studio (BIDS); Solution Explorer; SSIS Designer; Variables; SSIS Architecture; Try It; Chapter 5: Using the Control Flow; Control Flow Containers; Control Flow Tasks; Precedence Constraints; Connection Manager; Control Flow Designer; Try It; Chapter 6: Using the Data Flow; Data Flow Sources (Extracting Data); Data Flow Transformations; Data Flow Paths; Data Flow Designer; Try It; Chapter 7: Solving Common SSIS Scenarios; Try It
Chapter 8: Loading DimensionsUsing the Slowly Changing Dimension Task; Try It; Chapter 9: Loading a Fact Table; Try It; Chapter 10: Deploying SSIS Packages; Deploying a Single Package Using SSMS; Deploying a Single Package Using BIDS; Creating a Deployment Utility Using BIDS; Try It; Section III: SQL Server Analysis Services; Chapter 11: Understanding SSAS; SSAS Architecture; Cubes; MDX; BIDS for SSAS; Try It; Chapter 12: Configuring a Data Source and Data Source View; Creating a Data Source; Creating a Data Source View; Try It; Chapter 13: Using the Cube Wizard; Try It
Chapter 14: Editing Your DimensionDimension Editor; Attribute Relationships; Key Columns; Dimension and Attribute Types; Try It; Chapter 15: Editing Your Cube; Cube Editor Tour; Browsing the Cube; Try It; Chapter 16: Adding New Dimensions and Measure Groups; Adding a Measure Group and Measures; Adding a Dimension; Try It; Chapter 17: Using MDX; Anatomy of Basic MDX; Navigation Functions; Try It; Chapter 18: Creating Calculations; Calculation Basics; Color-Coding Measures; Named Sets; More Advanced Calculations; Try It; Chapter 19: Data Mining; Introduction to Data Mining; Data-Mining Process
Creating a Mining ModelExploring the Model; Evaluating the Model; Querying the Model; Try It; Chapter 20: Administering the SSAS Instance; Securing the Database; Partitioning the Data; Aggregations; Usage-Based Optimization; Processing the Cube; Deploying Change; Try It; Section IV: SQL Server Reporting Services; Chapter 21: Understanding SSRS; Building Your First Report; Try It; Chapter 22; Using Report Wizard; Try It; Chapter 23: Building a Matrix Report; Try It; Chapter 24: Parameterizing Your Reports; Creating Parameters; Default Parameter Values; Parameter Available Values
Multi-Value Parameters
Editing Your DimensionDimension Editor; Attribute Relationships; Key Columns; Dimension and Attribute Types; Try It; Chapter 15: Editing Your Cube; Cube Editor Tour; Browsing the Cube; Try It; Chapter 16: Adding New Dimensions and Measure Groups; Adding a Measure Group and Measures; Adding a Dimension; Try It; Chapter 17: Using MDX; Anatomy of Basic MDX; Navigation Functions; Try It; Chapter 18: Creating Calculations; Calculation Basics; Color-Coding Measures; Named Sets; More Advanced Calculations; Try It; Chapter 19: Data Mining; Introduction to Data Mining; Data-Mining Process
Fact Table ModelingTry It; Section II: SQL Server Integration Services; Chapter 4: Understanding SSIS; Business Intelligence Development Studio (BIDS); Solution Explorer; SSIS Designer; Variables; SSIS Architecture; Try It; Chapter 5: Using the Control Flow; Control Flow Containers; Control Flow Tasks; Precedence Constraints; Connection Manager; Control Flow Designer; Try It; Chapter 6: Using the Data Flow; Data Flow Sources (Extracting Data); Data Flow Transformations; Data Flow Paths; Data Flow Designer; Try It; Chapter 7: Solving Common SSIS Scenarios; Try It
Loading DimensionsUsing the Slowly Changing Dimension Task; Try It; Chapter 9: Loading a Fact Table; Try It; Chapter 10: Deploying SSIS Packages; Deploying a Single Package Using SSMS; Deploying a Single Package Using BIDS; Creating a Deployment Utility Using BIDS; Try It; Section III: SQL Server Analysis Services; Chapter 11: Understanding SSAS; SSAS Architecture; Cubes; MDX; BIDS for SSAS; Try It; Chapter 12: Configuring a Data Source and Data Source View; Creating a Data Source; Creating a Data Source View; Try It; Chapter 13: Using the Cube Wizard; Try It
Administering the SSAS Instance; Securing the Database; Partitioning the Data; Aggregations; Usage-Based Optimization; Processing the Cube; Deploying Change; Try It; Section IV: SQL Server Reporting Services; Chapter 21: Understanding SSRS; Building Your First Report; Try It; Chapter 22; Using Report Wizard; Try It; Chapter 23: Building a Matrix Report; Try It; Chapter 24: Parameterizing Your Reports; Creating Parameters; Default Parameter Values; Parameter Available Values
Data Warehousing and Business Intelligence; Chapter 1: Why Business Intelligence?; How Intelligent Is Your Organization?; Try It; Chapter 2: Dimensional Modeling; Key Dimensional Modeling Elements; How Does Dimensional Modeling Work?; Try It
Zusammenfassung: A book-and-video introduction to Microsoft's Business Intelligence tools If you are just starting to get a handle on Microsoft Business Intelligence (BI) tools, this book and accompanying video provides you with the just the right amount of information to perform basic business analysis and reporting. You'll explore the components and related tools that comprise the Microsoft BI toolset as well as the new BI features of Office 2010. After a basic primer on BI and data modeling, the expert team of authors provides you with step-by-step lessons in the book and videos on the accompanying DVD on how to use SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, Excel BI (including PowerPivot), and SharePoint. Integrates instructional videos with each of the lessons found in the book to enhance your learning experience Explores the Microsoft Business Intelligence (BI) toolset as well as the new BI features of Office 2010 Encourages you to practice what you've learned in "Try It Out" sections Contains video demonstrations that walk you through how to tackle each lesson featured in the book With Knight's Microsoft Business Intelligence 24-Hour Trainer, veteran authors present you with an ideal introductory book-and-video package so that you can get started working with the BI toolset immediately!/p Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.Zusammenfassung: Knight's Microsoft Business Intelligence 24-Hour Trainer -- About the Authors -- About the Technical Editor -- Acknowledgments -- Contents -- Introduction -- Who This Book Is For -- What This Book Covers -- How This Book Is Structured -- What You Need to Use This Book -- Instructional Videos on DVD -- Conventions -- Supporting Packages and Code -- Errata -- p2p.wrox.com -- Section I: Data Warehousing and Business Intelligence -- Chapter 1: Why Business Intelligence? -- How Intelligent Is Your Organization? -- Try It -- Chapter 2: Dimensional Modeling -- Key Dimensional Modeling Elements -- How Does Dimensional Modeling Work? -- Try It -- Chapter 3: Fact Table Modeling -- Try It -- Section II: SQL Server Integration Services -- Chapter 4: Understanding SSIS -- Business Intelligence Development Studio (BIDS) -- Solution Explorer -- SSIS Designer -- Variables -- SSIS Architecture -- Try It -- Chapter 5: Using the Control Flow -- Control Flow Containers -- Control Flow Tasks -- Precedence Constraints -- Connection Manager -- Control Flow Designer -- Try It -- Chapter 6: Using the Data Flow -- Data Flow Sources (Extracting Data) -- Data Flow Transformations -- Data Flow Paths -- Data Flow Designer -- Try It -- Chapter 7: Solving Common SSIS Scenarios -- Try It -- Chapter 8: Loading Dimensions -- Using the Slowly Changing Dimension Task -- Try It -- Chapter 9: Loading a Fact Table -- Try It -- Chapter 10: Deploying SSIS Packages -- Deploying a Single Package Using SSMS -- Deploying a Single Package Using BIDS -- Creating a Deployment Utility Using BIDS -- Try It -- Section III: SQL Server Analysis Services -- Chapter 11: Understanding SSAS -- SSAS Architecture -- Cubes -- MDX -- BIDS for SSAS -- Try It -- Chapter 12: Configuring a Data Source and Data Source View -- Creating a Data Source -- Creating a Data Source View -- Try It.PPN: PPN: 809059231Package identifier: Produktsigel: ZDB-26-MYL | ZDB-38-EBR | ZDB-30-PBE | ZDB-30-PAD | ZDB-30-PQE
Dieser Titel hat keine Exemplare
KIT – Die Universität in der Helmholtz-Gemeinschaft                         Home | Impressum | Datenschutz | Barrierefreiheit | KIT