Data Management Posts

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

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

April 7, 2018    0 Comments

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

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

March 27, 2018    0 Comments

Avoid Penalties and Build Trust by Becoming GDPR Compliant

Analytics, Data Management

Avoid Penalties and Build Trust by Becoming GDPR Compliant

What is GDPR and why does it matter? The deadline is coming fast (May 25, 2018) and most are not prepared and are at risk of huge penalties and brand damage. If it isn’t a top priority to become GDPR compliant, it should be. Odds are that you are overwhelmed like many are, and if you are looking for a simple explanation of GDPR that you can finally wrap your head around…you’ve come to the right place!

Turn GDPR from a threat into an opportunity for your brand to stand out and build trust with your audience (customers).

Read More

February 9, 2018    3 Comments

Meet Tableau’s New ETL Tool: Project Maestro

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

January 14, 2018    0 Comments

Validate 2017: Top 6 Data Governance Takeaways

Data Management

Validate 2017: Top 6 Data Governance Takeaways

Up until now, data governance hasn’t received a lot of attention, especially within digital analytics, but that’s changing. Data-driven decision making is driving the focus on data governance to ensure business decisions are based on accurate data.

Hear our Top 6 takeaways from Validate 2017 — the recent ObservePoint conference in Park City, Utah. These tips and takeaways are straight from analytics industry experts and include insights regarding the future of data, how to break down barriers between Marketing and IT, whether or not you should add a Chief Data Officer (CDO) to your organization, and more.

Read More

October 16, 2017    0 Comments

Hey! You! Get Onto the Cloud!

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

July 2, 2017    0 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