June '16 BRSSUG / PowerBI Meeting

posted Jun 1, 2016, 12:51 PM by BRSSUG SQLPass BatonRouge   [ updated Jun 8, 2016, 7:09 AM by william assaf ]

DateWednesday, June 8, 2016

LocationThe Louisiana Technology Park - http://www.brssug.org/where


SponsorIdera (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

ć
william assaf,
Jun 9, 2016, 9:02 AM
Comments