This event has ended

SQL Saturday #215 Building a SQL Server 2012 BI Platform

Jacksonville SQL Server User Group

Friday, April 26, 2013 from 8:30 AM to 4:30 PM (EDT)

Jacksonville, FL

Ticket Information

Ticket Type Sales End Price Fee Quantity
Early Bird Special Ended $99.00 $3.47
Regular Price Ended $120.00 $3.99

Who's Going

Loading your connections...

Share SQL Saturday #215 Building a SQL Server 2012 BI Platform

Event Details

Building a SQL Server 2012 BI Platform

Presenters: Brian Knight (@brianknight) and Devin Knight (@knight_devin)

In this day-long seminar, you'll learn how to build a Business Intelligence solution for your company and support it with the Microsoft platform. We'll start with how to design and data model a data warehouse, including the system preparation. Then, we'll jump into using SQL Server Integration Services to load the data warehouse. 

After the data warehouse is loaded, you're ready to roll up the data and provide slice and dice reporting with SQL Server Analysis Services. We'll walk through cube development and enriching your cubes with added business metrics, which are essential for your future dashboards. Last, we'll cover how to report against the data warehouse with SQL Server Reporting Services and SharePoint BI. Make sure you bring your own optional laptop so you can follow along as we design, load, and report against our BI solution.

  • Design
    • Project Management Methodology
    • Designing a Data Warehouse
  • Load
    • Loading a Dimension Table
    • Loading a Fact Table
    • Scaling the Data Load
  • Aggregate
    • Analysis Options
    • Tabular Vs Multidimensional
    • Designing a Tabular Model
    • DAX
    • Calculations
    • KPIs
  • Report
    • Building a Basic Matrix Report on SSAS
    • Building a Dashboard
    • Using other Microsoft Presentation Layer Tools


Seminar includes lunch and refreshments. 

Be sure to return back the following day for SQL Saturday #215 which is filled with many free sessions and networking.  For more info and to register for SQL Saturday, please visit the event website: http://www.sqlsaturday.com/215/eventhome.aspx

Have questions about SQL Saturday #215 Building a SQL Server 2012 BI Platform? Contact Jacksonville SQL Server User Group

When & Where



University of North Florida
1 UNF Drive
Building 15
Jacksonville, FL 32224

Friday, April 26, 2013 from 8:30 AM to 4:30 PM (EDT)


  Add to my calendar

Organizer

Jacksonville SQL Server User Group

The Jacksonville SQL Server Users Group (JSSUG) was founded by Brian Knight in January 2003, creating a community for database developers and administrators in the Jacksonville area. The goal of JSSUG is to share knowledge, best practices, and network. Today, it is a community focusing on development, administration, and business intelligence.
Free meetings are open to the public the third Wednesday of every month. Meetings include presentations, technology announcements, local job opportunities, and quick brainstorming/guidance for users experiencing difficulty. An after event is hosted by Scott Gleason for additional networking, shop talk, and users desiring more detailed guidance for specific challenges.
  Contact the Organizer

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.