Watch Google Sheet + Power Query for Report Automation in Excel and Power BI by Mr. Michael Olafusi
Lead Consultant, UrBizEdge
1) How to import data from Google Sheet into Excel and Power BI
2) Power Query to transform data coming from Google Sheet
3) Building reports in Excel and Power BI from imported Google Sheet data
4) Setting scheduled refresh for Google Sheet data source on Power BI
Michael Olafusi is a Financial Modeler and Business Data Analysis specialist. He is a certified Advanced Financial Modeler (AFM), a chartered stockbroker in Nigeria, and a member of the UK CISI. He is a 6x Microsoft MVP (most valuable professional) award from Microsoft. It is the highest recognition Microsoft gives an industry expert. He is also a Microsoft Certified Trainer with MCSA BI Reporting, MOS Excel 2013, and MOS Excel 2010 Expert professional certifications. Prior to becoming a full-time consultant, he worked as the Service Delivery Manager for 21st Century Technologies, Business and MIS analyst for Comviva – Airtel Africa CRBT Operations, and as a BSS Engineer for Nokia Siemens Networks.