topic Re: Improve data model, tables and connections in App Development

Improve data model, tables and connections

Oleksi — Mon, 05 May 2025 14:33:52 GMT

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.

Re: Improve data model, tables and connections

Oleg_Troyansky — Tue, 06 May 2025 13:40:35 GMT

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,

Re: Improve data model, tables and connections

ali_hijazi — Wed, 07 May 2025 11:56:32 GMT

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