Knight's Microsoft Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server Integration, Analysis, and Reporting Services with Excel and Sharepoint - Brossura

Knight, Brian; Knight, Devin; Jorgensen, Adam; Leblanc, Patrick; Davis, Mike

Brossura

ISBN 10: 0470889632 ISBN 13: 9780470889633

Casa editrice: Wrox Pr Inc, 2010

Riassunto

Provides information on using the Microsoft business information tools to perform analysis and reporting using Excel and SharePoint.

Su questo libro

L'autore:

Brian Knight, SQL Server MVP, is the founder of Pragmatic Works. He is author of more than a dozen books.

Devin Knight is an author, consultant, and trainer with Pragmatic Works.

Adam Jorgensen is an author, trainer, consultant, and President of Pragmatic Works Consulting.

Patrick LeBlanc, SQL Server MVP, is a BI Architect, consultant, and trainer with Pragmatic Works.

Mike Davis is an author, developer, consultant, and trainer with Pragmatic Works.

Dalla quarta di copertina:

A hands-on guide to Microsoft's Business Intelligence toolset

An ideal starting point for anyone new to the world of Business Intelligence (BI), this unique book-and-DVD package introduces you to the Microsoft BI toolset and provides you with information you need to perform basic business analysis and reporting with Excel and SharePoint. The expert authors begin with a basic primer on BI and data modeling and go on to show you step by step how to use SQL Server Integration Services, Analysis Services, Reporting Services, Excel BI (including PowerPivot), and SharePoint. Each lesson in the book has an accompanying tutorial on the DVD, making your learning experience thorough and understandable.

Knight's Microsoft Business Intelligence 24-Hour Trainer:

• Breaks down data warehousing and Business Intelligence into digestible pieces

• Escorts you through solving common scenarios involving SQL Server Integration Services

• Details the ways to configure a data source and a data source view in SQL Server Analysis Services

• Demonstrates how to develop, deploy, and administer SQL Server Reporting Services, use maps in your report, and build a matrix report or dashboard

• Teaches you to deploy and use Reporting Services, Excel Services, and PowerPivot for Excel 2010 and SharePoint 2010

Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved.

On the DVD

Don't just learn—do!

The lessons within the book are each accompanied by an instructional demonstration on the DVD.

You'll learn to:

• Use control flow and data flow

• Solve common SSIS scenarios

• Load dimensions as well as a fact table

• Configure a data source and a data source view

• Add new dimensions and measure groups

• Create calculations

• Build a matrix report

• Deploy and administer SSRS

• Use Report Builder

• Load data into a PowerPivot workbook

• Deploy and use Reporting Services in SharePoint 2010

Please see the DVD appendix for details and complete system requirements.

Su questa edizione

• Editore: Wrox Pr Inc
• Data di pubblicazione: 2010
• ISBN 10: 0470889632
• ISBN 13: 9780470889633
• Rilegatura: Copertina flessibile
• Numero di pagine: 394