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

Cloud Based Data Management: Concepts & Tips For Businesses

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

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

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.

Mitto

Tableau Data Extracts & Tableau Data Sources

Are you wondering how to use Tableau data extracts and data sources? This is an informative guide.

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

Tabcmd is a powerful tool, allowing a Tableau Server or Tableau user to do many things, such as create sites and users via a command line interface (CLI). Using tabcmd export, users can export views, workbooks, and data to PDF, CSV or PNG. Downloading and Installing tabcmdtabcmd is installed by

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

Dashboard actions, parameters, and filters are some of the best tools you can use in Tableau. They give you a way to transfer the control of the analysis to your end-users, which is critical in data visualization to help allow discovery for your users and also to make it easier

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.

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.

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.