Tips & Tricks: ETL, Embedded Analytics, Big Data and more

Tableau Dynamic Zone Visibility explained

How to Use the New Dynamic Zone Visibility Feature in Tableau

Learn how to use the new dynamic zone visibility feature in Tableau with this step-by-step guide.

Tutorial to delete and restore data in a Snowflake database

Snowflake Data Deletion, Recovery & More: Including How to Delete a Table

Overview of the best practices for safely deleting & recovering data in a Snowflake database, including tables and rows.

News & Events

Cloud Based Data Management: Concepts & Tips For Businesses

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

Tableau

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

AWS monitoring using CloudWatch, SNS, Lambda & Slack for EC2

Databases

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.

Tips and Tricks

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.

Learning

Data Cleaning: Benefits, Steps and Using Clean Data

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

Tips and Tricks

Postgres: Filter an aggregation without the WHERE clause

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

Databases

Loading Flat Files Into a Database For Analytic Insights

At Zuar, we encounter all sorts of file formats and structures out in the real world. Although they may seem simple to work with, flat files can often create interesting situations to overcome.

Netsuite

The NetSuite API: Exploring SOAP Requests

Learn new ways to work with NetSuite's SuiteTalk Web Services Platform to gain access to customer data for subsequent transformation, enhancement, and presentation.

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.

Embedded Analytics

Embedded Analytics: How to Embed Tableau Dashboards Into a Web Page

Here's how to embed Tableau dashboards with a Tableau embed code, Tableau Javascript API, and iframe + Tableau share link.

Tableau

Tableau Server Hardware Performance Tuning

See a customer use case showing how to measure and maximize the performance of your Tableau Server investment.

Learning

How to Embed Raw Code From Github in Ghost Posts

Embed Github raw code into a Ghost post. This is an integration-free solution, using only HTML and Javascript.

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.

Tableau

What to Do if Tableau Crashes/Cancels/Hangs

Trying to do something in Tableau Desktop only to find it crashing or getting hung up? Here are 4 steps to help you get through it.

Tableau

Export Tableau Dashboards to PDF Using Tabcmd

Learn how to use tabcmd for Tableau to export dashboards, views, workbooks, and data to PDF.

Tips and Tricks

Troubleshooting Tableau Trusted Authentication

Trusted Authentication is one method that Tableau Server customers use to embed dashboards into their applications. If your trusted tickets aren't working, this article will help.

Tableau

Tableau Dashboard Actions: Use Cases and Resolving Common Problems

Tableau dashboard actions can greatly improve your user experience. See how to set them up, some great use cases, and how to resolve common problems!

Mitto

Using Rclone for SharePoint Shared Files

Use Rclone for Sharepoint Shared Files. In this example, the Sharepoint user doesn't own the files shared with them, so Rclone does not show them...

Learning

Using Amazon Seller Central's Brand Analytics

Amazon Seller Central's Brand Analytics is a free tool that allows sellers with their own brands to access a range of insightful data, which can be used to make more informed and strategic decisions to improve their store’s performance.

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!

Databases

Cheat Sheet: Microsoft Azure Blob Storage

Learn Microsoft Azure Blob Storage with Zuar's handy cheat sheet. Tiers, containers, creation, deletion, leasing and more.

Mitto

Updating Multiple Jobs with the Python Mitto SDK

Mitto has an extensive API, allowing users to remotely interact with jobs, schedules, etc on their Mitto instance. We recently released a Python SDK for interacting with the Mitto API, available on the Python Package Index.