A Gentle Introduction to Data Analytics in SQL Server 2016

Overview

Explore data analytics using SQL Server 2016, comparing it to BI and data science. Learn to organize data, use Power BI, R, and Analysis Services for exploration and visualization techniques.

Syllabus

• Introduction to Data Analytics and SQL Server 2016
Overview of Data Analytics
Introduction to SQL Server 2016
Comparing Data Analytics, BI, and Data Science
• Understanding and Organizing Data
Data Types and Structures in SQL Server
Importing and Exporting Data
Data Cleansing and Preparation Techniques
• SQL for Data Exploration
Basic SQL Queries
Aggregation and Grouping
Joining Tables and Data Relationships
• Introduction to SQL Server Analysis Services
Setting up Analysis Services
Creating and Managing OLAP Cubes
Multi-Dimensional Expressions (MDX)
• Data Visualization with Power BI
Introduction to Power BI
Connecting Power BI to SQL Server
Creating Interactive Dashboards and Reports
• Introduction to R in SQL Server
Setting up R Services in SQL Server
Basic R Scripts and Integration with SQL
Advanced Data Analysis with R
• Advanced Exploration and Visualization Techniques
Predictive Modeling with SQL
Advanced Visualization Techniques in Power BI
Exploring Statistical Models and Hypothesis Testing with R
• Real-World Applications and Case Studies
Case Study on Business Intelligence Solutions
Data Analytics Project utilizing SQL, Power BI, and R
Best Practices and Future Trends in Data Analytics
• Final Project
Designing and Implementing a Data Analytics Solution
Presentation and Peer Review of Projects

Subjects

Conference Talks