Experienced data scientists and developers are spoilt for choice when it comes to data analytics tools. But for those who don’t hail from a data-centric background, it can prove to be quite a challenge.Data operations platforms like Keboola are valuable…
Continue reading Top 5 Keboola Alternatives: Weighing Expertise and Ease of Use
Some people think you only need a data warehouse if you have huge amounts of data. That used to be true. It’s not anymore.These days, any business that uses Salesforce, Shopify, Twitter, an online accounting tool, and other online systems is…
WordPress and Google Analytics are two BI tools (Business Intelligence) that go together like peas and carrots (if you’re into that sort of thing). WordPress powers over 35% of websites today and Google Analytics is running on over over 53%…
Continue reading How To Combine And Analyze WordPress And Google Analytics Data Together
This post has been updated to reflect changes to Instagram’s API (Facebook’s Graph API). You will now need to switch to anInstagram Business accountto perform this analysis in Panoply.Ok, Instagram datanauts, welcome back to the second installment of our ongoing…
Continue reading Analyzing Instagram API Data, part 2: Engagement Over Time
Elasticsearch is the search and analytics engine that powers the Elastic Stack, a suite of products from the Elastic company. This popular search and analytics engine searches websites, apps enterprises, maps, logs, IoT data sources, and more, and creates a…
Continue reading Extract Data from Elasticsearch: Top 10 Tools for ETL
Twitter, the punchy platform that gave us the #hashtag, turned 13 this year.Thankfully, it’s not a real teenager. But the iconic blue bird has done a lot of growing up, especially as a business marketing channel.75% of B2B businesses are…
One billion people use Instagram every month. 4.2 billion likes each day—to be exact. With over 25 million businesses using Instagram, the competition is fierce for all that attention.For brands trying to grow this year, Instagram analytics tools have become…
Continue reading Follow the Data: the Top Instagram Analytics Tools
The R Project is an open source programming environment that supports statistical computing and graphic design. For R work or any data operations, you need an ETL tool (extract, transform and load) to process your data from its source to…
Applying a modernized approach to the concept of data management is a necessity in today’s cloud computing environment. This facilitates insights by embracing full transparency across your data lifecycle, allowing seamless extraction of the most useful data, all at the…
Continue reading Cloud Data Management Concepts And Techniques
Today I want to show you how you can combine performance metrics from three popular ad networks, Google Ads, Bing Ads, and Facebook Ads without exporting a CSV or writing a single line of code. Then I’ll show you how…
Continue reading Combining Data from Google Ads, Bing Ads, and Facebook Ads in Google Data Studio
We recently worked with Aron Clymer, CEO of the data consulting firm Data Clymer to show you how you can consolidate all of your analyze your Shopify ecommerce data from any number of sources into a data warehouse and display…
Continue reading Building a Shopify Ecommerce Dashboard with Looker
Cloud-based data warehouses are quickly replacing their on-premise counterparts, allowing organizations with big data needs to potentially save millions in costs. Amazon Web Services’ Redshift data warehouse platform is one of the most popular, offering relatively easy set up from…
Continue reading Setting Up A Cloud Data Warehouse: A Schema To SQL Tutorial
