BI, Big Data, Data Analytics, and Data Visualization

SQT12 Skills Needed to Transition from DBA to Data Warehouse Architect


4:15pm - 5:30pm

Level: Intermediate

Thomas LeBlanc

Data Warehouse Independent Consultant

Data on the Geaux

Whether you're a development or administrative DBA, there's always room to expand your technical skills. Data Warehouse careers have certain skills that can develop from existing DBA skills. 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.

You will learn:

  • Updating skill set for transition from DBA to BI Developer/Architect
  • What is the difference between Database Normalization and Dimensional Modeling
  • The future of the Data Analyst - Big Data, Analytics, and so on