Soul of Data

Tech Blog

Deep dives into AI, data engineering, and the tools and patterns that shape modern data systems.

Auto Generate Time Intelligence DAX Measures Without Writing DAX In Power BI

Why We Need A No-Code DAX Solution? Writing DAX measures can be overwhelming and time consuming, specially writing time intelligence ones. I personally had

Data ModellingDAXPower BI

Create 'Measures Table' In Power BI

Summary DAX measures in Power BI play crucial role by offering aggregation and calculations on top of facts, that can be visualized and sliced by dimensiona

Data ModellingPower BI

Why Power BI Is Better Than Excel?

Addressing The Elephant In The Room For decades, there has been no competition to Microsoft's Excel, virtually every human ever worked on a computer screen,

ExcelPower BI

Browse SQL Server Databases Using Power BI

Problem Statement The Scenario Say you have a vast pool of SQL Servers and Databases storing thousands of database objects, including tables, views, st

Power BISQL Server

Top 5 Data Shaping Rules In Power BI

Summary **“*Shape the raw data to suit your data model*, *make it your own*“** Data shaping is a process of transforming schema and format of data, it is a

Power BIPower Query

Must Not Skip These 6 Data Cleansing Rules In Power BI

Introduction ***"Dirty data in, dirty analytics out"*** Traditional data sources such as, SQL Server Warehouse or raw file feeds, tend to contain dirty dat

Power BIPower Query

5 Best Tips for Data Transformation in Power BI

Watch The Full Video Covering This Blog https://youtu.be/aN6stE6RfK4 Introduction Have you just started building a Power BI Dataset and your initial ta

Power BIPower Query

Power BI Best Learning Resources

Learning Resources **Learning****Utilities & Downloads****Power Query**[Microsoft Power Query Docs](https://docs.microsoft.com/en-us/power-query/) [Microso

Power BI