Greg Rossi - Zuar

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.

Mitto

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.

Mitto

MITTO 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 Mitto 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.

Tips and Tricks

Postgres: Filter an aggregation without the WHERE clause

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

Tips and Tricks

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.

Tableau

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

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

Tips and Tricks

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

Tips and Tricks

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.

Mitto

Getting Started with Mitto

The video tutorials below are for those looking to get started using Mitto or learn more about the available features. * Mitto 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.

Mitto

How To Unzip Files in Mitto

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

Tableau

HOW-TO: Drop Shadows in Tableau

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