I've been self-teaching and practicing SQL, Power BI, Python, for about three months now. I also know how to use Excel as well.
Is there anything else I should add to my skill set, or are these enough to help me land an entry level job? I don't have any professional experience with (Postgre)SQL, PB, or Python, and I don't have any formal education in those subjects.
Hey there! We have Postgres, already a replica of the operational transactional Postgres, and also ClickHouse. We are treating the replica Postgres as our analytics dwh and are running dbt in it. And our BI layer is connected to it.
We have events data stored in ClickHouse, but it is not in use at the moment.
Moving forward, what is my best long-term solution? I need to bring in the events data into our analytics dwh, so it becomes a natural decision point if we want to continuously commit to Postgres, or move analytics work and dbt over to ClickHouse, or explore other possibilities. We only want self-hosting options.
Thanks!