Forum Discussion
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.
2 Replies
" 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 🙂
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.
