fbpx
Madonna House, Westlands Road - Nairobi
+254790706395
info@opencastlabs.co.ke

Category: Power Pivot

Power Pivot: Powerful data analysis and data modeling in Excel

Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.In both Excel and in Power Pivot, you can create a Data Model, a collection…
Read more

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