Share:

Share on facebook
Share on twitter
Share on linkedin

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.

Advantages

• You have a full backup of your data in a format that can be accessed by nearly every client tool from Power BI, Excel, Tableau, Qlik to custom built solutions
• The platform is optimized for reporting and analytics requirements and enables the fastest possible query times
• The approach is nearly infinitely scalable as the cloud capacity can be instantly adapted to the needed capacity
• Build dashboards and interactive reports with Hubspot data alongside any other data source e.g. accounting, ERP, web analytics sources among others
Here are the necessary steps

Reporting for Hubspot in Power BI Desktop and Excel

1. Sign up and start a free Acterys trial with an expert at your side

hubspot-sign-up

2. Add your Hubspot Account in the Apps section:

Hubspot-Connector-Power-BI

This step will create the data warehouse tables for your Hubspot data (currently contacts, companies and deals tables) in a relational star schema format optimized for analysis purposes.

3. Connect to Hubspot Data Warehouse in Power BI Desktop or Excel
Just connect to your database with your Acterys user name and password or use the Acterys Power BI Connector and select the required Hubspot tables.

4. Build reports with any Power BI visual, Excel Pivot Tables or Acterys Cube Formulas:

Hubspot-Power-BI

Coming soon: Install the Acterys HubspotPower BI App in Appsource.

One of the biggest benefits of this approach is that reporting is just one of many aspects that the solution covers. It can be easily extended with other business requirement from planning and budgeting to project management and the addition of nearly any data source.
The shown approach natively supports widely used authentication standards like Microsoft accounts and active directory and instantly integrates with Office Productivity solutions.
Finally, there is the option to easily extend Acterys with new no code app development platforms like PowerApps and workflow automation like Microsoft Automate enable you to realise nearly any workflow requirement from approvals to email notifications.
Please feel free to contact us for any questions or start a trial for better analysis for Hubspot data in Power BI or Excel.

Recent Posts

Top 5 Tips & Tricks For Planning, Budgeting and Forecasting in Power BI & Excel In this blog I am

Planning and Analytics [Infographic]

It is not uncommon for companies to have separate planning and analytics processes or legacy solutions that result in more

Materialize and Synchronize Power BI with a Data Warehouse “Materialize” is a database concept that refers to storing the result

I can’t help smiling when I see legacy BI/Planning application vendors -that were not so long ago laughing away Power BI- coming out with their own “Power BI Integration” after Microsoft has turned around the industry. These are more often than not nothing but “a marketing spiel” to build on Power BI’s awareness and of very limited use in real life application scenarios.

Across many mid-sized and large companies, finance and operations teams are at crossroads. This was one of the findings from the recent BPM Pulse 2021 survey which revealed that only a third of companies had truly harmonized strategic, financial, and operational plans.