MPN Competency: Data Platform & Analytics Foundational for Data Analytics Competency MPN14356 (April 2017)

Learning path description

Technical Assessment: Technical Assessment Data Analytics Foundational

Keywords

Exams & accreds : Technical assessments
MPN Competency : Data Analytics
Partner Type : Licensing Solution Providers (LSPs)
Product : Data Platform Solutions (SQL Server 2016)
Role : Technical
Country : Global
SQL Server 2016 for Data Analytics Foundational [0 h 13 m]

This module overviews SQL Server 2016 and it's mission-critical and performance capabilities with a focus on new features in the area of performance, security, availability and scalability.

Launch course
Azure Data Services for Data Analytics Foundational [0 h 11 m]

This module overviews Microsoft Azure Data Services including Azure SQL Database, Azure DocumentDB, Azure Tables, Azure Blobs and the use of SQL Server in a Azure VM.

Launch course
Modern Data Warehouse for Data Analytics Foundational [0 h 10 m]

This module discusses the role of the modern data warehouse and draws the distinction between Traditional, Operational and Logical data warehouses. It then positions the main data warehouse options provided by Microsoft, specifically SQL Server 2016, Azure Data Warehouse and Azure Data Lake. The module finishes with more detail on Azure Data Warehouse.

Launch course
SQL Server BI for Data Analytics Foundational [0 h 15 m]

This module discusses the Business Intelligence capabilities of SQL Server 2016. Most notably this includes Analysis Services, Reporting Services and Hybrid BI features.

Launch course
SQL Server EIM for Data Analytics Foundational [0 h 19 m]

This module overviews the objectives of "Enterprise Information Management" (EIM) and then goes into more detail on the three services by which SQL Server delivers EIM, specifically SQL Server Integration Services, SQL Server Master Data Services, and SQL Server Data Quality Services.

Launch course
Power BI for Data Analytics Foundational [0 h 15 m]

This module discusses how Power BI helps deliver a new generation of BI by extending Business Intelligence to everyone. The module overviews Power BI with a focus on what Data Sources are supported, and how Power BI delivers solutions for each of Business Users, Business Analysts, BI Professionals and Software Developers.

Launch course
Data Factory for Data Analyics Foundational [0 h 9 m]

This module defines the Azure Data Factory Service a cloud-based data integration service that orchestrates and automates the movement and transformation of data. It then talks in more detail how Azure Data Factory Service delivers Pipelines, Activities, Data Movement, Data Transformation and Linked Data Services. It then covers the important concepts of Datasets, the relationship between Data Factory entities and Data Flow Concepts.

Launch course
Machine Learning for Data Analyics Foundational [0 h 11 m]

This module begins with a definition of Machine Learning, the typical Machine Learning Flow, Roles and challenges. It then goes on to introduce Azure Machine Learning and how it can be used in typical Business Scenarios.

Launch course
SQL Server R Services for Data Analyics Foundational [0 h 13 m]

This module starts with a definition of "R" as a open source statistics programming language and data visualization tool that is taught in most universities and is supported by a large community and Ecosystem of developers and free add-ons & applications. We then go on to discuss Microsoft "R" and how it can deliver greater parallelism, scale and speed, combined with simplicity and agility. The module ends with a look at he Predictive Analytics Process and the role of "R".

Launch course
Hadoop on Azure for Data Analytics Foundational [0 h 16 m]

This module begins with a definition of Big Data and the business imperative it represents. It then goes on to introduce Apache Hadoop and it's components (HDFS, MapReduce, &Yarn). We then go on to discuss HDInsight which is a standard Apache Hadoop distribution offered as a managed service on Microsoft Azure. This is followed by a description of how HDInsight supports Hive (a SQL-like language which is subset of SQL), HBase (a NoSQL database on data in HDInsight), Mahout ( a machine learning library), Storm (Stream Analytics for near real-time processing), and Spark (In-memory processing on multiple workloads). Finally w look at how Visual Studio makes working with Hadoop easier and we look at some of the benefits of an Azure based approach to Big Data.

Launch course
Data Lake for Data Analytics Foundational [0 h 14 m]

This module begins with a look at the two approaches to information management for analytics: Top-down and bottom-up. Azure Data lake uses a bottom-up approach and consists of Azure Data Lake Store and Azure Data Lake Analytics. Azure Data Lake Store is a highly scalable, distributed, parallel file system in the cloud specifically designed to work with multiple analytic frameworks. It is built from the ground up as a Hadoop file system, supports for file/folder objects and operations and integrates with HDInsight, Hortonworks, and Cloudera. Azure Data Lake Analytics is built on Apache YARN, scales dynamically with the turn of a dial, supports pay by the query & Azure Active Directory for access control, roles, and integration with on-premises identity systems. Further more it is built with U-SQL to unify the benefits of SQL with the power of C#.

Launch course
Apache Spark for Data Analytics Foundational [0 h 10 m]

This module discusses Apache Spark a unified framework for big data analytics. Apache Spark SQL includes Spark SQL ( for Interactive queries), Spark Streaming (for stream processing), Spark Mlib (Machine Learning Library) and GraphX (for graph computation).

Launch course
Resources for Foundational Data Analytics [0 h 0 m]

Resources for Foundational Data Analytics

Launch course
Technical Assessment Data Analytics Foundational [1 h 0 m]

Technical Assessment Data Analytics Foundational

Launch course

Saving please wait...

containiner