How to Become a Power BI Developer

Imagine yourself at the helm of a spacecraft, charged with traversing a vast array of data. The path ahead can seem overwhelming, with a myriad of objects (or in this instance information points) scattered throughout the universe. However, don't worr...

Understanding Power BI Basics

What is Power BI? Power BI is a suite of business analytics tools that allows you to visualize your data and share insights across your organization or embed them in an app or website. It connects to hundreds of data sources, simplifies data prepara...

What is Microsoft Power BI?

Introduction to Microsoft Power BI Power BI is a business intelligence tool developed by Microsoft, designed to transform raw data into meaningful insights through interactive dashboards and reports. It integrates seamlessly with other Microsoft prod...

Power BI Aggregations and Synapse query performance

Documenting your Power BI model

Marc Lelijveld created an external tool to help document your Power BI model Document your model How it works Open a Power BI solution that you want to document In the Top Ribbon under External Tools, click Document Model. After the click, you mi...

What is a dense measure? and why you should avoid it.

There’s not enough memory to complete this operation. There’s not enough memory to complete this operation. Examples of dense measures: [measure] = 1 [measure] = COUNT('Sales'[ProductKey]) + 0 [measure] = If([Total Sales] <> 0, [Gross Margin] / ...

Tabular Object Model (TOM)

The Tabular Object Model (TOM) in SQL Server Analysis Services is a powerful programming interface designed for managing and manipulating tabular models. With TOM, developers and data professionals can programmatically interact with tabular models, m...

Power BI Migration

4 high-level phases for deploying Power BI Set up and evaluate Power BI. The first phase involves establishing the initial Power BI architecture. Preliminary deployment and governance planning are handled at this point, as well as Power BI evaluati...

Data Professionals spend an average of 23% of their time cleaning data — here’s a BulkTextReplaceValue function to save you some time 🕒

Proportion time spent on data science activities In Bob Haye’s article from earlier this year, results of a recent study of over 23,000 data professionals found that data scientist spend about 40% of gathering and cleaning data, 20% of their time bui...