An Introduction to Snowflake’s Marketplace
This article intends to provide a brief overview of what all the talk about Snowflake Native Apps Marketplace is about, how organizations can utilize the space to monetize their offerings, and how consumers can benefit from these third-party off-the-shelf applications, ending with detailed instructions to help new users navigate to and around the Native Apps […]
Planning a Business Intelligence System
Selecting business intelligence software and planning a rollout is a significant undertaking. The real work should begin well before you start selecting software. You must comprehensively assess your entire organization’s information needs, wants and data workflows. Building a Strategic Vision Roadmap We call these planning sessions Strategic Vision Roadmaps (SVR). InterWorks has a well-developed, fixed-cost […]
Building a Data Culture Through Effective Planning, Governance and Measurement
Executives understand the value of high-quality, timely information. When asked why they invested in business intelligence software, they can cite examples that explain how their investments paid off. Most feel the paybacks achieved justify their investments, but they also believe that the adoption of the tools has not been as deep or wide as they […]
An Intern’s First Visual Storytelling Project in Tableau
This article reflects on my attempt at transforming a previously created Tableau dashboard. This transformation was greatly influenced by the insights gained from the excellent two-week Tableau data visualization training provided to me as a BI intern at InterWorks. Most humans are visual creatures. We consume knowledge better when it is presented in a visually […]
InterWorks Causes: Special Olympics Oklahoma
As I’ve touched on in prior posts, being involved with important causes in our local communities is one of the things that makes InterWorks a special place to work for. There are plenty of company-organized opportunities lined up throughout the year, giving each person a chance to participate as time allows. I am especially passionate […]
Power BI DAX Iterator Functions Guide
DAX Iterator functions are a subset family of aggregator functions used to iterate over a table of rows. First, they evaluate an expression for each row in a table. Then they apply some form of aggregation to the row-level results of the first expression calculated for each row. You can imagine iterator functions as adding […]
InterWorks Blog Roundup – June 2024
Hey, there, party people! Hope you all had an amazing June. We’re halfway through the year. Hope you all have been keeping up with your New Year’s Resolutions. (Didn’t think we’d remember that, did you?) We had some great blogs out in June, so we hope you’ll find something you’re in to. First, here’s a […]
How to Build a Report in Power BI Desktop
Getting started in the Power BI Desktop application is a fun and exciting time. There are so many components that make up this masterful business intelligence tool, that at first glance it can appear a bit overwhelming. Not to fret. The good news is if you are familiar with Microsoft Excel and/or Microsoft PowerPoint already, […]
Querying Stock Data with an API Query Profile in Matillion ETL
Matillion ETL is a GUI-based orchestration and transformation tool for data movement that has many functionalities, including querying external data via API. There are three primary ways to query this data from Matillion ETL: Create a custom Python script to send requests to the API directly, storing the response in variables in Matillion ETL: This […]
Snowflake External Access: Retrieve Data from an API
Recently, Snowflake released external access integrations into general availability. This allows Snowflake admins to create secure tunnels for Snowflake to communicate with the outside world, and can therefore communicate with external APIs to complete all manner of tasks. For example, external access could be used for any of the following, among many others: Send alerts […]
