Category: Excel

Write Back

How to Do Write Back & Planning in Power BI?

Data entry, planning and Wrte-back are key aspects of the performance management process not covered out of the box in Power BI. Acterys as developed to address that by offering a comprehensive ecosystem for enterprise grade business modelling, planning and consolidation that seamlessly integrates with the market leading data discovery solution Power BI and Excel/Excel Online.

hubspot logo

How to Use Power BI with a HubSpot Data Warehouse

In this article we cover how to automate the data load for Hubspot into a data warehouse optimized for analytics options with Power BI or designing dynamically updating reports in Excel. The approach that we are covering here is based on an enterprise grade data warehouse using Acterys which utilizes Microsoft’s (Azure) SQL Server in the cloud or on premise.