Skip Navigation Links
SQL Server Global Webinar Series

March Webinar Series: Week of Business Intelligence

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.

Please be sure to install gotomeeting video codec’s , those unable to play webinar recordings should click here

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.