By Stuart Box

Power BI Resources

Excel Power Pivot – Just how big is BIG?

As I started working with Power Pivot and Power BI I was aware that it allowed large amounts of data to be manipulated by Excel, but just how large? and how does it do that ? Just how big was the "Big Data" being talked about. I spent a little while digging to find the answers. I was confused, how could Excel handle "Millions of rows"? Did the Excel Rows and Columns limits increase to new limits or was there… Read More

By Stuart Box

Excel Office 2013 Office 365 Power BI Resources

Microsoft Power BI for Office 365, this is not your Father’s Spreadsheet

Microsoft Power BI for Office 365 is a fusion of tools designed to provide data analysis, visualisation, ad-hoc query and sharing of Excel data and spreadsheets. It brings together the "Power Tools" for Excel, Power Query, Power Pivot, Power View and Power Map, with cloud-based online facilities which allow you to view, store, share and query the dashboards you create with Excel and the Power tools. It is not simply an add-on to Excel, but a radical enhancement of the… Read More

By Stuart Box

Excel Power BI Resources PowerPivot

PowerPivot 6 – The Joy of Sets

Time Intelligence Functions One of the most powerful features of PowerPivot is the ability to analysis your data across time periods.  To use the Time Intelligence functions, you must have a table in the PowerPivot window that comprises all the dates from the date range of your data.  For example, my wine sales range is between 1st September 2010 and the current date.  Therefore, I’ve created a Date Table that lists all the dates between these two dates.  I’ve also… Read More

By Stuart Box

Excel Power BI Resources PowerPivot

PowerPivot 5 – Measure for Measure

“Our doubts are traitors, and make us lose the good we oft might win, by fearing to attempt.” ― William Shakespeare, Measure for Measure Creating Measures A Measure is a formula that is created specifically for use in the Values area of a PivotTable (or PivotChart), very similar to Calculated Fields in a normal Excel Pivot Table.  However, in PowerPivot a Measure uses DAX functions.  The Values area of a Pivot Table will always require some kind of aggregation and… Read More

By Stuart Box

Excel Power BI Resources PowerPivot

PowerPivot – 4

Calculations in PowerPivot PowerPivot doesn’t use Excel’s formulas or functions but uses its own special expressions, known as DAX (Data Analysis Expressions). DAX Functions are different from Excel Functions in the following ways:- DAX doesn’t reference single cells or ranges of cells (e.g. B1 or C2:D11). A DAX function always references a complete column or a table. If you want to use only particular values from a table or column, you add filters to the formula. DAX includes functions that… Read More