Preparing for 70-445 and 70-446
I have been wanting to get into BI for some time now. My experience includes installation and some light troubleshooting on SSRS and SSAS 2005. I have some light performance tuning of SSAS 2000 and 7.0 OLAP. I have had intentions of attending BI sessions at the conferences but I always end up in the performance or internals sessions. This may be because most of the session would be over my head.
I am going to start with the basics and work my way up. With the available material, I will have to pull from many sources. The good thing about this is it will give me more real world knowledge but the test may be a little harder without “test prep” type material.
Here is my study material. If anyone has any other resources, please let me know. jason****remove****@statisticsio.com
Books:
McGraw Hill Osborne Delivering Business Intelligence with Microsoft SQL.Server 2005
Addison Wesley Practical Business Intelligence with SQL Server 2005
Wrox Professional SQL Server 2005 Reporting Services
MS Press – Microsoft SQL Server 2005 Reporting Services Step-By-Step
MS Press – Microsoft SQL Server 2005 Analysis Services Step-By-Step
MS Virtual Labs:
- Auto-generate a Report Model in Model Designer
- Refine the model using model item properties
- Understand how model item properties affect end user reporting
- Create a SQL Server 2005 Integration Services (SSIS) package
- Create an SSIS package project
- Monitor the progress of an SSIS package
- Log results from an SSIS package to both a text file and the Windows Event log
- Create an Analysis Services cube
- Create dimension attributes and hierarchies
- Create calculated members and Key Perfomance Indicators (KPIs)
- Create Decision Tree and Naïve Bayes Data Mining Models
- View Mining Accuracy Charts
- Create a Prediction Query
- Model Time Series
- Familiarize users with the workspace
- Instruct users in the procedure for using already existing scorecard
- Instruct users in the procedure for modifying already existing scorecard
- Instruct users in the procedure for deploying a scorecard to a SharePoint site
- Create a SQL Server Integration Services (SSIS) package
- Monitor the progress of a SSIS package
- Log results from a SSIS package to both a text file and the Windows Event Log
- Use the new SQL Server Management Studio
- Perform basic SQL Server administration tasks
- Create an Analysis Services cube
- Create dimension attributes and hierarchies
- Create calculated members and Key Performance Indicators (KPIs)
- Create a Report Using the Wizard
- Create a List Report
- Manage Security
- Auto-generate a Report Model in Model Designer
- Refine the model using model item properties
- Understand how hodel item properties affect end user reporting
On a side note, the pickings are slim for BI at Microsoft eLearning.
https://www.microsoftelearning.com/catalog/itproDev.aspx#sqlServer
New DMF in SP2 – sys.dm_exec_text_query_plan
Here is a DMF of interest in sp2. This could be applied some of my previous blogs.
sys.dm_exec_text_query_plan
Returns the Showplan in text format for a Transact-SQL batch or for a specific statement within the batch. The query plan specified by the plan handle can either be cached or currently executing. This table-valued function is similar to sys.dm_exec_query_plan, but has the following differences:
select * from
sys.dm_exec_requests cross apply sys.dm_exec_text_query_plan(plan_handle)
My RSS
-
My LifeStream
My Presence
