08 6210 8500
How to Implement Power BI If you want to implement Power BI, as with any system implementation, you need to firstly define the business goals and objectives up front and break the project down into a series of phases. Don't try to do everything at once. To implement Power BI well, each phase should clearly [...]
Introducing Power Pivot In this video I introduce Power Pivot and how you can use it to join multiple tables of data together and display your data in a Fiscal Year format. In part 1 I demonstrated how Power Query can quickly consolidate all of the files in a folder and bring that data [...]
Top 10 reasons why winning CFOs are flocking to Power BI for data analysis “A (data analysis) picture is worth a thousand words” (Frederick R. Barnard – 1921) “Time is Money” (Benjamin Franklin – 1706 to 1790) The above truths are even more relevant in today’s real-time business environment. Those who make the smart decisions [...]
Power Query (Get & Transform) - Part 2 In part 1 I demonstrated how Power Query can quickly consolidate all of the files in a folder and bring that data into Excel. In this 6 minute video I follow on from that introduction and add an extra transformation step to get the dates I need. Once [...]
Power Query (Get & Transform) Part 1 Power Query is amazing at linking to data sources and cleansing / transforming that data as it's loaded into Excel (or Power BI Desktop). Watch this 4 minute video and see how you can consolidate all of the files from a folder instantly using Power Query. Build the transformation steps [...]
One of the great things about Power BI visualisations is the fact that they are open source and clever generous folk are developing fantastic tools for free that can help us all deliver a more enjoyable experience to the end users. Custom Visuals Gallery Two of my current favourites are both by OKVIZ and are [...]
Check out our YouTube channel with weekly videos dedicated to Excel, Power Query and Power BI Power Query is the best thing to happen to Excel since Tables were introduced in Excel 2007 **Updated May 2018** When developing Power Query solutions for others to use, or when needing parameters that can be changed [...]
Power Query Trap: Formula Autofill If you output the results of Power Query to a table in Excel then it’s often really useful to be able to add an extra calculated column or two onto the end of this output table. I used to do this all the time when using Microsoft Query. However, now [...]
How to combine multiple tables with Excel Power Query If you have multiple tables of data in a file and you want to view a single report based on these tables then it can be time consuming and risky to manually copy and paste them into a single table before creating pivot [...]
So firstly lets face facts. Not many people need to bring 4 million rows of data into Excel. Point accepted. However, some do, and I recently needed to do this. If you've ever checked (Press End then the down arrow key) Excel has just over 1 million rows, but if you start adding a formula [...]
The next version of Microsoft Office is just around the corner and we’re nearly as excited as this girl! So here are the top 3 new features (according to us) … let us know if you agree (download preview). 1. Cool new charts Check them out! 2. More Powerful Power Query Power Query has been with [...]
We’ll go into much more detail on these in future posts but this is very new stuff and we thought we’d let you know about it Key Points: It’s free and it’s pretty amazing. If you want to get more advanced then it is $9.99 per user per month. Pull your data together from single [...]
Pay my invoice
