Greg Rossi - News & Education

Data Migration: Business Considerations & Implications

Learn about the process of migrating your database including the benefits of cloud migration, creating a data strategy, and choosing a database.

Data Pipeline

How to Use Data to Become a Cannabis Industry Leader

In any industry that experiences exponential growth over a short period of time, leveraging data becomes a differentiating factor for sustainable, long-term success. Learn how to do this in the cannabis industry.

Step-by-step guide for converting CSV to SQL

Learning

How to Convert CSV to SQL

Do you need a solution to convert CSV to SQL? This guide will provide you with the best methods and solutions to transform your data.

Embedded Analytics

What is a Data Portal? Everything Explained

Are you looking to understand data portals? In this complete guide, see what they are and the different kinds- vertical, horizontal, marketplace, media, etc.

Data Pipeline

ZUAR RUNNER UPDATE - SALESFORCE & TABLEAU CLOUD MFA REQUIREMENTS

On February 1, 2022, Salesforce began requiring MFA on all products developed on the Salesforce platform - including Salesforce Sales Cloud and Tableau Cloud. This may have an impact on Zuar Runner usage and we will address measures needed to be taken to avoid disruptions to you data pipeline...

Embedded Analytics

Access Your Tableau Analytics From Anywhere, Even Without a VPN

Whether you are having to make tough decisions about your business or experiencing high demand and growth, data driven decision making should become a top priority for any business that is navigating a volatile market.

Postgres: Filter an aggregation without the WHERE clause

Turns out you can filter aggregations in PostgreSQL outside of the WHERE clause.

Database/Cloud

SNOWFLAKE HOW TO: Create Date Dimensions Table, Calendar Table, Date Scaffold, or Date Spine

Learn how to create a Date Dimensions or Calendar Table, also known as a Date Scaffold or Date Spine.

Learning

How to Visualize Financial Data With Google Finance API, Google Sheets & Tableau

Looking for an innovative solution to monitor financial data? Learn how to visualize the data with Google Finance API, Google Sheets, and Tableau 2020.2

Tableau Trick: Compare Current Quarter to Prior Quarter by Creating a Hierarchy

How to create a Hierarchy for This Quarter to date over Prior Quarter to date Analysis that allows the user to drill from month in quarter to week to day in both quarters on a dual axis, maintaining comparative analysis.

Guide to hiding filters by using Tableau Dashboard Actions

How to Hide Filters With Dashboard Actions in Tableau

See a special technique for hiding Tableau dashboard filters until an action is initiated. View this article for full instructions!

Tableau date calculation using the most recent date function and the datetrunc Tableau function

Tableau Tip, Date Calculation: The Power of Most Recent (MAX + DATETRUNC)

In this post, I will show you a calculation to display the aggregation of up to date data (by month) that will automatically update over time and is safe to use with actions and filters.

Data Pipeline

Getting Started with Zuar Runner

The video tutorials below are for those looking to get started using Runner or learn more about the available features. * Runner UI Tour * Creating IO (Input/Output) Jobs * Creating SQL Jobs * Using API and Webhooks to Fire Off Jobs * Creating Sequences * Creating Schedules * Adding Tags * Creating Notifications * Rclone Use Cases

Learning

Differences Between a Data Engineer & Data Scientist

At Zuar, data engineers and data scientists work together for streamline data staging and strategy. We’ll walk you through the roles and responsibilities of data scientists and data engineers so you can learn how to use data to your advantage.

Data Pipeline

How To Unzip Files in Zuar Runner

It's inevitable that if you deal with enough data, especially exporting data from source systems, that you'll eventually need deal with .zip, .gz, or tar.gz files. To get this into a database, you will likely need to unzip the file and use the decompressed files inside. The following steps

Learning

HOW-TO: Drop Shadows in Tableau

Can you create drop shadows around Tableau Elements? Yes...