✅ Correct approach and used in real life OLTP -> OLAP ETLCode first approach!
Hello I am trying to learn on making my very own business Web app it can contain many modules like grocery app, self checkout, restaurant app with OLAP features like getting interesting pie charts and other telemetry... I have done my own OLTP already but there seems to be almost non existent C# tutorials on how to create ETL the Datawarehouse code first approach.
I was looking up BI snowflake but it looks like it's for people that already know what they are doing amd it's not code first.
Any suggestions?
I am currently asking these same questions in GPT O1 model so i would like to double check everything before I start doing things. Also note i have not seen any materials for doing OPS systems also...
6 Replies
Unknown User•7d ago
Message Not Public
Sign In & Join Server To View
Hmm let me rephrase a little bit.
I have a good OLTP planned but the main problem is there a good way to do code first approach for OLAP dimensions without touching the OLTP database that's why I mentioned ETL. While researching I got some notes about power BI and snowflake (the site)
It's about learning on data warehouse for my olap reports
Unknown User•7d ago
Message Not Public
Sign In & Join Server To View
Like Q sales etc.
Unknown User•7d ago
Message Not Public
Sign In & Join Server To View
Just say you don't know... thanks :harold: