cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jcamilo1985
Helper I
Helper I

hubspot modeling

Good Night Experts

I am recently working with power bi on the hubspot tool, management has asked us to do some reports. After connecting power bi to hubspot, I need to arrive at a star schema, but I still can't do it because I don't know how to de-normalize some tables, I feel that I still haven't reached the most optimal model with this database.
Someone from here can help me, any guidance will be well received.
Thanks in advance
I attach images of the official hubspot help and how I currently have my model.

 

model hubspot.png

 

model power bi.png

 

https://support.datawarehouse.io/hc/en-us/articles/360054107794-Datawarehouse-io-HubSpot-Connector-E...

2 REPLIES 2

You are well advised to aim for a Star Schema if possible. Power BI is built to work with that structure. You can stray from that if your modelling requires it, but it is good advice to aim for a well structured Star Schema if possible.

 

I suggest you step back from the existing DB design and think about your data from a business context. Ask yourself 

1. What transactional/activity data do I need to report on (fact table(s))

2. How do I want to summarise this data "who, what, when, where" (dimension tables). 

Try to focus on what you need rather than what you have got, work out a plan, then set about building it. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
lbendlin
Super User
Super User

" I need to arrive at a star schema"

 

Who says that?  It's a recommendation, not a requirement.  Power BI doesn't really care, it works on the principle of Expanded Tables.  Star schema is easier to understand for humans, and easier to maintain. But it is not a hard requirement. Graphs are the future 🙂

Helpful resources

Announcements
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!