Storage account created

Getting started with Azure Storage

April 1, 2022 by

This article will help you understand the Azure storage options available in the Microsoft Azure cloud. Microsoft Azure provides various services to store data depending on their type, nature, shape, and size. Data could be anything like an image, a video, a text file, a database file to store customer’s data, or data that comes […]

Set up Azure Function App

Azure Functions for Azure SQL Database

March 10, 2022 by

As a Platform as a Service (PaaS) service, Azure SQL Database enables developers to deploy SQL Database in Azure Cloud without managing the infrastructure. We use SQL Server Agent to schedule jobs to run at a specific schedule in an on-prem SQL instance. However, Azure DB does not have agent functionality.

Power BI Data Model for Time Intelligence - Power BI Time Calculation

Overview of Power BI Time calculations

October 11, 2021 by

In this article, we are going to understand the various types of Power BI time calculations and how to implement these calculations. We will also understand the reason behind implementing such time-based calculations and the importance of these in the real world. The Power BI time calculations are also known as Time Intelligence functions that […]

Building Ensemble Classifiers in Azure Machine Learning

September 21, 2021 by

Introduction This article is the newest addition to the article series of Azure Machine Learning which is Ensemble classifiers in Azure Machine Learning. During this article discussion, we have focused on data cleaning and feature selection techniques of Machine Learning. Further, we have discussed several machine learning tasks in Azure Machine Learning such as Classification, […]

Power BI Interview Questions

Popular Power BI Interview Questions

September 2, 2021 by

In this article, we are going to learn about the most popular Power BI Interview Questions being asked while applying for a Data Analyst role. Power BI is one of the most commonly used data visualization tools in the market. It is offered as a desktop tool using which you can author your reports and […]

Comparison of the Merge Join vs Hash Match Join

Query Optimization Myths

March 23, 2021 by

In this article, we will talk about two query optimization myths and these myths can be changed according to the characteristics of the queries. Every query can exhibit different behaviors according to data distribution, SQL Server version, database settings, and other tons of parameters therefore the fixed ideas may not help to overcome the query […]

AWS Well-Architected Framework

An overview of AWS Well-Architected Principles

January 27, 2021 by

In this article, I am going to explain about the AWS Well-Architected Framework that helps AWS customers to design solutions following best practices while designing the architectures of their solutions. It enables the users to design secure, reliable and high performant cloud applications and workloads. This is more of a theoretical concept that is often […]

Trigger Now a pipeline

How to monitor Azure Data Factory

January 15, 2021 by

In the previous articles of this series, we discussed how to perform different types of activities using Azure Data Factory. These tasks include copying data between different data stores, running SSIS packages and transforming data before writing it to a new data store.