Level: Beginners Power Query is a product that allows business users to extract data from any source, cleanse and transform that data, and then load the modified data to a new location, typically into an Excel spreadsheet or a Power BI data model. Power Query is very easy to learn, […]
After what seems like a lifetime of waiting for the paperback book economy to tick its required boxes, both of my new books Supercharge Excel and Supercharge Power BI are now available to ship to most countries in the world from Amazon.com. This is a good opportunity for me to […]
Today I want to issue a warning to anyone considering using Publish to Web to share corporate data internally within an organisation. Publish to Web is a standard feature on all Power BI accounts (free and Pro) – I first wrote about it two years ago here. This is a […]
There are lots of different ways that you use to do Text Filtering in Power BI including: Slicers (with various configurations) Cross filtering from any visual object The filters pane on the right hand side of your report Custom visuals designed specifically for filtering Most of these standard filters require […]
I was explaining to one of my blog readers recently how to extract table size from Power BI Desktop using DAX Studio and thought it would be useful for others. I have covered the basics of DAX Studio in the past so I wont cover this detail again here. The latest version […]
Level: Beginners I blogged on conditional formatting in Power BI Table visual here when it was released in the May 2016 Power BI Desktop update. At the time of first release, the conditional formatting was pretty basic with only 1 formatting option available. Over time, Microsoft has improved this feature, and now, it is […]
Level: Beginners As I often say, sometimes it is the little things that can make a big different for some people – in this case Accountants. I was teaching a Power BI class a few weeks ago and I was discussing how the number formatting options work in Power BI. […]
Level: Beginners/Intermediate In the August 2017 update of Power BI Desktop Microsoft released the new What If feature (first demonstrated at MDIS in July). This new What If capability uses two new DAX functions to complete a task that you have always been able to do manually. You still can […]
Level: Beginners/Intermediate As those that read my blog regularly would know, I have been at the Microsoft Data Insights Summit in Seattle Washington for the last 2 days. I had the privilege and pleasure of presenting two sessions at the event. For those that were not able to attend, here […]
Level: Beginners One of my regular blog readers (and graduate of my live training course) Phil Cross asked me last week if I knew of anywhere to find a comprehensive guide for Self Service BI users of when to use Excel vs Power BI to author new data models. I […]
Level: Beginners One very important concept that Excel users often struggle with when starting on their Power BI and Power Pivot journey is that they need to learn to think about data in tables rather than thinking about data in cells. In the spreadsheet world every cell can be a […]
Level: Beginners Power Pivot is a database that has been designed from the ground up to be optimised for reporting and analysis in Power BI, Power Pivot for Excel and SSAS Tabular. The technology is essentially the same across all of these products so I will generically refer to Power […]
Level: Beginners Edit: Sep 2019 There are many best practices for Power BI. I know these things so intuitively now that it is very easy to forget how I incrementally learnt these things along the journey. Most of these things are not “right” vs “wrong” – they are more often […]
Level: Beginners I help a lot of people on forums who ask questions about time intelligence for DAX. If you are just starting out then the chances are that you may not even be clear what time intelligence is and hence sometimes you don’t even know what to ask. Often […]
Level: Beginners I think today’s article will be of interest to my readers even though it is a little astray from my normally pure Power BI, Power Pivot and Power Query content. I will show you how to quickly and easily create an On-Line Survey that you can distribute to […]
Level: Beginners I often get asked if there is an easy way to create documentation for DAX measures when using Power Pivot for Excel. I am not a big fan of documentation for the sake of it, but I do see value in having “some” appropriate level of documentation. I […]
Level: Beginners Today Avi Singh and I met with Howie Dickerman from Microsoft to discuss the Power Pivot for Excel Add-In. You can read the background to this meeting at my blog post last month. Howie is the Program Manager assigned to Power Pivot for Excel and has a wealth […]
Level: Beginners Today I explain when it is important to create a lookup table and when it is fine to use native columns in a data table. I have rated this topic as a beginner topic as it is a fundamental skill to learn on your journey to become a […]
Level: Beginners If you want to learn new skills using a new tool, then you simply must practice. One great way to practice is to weave the new tool into you daily problem solving. If you have something meaningful to do with the new tool, then you are much more […]
Level: Beginners I got this dreaded Dropbox email recently as shown below. I needed to clear out some of the files I have loaded in Dropbox so I didn’t have to upgrade my account. It occurred to me that I could make this process a lot easier by using Power […]
Excelerator BI | © 2023 | Sitemap