Date: Wednesday, June 8, 2016
Location: The Louisiana Technology Park - http://www.brssug.org/where
Sponsor: Idera (SQL) and Pyramid Analytics (Power BI)
Agenda:
5:45 - 6:15 pm: Networking and Dinner with the other user groups
6:15 - 6:30 pm: Announcements, Sponsor Message, and Lightning Talks
6:30 - 7:00 pm: User Group business
7:00 - 8:00 pm: Main Topic Speaker
8:00 - 8:30 pm: Raffle and Giveaways
This will be a joint meeting with the Baton Rouge Power BI User Group (BRPBIUG)
Main Topic: Skills Needed to
Transition From DBA to BI/DW Architect
Abstract: Dimensional Modeling is a re-tooling of your
existing database normalization knowledge. T-SQL and coding knowledge can
transfer to ETL (Extract, Transform and Load) using Integration Services
(SSIS).
Report Writing has been around for decades and
learning Analysis Services (SSAS) can save days of work that custom report
writing has taken teams.
Development today requires the design and
analysis of Online Transaction Processing (OLTP) to take into account Data
Warehousing/OLAP (Online Analytical Processing) output.
My personal transition from Sr. DBA to DW
Architect has been a process of sanding the rough edges of my passion from
fully normalized databases.
The Dimensional Modeling started a re-tooling
of my mind to look at end results analytically. These lessons have molded me
into a DW Architect.
Speaker: Thomas LeBlanc
Thomas LeBlanc is a Data
Warehouse Architect in Baton Rouge, and uses his 26 years in IT to help develop
OLTP systems with
normalized databases for
high-performing T-SQL and end-to-end dimensional data marts using SSIS, SSAS,
PPS, and Excel. His SQL Server certifications
include MCSA 12, MCITP 08 BI and
DBA, MCITP 2005 DBA, and MCDBA 2000. As a PASS volunteer, he is current chair
of Excel BI VC, past chair of Data Arch VC and is
active in the Baton Rouge UG and
SQLSaturday.
Important Announcement!
Registering for the PASS Summit in October? Use this code for a discount! LC15BGL5