top of page




Power Query - ETL
Here we talk about basic and advance concepts of transformation before actually working on the dashbaord.
nitin rungta
Jan 182 min read
Data Analytics Mindset: Tip 1 - Unpivot Columns
Key Principle: Think minimal, automated, and perpetual Minimal: Keep your data tidy and free from unnecessary complexity. Automated:...
15 views0 comments

nitin rungta
Dec 21, 20243 min read
Power Query | Table Button - Guide
Power Query Buttons on a Table from Right-click 1. Copy/Paste: You can copy a table from one project and paste it into another project's...
11 views0 comments
nitin rungta
Dec 21, 20243 min read
Understanding Duplicate vs. Reference in Power BI
When working with Power BI, understanding the difference between Duplicate and Reference is crucial for building clean and efficient...
7 views0 comments
nitin rungta
Dec 21, 20242 min read
How to Avoid Many-to-Many Relationships in Power BI: The 'Z Items' Table Approach - Bridge Tables
Many-to-many relationships in Power BI can lead to ambiguous results, slow performance, and circular dependencies. While many users rely...
5 views0 comments
nitin rungta
Jul 12, 20242 min read
How to Get a List of Dates Between Two Date Columns in Power BI
Introduction In data analysis and reporting, there are often situations where you need to generate a list of dates between a start date...
72 views0 comments


bottom of page