topic Re: HubSpot CRM to Power BI (Sales Pipeline Insights) by BIGINTSolutions.com in Data Stories Gallery

HubSpot CRM to Power BI (Sales Pipeline Insights) by BIGINTSolutions.com

ranbeermakin — Fri, 15 Mar 2019 13:14:46 GMT

How much revenue is in pipeline?

How are we doing against the quotas/targets?

At what stage are the deals stuck?

Who is the deal owner?

What's my sales cycle?

And much more.

Analyze your HubSpot CRM data using this report developed to showcase Sales Pipeline Insights. The data is pulled using Rest APIs, modeled and visualized in Power BI.

More details on our website with more Report tabs/views. Play live here:

https://bigintsolutions.com/2019/01/17/2-ways-to-copy-data-to-power-bi-from-online-services/

And btw, good news. We now have the most requested custom data connector. Yes, you guessed it right. Custom data connector to HubSpot CRM is available on our GitHub Page.

Feel free to try it out and give feedback.

Head here: https://github.com/ranmax123/powerbi-custom-connectors

Thank you

Ranbeer Makin

ABOUT US:

Website: https://bigintsolutions.com/

You’ll find me here:

Linkedin: https://www.linkedin.com/in/ranbeer

Twitter: @ranbeerm

eyJrIjoiYjI2YmMyMDgtNzEzMi00MDkzLWFkZjQtYmY0ZDBlOWQzNDYzIiwidCI6IjE1MTI1NmRmLTcyYmMtNDc0ZS1hMzYwLWFhYjg1NjY3ZmE5MiJ9

Re: HubSpot CRM to Power BI (Sales Pipeline Insights) by BIGINTSolutions.com

michaelshparber — Sat, 09 Mar 2019 11:37:24 GMT

Nice!

How do you calulate the win rate?

And what chart did you use for funnel?

Thanks

Re: HubSpot CRM to Power BI (Sales Pipeline Insights) by BIGINTSolutions.com

ranbeermakin — Fri, 15 Mar 2019 13:14:19 GMT

Thanks for the feedback michaelshparber

Win Rate = (total won opptys)/(total closed opptys (won + lost))

The funnel chart is a custom visual -> horizontal funnel chart.

And btw, good news. We now have the most requested custom data connector. Yes, you guessed it right. Custom data connector to HubSpot is available on our GitHub Page.

Head here: https://github.com/ranmax123/powerbi-custom-connectors

-Ranbeer

Re: HubSpot CRM to Power BI (Sales Pipeline Insights) by BIGINTSolutions.com

Anonymous — Tue, 30 Apr 2019 12:36:06 GMT

hI Which Visual you have used for MAP as background is white which i m looking. Please help me..

ranbeermakin wrote:

Thanks for the feedback michaelshparber

Win Rate = (total won opptys)/(total closed opptys (won + lost))

The funnel chart is a custom visual -> horizontal funnel chart.

And btw, good news. We now have the most requested custom data connector. Yes, you guessed it right. Custom data connector to HubSpot is available on our GitHub Page.

Head here: https://github.com/ranmax123/powerbi-custom-connectors

-Ranbeer

Re: HubSpot CRM to Power BI (Sales Pipeline Insights) by BIGINTSolutions.com

ranbeermakin — Thu, 20 Jun 2019 14:00:41 GMT

This is a shape map visual with world map GeoJSON file.

Re: HubSpot CRM to Power BI (Sales Pipeline Insights) by BIGINTSolutions.com

bhupendrapatel — Tue, 14 Apr 2020 11:02:01 GMT

Hey Ranbeer,

What visual have you used for salespipe line please? Looks very nice.

Cheers,

Bhupendra

Re: HubSpot CRM to Power BI (Sales Pipeline Insights) by BIGINTSolutions.com

ranbeermakin — Tue, 14 Apr 2020 11:06:29 GMT

It's a custom visual. Horizontal Funnel Chart

Re: HubSpot CRM to Power BI (Sales Pipeline Insights) by BIGINTSolutions.com

bhupendrapatel — Tue, 14 Apr 2020 11:07:25 GMT

thanks

Re: HubSpot CRM to Power BI (Sales Pipeline Insights) by BIGINTSolutions.com

ranbeermakin — Wed, 19 Mar 2025 05:57:54 GMT

The Power BI connector to HubSpot has been upgraded to use HubSpot Private apps. Why don't you check out my GitHub?

https://github.com/ranmax123/powerbi-custom-connectors

Why don't you give it a try?

Best
Ranbeer M