Database/Cloud

Apache Spark Cheat Sheet

Use this quick reference cheat sheet for the most common Apache Spark coding commands.

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.

Database/Cloud

Cloud Computing Trends for 2022

Cloud computing is a familiar technology that is experiencing a boom. Let’s take a look at how this tech is changing the way we interact with the world.

News & Events

Zuar Receives Partner of the Year Award From Tableau SMB Team

Tableau’s SMB Sales team has honored Zuar with a ‘Partner of the Year Award’. This is the second year in a row that Zuar has received this award.

News & Events

Cloud Based Data Management: Concepts & Tips For Businesses

Everything you need to get started with cloud-based data management

Database/Cloud

Pros and Cons of Using Snowflake Cloud Data Warehouse

What are Snowflake’s pros and cons? Learn about Snowflake benefits, considerations, and more.

How to Improve Tableau Dashboard Performance

Have you ever been stuck using a slow-loading Tableau dashboard, a sluggish server, monster query times, etc.? This article is for you...

Database/Cloud

AWS EC2 Monitoring With CloudWatch, SNS, Lambda & Slack

Learn how to subscribe a custom Lambda function, that formats a slack message and makes a POST request to a slack channel.

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

Database/Cloud

What is Amazon RDS?

This guide provides an introduction to what Amazon RDS is, what this AWS service is used for, how to set up an RDS database.

Learning

The Best Place to Store Your Data: Amazon Redshift vs. Amazon Simple Storage Solutions (S3)

Are you curious about the differences between Amazon Redshift and Amazon Simple Storage Solutions? Here’s what you need to know...

News & Events

Zuar Appoints New CFO Jennifer Crane

PRESS RELEASE: Zuar appoints new CFO, Jennifer Crane. Kevin Stellner will transition to Executive Director.

Data Pipeline

Pros & Cons of ELT vs. ETL

Learn the differences between ELT and ETL tools, the processing differences between each, and how to choose between them for your data pipeline needs.

Database/Cloud

Snowflake vs. Redshift vs. BigQuery: Comparisons and How to Choose

Unsure which data warehouse is best for your organization? We compare different aspects of Snowflake, Amazon Redshift, and Google BigQuery.

Learning

Automate the Execution of Python Scripts With Cron

Learn how to automate Python scripts via cron jobs.

Learning

A Basic Crontab Tutorial Guide for Beginners

Learn how to use crontab for cron jobs in Linux and other operating systems. Schedule reoccurring activities, automate repetitive tasks, etc.

Embedded Analytics

Implementing Trusted Tickets For Tableau Server With NodeJS

This article shows how to implement trusted tickets, as described in Trusted Ticket Authentication with Tableau Server.   We'll build a ticket broker with a simple API called by a front-end that uses the HTML5 <template> tag.  The intended audience is users who want to integrate trusted

Learning

Data Cleaning: Benefits, Steps and Using Clean Data

This article discusses data cleaning, its benefits, and how to create and use clean data.

Database/Cloud

How to Load Data From an Amazon S3 Bucket Into Redshift

See how to load data from an Amazon S3 bucket into Amazon Redshift. We’ll cover using the COPY command to load tables in both singular and multiple files. with some options available with COPY that allow the user to handle various delimiters, NULL data types, and other data characteristics.

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.

Embedded Analytics

Embedded Analytics: SAML SSO with Tableau Cloud and Okta

Implement single sign on (SSO) for Tableau Online with security assertion markup language (SAML) identity provider (IdP) Okta.

Embedded Analytics Featured

Embedded Analytics: SAML SSO With Tableau Cloud & OneLogin

Implement single sign-on for Tableau Online with SAML & IdP OneLogin. And create a simple application that embeds a Tableau dashboard into a webpage.

Database/Cloud

The Straightforward Guide to Data Warehouse Design

Do you need assistance with your data warehouse design? Zuar provides a few tips to help with this process.

Database/Cloud

MariaDB vs. MySQL

Trying to choose a DBMS? Learn the differences between MariaDB and MySQL. Zuar compares and contrasts these two database management systems.