Posts by Nick Mannon

Google Analytics, Data Management

Implementing ETL Process Steps (to Import Google Analytics into Data Warehouse)

In the second installment of this ETL process blog post series, Nick Mannon will share a detailed ETL example using Google Analytics data. Specifically, he will show you how to create the data model, the database, develop the ETL, and test/implement. Ultimately, giving you the ability to setup a data warehouse that best fits your needs and data.

Read More

Apr 7, 2018    0 Comments

Google Analytics, Data Management

Defining ETL Process Steps (to import Google Analytics into Data Warehouse)

ETL stands for Extract, Transform and Load, but what does that really mean? In part one of this two part series, Nick Mannon uses Google Analytics as the data source, and he provides a simple explanation of the strategy behind an ETL process, teaching you how to create an ETL infrastructure and define ETL Data Requirements. These two steps are essential in successfully transforming, enhancing, and cleaning your data. Keep an eye out for part two next week where he dives into ETL implementation!

Read More

Mar 27, 2018    0 Comments

Data Management, Data Visualization

Meet Tableau’s New ETL Tool: Project Maestro

We love Tableau for putting data, analysis, visualizations and dashboards into the hands of anyone. Now we love them even more for developing Project Maestro, giving everyone the ability to perform ETL! Nick Mannon, data management and visualization consultant, reviews what Project Maestro is, and how you can use it to easily extract, transform, and load your data. This will ensure accurate and clean data so you can spend less time manipulating it, and more time analyzing it!

Read More

Jan 14, 2018    0 Comments

Data Visualization

Data Visualization Techniques: Adopt an Agile Process

Playing with a new data visualization tool is fun and exciting at first, but at some point you might want to use it more efficiently. And adding visual analysis to your regular business practices is a worthy effort that can be overwhelming if you don’t have a plan. Find out how to follow our nimble process, called the Cycle of Visual Analytics. By focusing on only a few questions, iterating and learning as you go, you can expect faster, more relevant results.

Read More

Jul 31, 2017    0 Comments

Analytics, Data Management

Hey! You! Get Onto the Cloud!

There are many good reasons to manage your data in the cloud to meet IT and business needs. And, when I went to AWS (Amazon Web Services) Summit 2017 in San Francisco, dare I say, it opened my mind to even more reasons for utilizing cloud platforms. The advancements in technology and improvements in services continue to make AWS a compelling solution to meet many requirements.

Read More

Jul 2, 2017    0 Comments

Data Visualization

Tableau Conference 2016: Top 10 Future Features

Many new features were announced at Tableau Conference 2016. Get the inside scoop from one of our resident data visualization and dashboard experts who will provide an overview of his favorite Top 10 new features, and how you can use those features to enhance your visualizations. By the end of this post you’ll be dying to get your hands on the latest and greatest from Tableau.

Read More

Nov 30, 2016    0 Comments

Analytics, Data Visualization

Tableau Tips: Review of New Cross Database Joins

Data analysts have been waiting a long time for Tableau to add the Holy Grail of functionality, cross database joins. And with Tableau 10 just around the corner, it is on the threshold of arrival. Get ready for a shorter, more simple path to a holistic picture of your data.

Instead of being dependent on IT, you can join data to create reports and visualizations to answer your own questions.

Read More

May 31, 2016    5 Comments

Analytics Blog

We're here to help with tips and insight on the following topics:

Subscribe to RSS


Stoke Your Passion for Digital

Subscribe for a monthly digest of analytics tips, digital marketing news, and case studies from experts certified with Google, Adobe, Tableau, Tealium, and more!




Connect with Blast Analytics & Marketing