Excelerator BI
1,145 FOLLOWERS
Excelerator BI can help you exploit your data using Power BI. Kick-Start Your Power Pivot Journey Get expert Power Pivot help so you can quickly turn any data into high value reporting assets. Power Pivot & Power BI Training and Coaching Not all Power Pivot training is made equal.
Excelerator BI
2w ago
Last week I again had the pleasure of being invited by Rob Collie to be on his podcast Raw Data by P3 Adaptive. For those that are not familiar with my story, I identified Rob as a leader in the Power Pivot/Power BI space very early on (back in the [...]
Read More ..read more
Excelerator BI
3w ago
Level: Intermediate Why You May Want to use RLS Imagine you’ve just built a Power BI report filled with sensitive financial data. You want to start to share this data across the organisation but not everyone is allowed to see everything. The CFO should be allowed to see everything, but [...]
Read More ..read more
Excelerator BI
1M ago
As you may know, Microsoft has an MVP Programme where it acknowledges and rewards community leaders for their subject matter expertise and contribution to the community. There are many benefits of being an MVP including the recognition (leading to people understanding that you must be doing something right if Microsoft [...]
Read More ..read more
Excelerator BI
4M ago
Have you ever had a situation where you have a slicer selection that “sticks”? You make a selection in a slicer, then make some changes somewhere else, but the first selection you made “sticks” when it is no longer valid? Take a look at this animated demo below to see [...]
Read More ..read more
Excelerator BI
4M ago
In this article I’m going to talk about the recent change that Microsoft has made in renaming the underlying database used in Power BI from the term “dataset” to “semantic model” (or as I would call it, “semantic data model”). The Word “Semantic” Let me start by talking about the [...]
Read More ..read more
Excelerator BI
10M ago
In my last article I introduced the three different connectivity modes that are available for Power BI to fetch data from a source, with a specific focus on when and where to use DirectQuery connections. In this article I am going to go deeper and introduce the modelling aspects of a DirectQuery [...]
Read More ..read more
Excelerator BI
1y ago
On 12th April 2023, Iman and I hosted Miguel Myers as our special guest at the Sydney Power BI User Group. Miguel is a visualisation guru from Microsoft and has worked there for many years. He has recently been assigned as the Product Manager for Visualisations in Power BI, and [...]
Read More ..read more
Excelerator BI
1y ago
Back in April 2022, I wrote an article called Poor Man’s Paginated Reports. That article covered an easy way to create a paginated report without having to learn how to use paginated report builder. Sometime since then, Microsoft has released the ability to create a simple paginate report online inside [...]
Read More ..read more
Excelerator BI
1y ago
The Power BI Matrix visual is similar to an Excel Pivot table, however there are quite a few limitations in the Matrix. In the Power BI Matrix below I have put the product categories on Rows, Calendar Year on Columns and the measure [Total Sales] on Values. At this point, [...]
Read More ..read more
Excelerator BI
1y ago
The External Tools ribbon is a feature that has been available in Power BI Desktop since the July 2020 release. This feature should be considered essential to anyone who is regularly working in the Power BI space. In this article I recommend my top five External Tools, that I [...]
Read More ..read more