Power BI

Home/Power BI

MYOB and Excel/Power BI integration

Approximately 1.2 million businesses use MYOB products, this versatile accounting package has several offerings, but one thing they have in common is a less then amazing reporting function and integration with Excel. In 2013 MYOB Introduced a set of Application Programming Interfaces (APIs) for several of its products, making it now possible to extract data [...]

Download your own Power Query Calendar

Every Excel Power Pivot Model or Power BI Desktop file needs a Calendar. With the addition of a Calendar to your Data Model you can start to do all sorts of useful analysis such sorting the data by Fiscal month and Fiscal Year or performing calculations such as TotalYTD, Year On Year Growth, [...]

Free yourself from using formulas

Power Query is the greatest addition to Excel in 10 years, it's amazing at extracting and transforming data ready for you to use in a report. In this two minute video we show you how easy it is to extract the data you need without using any formulas! Find out more Extract and clean your [...]

How to pull exchange rates from a web page into Excel or Power BI

This 3 minute video shows how easy it is to link to web page data with Excel. In this scenario it's connecting to the Reserve Bank of Australia exchange rates web page. Get & Transform is built into Excel 2016. It was previously known as Power Query and is still a free download for Excel [...]

Excel and Power BI – From the Microsoft Studios

Excel and Power BI are amazing analysis and data visualisation tools. Knowing what's possible is just the beginning. You can see the possibilities in this video recently recorded at the Microsoft Studios in Seattle. The speed of change and capabilities of Excel and Power BI are dizzying. The benefits of learning these technologies will save [...]

Excel or Power BI – where to start?

Excel or Power BI - where to start? So... Excel has Power Query and Power Pivot built in. Power BI uses the same technology.  So which one should you learn first? I say which should you learn "first" because if you learn one it's a relatively small step to learn the other 2 Questions: 1. What's your aim? [...]

Management Reporting in Need of an Overhaul?

3 Signs your Company's Management Reporting Needs a Massive Overhaul How much time does your organisation spend each month preparing budget and management reports? How much time does management spend trying to understand these reports? How much money does your organisation spend on reporting solutions? Do any of the following [...]

2017-10-03T14:28:21+08:00Power BI|

Power BI Data Sources for Estimating Market Share

Power BI data sources can be almost any file, database or web service. Here's an innovative way to use this amazing connectivity to estimate your market share using free information sources from the web. Facebook tells me my Market Size If you've ever placed an ad on Facebook, you'll know the incredible range of characteristics [...]

2018-07-31T21:15:16+08:00Data Handling, Power BI|

How to…CSVs to Power BI Dashboard in 10 minutes!

How to...CSVs to Power BI Dashboard in 10 minutes! If you've ever clicked "Export to CSV" then we are kindred spirits. In a previous life as analyst and accountant, I have been an unwilling follower of the export, copy paste, filter, remove top 2 rows, transpose mantra. In recent years a lot of [...]

2017-06-09T10:48:18+08:00Power BI|

Power Query Data Cleansing – solving all sorts of Excel issues

Power Query Data Cleansing - solving all sorts of Excel issues by Wyn Hopkins   Some may see Power Query simply as a brilliant way of connecting to multiple data sources and loading that data into a Microsoft Power BI development environment (Excel Power Pivot or Power BI desktop). Having spent 25 [...]