Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

A Gentle Introduction to Data Analytics in SQL Server 2016

PASS Data Community Summit via YouTube

Overview

Limited-Time Offer: Up to 75% Off Coursera Plus!
7000+ certificate courses from Google, Microsoft, IBM, and many more.
This course provides a gentle introduction to data analytics in SQL Server 2016. The learning outcomes include understanding the differences between data analytics, business intelligence, and data science, exploring data analytics tools within the Microsoft Data Platform, organizing data for analytics, and creating various visualizations for analytics. The course teaches skills such as using Power BI, R, SQL Server, and Analysis Services Data Mining for data exploration and visualization. The teaching method involves presentations and demonstrations by the instructor and moderator. The intended audience for this course is individuals interested in learning the basics of data analytics using SQL Server 2016.

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

Taught by

PASS Data Community Summit

Reviews

Start your review of A Gentle Introduction to Data Analytics in SQL Server 2016

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.