Gauri Mahajan

Author
Recent Posts

Gauri is a SQL Server Professional and has 6+ years experience of working with global multinational consulting and technology organizations. She is very passionate about working on SQL Server topics like Azure SQL Database, SQL Server Reporting Services, R, Python, Power BI, Database engine, etc. She has years of experience in technical documentation and is fond of technology authoring.

She has a deep experience in designing data and analytics solutions and ensuring its stability, reliability, and performance. She is also certified in SQL Server and have passed certifications like 70-463: Implementing Data Warehouses with Microsoft SQL Server.

View all posts by Gauri Mahajan

Natural Language based data exploration in Power BI

March 15, 2022 by Gauri Mahajan

In this article, we will learn how to add natural language-based data exploration capability to Power BI reports.

Analyzing data with decomposition trees in Power BI

March 9, 2022 by Gauri Mahajan

In this article, we will learn the use of decomposition trees in Power BI and learn how to use it to analyze data using the visual as well as the AI built into this visual.

Analyzing report performance of Power BI Desktop reports

March 1, 2022 by Gauri Mahajan

In this article, we will learn how to analyze the performance of Power BI Desktop reports using the Performance Analyzer.

Filtering data using Slicers in Power BI Reports

February 24, 2022 by Gauri Mahajan

In this article, we will learn how to user slicers to filter data in a Power BI report.

Data Lifecycle Management in Azure Blob Storage

February 17, 2022 by Gauri Mahajan

This article will show how to manage the lifecycle of data using the features available in the Azure Blob Storage account.

Introduction to the latest features of Power BI Desktop

February 10, 2022 by Gauri Mahajan

In this article, we will take a walk-through of the Power BI Desktop user interface and features provided to author reports.

Working with views in Azure Database for PostgreSQL

February 4, 2022 by Gauri Mahajan

In this article, we will learn the basics of working with views in the Azure Database for PostgreSQL.

Tracking your inventory in Azure Blob Storage

January 17, 2022 by Gauri Mahajan

In this article, we will learn how to configure Blob Inventory in an Azure Blob Storage account.

Point-in-time Restores in Azure Cosmos DB

January 4, 2022 by Gauri Mahajan

In this article, we will learn how to perform a point-in-time restore in Azure Cosmos DB on an account that has been configured with a continuous backup policy.

Continuous Backups in Azure Cosmos DB

December 20, 2021 by Gauri Mahajan

In this article, we will learn what continuous backup is and how to configure it on an Azure Cosmos DB account.

Advanced options in Azure Blob Storage accounts

December 8, 2021 by Gauri Mahajan

In this article, we will learn how to create an Azure Blob Storage account and understand all the different configuration options and their impact on the blobs stored in the account.

Centralizing data validation with domains in Azure Database for PostgreSQL

December 2, 2021 by Gauri Mahajan

In this article, we will learn how to work with domains in Azure Database for PostgreSQL and learn how to use it with tables to centralize the constraints logic that would be applied across tables.

Table Inheritance in Azure Database for PostgreSQL

November 30, 2021 by Gauri Mahajan

In this article, we will learn about the concept of table inheritance, and its use in Azure Database for PostgreSQL.

Using tables as templates in Azure Database for PostgreSQL

November 26, 2021 by Gauri Mahajan

In this article, we will learn how to create a new instance of Azure Database for PostgreSQL as well as understand how to use existing tables as templates while creating new tables.

Importing Azure Cosmos DB data in Azure Search

November 16, 2021 by Gauri Mahajan

In this article, we will learn how to configure the Azure Search instance to import data from Azure Cosmos DB.

Searching multi-lingual data in Azure SQL Databases

November 8, 2021 by Gauri Mahajan

In this article, we will learn how to enable multi-lingual search on data hosted in Azure SQL Databases.

Creating an Azure Search service instance for Azure Cosmos DB

November 4, 2021 by Gauri Mahajan

In this article, we will learn how to create an instance of Azure Search service and attach it to an instance of Azure Cosmos DB.

Discovering data assets with glossary terms in Azure Purview

October 29, 2021 by Gauri Mahajan

This article will show how to catalog data assets and then tag business glossaries at the attribute level of data assets in Azure Purview.

Defining Business Glossary with Azure Purview

October 27, 2021 by Gauri Mahajan

In this article, we will explore Azure Purview capability and understand it with a practical walkthrough.

Creating metadata-driven data pipelines using Azure Data Factory

October 25, 2021 by Gauri Mahajan

In this article, we will learn how to build metadata-driven pipelines using Azure Data Factory.

High Availability in Azure Database for PostgreSQL

October 21, 2021 by Gauri Mahajan

In this article, we will learn about the high availability features recently introduced in Azure Database for PostgreSQL.

Visualizing data with dashboards in Azure Databricks

October 18, 2021 by Gauri Mahajan

In this article, we will learn how to create dashboards using the data that is typically processed using notebooks in Azure Databricks.

Populating Delta Lake Tables in Azure Databricks with Azure Data Factory

October 13, 2021 by Gauri Mahajan

In this article, we will learn how to populate delta lake tables into Azure Databricks from Azure SQL Database using Azure Data Factory.

Creating Delta Lake Tables in Azure Databricks

October 11, 2021 by Gauri Mahajan

In this article, we will learn how to create a delta table format in Azure Databricks.

Integrating Azure Databricks with Azure Data Factory

October 7, 2021 by Gauri Mahajan

In this article, we will learn how to establish successful connectivity from Azure Data Factory to the Azure Databricks platform.