A Gentle Introduction to Data Analytics in SQL Server 2016

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Explore data analytics in SQL Server 2016 through this comprehensive PASS Data Community Summit presentation. Learn the distinctions between data analytics, business intelligence, and data science while discovering how to leverage analytics within the Microsoft Data Platform. Organize data effectively for analysis using the Bike Buyers example. Gain hands-on experience exploring data with Power BI, R in SQL Server, and Analysis Services Data Mining. Dive into various visualization techniques for analytics, including histograms, scatter plots, column charts, and categorical variable representations. Master the art of presenting single variables, continuous variables, clustered data, and ratios through practical demonstrations in R-SQL Server, Power BI, and Azure Machine Learning.

Syllabus

Intro
Technical Assistance
Overview
Data Analytics vs Business Intelligence vs Data Science
Comparing Data Analytics to Business Intelligence
And Then There's Data Science.
Using Analytics in the Microsoft Data Platform
Organizing Your Data for Analytics
Bike Buyers
Explore Your Data with Power BI
Explore Your Data with R - SQL Server
Explore Your Data with R-SQL Server
Explore Your Data with Analysis Services Data Mining
Exploring Visualizations for Analytics
Single Variables
Histogram in R-SQL Server Data
Histogram in Power BI (Model)
Visualization in Azure Machine Learning
Discrete Data in Column or Bar Charts
Two Continuous Variables: Scatter plot
Clustered Categorical Variables
Ratios of Categorical Variables
Categorical Variables as Multiples