SQLBits 2018
Data Overview and Manipulation - T-SQL, R, Python
Before doing any analysis, you have to prepare the data properly.
In a real data mining or machine learning project, you spend more than half of the time on data preparation and data understanding. The R language is extremely powerful in this area. The Python language is a match. Of course, you do work with data by using T-SQL. You will learn in this session how to get data understanding with really quickly prepared basic graphs and descriptive statistics analysis. You can do advanced data preparation with many data manipulation methods available out of the box and in additional packages fro R and Python. After this session, you will understand what tasks the data preparation involves, and what tools you have in SQL Server suite for these tasks.
Speakers
Dejan Sarka's previous sessions
Statistical Analysis in T-SQL
Learn how to analyze your data with pure T-SQL to get the performance you cannot reach with R, Python, or other tools. Learn the math behind as well.
Data Overview and Manipulation - T-SQL, R, Python
Before doing any analysis, you have to prepare the data properly.
Temporal Data in SQL Server
Use temporal support in SQL Server and add what is missing out of the box.
Analysing Text with SQL Server 2014
This session introduces SQL Server 2012 and 2014 text mining capabilities.
Optimizing Temporal Queries
Writing efficient queries with temporal predicates is finally not a problem anymore.
Excel 2013 Analytics
Excel is “The” analytical tool in Microsoft suite for advanced analysts. This session introduces Excel 2013 and 2010 business intelligence capabilities.
A Deep Dive in SQL Server 2012 Data Warehousing
In this session, we are going to explain and test different DW features in SQL Server 2012, including star join optimization through bitmap filters, table partitioning, window functions, columnstore indices and more.