Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Archive for December 6th, 2010

PASS DW & BI Virtual Chapter December Lineup

Posted by denglishbi on December 6, 2010

This month the PASS Data Warehousing & Business Intelligence Virtual Chapter has a great lineup of sessions starting today.  The topics are Analysis Services, Data mining, PowerPivot, and Integration Services. 

Date – Time Topic (Presenter) Description Live Meeting URL
Mon, 12/6 – 12pm EST Add It Up: Analysis Services Aggregations (Craig Utley) Are you looking to maximize the performance of your Analysis Services queries? This session explains what aggregations are and how they work. You’ll learn how to create aggregations, tune the aggregations based on actual usage, and design custom aggregations when necessary. You’ll discover the benefits and pitfalls of flexible aggregations, when to use rigid aggregations, and the meaning of lazy aggregation processing. You’ll dive into queries to see if aggregations are being used and learn when aggregations aren’t useful. If you thought aggregation design began and ended with the aggregation wizard, you owe it to yourself (and your cubes) to attend this session https://www.livemeeting.com/cc/usergroups/join?id=BTK6PP&role=attend&pw=d%2CR%25%28%7C%24c9
Fri, 12/10 – 12pm EST Using OLAP to Optimize and Maintain Predictive Analytics Models (Eugene Asahara)

In complex Predictive Analytics (PA) scenarios where it is being applied to a complex system or the players involved are actually trying to undermine the predictions (ex: credit card fraud), the sophistication of the PA must be taken up a notch or two. In this Webcast I will describe techniques for building sophisticated PA systems on the Microsoft BI Stack by using OLAP to:

· Analyze, validate, and optimize PA models.

· Manage and Monitor the performance of the PA models in a Performance Management style.

· Surface PA results to end users in a manner that allows them to work through the ambiguity that remains around predictions.

Wed, 12/15 – 7pm EST Self-Service BI with PowerPivot – Examples!!! (Grant Paisley)

PowerPivot is a free add-in to Excel 2010 where you can build a full BI solution
with over 100 Million Rows (under the covers it is an “in memory cube” using
column compression).

In this presentation ,I’ll show you a solution with over 24million ATM transactions with rich visualizations.

What do you think the most number of times a person went back to the same ATM on the same day?

The most amount of money withdrawn?

What type of establishments have what withdrawal patterns?

For such simple data we uncover really interesting things…

Mon, 12/20 – 12pm EST SSIS + CDC = SCD (Patrick LeBlanc) Building dimensions using the Slowly changing dimension wizard in SSIS is simple and quick. However its performance and flexibility is questionable. Even further, when trying to perform incremental loads of your Dimensions using the aforementioned approach or a custom approach prior to Change Data Captured (CDC) offered certain challenges. In this session Patrick will show you how to utilize CDC and SSIS to incrementally load Type I and Type II dimensions ;using features that are all native to SQL Server 2008. https://www.livemeeting.com/cc/usergroups/join?id=53BGCZ&role=attend&pw=3%3C%2C9%27CDcs


These sessions are recorded with Live Meeting, so if you are unable to attend you can check these ones out at a later time or previous ones that have already been done – Presentation Archive.

Posted in Business Intelligence, SQL Server, Training | Tagged: , , | Leave a Comment »