Have you ever started a warehouse or ETL project and realized that the data wasn’t as “clean” as you were told? If only you had profiled your data before you started then you wouldn’t have to rework design elements, change code or redesign your database. In this session we will talk about what data profiling is, why you should do it and how you can do it with tools that are already included in the SQL Server BI stack.
Angela Henry is a DBA/BI Developer, living in High Point, NC and loves what she does. She's worked with all versions of SQL Server and worn all the hats that come with dealing with SQL Server throughout the years: developer, administrator, data architect and BI developer. She has her MSCE: Business Intelligence and is a Data Platform MVP. She volunteers with PASS in various capacities, ranging from Program Committee to cleanup at local SQL Saturday events. She is also the chapter leader for the PASS Triad SQL User Group in Greensboro, NC. In her spare time you can probably find her in the pool, she's an avid US Masters swimmer, Coach and Instructor.