I have 11+ years of working experience in Business Intelligence Data Modelling, Power BI, SQL Server, SSRS, SSIS, Azure Data Factory, Power Apps.
Creating a cascading dropdown or dependent dropdown allows users to select values in one dropdown and filter the records in another dropdown for those selected… Read More »Create a cascading dropdown in Power Apps
A variable is a temporary storage that can be defined and used anywhere within Power Apps. Variables are created and typed by default when they… Read More »Create a variables in Power Apps
Power Apps ClearCollect function deletes all the records from a collection and then adds a different set of records to the same collection. Basically, this… Read More »ClearCollect function in Power Apps
A collection is used to store and manage a group of items or records. It acts as an in-memory data source. It allows you to… Read More »Collection in Power Apps
The Aggregate transformation in Azure Data Factory defines aggregations of columns in your data streams. Using the Expression Builder, you can define different types of… Read More »Aggregate Transformation in Azure Data Factory
HackerRank SQL Interview Question: Level Medium Source: HackerRank Pivot the Occupation column in OCCUPATIONS so that each Name is sorted alphabetically and displayed underneath its corresponding Occupation. The output column headers… Read More »HackerRank SQL interview Question- Occupations
Copy data activity in Data factory allows you to copy data among data stores located on-premises and in the cloud. After you copy the data,… Read More »Copy sample data using copy data activity in Microsoft Fabric
Filter activity is used in a pipeline to apply a filter expression to an input array, it filters an input data so that subsequent activities… Read More »Create Filter Activity in Azure Data Factory
Delete Activity in Azure Data Factory allow us to delete files or folders from on-premises storage stores or cloud storage stores. You can use this… Read More »Delete files from folder using delete activity
Schedule trigger allows you to schedule a pipeline to run periodically (hourly, minutely, daily, weekly and monthly). When creating a schedule trigger, you can specify… Read More »Create a Schedule Trigger in azure data factory
Copying multiple files from one folder to another in Azure Data Factory, you can use the Copy data activity in a loop. For looping through… Read More »Copy multiple files from one folder to another in Azure Data Factory
You can connect Azure SQL Database from local machine using SQL Server Management Studio (SSMS). Before connecting to Azure SQL Database from SSMS make sure… Read More »Connect Azure SQL database from local machine
Wait activity in a pipeline allows you to control the execution flow by pausing the pipeline for a specified period before continuing with the execution… Read More »Wait Activity in Azure Data Factory
The Power Query Text function Text.RemoveRange is used to remove a specified number of characters from a text, starting at a specified position. Syntax Text.RemoveRange(text… Read More »Power Query Text.RemoveRange Function
Power Query text function Text.Remove allow us to remove particular characters from string. Text.Remove(text as nullable text, removeChars as any) as nullable text text: given… Read More »Remove characters from string in Power Query
Power Query has various in-built functions which help us in transforming and preparing the data. To extract the first and last characters from string we… Read More »How to get first and last characters from string in Power Query
Power Query provides a set of tools and functions to transform your data. Here we will see how to insert a text or you can… Read More »How to insert text into an existing text in power query
SQL (Structured Query Language) is a programming language, It is used for managing and manipulating relational databases using various command such as DDL (Data Definition… Read More »SQL DDL, DML, DCL and TCL commands
The major difference between the UNION and UNION ALL operators in SQL is how they handle duplicate rows when the result set of multiple select… Read More »Difference between union and union all
This is one of the most asked SQL interview Question that write a SQL Query to display Employees and Manager name of the employee. Let’s… Read More »Display employees and their manger name in SQL