08 6210 8500
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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
