Madonna House, Westlands Road - Nairobi

Category: Power Query

Fetching Live Data from Kobo using Power Query

Power Query for Excel allows you to fetch/pull your Live Data from Kobo Data Collection database (submissions). Use the power of Power Query to Extract, Transform and Load your data to Excel

Power Query with Excel Training

The Excel Power Query gets data from almost anywhere (web sites, databases, Excel files, SharePoint, Salesforce etc.) and enables you to manipulate it in many ways (clean, transform, merge and append) using a straightforward interface add-in to Microsoft Excel. Non-technical Excel users can access large corporate databases to conduct analysis and produce reports. At the…
Read more