Recent Posts
JSON support in SQL Server 2016
JSON (JavaScript Object Notation) is an open-standard, lightweight file format for storing and transporting data. It is easy for humans to read and write. It…
Power BI – Replace values in a comma separated string by looking up in another Table
Recently I faced an interesting scenario where I need to replace values in a comma-separated string using values from a lookup table. It looked like…
Azure – Introduction to Azure Databricks
Azure Databricks is a scalable, collaborative Apache Spark based analytics platform that is optimized for Microsoft Azure cloud platform. It is designed in collaboration with…
Tadalafil: Comprehensive Guide to Uses, Dosages, Benefits, and Data Insights
Tadalafil: Everything You Need to Know for Safe Use and Data-Informed Decisions What is Tadalafil? A Medical and Data Analysis Perspective Tadalafil is a well-established…
Azure – Using Azure Storage Accounts
Azure Storage is the managed cloud storage service offered in Microsoft Azure. Azure Storage provides a highly available, durable, scalable, and redundant storage service. Azure…
Azure – How to create and use an Azure Storage account
Azure Storage is the managed cloud storage service offered in Microsoft Azure. Azure Storage provides a highly available, durable, scalable, and redundant storage service. Azure…
Azure – Understanding Azure Storage
Azure Storage is the managed cloud storage service offered in Microsoft Azure. Azure Storage provides a highly available, durable, scalable, and redundant storage service. Azure…
Power BI – Issue in using Query List Parameter (Query references other queries or steps)
I had a business requirement where I need to get the list of Products Ids in scope from an Excel file provided by the business…
Power BI – Parent-child Hierarchies in DAX
As part of my project activities, I sometimes have to deal with parent-child hierarchies and need to flatten them in Power BI. A common parent-child…