Master's in Power BI for Azure Data Factory

This real-life-based project on YouTube requires the learners to fetch a list of videos from the dataset of YouTube channels with the highest views and likes to promote advertisements on the channel with maximum traffic.

Practically work with Azure data factory, data kake, and SQL and create an automated solution that would enable the organization to see a real-time dashboard of the lead count with Power BI Heat maps, Azure SQL, etc.

Get the real-time list of maximum traffic-fetching videos from YouTube channels. Automate the transformation of the real-time video list on a weekly basis. The traffic can be analyzed on various parameters on a particular day.

This case study will help you design a dashboard with a basic set of visualizations and deploy it to Power BI cloud service. A top-level brief overview of transport corp data is shown using aggregated KPIs, trends, filters, etc.

This case study will help you successfully understand the workings of Azure Batch, flow process of data factory, and types of integration runtime in Azure data factory, and transform data by mapping data flows.

This case study will give you an opportunity to create, view, and manage metric alerts by using Azure monitor. You will use Azure SQL database auditing and implement Azure security logging and auditing.

This interesting project on relational databases allows the learners to work with various data types, table basics, SQL functions, and SQL operators to acquire customer details through database querying.

You will learn to convert rational design in this project. The rational designs will usually be enlisted within user roles and user accounts. You will define attributes and primary keys, and create respective foreign keys.

Design a dashboard by using Power BI DAX formulas. Bucketed categories are created to represent value measures on the categories axis. A scatter plot is also used to identify outliers or outperformers.

As part of this case study, you need to design an audit dashboard by making use of power query and query editor to perform data modeling by applying data transformations, which, in turn, will be done by managing relationships.

Design a dashboard to analyze the admission trends of a state university. Query editor is used to perform data modeling by applying transformations such as append data, split data, merge join, etc.

In this case study, you will work on ETL by using Azure databricks and Azure stream analytics windowing functions. This case study will also familiarize you with the working of Azure stream analytics.

You will learn to understand SQL subqueries in this project. The subqueries include IN or NOT IN, ANY or ALL, EXISTS or NOT EXISTS, and others. You will access and manipulate datasets, operate and control segments, etc.

In this project, you need to record different kinds of purchases, such as video games, indoor games, toys, etc., and create a Power BI report. You will get to learn tabular visualization, matrix visualization, funnel, etc.

This case study will make you adept in designing a dashboard and performing calculations by making use of Power BI DAX formulas. The scheduled deliveries of loads are analyzed using correlation across measures.

This project checks the learners' knowledge of non-relational databases, categories, and where to use them. You will be working closely with NoSQL or non-relational database and Azure data lake storage and its key components.

Copy data from Azure blob storage to Azure data lake storage Gen2. Create an Azure Cosmos DB account and demonstrate adding and removing regions from one's database account. Partition data and semantics in Cosmos DB.

This case study includes relational databases, deployment models in Azure SQL, creation of an elastic pool, Azure SQL security capabilities, and importing data from blob storage to Azure synapse analytics using PolyBase.