Do you work with data? Zuar provides knowledge guides to help!

Overview of dbt and breakdown of dbt sources

What Are dbt Sources?

We dive into what dbt sources are, how they work, and how you can use them to advance your data warehouse.

A professional in a dark suit stands in front of a blackboard covered with equations and graphs.

Data Science: A Comprehensive Career Guide

Data science is a growing career field that offers numerous opportunities. Here, we discuss the skills, education, and experience you’ll need for a career in data science, and describe some programs and resources for data science information.

Data staging tutorial, overview, and best practices

Learning

The Complete Guide to Data Staging

In this in-depth guide, Zuar explains what data staging is, why it's important, types of data staging, software staging best practices, and more.

Overview of the types of data integration patterns

Learning

Data Integration Patterns Explained

Learn about the top 5 most common data integration patterns: data migration, broadcast, bi-directional sync, correlation, and aggregation.

Overview and explanation of data lakes, data mesh, and data fabric

Database/Cloud

Data Mesh vs. Data Fabric vs. Data Lake

Learn the differences between data lakes, data mesh, and data fabric and how your organization can leverage these frameworks in your data stack.

Overview of data silos, including disadvantages and how to identify and break down data siloes.

Learning

What is a Data Silo?

Learn what a data silos is, how they negatively impact your business, how to identify and eliminate them, and frequently asked questions .

Database/Cloud

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.

Differences between Python vs Java: speed, uses, performance, etc.

Learning

Python vs. Java: Uses, Performance, Learning

Python vs. Java. See their different uses, performance considerations, and info about learning each.

Database/Cloud

What is Google Cloud Composer?

Get an overview of Google Cloud Composer, including the pros and cons, an overview of Apache Airflow, workflow orchestration, and frequently asked questions.

Cheat sheet and frequently asked questions for the AWS Redshift DATEDIFF function

Database/Cloud

Amazon Redshift DATEDIFF Function: Cheat Sheet & FAQ

This how-to guide explains Redshift's DATEDIFF function including arguments, examples, related functions, and frequently asked questions.

Database/Cloud

What is Amazon DocumentDB?

Amazon DocumentDB basics including types of NoSQL databases, DynamoDB vs. DocumentDB vs. MongoDB, and instructions for DocumentDB development.

Learning

Exploring the Data Value Chain

See how companies create value with data, better understand the data lifecycle, and learn how to implement the data value chain.

Tableau Trusted Ticket Authentication using Tableau Server

Embedded Analytics

Trusted Ticket Authentication With Tableau Server

This article describes how Tableau trusted authentication provides Single Sign-On (SSO) for embedded analytics in third-party applications.

Database/Cloud

What is Google BigQuery?

Learn the basics of Google BigQuery including features and functionality, SQL examples, the architecture, and more.

Database/Cloud

Amazon S3 Overview & Cheat Sheet

Use this cheat sheet to quickly reference common S3 commands, buckets, storage classes, lifecycle management, and frequently asked questions.

Learning

What is Google Cloud Dataflow?

Learn the concepts of Google Cloud Dataflow, how it executes data pipelines, its data sources and sinks, and its functionalities/limitations.

Alternatives to Tableau Bridge, with Hybrid Cloud Strategies

Learning

Hybrid Cloud Strategies & Alternatives to Tableau Bridge

If you have data hosted on-premise behind a firewall, you’ll need to think through how to keep your Tableau dashboards fresh. Let’s discuss the pros and cons of the different options available.

Database/Cloud

Cheat Sheet for Amazon DynamoDB

Use this cheat sheet to quickly reference common Amazon DynamoDB commands, identity and access management, and more.

Learning

What is AWS Glue?

Amazon Web Service’s Glue is a serverless, fully managed, big data service that provides a cataloging tool, ETL processes, and code-free data integration. These are services for data that is moved, transformations and managed both within and outside the AWS account. The biggest asset outside of its serverless architecture

Learning

What is Analytic Process Automation?

What is analytic process automation? How can it help your business? Check out this guide to learn everything you need to know about analytic process automation.

Database/Cloud

BigQuery Cheat Sheet

Use this cheat sheet to quickly reference some of the most common Google BigQuery commands, expressions, data types, and more.

Database/Cloud

Cheat Sheet for MariaDB SQL Database Commands

This is a quick reference MariaDB cheat sheet for the most commonly used MariaDB SQL database commands.

Database/Cloud

What is Amazon EMR?

Amazon EMR (Elastic Map Reduce) is a managed 'Big Data' service offering from AWS (Amazon Web Services). With it, organizations can process and analyze massive amounts of data.

Database/Cloud

Apache Spark Cheat Sheet

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

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.