ETL. It should be fairly straightforward, right? We extract data, transform it as needed, and load it into the target application. But like the recipe for the perfect ...

ETL/ELT

The Worst Advice We’ve Ever Heard About ETL

By An Bui   |   February 27, 2018

As an analyst who deals with data from many data sources daily, you might find yourself as the go-to source for information about business intelligence in your office. ...

Data Warehousing

9 Things Your Boss Wants to Know About Data Warehousing

By An Bui   |   February 7, 2018

Your company sits on an immense treasure trove of data, but tapping this data and accessing its value can be a challenge.

Data Stack

Get Stacked: Designing a High Performance, High ROI Data Stack

By An Bui   |   January 30, 2018

Like most data teams, Kimberly Clark’s EMEA Omnichannel team has results, insights and findings to deliver to dozens of stakeholders. The team also has data scattered ...

Customer Stories

How Helena Carre of Kimberly Clark Uses Panoply

By Jason Harris   |   January 24, 2018

Amazon Redshift is a very powerful data warehouse, optimized for analyzing massive amounts of data in a blink of a second, when configured right.

Redshift

Redshift Benchmark: A First Test of the Entire Data Funnel

By Roi Avinoam   |   January 24, 2018

As a member of the marketing team you already know that data is power. However, it’s not always easy to get, and even when you can get the data you need, it’s not always ...

Data Analysis

A Marketing Professional's Guide to Collecting Twitter Data

By An Bui   |   January 19, 2018

Data analytics is a requirement for virtually every business today. However building an analytical data warehouse requires vast computing power to maintain performance ...

Data Warehousing

How to Move Your MySQL to Redshift

By Roi Avinoam   |   January 10, 2018

The data industry continues to impress with new tools being released every month. While we all love choices, the current data stack landscape can be overwhelming. We’re ...

Data Stack

Top Tools For A Dangerously Effective Data Stack

By An Bui   |   December 20, 2017

Pressed by the end-of-year holiday rush, we all feel the pain of trying to do more. To help you get some time back, we've made our data warehouse even smarter—which ...

Panoply News

Now Available in Panoply: Faster, More Transparent Data

By Elena Levi   |   December 14, 2017

Data warehouses and data lakes are two different types of data storage repositories. Data warehouses integrate data from various sources and structures them for business ...

Data Warehousing

Key Differences Between a Data Warehouse and a Data Lake

By An Bui   |   November 21, 2017

Following the steady growth trajectory of customer onboarding, with a select-user rollout in late 2016 and a quiet launch in February 2017 that has ballooned to over 100 ...

Product

Announcing General Availability on Data Warehouse in the Cloud

By Paul Friesen   |   November 14, 2017

The future of any successful enterprise will hinge on its ability to harness and use massive amounts of data currently available, to improve productivity, decrease ...

Data Warehousing

Database vs Data Warehouse - What's The Difference?

By An Bui   |   November 7, 2017

You're probably reading this post because it's time to choose a database, and you're a little stuck. You may be leaning towards PostgresSQL and want to see how it stacks ...

Databases

PostgreSQL vs MariaDB: In-Depth Comparison

By Malsha Ranawaka   |   November 1, 2017

Business Intelligence (BI) has, by tradition, been a long and drawn out process. In the early days of computers, BI tools such as SAP/Crystal Reports and IBM/Cognos came ...

BI and Data Visualization

Embedded Analytics with Power BI and Azure

By Cheryl Adams   |   October 25, 2017

As your organization moves its data into the cloud, you face the challenge of balancing productivity and efficiency gains with tremendous compliance and security ...

Data Industry Trends

Cloud Security Best Practices

By Cheryl Adams   |   October 25, 2017

Preparing data for Business Intelligence (BI) can be a very tedious and time consuming process. You want the data to turn into the best reports for analysis. But, the ...

BI and Data Visualization

How to Prepare Data for Business Intelligence and Analytics

By Alon Brody   |   October 24, 2017

Every single day we, as a connected – mobile – workforce, are creating vast amounts of data. In fact, a recent Cisco report indicates that by 2020, data center storage ...

Data Industry Trends

How Big is Big Data - Discover New Ways to Leverage Data

By Bill Kleyman   |   October 18, 2017

Managing big data is a never-ending challenge. Extract, transform, and load (ETL) processes serve as the traditional foundation for enterprise data warehousing. However, ...

Data Industry Trends

ETL: Will it survive big data?

By Cheryl Adams   |   October 17, 2017

Is it easy to connect to a data warehouse? Selecting the right tool can help make this connection attainable. Tableau Desktop makes this connection easy, from opening ...

Data Warehousing

Connecting to Data Warehouses in Tableau

By Cheryl Adams   |   October 6, 2017

If you ask a group of big data analysts what are some of the top professional challenges they face, you can easily imagine which challenges are consistently shortlisted. ...

Being Data-Driven

How To Get People to Share Data

By Cheryl Adams   |   September 27, 2017

There are many risks involved with data security. Storing data in the cloud might seem like a safe bet, and for most users it is. But risks will always exist. Below we ...

Best Practices

Top Cloud Data Security Risks, Threats, and Concerns

By Cheryl Adams   |   September 27, 2017

One of the most critical steps in building a data warehouse or building a data lake is integrating your data sources into one format.

ETL/ELT

ELT vs. ETL: Differences in Design and Architecture

By Malsha Ranawaka   |   September 20, 2017

As more organizations begin their journey to the cloud, they need to plan how they will apply the best practices of data management to ensure that cloud-based, ...

Best Practices

Data Management Best Practices for Cloud Computing

By Cheryl Adams   |   September 19, 2017

There’s no question that the cloud offers many potential benefits. Major companies everywhere are lining up to reap the benefits by moving their back-office systems to ...

Data Warehousing

Enterprises Eye Big Benefits from Cloud Data Warehouses

By Cheryl Adams   |   September 12, 2017

Are you considering a career as a BI Architect? You have made an excellent choice. Business Intelligence Architects are some of the leading minds in business and ...

Analytics Leadership

Business Intelligence Architect: Defining the Role

By Cheryl Adams   |   September 12, 2017