Database/Cloud 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.
Database/Cloud Data Mart vs Data Warehouse vs Database vs Data Lake Not sure whether to invest in a data mart, data warehouse, database or data lake? Let's examine the key differences.
Data Pipeline 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.
Database/Cloud The Types of Modern Databases in 2026: A Complete Guide for the AI Era Aren’t sure which modern database is right for your organization? Zuar explores the different database models and their benefits.
Database/Cloud How to Design a Database Schema, With Examples Learn how to design a database schema, best practices, examples, naming conventions, security concerns, and the 6 common types of database schemas.
Database/Cloud What’s the Difference Between SQL & NoSQL How do you know if a SQL or NoSQL database is the right choice for your business? First, let’s touch on what these two databases actually are. * SQL databases are relational. The
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
Database/Cloud Data Warehouse Strategy: What Questions Should You Ask? What questions should you ask before implementing a data warehouse strategy? Read our informative blog and contact Zuar today to learn even more!
News & Events Zuar Appoints Whitney Myers as Chief Executive Officer Today Zuar announced that the Company’s Board of Directors has appointed Whitney Myers as Chief Executive Officer. Learn more...
Learning Fixed Dashboard Sizes in Tableau: How & Why Setting a Tableau dashboard to a fixed size ensures it will maintain a consistent look and feel. Learn how to set a fixed dashboard size in Tableau.
Embedded Analytics How to Embed Tableau Into Salesforce With Zuar Portal Utilizing Single Sign-On (SSO) Embed Tableau Into Salesforce With Zuar's data portal product. Zuar Portal is an easy way to provide branded Tableau dashboards.
Tableau Server Hardware Performance Tuning See a customer use case showing how to measure and maximize the performance of your Tableau Server investment.
Database/Cloud Everything You Need To Know About Data Mapping Employ data mapping to combine/migrate all of your desperate data into a single destination. Learn how!
Learning Tableau Data Extracts & Tableau Data Sources Are you wondering how to use Tableau data extracts and data sources? This is an informative guide.
Learning The Easiest Way to Analyze NetSuite Data in Tableau Are you looking to analyze your Netsuite data in Tableau? Then check out this article to learn an easy way to do so. From selecting a data warehouse, to data staging, and more.
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.
Learning Pandas Profiling: Your One-Stop for Instant EDA The pandas profiling library for Python creates an interactive suite of exploratory data analysis (EDA) tables & visualizations. See how to install & use it.
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.
Learning Install PostgreSQL drivers for Tableau Server Linux (Ubuntu) Follow this step-by-step guide for correctly installing PostgreSQL drivers for Tableau Server. This is critical if you have a live connection to PostgreSQL.
Embedded Analytics How to Embed amCharts Into a Web Page In this article you'll see several methods for embedding an amCharts chart into a web page.
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.
Learning Export Tableau Dashboards to PDF Using Tabcmd Learn how to use tabcmd for Tableau to export dashboards, views, workbooks, and data to PDF.
Embedded Analytics 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.
Database/Cloud MongoDB Cheat Sheet Working with a MongoDB NoSQL database? This guide shows the most common functions: queries, operators, and commands.
