In these sessions you will learn how to design a data warehouse, load it using
SSIS, place a cube on top of it using SSAS and report against it using SSRS.
Finally, you'll see how to performance tune and scale the data warehouse using
common techniques. All speakers have authored many of your favorite books from
Wrox.
Date and Time
All sessions are free. |
Session |
Description |
|
March 22 10AM and 1PM
View Recording
Webinar PowerPoint and Demos
SQL Mag 58% OFF!
|
Designing a Data Warehouse
Featuring: Joy Mundy

|
Topic Summary:
Improve the speed of your production can be as easy as giving your users a new
place to report against. In this session, you'll learn how a data warehouse can
benefit your organization and how to design one for SQL Server. You'll also see
at a high level how the data flows into the warehouse in a Microsoft data
warehouse ecosystem. |
|
March 23 9AM and 1PM
View Recording
SQL Mag 58% OFF!
|
Loading a Data Warehouse with SQL Server
Integration Services (SSIS)
Featuring: Devin and Brian Knight

|
Topic Summary:
Now that you have a data warehouse designed, how would you go about loading the
warehouse from your relational database that has been in production for years.
Join author Devin Knight in this session on how to use SSIS to load and
synchronize a data warehouse.
|
|
March 24 9AM and 1PM
View Recording
SQL Mag 58% OFF!
|
Introduction to Analysis Services (SSAS)
Featuring: Adam Jorgensen
 |
Topic Summary:
Tired of having to write hundreds of one-off reports? SQL Server Analysis
Services (SSAS) can help clear your report backlog by giving your users the
ability to perform ad-hoc reporting with pivot tables. Learn how to create a
SSAS cube, how to process it and finally view quick reports to answers questions
you didn't even know you had about your business. |
March 24 11AM
View Recording
SQL Mag 58% OFF!
|

Introduction to Data Mining
Featuring: Brian Knight |
Topic Summary:
Data mining is one of the key hidden gems inside of Analysis
Services but has a steep learning curve for most.
In this session, you’ll learn how to create a
data mining model to predict who is the best customer for you and learn how to
use other algorithms to spend your marketing model wisely. You’ll also learn how
to integrate data mining into your application.
|
|
March 25 9AM
View Recording
SQL Mag 58% OFF!
|
Report Design Recipes
for BI Solutions
Featuring: Paul Turley
 |
Topic Summary:
In this session, SSRS expert Paul Turley will show you how to build amazing
looking reports in Reporting Services. |
|
March 25 1PM
View Recording
SQL Mag 58% OFF!
|
Report Design for SSAS Cubes and MDX
Featuring: Paul Turley
 |
Topic Summary:
Reporting against a large data warehouse effectively can be challenging and time
consuming. In this session, you'll learn how to build dashboards and amazing
reports in Reporting Services that consume data from an Analysis Services cubes.
|
March 25 3PM
View Recording
SQL Mag 58% OFF!
|

Microsoft PowerPivot - changing the future of
Business Intelligence
Featuring: Donald Farmer
|
Topic Summary:
To the business user, PowerPivot includes an Excel-based environment for
powerful analysis of all your data; from tens of millions of rows from the
corporate datawarehouse, to personal data from your desktop. Analysing this data
is easy, with Pivot Tables, new filtering features, and expressions that make
light work of complex business calculations such as parallel periods,
contribution to parent, and hierarchical aggregations.
Once the analysis is
built, collaboration is through SharePoint, with a rich "social network" library
of published data documents, where the analysis can be refreshed, commented on,
and browsed from the web. For the IT department, PowerPivot offers a suite of
server tools that give insight and oversight to the business users' analysis and
collaboration.
Don't miss it - this is the future of business intelligence.
|
March 26 9AM
View Recording
SQL Mag 58% OFF!
|
Presenting BI inside of SharePoint
Featuring:
Mark Stacey
|
Topic Summary:
In this session, you'll learn how to view business intelligence data in the
world's best user interfaces for doing so, Excel and SharePoint. The speaker
will walk you through the benefits of the PowerPivot feature and how to view
your cube data inside of SharePoint 2007 and 2010. You won't want to miss this
session if you're new to modern user interfaces for BI. |
|
March 26 1PM
View Recording
SQL Mag 58% OFF!
|
SQL Server Fast Track Data Warehouse
Featuring: Mike Clark
|
Topic Summary:
SQL Server Fast Track Data Warehouse accelerates your data warehouse roadmap with
new SQL Server 2008 Enterprise scalable reference architectures for HP, Dell,
Bull, EMC and IBM. Reduce costs, save time and reduce risk with reliable
reference architectures and best practices for warehousing.
|