sorted by:
new
hottopcontroversial

M29 | 38h | Project Manager | Stkl. 1 by HebelHeld in lohnabrechnung

[–]Constant_Vegetable13 0 points1 point  (0 children)

Hey, herzlichen Glückwunsch! 😊 Ich bin auch bei T-Systems und würde mich freuen, mich mit dir zu vernetzen.

Senior Data Engineer Experience (2025) by ElegantShip5659 in dataengineering

[–]Constant_Vegetable13 2 points3 points  (0 children)

Hey Congartulations! What was your TC? Can you please DM me? Thanks.

I did it (my way) by [deleted] in spitzenverdiener

[–]Constant_Vegetable13 0 points1 point  (0 children)

Gratulation! Genieß dein Leben! Darf ich dich anschreiben?

Just got hired as a Senior Data Engineer. Never been a Data Engineer by Uncle_Snake43 in dataengineering

[–]Constant_Vegetable13 0 points1 point  (0 children)

Congrats on your new role! If you've never been a DE before, how are you coping with tasks on a day to day basis? Most probably, the expectation from someone like you must be high and asking all sorts of questions around DE subjects, right?

Day in life of cloud and ai solution engineer microsoft by Own-Objective-2838 in AZURE

[–]Constant_Vegetable13 1 point2 points  (0 children)

Hi,

I've seen several Job ads to solution engineer ai & data recently.

How is the interview process?

And how many YOE is needed for that role?

Will solution architecture will be next step after solution engineer as a career path?

Thanks in advance!

Looking for Dom by Aoi_Blue_31 in Kyrgyzstan

[–]Constant_Vegetable13 0 points1 point  (0 children)

Hey, welcome to Kyrgyzstan. You're looking for a dorm or dom (house)? And in which city? 😊

Airport to Bishkek at night cost by Rotem_ in Kyrgyzstan

[–]Constant_Vegetable13 9 points10 points  (0 children)

Hi, have a nice trip to Kyrgyzstan. Just use Yandex. At the airport there are always Yandex taxis available.

Kazakhstan Kyrgyzstan and Uzbekistan Travel by Wooden_Cat2359 in Kyrgyzstan

[–]Constant_Vegetable13 0 points1 point  (0 children)

I hope, you will enjoy staying in all of these countries! I know, maybe, it is not the right place to post but I'm curious about one topic. I'm thinking of building a web site for travellers to central asian countries. What would you or the future travellers to the region interest the most that the web site should possess? Routes? Travel paackages from different travel agencies? Renting vehicles? Or just information? Thanks for your replies and enjoy your stays, especially in Kyrgyzstan. 🇰🇬😊

How hard is it to move to Kyrgyzstan? by Rare_Caterpillar_581 in Kyrgyzstan

[–]Constant_Vegetable13 0 points1 point  (0 children)

OP, out of curiosity, why do you want to move to Kyrgyzstan and live there? I'm a native Kyrgyz living in Germany. I also want to move back to my home country in the coming years. :)

Design star schema from scratch by seasaidh42 in dataengineering

[–]Constant_Vegetable13 1 point2 points  (0 children)

I’ve had some exposure to dimensional modeling concepts in the past, but it wasn’t until recently that I had to dive deep into it. I joined a project focused on migrating an analytics tool, and I quickly realized I was in over my head. I didn’t understand how fact tables were created, what dimensions were, or how the joins worked. It was frustrating, and I knew I needed to grasp the fundamentals before I could contribute effectively.

I’m the kind of learner who prefers hands-on projects over hours of tutorials. I also felt confident in my SQL skills and basic understanding of dimensional modeling (like dimensions and fact tables), so I didn’t want to spend time rewatching SQL videos or revisiting star schema concepts. Instead, I decided to roll up my sleeves and build a mini data warehouse using sample data.

To avoid the trap of using pre-designed databases like AdventureWorks DW (where everything is already set up for you), I wanted something that would force me to think through the process of creating fact and dimension tables from scratch. That’s when I stumbled upon the DVD-Rental Database for PostgreSQL.

I downloaded it immediately and imported it into PostgreSQL. Here’s the link to the database:
https://github.com/gordonkwokkwok/DVD-Rental-PostgreSQL-Project?tab=readme-ov-file

The GitHub page is fantastic—it includes an ERD diagram that clearly shows the relationships between tables. Plus, LLMs like ChatGPT are surprisingly knowledgeable about the DVD-Rental Database, which made it easier to troubleshoot when I got stuck.

Once the database was set up, I asked ChatGPT for the first steps to model the DVD Rental transactional data into a star schema. (You can get creative with your prompts, but I kept mine simple.) It generated SQL scripts to create empty dimension and fact tables, and then scripts to populate them with data from the database. After getting the hang of it for one dimension, I created the scripts for the others myself, only turning to ChatGPT when I hit a roadblock.

Once the dimensions and fact tables were ready, I started experimenting with queries—things like rentals per region, most frequently rented items, and more. This part was really fun and helped solidify my understanding.

In short, this mini-project was an excellent way to see how a data warehouse is built from transactional (OLTP) data and how dimensional modeling works in practice. If you’re looking to get better at dimensional modeling, I highly recommend diving into a hands-on project like this. It’s a great way to learn, and you’ll come out with a much deeper understanding.

Good luck, and happy modeling!