Level: Beginners One of the great challenges Microsoft has faced with its “new” suite of Self Service BI tools (particularly Power Pivot) is that most people that could benefit from the holy trinity (Power Pivot, Power Query and Power BI) don’t even know these tools exist, let alone how the tools […]
I have been on holidays taking a much needed break from work, so it has been very quite on my blog over the last few weeks. But I am back now! I woke up this morning to a very pleasant surprise – Microsoft has delivered the long waited for Query […]
Level: Beginners Edit: Sep 2019 I really love Power BI, and I have learnt so much over the last 12 months that sometimes it is easy to forget the challenges I had in getting started. Today I am sharing my top 10 tips on how to get started with Power […]
There was a great new feature that snuck in unannounced to the July release of Power BI Desktop. It was only a tweet by my colleague Imke Feldmann from http://www.thebiccountant.com/ that I was even aware it was there. Include in Report Refresh When you look in the Queries pane in […]
Level: Intermediate Update: 2019. You can now do this natively in a Matrix, but this is still a good trick that can be used to solve various problems. You may or may not be aware that it (previously was) not possible to put Measures on rows in a Matrix in […]
Level: Beginners I have learnt a lot about sharing Power BI content over the last year since Power BI hit the main stream. A lot of my learning has come from trial and error, and there are lots of things I wish I knew before I started. Today I am […]
Level: Beginners Microsoft recently announced a new conditional column feature in Power Query (Power BI Desktop version) that warrants a blog post. This feature makes the process of creating banded columns much easier for the average user. I blogged about banded columns using DAX here, and now there is this […]
Level: Intermediate One of the many excellent sessions I attend this week at the PASS Business Analytics Conference in San Jose was a session titled “Get Latest Insights by connecting your data using Power BI Content Packs and PBI Gateways”. The title was interesting but the content presented by Dimah Zaidalkilani […]
In October last year, Iman Eftekhari and I set up the Official Microsoft Power BI User Group (PUG) here in Sydney Australia. Since then we have gone from strength to strength and as of the time of this post the user group consists of a total of 330 members. If […]
Level: Beginners Edit: Sep 2019 What is Power BI? Microsoft Power BI Expert, Matt Allington, explains This ‘What is Power BI’ post is the third in my “what is” series having previously blogged about “What is Power Pivot” and “What is Power Query”. This topic is the hardest of the […]
Level: Advanced, but explained in detail so everyone can understand There is a lot to learn in DAX if you want to be a ninja. A couple of the more complex and important things to learn and understand are filter propagation and context transition. It is not so much that […]
I was recently a presenter at the PASS BA Webinar Marathon – Dec ‘15. This was an online Webinar with a total of 7 separate presentations from various experts across the industry. My topic was “Moving from Excel to Power BI – A Business Analyst’s Perspective”. The session was recorded […]
I just finished watching the presentation from James Phillips – GM of Power BI at Microsoft from PASS Summit 2015. He talks about the incredible progress that Microsoft has made this year in the BI space, particularly with Power BI, but importantly about the future of Business Intelligence at Microsoft. […]
Level: Beginners No software company can build every single feature that everyone wants to see all at once. Ultimately there has to be some prioritisation, and along with the prioritisation comes compromises and ultimately disappointments for some (many?). Back in July 2015, Microsoft started a chain of actions and announcements […]
I am really looking forward with anticipation and excitement about the future of http://PowerBI.com. Microsoft has just released the August 2015 update to Power BI Desktop just 1 month after PowerBI.com becoming generally available (GA). Power BI Desktop used to be called Power BI Designer, and it is the tool […]
Excelerator BI | © 2023 | Sitemap