PowerPivot – Inserting and working with Pivot tables

PowerPivot allows you to pivot columns of data from different tables and sources against each other. You may recall when creating pivot tables in standard Excel, one would often use Vlookups to pull all the data into one table and then create a pivot table.  This is no longer needed with PowerPivot because all the […]

Finding Your Way around Power Pivot – An Orientation

When you see Power Pivot for the first time it can be confusing.  It’s a new interface, with new ribbons and views.  Before you start working with tables of data and complex models, you need to get comfortable with the user interface.  In this article, we will take a look around Power Pivots user interface […]

manage measures in PowerBI

How to Manage Measures in PowerBI

So you have connected all of your data into PowerBI and you have transformed and shaped it.  Now all you need to do is create some calculations, know as measures, so you can begin to make some visualizations. Off you go and do the normal SUM, Count and Average DAX functions across a number of the tables […]

many to many relationships power pivot

Easy Excel Solutions: Power Pivot Many to Many Relationships

Learn How to Manage Many to Many Relationships in Power Pivot Power Pivot has been around since 2010, and many people still struggle with managing relationships.  Even more so most struggle with more complex relationships such as Many to Many relationships.  In fact, I have seen many people begin to set up data models in […]

Business Intelligence for the Excel User and Accountant

Over the last few posts, we looked at Business Intelligence and an example of how it can be used in a small business. But is Business Intelligence for the Excel User? And does it have anything to do with Accountants? ( missed the first post, you can access it here. You can also access the second post […]