Knight's Microsoft Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server Integration, Analysis, and Reporting Services with Excel and SharePoint
- 4h 24m
- Adam Jorgensen, Brian Knight, Devin Knight, Mike Davis, Patrick LeBlanc
- John Wiley & Sons (US)
- 2010
If you are just starting to get a handle on Microsoft Business Intelligence (BI) tools, this book 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 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
With Knight's Microsoft Business Intelligence 24-Hour Trainer, veteran authors present you with an ideal introductory book so that you can get started working with the BI toolset immediately!
About the Authors
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.
In this Book
-
Introduction
-
Why Business Intelligence?
-
Dimensional Modeling
-
Fact Table Modeling
-
Understanding SSIS
-
Using the Control Flow
-
Using the Data Flow
-
Solving Common SSIS Scenarios
-
Loading Dimensions
-
Loading a Fact Table
-
Deploying SSIS Packages
-
Understanding SSAS
-
Configuring a Data Source and Data Source View
-
Using the Cube Wizard
-
Editing Your Dimension
-
Editing Your Cube
-
Adding New Dimensions and Measure Groups
-
Using MDX
-
Creating Calculations
-
Data Mining
-
Administering the SSAS Instance
-
Understanding SSRS
-
Using Report Wizard
-
Building a Matrix Report
-
Parameterizing Your Reports
-
Building Reports on Your Cube
-
Using Maps in Your Report
-
Building a Dashboard
-
Deploying and Administering SSRS
-
New Reporting Services Visualizations — Sparklines, Data Bars, and Indicators
-
Using Report Builder
-
Reporting against a Cube with Excel
-
Loading Data into a PowerPivot Workbook
-
Creating a PowerPivot Report
-
Data Mining in Excel
-
Understanding SharePoint for Business Intelligence
-
Deploying and Using Reporting Services in SharePoint 2010
-
Building PerformancePoint Dashboards in SharePoint 2010
-
Deploying and Using Excel Services
-
Deploying and Using PowerPivot in SharePoint
-
Managing SharePoint Business Intelligence
