Category: Data Visualization

Data Modeling In Power BI Using Supporting Tables

Data Modelling Supporting Tables

When doing an analysis on our model, we might want to find an insight that’s unrelated to anything within our tables. That’s where the concept of using supporting tables for Power BI data modeling comes in. Supporting tables don’t have any relationship with our tables, but we can use them to support the visualizations in

Continue reading

Power BI Filtering Techniques For Tables

Power BI Filtering Techniques For Tables

In this blog, we’re going to learn about some essential Power BI filtering techniques for tables. We’ll discuss some simple techniques that we can utilize when we have massive tables on our query.  For example, when we need to extract information from a database or an ERP system, it could have 10 million rows within

Continue reading

Vega-Lite Tutorial: Exploring Deneb Custom Visual In Power BI

For today’s blog post, I’ll talk about the newly available Deneb Vega-Lite custom visual for Power BI, which I used exclusively in my partial submission for the Enterprise DNA Challenge #17 on environmental data reporting. You can watch the full video of this tutorial at the bottom of this blog. This received some positive feedback,

Continue reading

DAX And Power Query | Creating Self-Sorting Columns

Subsequent to a recent DAX pop quiz that I prepared and posted on LinkedIn, one of the people who responded to the quiz raised a fascinating idea, via which text columns no longer needed a numeric sort column to put them in proper order. I experimented with this new approach and it worked beautifully. In

Continue reading