Data warehousing and creating views for third party visualisations

Hello experts,

What are the best practices you use for DHIS2 being used for data warehousing.

I’m am a bit of struggling to create views around analytics table, so that it can be connected & visualized easily in superset/tableau kind of tools. Have anyone created some samples for this, especially to decode UID columns