Knights Microsoft Business Intelligence 24-Hour Trainer

Kobo eBook available

read instantly on your Kobo or tablet.

buy the ebook now

Knights Microsoft Business Intelligence 24-Hour Trainer

by Adam Jorgensen, Brian Knight, Devin Knight

Wiley | September 28, 2010 | Trade Paperback

Not yet rated | write a review
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.

Format: Trade Paperback

Dimensions: 432 pages, 9.22 × 7.4 × 0.88 in

Published: September 28, 2010

Publisher: Wiley

Language: English

The following ISBNs are associated with this title:

ISBN - 10: 0470889632

ISBN - 13: 9780470889633

save 37%

  • In stock online

$35.63  ea

Online Price

$53.99 List Price

or, Used from $31.16

eGift this item

Give this item in the form of an eGift Card.

+ what is this?

This item is eligible for FREE SHIPPING on orders over $25.
See details

Easy, FREE returns. See details

Item can only be shipped in Canada

Downloads instantly to your kobo or other ereading device. See details

All available formats:

Reviews

– More About This Product –

Knights Microsoft Business Intelligence 24-Hour Trainer

by Adam Jorgensen, Brian Knight, Devin Knight

Format: Trade Paperback

Dimensions: 432 pages, 9.22 × 7.4 × 0.88 in

Published: September 28, 2010

Publisher: Wiley

Language: English

The following ISBNs are associated with this title:

ISBN - 10: 0470889632

ISBN - 13: 9780470889633

Table of Contents

Introduction. Section I: Data Warehousing and Section I: Business Intelligence. Lesson 1: Why Business Intelligence? Lesson 2: Dimensional Modeling. Lesson 3: Fact Table Modeling. Section II: SQL Server Integration Services. Lesson 4: Understanding SSIS. Lesson 5: Using the Control Flow. Lesson 6: Using the Data Flow. Lesson 7: Solving Common SSIS Scenarios. Lesson 8: Loading Dimensions. Lesson 9: Loading a Fact Table. Lesson 10: Deploying SSIS Packages. Section III: SQL Server Analysis Services. Lesson 11: Understanding SSAS. Lesson 12: Configuring a Data Source and Data Source View. Lesson 13: Using the Cube Wizard. Lesson 14: Editing Your Dimension. Lesson 15: Editing Your Cube. Lesson 16: Add ing New Dimensions and Measure Groups. Lesson 17: Using MDX. Lesson 18: Creating Calculations. Lesson 19: Data Mining. Lesson 20: Administering the SSAS Instance. Section IV: Reporting Services. Lesson 21: Understanding SSRS. Lesson 22: Using Report Wizard. Lesson 23: Building a Matrix Report. Lesson 24: Parameterizing Your Reports. Lesson 25: Building Reports on Your Cube. Lesson 26: Using Maps in Your Report. Lesson 27: Building a Dashboard. Lesson 28: Deploying and Ad ministering SSRS. Lesson 29: New Reporting Services Visualizations — Sparklines, Data Bars, and Indicators. Lesson 30: Using Report Builder. Section V: Containers. Lesson 31: Reporting against a Cube with Excel. Lesson 32: Loading Data into a PowerPivot Workbook. Lesson 33: Creating a PowerPivot Report. Lesson
read more read less

From the Publisher

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.

From the Jacket

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.

About the Author

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.

Item not added

This item is not available to order at this time.

See used copies from 00.00
  • My Gift List
  • My Wish List
  • Shopping Cart