'How Do I BI?' screencast series

  • Article

 

As a companion to my new book "Smart Business Intelligence Solutions with Microsoft SQL Server 2008" (MSPress, ISBN-13: 9780735625808), I am beginning to record this screencast series. Here's the planned series outline - links will become active as I record, edit and then upload completed screencasts. I welcome comments and feedback via this blog. 

I will update this blog page frequently as I work on the series.

FAQ

1. Who is this series for? BI Developers who use SQL Server Analysis Services 2008

2. What will the series cover? OLAP cubes and Data Mining Structures

3. What is covered in each screencast? 5-15 min. screencast recording of procedural executation for one particular topic, ex. 'How do I create a data source?'

4. What is NOT covered? Architecture and modeling considerations - read my book for that!

5. What is the outline? Listed below (subject to revision)

6. How do I ask you a question? Send me mail via this blog

7. What formats will be available? The plan is for streaming and downloadable video and audio only (i.e. podcast)

8. Can I get the power point decks? The intent is to use only a couple of opening and closing slides, these will be recorded as part of the screencasts.

9. Will you cover ETL or reporting? Maybe, it depends on time and demand, I'll start with SSAS only.

10. Will you speak live at my event? Send speaking requests to me via this blog with this info - date, time, location, group size, composition.

 Series Webcasts

1. Getting started - what you must install and configure to build OLAP cubes or Data Mining Models
2. BI Dev Tools - SSMS, Profiler, BIDS
3. Installing the AdventureWorks DW samples
4. Examining a cube in BIDS
5. Examining a data mining structure in BIDS
6. Creating Data Sources in BIDS
7. Creating Data Source Views in BIDS
8. Examining Dimensions in BIDS - about Hierarchies and Attributes
9. Working with the Cube Editor in BIDS - Dimension Usage
10. Working with the Cube Editor in BIDS - KPIs
11. Working with the Cube Editor in BIDS - Calculations
12. Working with the Cube Editor in BIDS - Actions
13. Working with the Cube Editor in BIDS - Translations
14. Working with the Cube Editor in BIDS - Partitions
15. Working with the Cube Editor in BIDS - Aggregations
16. OLAP Database Security
17. OLAP cube performance monitoring using Profiler
18. OLAP cube scalability
19. Understanding AMO warnings for OLAP cubes (advanced)
20. Future directions for OLAP cubes

1. Exploring Data Mining models in BIDS- algorithms 1,2,3
2. Exploring Data Mining models in BIDS- algorithms 4,5,6
3. Exploring Data Mining models in BIDS- algorithms 7,8,9
4. Using content and data types
5. Using input, predict and predictOnly
6. Using Lift Charts
7. Using Profit Charts
8. Using Cross Validation
9. Using DMX Queries
10. Using DM model processing, training
11. Application integration - with SSIS
12. Applicatoin integration - with Excel - table analysis
13. Application integration - with Excel - data mining ribbon
14. Appliction integration - using embeddable controls
15. Performance tips and best practices