search

manoojmj / Data-Engineering

0 stars 0 forks source link

Course Content #1

Open manoojmj opened 1 year ago

manoojmj commented 1 year ago

To Learn

manoojmj commented 1 year ago

Table of Contents

  1. Introduction to Microsoft Azure and Its Services
  2. Introduction to Azure Data Engineering
  3. Storing Data in Azure Azure Data Factory - I
  4. Azure Data Factory - II
  5. Azure Synapse Analytics - I
  6. Azure Synapse Analytics - II
  7. Data Warehouses using Azure Synapse Analytics - I
  8. Data Warehouses using Azure Synapse Analytics - II
  9. Optimizing Data Queries in Azure
  10. Managing Workloads in Azure Synapse Analytics
  11. Deep Dive into Azure Databricks
  12. Capstone Project
  13. Integrating Azure Data Solutions with Other Services (Self-paced)
  14. Security and Compliance (Self-paced)
  15. Monitoring and Optimizing Data Solutions (Self-paced)
  16. Industrial Case Studies (Self-paced)
  17. Scenario-Based Exam Dumps
  18. DP-203 Certification: Practice Exam
  19. Azure Data Engineering Interview Preparation
  20. Reference Material
  21. Bonus Content
manoojmj commented 1 year ago

Skills Covered:

  1. Design data storage solutions
  2. Analyze data using SQL and Spark
  3. Design and implement data security
  4. Monitor data storage and data processing
  5. Optimize data storage and data processing
  6. Create and manage data pipelines
manoojmj commented 1 year ago

Projects:

Data-Driven Decision-Making to Optimize Online Retail Customer Experience and Increase Sales

Problem Statement: The retail company needs to leverage data-driven decision-making techniques to understand customer behavior and sales patterns in order to stay competitive. Real-time analysis of customer preferences, purchase history, and buying habits is essential for optimizing marketing campaigns and online store layouts, resulting in a personalized and engaging shopping experience. The desired outcome is increased sales and improved customer loyalty.

Goal: As a certified Azure data engineer, the goal is to analyze real-time customer data to optimize marketing campaigns and online store layout, driving sales growth and customer loyalty.

Enhancing Data Processing and Analysis Capabilities for Advertising Analytics Company

Problem Statement: An advertisement analytics firm seeks to enhance data processing and analysis. They receive vast daily data from multiple sources (social media, search engines, websites) regarding user behaviour (clicks, views, impressions) and user demographics (age, gender, location). Real-time data processing is necessary to extract insights for better advertisement campaigns.

Goal: As an Azure Data Engineer, the objective is to present a real-time data processing and analysis scenario for an advertisement analytics company.

manoojmj commented 1 year ago

Visualisation - Python / R ETL Power BI, MS BI

Cloud Data Engineering/Data Engineer

Tools:

Azure Synapses ADF - SQL