70-475 Designing and Implementing Big Data Analytics Solutions (3 Days)
552241-Microsoft Azure Big Data Analytics Solutions Part 1
70-475 Designing and Implementing Big Data Analytics Solutions- is a three-day instructor-led Boot Camp course is intended for data professionals who want to expand their knowledge about creating big data analytic solutions on Microsoft Azure. Students will learn how to design solutions for batch and real-time data processing. Different methods of using Azure will be discussed and practiced in lab exercises, such as Azure CLI, Azure PowerShell and Azure Portal.
About This Course
552241 is a two-day instructor-led course is intended for data professionals who want to expand their knowledge about creating big data analytic solutions on Microsoft Azure. Students will learn how to design solutions for batch and real-time data processing. Different methods of using Azure will be discussed and practiced in lab exercises, such as Azure CLI, Azure PowerShell and Azure Portal.
552241 labs and exercises will cover the first two objectives of exam 70-475 (Designing Big Data batch, interactive & real-time solutions). The other objective (Operationalize end-to-end cloud analytics solutions) is covered in 552242.
Audience Profile
This course is intended for experienced data professionals who design big data analytics solutions on Microsoft Azure.
At Course Completion
- Design big data batch processing and interactive solutions (552241A)
- Design big data real-time processing solutions (552241A)
- Operationalize end-to-end cloud analytics solutions (552242A)
Course Details
Module 1: Design big data batch processing and interactive solutions (552241)
This module explains how to load data into Microsoft Azure for batch processing.
Lessons
- Ingest data for batch processing
- Design for batch processing
- Design interactive queries
- Review
Lab 1: Design big data batch processing and interactive solutions
- Load data into Microsoft Azure
- Prepare data for batch processing
- Query the data
After completing this module, students will be able to:
- Load data into Microsoft Azure
- Prepare data for batch processing
- Query the data
Module 2: Design Big Data Real-Time Processing Solutions (552241)
This module explains how to load data into Microsoft Azure for real-time processing.
Lessons
- Ingest data for Real-Time Processing
- Designing for Real-Time Processing
- Design interactive queries for Big Data
- Review
Lab 1: Design Big Data Real-Time Processing Solutions
- Load data into Microsoft Azure
- Prepare data for Real-Time Event Processing
- Visualize the Data
After completing this module, students will be able to:
- Load data into Microsoft Azure
- Prepare data for real-time event processing
- Visualize the data
Module 3: Operationalize end-to-end cloud analytics solutions (552242)
This module explains how to Azure Data Factory to centrally manage data from different sources.
Lessons
- Create a data factory
- Create a data-driven workflow
- Monitor and Manage the data factory
- Move, Transform and Analyze Data
- Design a deployment strategy for an end-to-end solution
- Review
Lab 1: Operationalize end-to-end cloud analytics solutions
- Create a data factory
- Create a data-driven workflow
- Monitor and Manage the data factory
- Move, Transform and Analyze Data
- Design a deployment strategy for an end-to-end solution
After completing this module, students will be able to:
- Create, Manage & Monitor a data factory
- Create a data driven workflow
- Move, Transform and Analyze Data
- Create a deployment strategy using PowerShell
Module 4: PowerShell for Technology Professionals (552241 Optional)
This module explains how to use PowerShell to administer computer, network, application and Azure resources.
Lessons
- Introduction
- Compared to Other Scripting Languages
- Configuring and Using PowerShell
- Creating and Running Scripts
- Administering Local Resources
- Administering Network Resources
- Resolve PowerShell Scripting Problems.
Lab 1: Operationalize end-to-end cloud analytics solutions
- Use PowerShell to get Computer Information
- Use PowerShell documentation to understand and use cmdlets
- Create and execute scripts
- Configure and test Remote Management
- Create and Azure VM with Azure PowerShell
After completing this module, students will be able to:
- Use PowerShell to get Computer Information
- Use PowerShell documentation to understand and use cmdlets
- Create and execute scripts
- Configure and test Remote Management
- Create and Azure VM with Azure PowerShell
Prerequisites
- Experience processing and querying bulk data
- Experience analyzing real-time and historical data
- Experience using SQL and data analysis / visualization tools (e.g. Power BI)
- Experience using PowerShell (Note: A basic PowerShell tutorial is included in the course.)
552242 - Operationalize Cloud Analytics Solutions with Microsoft Azure Part 2
About this course
552242 is a two-day instructor-led course intended for data professionals who want to expand their knowledge about creating big data analytic solutions on Microsoft Azure. Students will learn how to operationalize end-to-end cloud analytics solutions using the Azure Portal and Azure PowerShell. It can be used on its own or with 552241, Microsoft Azure Big Data Analytics, to prepare for exam 70-475.
Audience profile
This course is intended for experienced data professionals who design and build big data analytics solutions on Microsoft Azure.
Prerequisites
Before attending this course, students must have:
- Experience processing and querying bulk data
- Experience analyzing real-time and historical data
- Experience using SQL and data analysis / visualization tools (e.g. Power BI)
- Experience using PowerShell (Note: A basic PowerShell tutorial is included in 552241.)
At course completion
After completing this course, students will be able to:
- Create a Data Factory
- Orchestrate data processing activities in a data-driven workflow
- Monitor and Manage a Data Factory
- Move, Transform or Analyze data
- Design a deployment strategy for end-to-end solutions with Azure Portal or PowerShell
Course OutlineModule 1: Operationalize end-to-end cloud analytics solutionsThis module explains how to Azure Data Factory to centrally manage data from different sources.Lessons
- Create a data factory
- Create a data-driven workflow
- Monitor and manage the data factory
- Move, Transform and Analyze Data
- Design a deployment strategy for an end-to-end solution
- Review
Lab : Operationalize end-to-end cloud analytics solutions
- Create a data factory
- Create a data-driven workflow
- Monitor and manage the data factory
- Move, Transform and Analyze Data
- Design a deployment strategy for an end-to-end solution
After completing this module, students will be able to:
- Create, Manage & Monitor a data factory
- Create a data driven workflow
- Move, Transform and Analyze Data
- Create a deployment strategy using the Azure Portal or PowerShell
Module 2: Appendix B: PowerShell for Technology Professionals (Optional)This module explains how to use PowerShell to administer computer, network, application and Azure resources.Lessons
- Introduction
- Compared to Other Scripting Languages
- Configuring and Using PowerShell
- Creating and Running Scripts
- Administering Local Resources
- Administering Network Resources
- Resolve PowerShell Scripting Problems.
Lab : Lab B: Operationalize end-to-end cloud analytics solutions
- Use PowerShell to get Computer Information
- Use PowerShell documentation to understand and use cmdlets
- Create and execute scripts
- Configure and test Remote Management
- Create and Azure VM with Azure PowerShell
After completing this module, students will be able to use PowerShell to:
- Use PowerShell to get Computer Information
- Use PowerShell documentation to understand and use cmdlets
- Create and execute scripts
- Configure and test Remote Management
- Create and Azure VM with Azure PowerShell
Additional Reading
To help you prepare for this class, review the following resources: