Red Pill Analytics is looking forward to placing some bets in Las Vegas for Collaborate18 on April 22–26, 2018. We are honored to be joining the amazing lineup of presentations and panels filled with the latest tips and information about various Oracle topics. Along with presenting Red Pill Analytics likes to take an active role […]
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 […]
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 […]
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 […]
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 […]
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 […]
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” datasets–think census, stock market, and employment and inflation rate data–known to be publicly available? […]
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. […]
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). […]
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. […]