Skip Main Navigation
Page Content
This event has ended

SQL Saturday 85 BI Day of Training

OPASS & MAGICPASS

Friday, September 23, 2011 from 9:00 AM to 5:00 PM (EDT)

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
SQL Saturday 85 Pragmatic Works BI Day of Training *EARLY BIRD PRICE 46 Tickets Ended $99.00 $3.46
SQL Saturday 85 Pragmatic Works BI Day of Training 41 Tickets Ended $119.00 $3.96

Share SQL Saturday 85 BI Day of Training

Event Details

Business Intelligence Workshop
Jorge Segarra, Bradley Schacht, Kyle Walkter, &  Mike Davis

Abstract:

In this full-day workshop, you'll learn from the author team of Jorge Segarra, Mike Davis, Brad Schacht, and Kyle Walker how to build a data warehouse for your company and support it with the Microsoft business intelligence platform. We'll start with how to design and data model a data warehouse including the system preparation. Then, we'll jump into loading a data warehouse with SSIS. After SSIS, you're ready to roll the data up and provide the slice and dice reporting with SSAS. The team will walk through cube development and data enrichment with things like key performance indicators, which are essential for your future dashboards. Lastly, we will cover how to report against the data warehouse with SSRS including a primer in how to write MDX queries against the SSAS cube.

Take Home Skills:

  1. Practical knowledge of building a Dimensional Model
  2. Designing a simple ETL process using SSIS
  3. Designing a Cube
  4. Designing simple SSRS Reports
  5. Building an integrated process that fully leverages the entire MS BI stack to load a Data Warehouse

 

Speaker Bio(s)

Jorge Segarra  

 

Speaker photoJorge is a BI Consultant for Pragmatic Works and a SQL Server MVP. In addition to being a member of the Jacksonville SQL Server User Group (JSSUG) he is also a PASS Regional Mentor for the U.S. Greater Southeast region. He has also co-authored the book from Apress “SQL 2008 Pro Policy-Based Management“. Redgate Exceptional DBA of the Year 2010 Finalist.

 

 

 

Bradley Schacht  

 

Bradley is a consultant at Pragmatic Works in Jacksonville, FL. He was an author on the book SharePoint 2010 Business Intelligence 24-Hour Trainer. Bradley has experience on many part of the Microsoft BI platform. He has spoken at events like SQL Saturday, Code Camp, SQL Lunch and SQL Server User Groups. He is a contributor on sites such as BIDN.com and SQL Server Central as well as an active member of the Jacksonville SQL Server User Group (JSSUG).

 

 

 

Kyle Walker  

 

Kyle is a Business Intelligence consultant for Pragmatic Works. His current and past work experience includes Integration Services, data warehousing concepts, Reporting Services, and Crystal Reports. He is active in the local and online community as a speaker for SQL Lunch, Jacksonville SQL Server Users Group, and past SQLSaturday events, as well as a blogger on BIDN.com.

 

 

 

Mike Davis  

 

Mike Davis, MCTS, MCITP, is a Senior BI consultant at Pragmatic Works. He is an author of a few Business intelligence books. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, SQL Rally, and SQL Saturday events. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.

 


 

 

 

 

 

 


Have questions about SQL Saturday 85 BI Day of Training? Contact OPASS & MAGICPASS

When & Where


Orland Marriot Lake Mary
1501 International Parkway
Lake Mary, FL 32746

Friday, September 23, 2011 from 9:00 AM to 5:00 PM (EDT)


  Add to my calendar

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.