Denver SQL Server User Group March 2017 Meeting

Meeting Agenda:

5:30 – 6:00 – Food / Socializing

6:00 – 6:15 – User Group Business

6:15 – 6:30 – Open Panel/Questions & Answers

6:30 – 7:00 – Warmup presentation

7:00 – 8:00 – Main presentation

30-minute talk:

Abstract:

Democratizing Data Science with Microsoft

In times past, Data Science was only for those elite few with a rare combination of skills including advanced knowledge of statistics. Microsoft has been making sure that everyone can participate in the data revolution by giving people access to predictive API’s, in-database advanced analytics and drag-and-drop predictive experiments. All thanks to SQL Server 2016 and the Cortana Intelligence Suite in Azure. These advances have given people with less knowledge of statistics and programming the ability to become what Gartner calls citizen data scientists. Should we be worried about fools-with-tools or should we embrace the democratization of data science as the golden age of data? In this short session we focus on how Microsoft ensures democratization of data science and the possible dangers that lurk below the surface.

Bio: Jan Mulkens is a Microsoft BI Consultant and the Competence Center Lead for Microsoft Advanced Analytics at Ordina Belgium. In his spare time, he is a co-founder of the Global Power BI virtual user group, speaker at conferences and local SQL Server usergroups and he gives guest lectures at local colleges.

Download Slides: (20170317) Citizen Data Science with Microsoft

60-minute talk:

Abstract:

Up Close and Personal with the Tabular SSAS DMVs

Did you know that we got new Dynamic Management Views (DMVs) for the SQL 2016 SSAS Tabular models that also work with Power BI? They can be used to monitor the health of your database as well as to retrieve useful metadata. In this session, you’ll learn how to access and query SSAS DMVs as well as important data points found in the DMVs. Then I’ll demonstrate my Tabular Model Documenter based upon the DMVs and explain how I built it. You’ll walk away with a tool that automatically documents your tabular model, saving you from tedious manual documentation.

Bio: Meagan Longoria is a business intelligence consultant with BlueGranite who lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use Biml, SSAS, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings as well as through her blog (DataSavvy.me).

Download Slides: Tabular SSAS DMVs