SQL Delight in Snowflake | EXCLUDE, RENAME, REPLACE, ILIKE, GROUP BY ALL
Snowflake is like that friend who’s always got something new up their sleeve! Snowflake is all about staying up-to-date and cool, regularly spicing up its lineup of awesome features to keep up with the changing times in the world of data. So, in this blog post, get ready for a front-row seat to the show […]
PYD123 – Data Science, AI and Dataiku with Rachel Kurtz
InterWorks Content Manager Garrett Sauls sits down with two time Dataiku Neuron and InterWorks Analytics Architect Rachel Kurtz about the AI/ML craze, what’s new with Dataiku and more.
Does Home Field Advantage in the World Series Even Matter?
During the summer between 6th and 7th grade, my best friend Paul and I walked to the Piggly Wiggly across from the street from my house, and we each impulse purchased our first pack of baseball trading cards. I was immediately hooked! Many more packs (and boxes) followed, and I spent the rest of the […]
How To Be a Great Presenter
I’ve been with InterWorks for almost a year now. It’s interesting being surrounded by a team of expert consultants. There is quite an immeasurable collection of shared IT and business intelligence experiences represented throughout our organization. And much of the regular scope of work for most of our employees is client-facing, meaning we have hundreds […]
Understanding Micro-Partitions and Clustering in Snowflake
There are several features in Snowflake that contribute to your environment’s performance and scalability. Two of the most important in my experience have been micro-partitions and clustering. In short, micro-partitions are the fundamental storage units of Snowflake, and clustering is a feature that organizes data within micro-partitions based on one or more columns. The two […]
What I Learned from Totally Messing Up Joins and Snowflake Credits
The Day Before: Bringing our Snowflake Data into Tableau As the week began, we entered the development stage of our big intern project. My role thus far has been preparing for development by creating wireframes for the new dashboards. For this project, we used a Snowflake-held data source which we would pull into Tableau and […]
AWS Step Functions: Catch ‘Em All by Loading Pokémon Data from a RESTful API into Snowflake
As modern applications expand in complexity, effectively managing workflows can become a significant challenge. AWS Step Functions provides a comprehensive solution for orchestrating multi-step workflows in the cloud. Whether it’s invoking Lambda functions in Task states, separating branches of execution with Parallel states or running a set of steps for each item in a dataset […]
Track Your KPIs with Tableau Metrics
When businesses progress along the data maturity scale, the volume of data and associated dashboards will start to expand. This is great news! But, it can cause problems along the way. It is likely that your Tableau estate can start getting more difficult to navigate, and some users might get bogged down into much detail. […]
Sentiment Analysis With Native Algorithms in Dataiku
This is the third part of a short series called “Natural Language Processing with Dataiku,” where we are analysing airline reviews. In the first part, we did very basic data preparation, used the Dataiku sentiment analysis plugin and evaluated the model with the help of a confusion matrix. In the second part, we applied some […]
InterWorks Blog Roundup — July 2023
If you’re in the northern hemisphere, I’m pretty sure you know how I’m gonna open this monthly roundup: It’s hot. We’re right in the thick of the dog days of summer (and you know I’ll be blasting Florence + The Machine when they’re over.) My rinky dink apartment AC is struggling to keep up with […]
