Big Data, Data Warehouses, Business Intelligence, Data Analytics Intern

Uli Bethke Big Data

Interested in Big Data, Data Warehouses, Business Intelligence, Data Analytics? Want to learn more about data warehousing, data analytics, and cloud computing (AWS, Google, Azure)? Sonra Intelligence is looking for a computer science intern to join our growing team based in Dublin 7 Grangegorman DIT campus Starting asap The position is full time. Working remotely is an option. Duration: 3-6 ...

The evolution of cloud data warehousing

Uli Bethke Data Warehouse

Let’s have a look at the evolution of cloud data warehousing. It’s hard to believe, but just a few years ago all data warehouses were run on-premise. Some of them on expensive and highly engineered MPP appliances. Very fast. Not cheap. Smaller data warehouses would run on relational databases such as Oracle or SQL Server, which had been originally engineered ...

Snowflake date and time dimension

Uli Bethke Uncategorized

Here is a simple SQL script that will generate a date dimension in Snowflake. We are using the built-in GENERATOR and SEQ function. Start date for the dimension is 2017-01-01.


Build a Predictive Model on Snowflake in 1 day with Xpanse AI

Uli Bethke Snowflake

Intro “Building a Churn Model is at least 3 months of work” You are the Data Analytics Manager and you have successfully implemented your cloud data warehouse on Snowflake. Great news! You deserve a pat on the back 🙂 Thanks to Business Intelligence and Data Warehousing you can easily identify problems in your business. For instance, your shiny new dashboards ...