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 […]
IT Sales Simplified: Intern to Employee with Seth Maston
In this episode, IT Sales Simplified host Genna Callahan sits down with InterWorks Client Manager Seth Maston to chat about transitioning from an IT intern to a fully fledged IT salesperson at a global tech company.
Maturing Analytics: Why Dashboards Fail
In Part 1, we looked at our Job to be Done and why it wasn’t building Dashboards. The key takeaway is to focus on user value and solve their pain points. Now, let’s turn to why what building dashboards doesn’t deliver the user value we expect. Dashboards Fail by not Matching Users’ Needs The primary […]
Maturing Analytics: The Job To Be Done
The data and analytics industry is changing. Buried beneath the marketing hype and buzzwords, there’s something real happening, and the data industry is going through a giant shift. I’ve heard it described as both “overhyped and underestimated.” Overhyped in that a sprinkling of AI is not going to perform the magic many vendors hope you’ll […]
Python and Snowflake FAQ
Python is a first class language in the Snowflake eco system, and there are multiple ways to use Python with Snowflake: Snowflake Connector for Python: Listed in Snowflake drivers, this is a standard connector to Snowflake written using Python. It supports developing applications using the Python Database API v2 specification (PEP-249) which include familiar objects […]
Boost Your Tableau Workbooks With Large and Complex Data Sources
Speed is of the essence in lots of things, and Tableau dashboards are no different. Developers and end users alike want dashboards loaded in a blink of an eye. Luckily, there are many resources online that will help you optimise your dashboards, such as optimising calculations, taking extracts and limiting the data and worksheets to […]
IT Sales Simplified: Tech Talk with Tim Adams
In this episode, IT Sales Simplified host Genna Callahan sits down with IT Support Manager Tim Adams to talk about real world IT experience and Tim’s path to IT.