Things Excel with a BIas

Help, information, and products for users of Microsoft® Excel with a focus on BI

One of Excel's best kept secrets ...

is Excel Cube Functions. Click here for an overview.

Business Modeling and Planning with Power Pivot

How you can add assumptions and modeling capabilities to you Power Pivot Data Model. Read more >

Excel and Power Pivot for accountants and finance managers

Articles and links to articles describing how accountants, finance managers and finance professionals might leverage Power Pivot as a robust platform to handle a variety of financial reporting and analysis needs. Read more >

Excel reports that combine data from Power Pivot and Power BI

 Let's say that you have some budget data in an Excel Data Model. In Power BI (PBI) the corresponding actual historical data has been published by your finance department. You want to conduct some performance analysis between the two data sets. Read more >

Slicing and dicing text values in a PivotTable

Want to retrieve text (as opposed to numeric) values into a PivotTable to slice-dice-pivot the text? Read more >

Comparing Actual and Budget with a Scenario table

In certain circumstances you may find it useful to set up Actual and Budget data (perhaps multiple flavors of Budget) in your Data Model using a Scenario table. Doing so reduces the number of time calculation measures that you need to create (MTD, QTD, YTD etc). This video shows how you might do this.

Leverage the power of Excel's Cube Formula Reporting in your reports and dashboards with an Excelcraft Training Kit

Excel Cube Formula Reporting with the Data Model (2nd Edition)
Sold in over 25 countries, Excelcraft's multi-media training kits, now released in Second Edition focus on building cube formula reports and dashboards with data sourced either from Excel / Power Pivot / Power BI Data Models or from Analysis Services Multidimensional Cubes/Tabular models.
Read more >
Share by: