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

Import data using R in Power BI

July 27, 2022 by Gauri Mahajan

In this article, we will learn how to configure Power BI to work with R and source the required datasets from it for reporting in Power BI Reports.

How to perform Process Mining using Power BI

July 20, 2022 by Gauri Mahajan

In this article, we will learn how to perform Process Mining with Power BI.

Analyzing spatial data with Azure Maps in Power BI

July 14, 2022 by Gauri Mahajan

In this article, we will learn how to represent spatial data on Azure Maps visualization and explore the features to effectively format the data to make it intuitive for the end-user.

Analyzing key influencers in data with Power BI

June 29, 2022 by Gauri Mahajan

In this article, we will use Power BI Desktop to analyze key influencers in a dataset and learn how to use the corresponding visualization as well.

Generating smart narratives in Power BI

June 28, 2022 by Gauri Mahajan

In this article, we will learn how to use smart narratives in Power BI to generate textual narratives that summarize the key highlights of the data presented in the report.

Using psql tool with Azure Database for PostgreSQL

May 27, 2022 by Gauri Mahajan

In this article, we will learn how to connect the pSQL tool with Azure Database for PostgreSQL.

Introduction to Azure Synapse Lake Database in Azure Synapse Analytics

May 23, 2022 by Gauri Mahajan

In this article, we will learn what is an Azure Lake Database conceptually, and the different components of this solution, followed by its practical implementation in upcoming articles.

Import data using Python in Power BI

May 11, 2022 by Gauri Mahajan

In this article, we will learn how to use Python to source data in Power BI using the python programming language.

Reporting data from Azure Cosmos DB using Power BI

May 6, 2022 by Gauri Mahajan

In this article, we will learn how to report data from Azure Cosmos DB using Power BI which is one of the most popular reporting tools in the industry.

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.