By identifying problems before they become errors Data profiling views in power query helps to ensure your data is clean & ready to be loaded into a model
Modeling for DAX Power Pivot and Power BI – Learn why and how you should keep dimensions and facts tables separate.
Following on from last weeks post, Connecting Excel to Coinmarketcap data for live ticker information and historic pricing, I thought I would share with you some basic indicators that you can add to your Excel Cryptocurrency Dashboard. This week we are going to look at calculating 50 and 100-day moving averages using DAX In the […]
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 […]
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 […]
Learn about Excels Power Tools with these demonstrations of Power Pivot, Power Query and Power View. The future is here with Excel Power Tools.
To Parse Custom JSON data is to split out its name/value pairs into a more readable useable format. Excel is a powerful tool that allows you to connect to JSON data and read it. However sometimes this data might require a little manipulation to be fully understood and analysed in Excel. In this article you […]