Improve data model, tables and connections

[Oleksi]

Hello,

We have created app that combines data coming from several resources. The main resources are Google Analytics 4 (User usage) and Qualtrics (User feedback). 

Currently we are linking data by URLs. The issue that each connector has dates in different format and connection for dates are not working. I tried to create Bridge and link them and unify date formatting. 

I need someone who is experienced to review Data Model and see how to improve and optimize it. I do not feel that it's a perfect data model. There should be definitely better way of doing it, I do not have much experience to come with a better for now.

[Oleg_Troyansky]

Hi Olexi,

I'm happy to work with you and review the data model more closely. I'd need to see the app and learn more about the data and about your business requirements though.

Generally speaking, if this data is quite big, I'd look to create a Concatenated Fact data model, combining multiple fact tables into one. This would help normalizing the dates as well.

Cheers,

[ali_hijazi]

is it possible to share your app with me?
this helps alot