Project 1: Working with Azure Data Factory, Data Lake and Azure SQL
Problem Statement: You are working as an Azure Architect for Zendrix Corp. This company is a service-based company, and has its major revenue from the sales it makes for its subscription-based service.
The company needs to continuously monitor its lead flow from different countries. This helps them in strategizing how much they need to invest in Ad-Marketing for a particular country, this in-turn helps them to achieve their desired sales targets.
Currently, the company has to manually synchronize data from their live SQL database to their BI tool, for checking the lead flow from different countries.
The company wants an automated solution, using which they will be able to see a live dashboard of the lead count. You as an Architect have suggested the following things:
- Use of Power BI Heat maps
- Use of Azure SQL instead of On-Premise SQL
- Use of Data Factory to automate the data lifecycle from SQL to the BI tool.
Help them achieve the above goals.
Project 2 : Identify the videos that get maximum traffic in selected YouTube channels
Problem Statement: Getting the real-time list of maximum traffic fetching videos from YouTube channels to promote advertisements in the same channels (traffic should be considered on a weekly basis)
Description: There is a company ‘XYZ Pvt. Ltd’ that promotes advertisements in the maximum traffic generating YouTube channels (on a weekly basis) to drive profits. To maximize profitability, the marketing team that manages the posting of advertisements requires an interface using which they can get a real-time list of YouTube channels for promoting advertisements and monitoring the analytics of traffic on those channels.
Objective: As an Azure Data Factory specialist, you are supposed to automate the transformation of the real-time video list from YouTube channels on a weekly basis. This will help the marketing team promote advertisements on the right YouTube videos on targeted channels.
Note: The traffic can be analysed on various parameters like number of views, and likes or comments on particular day. You can get this publicly available data from the YouTube API.