04 SQL Server 2016 - BI (Business Intelligence)

Are you working in the data space, with relational databases, big data, business intelligence, or advanced analytics? Wondering how Azure Data Services and/or SQL Server 2016 can help you do more and achieve more? With a focus on mission-critical performance, deeper insights across data, and hyperscale cloud, find out how Azure Data Services and SQL Server deliver. Don’t miss these courses, which cover the full scope and spectrum of the Microsoft data platform and analytics technologies.

This first Foundational course is designed to provide an overview of the breadth of Microsoft Data Platform & Analytics offerings. The Data Series then continues with one course on each of the component technologies in the data platform and analytics space. The Foundational course allows you to explore all significant data-related technologies across both Azure and SQL Server, with short (10 to 20 minutes each) high-level overviews of each. Watch the summaries, and then go in-depth with the courses and technologies that interest you most.
1 | SQL Server 2016
Get an overview of SQL Server 2016 and its mission-critical capabilities, with a focus on new features in the areas of performance, security, availability, and scalability.
2 | Azure Data Services
Get an overview of Microsoft Azure Data Services, including Azure SQL Database, Azure DocumentDB, Azure Tables, Azure Blobs, and the use of SQL Server in a Azure Virtual Machine.
3 | Modern Data Warehouse
Explore the role of the Modern Data Warehouse, and take a look at the distinction between traditional, operational, and logical data warehouses.
4 | SQL Server BI
Learn about the business intelligence capabilities of SQL Server 2016, especially Analysis Services, Reporting Services, and Hybrid BI features.
5 | SQL Server EIM
Get an overview of the objectives of Enterprise Information Management (EIM), and explore in more detail the three services by which SQL Server delivers EIM.
6 | Power BI
Learn how Power BI helps deliver a new generation of BI by extending business intelligence to everyone.
7 | Machine Learning
Begin with a definition of machine learning, and then explore the typical machine learning flow, roles, and challenges.
8 | Data Factory
Get a definition of the Azure Data Factory Service, a cloud-based data integration service that orchestrates and automates the movement and transformation of data.
9 | SQL Server R Services
Learn about Microsoft R and how it can deliver greater parallelism, scale, and speed, combined with simplicity and agility.
10 | Hadoop on Azure
Find out how Visual Studio makes working with Hadoop easier, and look at some of the benefits of an Azure-based approach to big data.
11 | Data Lake
Learn about Azure Data Lake, which uses a bottom-up approach and consists of Azure Data Lake Store and Azure Data Lake Analytics.
12 | Apache Spark
Learn about Apache Spark, a unified framework for big data analytics.
Post-Course Survey
Complete the post-course survey.
Learn
Gain a high-level understanding of SQL Server 2016 mission-critical and hybrid capabilities.
Gain a high-level understanding of Azure Data Services.
Gain a high-level understanding of Modern Data Warehouse.
Gain a high-level understanding of SQL Server BI.
Gain a high-level understanding of SQL Server Enterprise Information Management.
Gain a high-level understanding of Power BI.
Gain a high-level understanding of Azure Machine Learning.
Gain a high-level understanding of Azure Data Factory.
Gain a high-level understanding of SQL Server R Services.
Gain a high-level understanding of Hadoop on Azure.
Gain a high-level understanding of Azure Data Lake.
Gain a high-level understanding of Apache Spark.