08 6210 8500
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? [...]
3 Easy Steps to Manage your Data Fields Want to control which data fields to keep in Power Query when removing other columns? When using the ‘Remove Other Columns’ transformation in Power Query (‘Get & Transform’ in Excel 2016+) the query editor hard-codes the remaining column names in the Advanced Editor. This is fine if your [...]
What are Excel's 3 Best Kept Secrets? Excel has seen great advancement in the last 10 years and every user who spends their days re-organising data can benefit hugely from Excel's 3 best kept secrets. 1. Power Query If you or members of your team use Excel a lot then you are missing out massively [...]
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 [...]
Dynamic Data Validation with Tables in Excel Check out our YouTube channel with weekly videos dedicated to Excel, Power Query and Power BI Why is Excel returning an error message? Why doesn’t my formula work? What did I do wrong? The answer to these common questions may surprise you. Many spreadsheets [...]
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 [...]
Get & Transform to the rescue! Is it a bird? Is it a plane? No it's way better than that, it's Excel! Get & Transform, also known as Power Query, gives Excel users super powers. Here's the latest scenario where it has helped out and also is an opportunity for me to demonstrate a method [...]
What is Power BI.com? This is the next in a series of 4-5 minute videos introducing the Power BI suite consisting of Excel Power Pivot & Power Query, Power BI desktop and Power BI.com Here's a link to my previous article on Power Pivot in Excel. This time it's Power BI.com and a short introduction [...]
Data is the oil of the 21st Century - Analytics is the engine “Data … the next natural resource” (Virginia Rometty, CEO, IBM, 2013) Oil - the commodity that got us here Current generations might be forgiven for being blasé about the mega role of oil in our daily lives. For most of us, [...]
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 [...]
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 [...]
Reach out to the Access Analytic team Monday to Friday on (08) 6210 8500 or submit your contact information and we will be in touch.
Get Ahead of the Game – Book Your Training Now!
Wyn has been awarded MVP status by Microsoft every year since 2017 and is the author of the book “Power BI for the Excel Analyst”. He is known worldwide for sharing his knowledge via the Access Analytic YouTube channel with over 5 million views and 90,000+ subscribers.
He gained his Chartered Accountant qualification at PwC in 2000 and has extensive Business Analyst experience with HBOS and Barclays in the UK plus multinational clients in Perth.
Wyn is skilled in Excel and Power BI development, Power Query automation, management reporting and is an experienced Excel and Power Bl trainer.
Pay my invoice
