Big Data Archives - Red Pill Analytics

Grand hallway with a black and white checkered floor, symbolizing structured data and open data sources for analytics and business intelligence

Got Technology, Need Data? Here’s the Best Free Data Sources for Analytics & AI

Photo by Cristina Gottardi on Unsplash The Data Challenge Have you ever wanted to assess or explore a new BI, analytics, data visualization, data science, etc. technology, but struggled to find a data set to use for your assessment and exploration activities? Have you grown tired of analyzing the “typical” free data sources–think census, stock […]

Got Technology, Need Data? Here’s the Best Free Data Sources for Analytics & AI Read More »

Big Data, Business Intelligence, Data Integration, Data Visualization, Free Data Sources, General, Open Data, Public Data Sets, Tips

What’s the Big Deal with Big Data?

What HBR’s Winter 2017 OnPoint Tells Us About Business & Data It was a November evening that I was at the grocery store, waiting in the line to check out when I saw the latest issue of Harvard Business Review’s OnPoint publication. For those that are unaware, OnPoint is a seasonal publication that focuses on a particular

What’s the Big Deal with Big Data? Read More »

Big Data, Data

The Good, The Bad, and the Gorgeous

Some tips, tricks and thoughts on using Google Data Studio Red Pill Analytics recently delivered a solution that exclusively used Google Cloud Platform. Our client, a marketing team at Google, wanted to know how they were engaging with users across several online channels. We used Google Analytics, YouTube Analytics, AdWords, among other sources via BigQuery to

The Good, The Bad, and the Gorgeous Read More »

Big Data, Cloud, Data, Data Visualization, Google Cloud Platform

Big Data Tundra: Creating a Flexible Cloud Based Data Ecosystem

Did you miss Phil Goerdt and Mike Fuller‘s presentation about Cloud computing and storing data at MinneAnalytics #BIgDataTech last week? Let us share their presentation with you! Download it here! Cloud computing has changed how organizations use, access and store their data. While these paradigms have shifted, the traditional way of thinking about databases and data warehouses remain steadfast in

Big Data Tundra: Creating a Flexible Cloud Based Data Ecosystem Read More »

Big Data, Cloud, Events, Snowflake

Because… Tradition?

Who doesn’t love traditions? While I am not the most nostalgic guy, I certainly have a handful of traditions that I hold dear. I think as we blaze bravely ahead, it’s important to remember where we come from, both good and bad to influence a better future. Sure, we all have traditions on a personal

Because… Tradition? Read More »

Big Data

BI-dentity Crisis

I had just gotten out of a discovery meeting with a client when she said “I’m sure we’re the worst you’ve seen”. The goal of the meeting was to better understand the process they were using, the data source, and how they were consuming that data. Turns out that data was entered into Share Point

BI-dentity Crisis Read More »

Analytics, Big Data, Business Intelligence, Data Science, Strategy, Tips

OTN Appreciation Day: Oracle Data Integrator 12c Flexibility

Well… it looks like Oracle ACE Director and former colleague Michael Rainey beat me to the topic. But as I read his story… I realized I could approach this in a slightly different way, so I decided to press on with my own take on ODI 12c Flexibility for Oracle Technology Network (OTN) Appreciation Day.

OTN Appreciation Day: Oracle Data Integrator 12c Flexibility Read More »

Big Data, Data Integration, Oracle 12c, Oracle Technology Network

Modules of Knowledge

One of the features of Oracle Data Integrator that sets it apart from other data integration tools is the use of Knowledge Modules to define how parts of the data integration process occur. The developer creates a data load mapping from sources, joins, filters and targets (and in ODI 12 even more components are available).

Modules of Knowledge Read More »

Big Data, ODI, Snowflake

Preparing Excel Data For Analysis

Whether you are using Excel as a data source for your Business Intelligence (BI) platform, or you are doing the actual analysis within Excel, your data will need to be in a format that is queryable. Often though, the data is formatted to be read visually, whether an export from a system, or manually entered.

Preparing Excel Data For Analysis Read More »

Big Data, Business Intelligence, Excel, Red Pill Analytics Tips, Tips, VBA