This post really stems from another blog where I referred to Excel as a BI tool, the most used BI tool… Read more What makes a BI tool a BI tool?
I could make this blog really short and boring by simply answering my own question with NO! certainly not right… Read more Is Power BI the new Excel
BI solutions can take many forms, and use may different technologies; however all BI solutions fall into one of 3… Read more Types of BI Development
Power Pivot is a free add-in for Excel (versions 2010 and later) that transforms Excel into a powerful data modelling,… Read more Introduction to Power Pivot for Excel
I loaded some data from an Excel table (called FactTable) into a Power Pivot data model. On each row of data… Read more Power Pivot subtotal and ranking using SUM, ALLEXCEPT and RANKX
In the most recent versions of Excel we’re able to develop some fantastic BI solutions using the Power add-ins for… Read more Refreshing Power Pivot in Excel 2010
Anyone who’s created a Pivot Table with Slicers in Excel 2013 or Excel Office 365 may have come across an… Read more Preserving Conditional Formatting on Pivot Tables
Column Charts and Bar Charts are more or the less the same thing; both represent data using rectangular columns / bars. The… Read more Column chart or Bar chart?
A common question that those using the Microsoft stack ask is “when should I create my report in Power View… Read more Power View OR Power Pivot?
If you’ve developed a Power Pivot data model, and you need to reduce the size of data model (either because your experiencing… Read more Power Pivot data model optimisation