Simple Data Preparation for Power BI Using Power Query: A Hands‑On Guide to “Column from Examples”

Posted on September 9, 2025September 13, 2025 by Reza Rad

If you’re looking for simple data preparation for Power BI using Power Query, the Column from Examples feature lets you describe the result you want and Power Query writes the transformation for you—no M code required. In this guide I’ll show practical recipes (full name, weekday name, “first three letters,” and more), how to choose Read more about Simple Data Preparation for Power BI Using Power Query: A Hands‑On Guide to “Column from Examples”[…]

We are hiring; Web Administrator

RADACAD is a leading provider of Consulting and Training services for companies worldwide in Business Intelligence, Data Analytics, Power BI, and Microsoft Fabric. Our team consists of highly specialized consultants and mentors with extensive experience in the field. Salary: $57K NZD annually, full-time, minimum 30-hour working week. Location: Auckland, New Zealand [at our company address] Read more about We are hiring; Web Administrator[…]

Mastering Power BI Development Training Course – Melbourne – August 2025

Who is this training for? This training is designed for Power BI Developers, Data analysts, Power BI architects, Data architects, BI Developers, and anyone who is building or designing a Power BI solution or implementation. You don’t need to know about Power Query, M, or DAX to attend this training. However, a general basic understanding Read more about Mastering Power BI Development Training Course – Melbourne – August 2025[…]

Mastering Power BI Development Training Course – Zurich – June 2025

Mastering Power BI Development Training Course – Miami – Nov 2025

Refresh Power BI Semantic Model After Dataflow Automatically

Posted on January 28, 2025January 28, 2025 by Reza Rad

Although this seems to be a simple thing to do, it is not a function that you can turn on or off. If you have a Dataflow that does the ETL and transforms and prepares the data, then to get the most up-to-date data into the report, you will need to refresh the Power BI Read more about Refresh Power BI Semantic Model After Dataflow Automatically[…]

REFRAME in Power BI Direct Lake

Posted on September 10, 2024September 10, 2024 by Reza Rad

Power BI offers a new type of connection to Microsoft Fabric Lakehouse or Warehouse, called Direct Lake. The Direct Lake connection acts like DirectQuery and won’t need the data to be refreshed. However, the Power BI semantic model has refresh settings that can be turned on or off. In this article and video, you will Read more about REFRAME in Power BI Direct Lake[…]

Roles in a Data Analytics Team

Posted on August 7, 2024August 7, 2024 by Reza Rad

In the previous article and video, I explained the important factors in having a successful data analytics team. One of those aspects is the team, the people, and their roles. In this article and video, I will explain the roles involved in the data analytics project and the types of tasks and requirements for each Read more about Roles in a Data Analytics Team[…]

Building a Data Analytics Team in this golden era of technology

Posted on August 4, 2024August 4, 2024 by Reza Rad

Recently, I did a presentation at a conference, and the topic was non-technical, unlike many other presentations that I do. I thought it would be helpful for you all to know about it, as I spent some time and gathered some information about it combined with the experiences I had with some of my customers. Read more about Building a Data Analytics Team in this golden era of technology[…]

SCD: Slowly Changing Dimension, an Ultimate Guide

Posted on July 16, 2024July 16, 2024 by Reza Rad

If you want to use Power BI, Microsoft Fabric, or any other data analytics tools, one of the key concepts to understand when working with a data warehouse system is the SCD (Slowly Changing Dimension). I will do this in a series of at least two articles. The first one (this one) will be on Read more about SCD: Slowly Changing Dimension, an Ultimate Guide[…]