Tips 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

Proof that Less can be More

Snowflake Data Warehouse release 2.11 (September 7, 2017) included the addition of an OVERWRITE parameter for the INSERT command. INSERT OVERWRITE effectively consolidates two commands, TRUNCATE TABLE and INSERT, into one. INSERT OVERWRITE also deletes the file load history and retains access control privileges on the target table; both of which are not insignificant details.

Proof that Less can be More Read More »

Red Pill Analytics Tips, Snowflake, Tips

Joining It All Up

When I start a new ETL project I often find it useful to have some idea how the source tables relate to each other. If I’m lucky there is documentation to guide me or even a diagram showing me how the tables link up (I do dream a lot). Of course, I could pull the

Joining It All Up Read More »

Oracle 12c, SQL, Tips

Installing Oracle Data integrator Cloud Service (ODICS)

Oracle Data Integrator Cloud Service is a new-ish cloud service from Oracle that allows us to run ODI as a platform in the Oracle Cloud. There are a lot of moving parts to this cloud service, so the first part of this article will cover creating the Oracle Cloud Database, The Java Cloud Service, and

Installing Oracle Data integrator Cloud Service (ODICS) Read More »

Cloud, ODI, Red Pill Analytics Tips, Tips

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

Installing OBIEE 12c on Exalytics

Red Pill Analytics recently performed the installation of OBIEE 12c on an Exalytics machine for one of our customers. There is no option to use the Domain Management Utility for installing OBIEE 12c… that’s still only capable of installing OBIEE 11g. Therefore OBIEE 12c is a manual install on Exalytics, but it’s very similar to installing OBIEE

Installing OBIEE 12c on Exalytics Read More »

Exalytics, OBIEE, Oracle 12c, Tips

GaOUG Tech Days Session

GaOUG Tech Days is just around the corner: May 9-10 to be exact. We have an incredible venue in Downtown Atlanta called the Loudermilk Center with exceptional event space throughout. We have a great collection of national speakers from the Oracle Community, so the locals in Atlanta can get a feel for larger, more national conferences

GaOUG Tech Days Session Read More »

Events, Tips

Finding an Open Slip

Let’s pretend that you need to change ports within your OBIEE 12c instance due to new applications that natively install into ports that OBIEE is running. Or maybe you want to have the ports be the same as the OBIEE 11g ports. Whatever the reason, how do we go about changing the ports within the

Finding an Open Slip Read More »

OBIEE, Red Pill Analytics Tips, Tips

Which Version Was It Again?

Recently I had to verify the version of an OBIEE installation for a client. As I was already ssh-ed into the Linux machine, I figured there was a way to determine the version without having to log into the presentation server. Turns out, I was right, but for thoroughness sake, I’ll cover both approaches. Using

Which Version Was It Again? Read More »

OBIEE, Oracle 12c, Tips

It All Boils Down To Starting Temperature

We have seen recently how easily false narratives get picked up and repeated so many times that eventually it is believed as true. Perhaps this is an idea that was borrowed from cooking. Cooking has long been rife with traditions and ideas that have been passed down from generation to generation that while the original

It All Boils Down To Starting Temperature Read More »

Tableau, Tips