General 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

OTN Appreciation Day: A Journey From Newbie to Veteran

As a business professional with little prior technical experience who moved over to the technical side of an Oracle-centric organization, the Oracle Technology Network (OTN) was an invaluable resource for me to quickly make the transition from newbie to full fledged Oracle developer. Thanks to OTN resources like product documentation, technical articles, discussion forums, tutorials,

OTN Appreciation Day: A Journey From Newbie to Veteran Read More »

General, Oracle Technology Network

OTN Appreciation Day: Looking for Change

As you may have seen in the Twittersphere, today is a special date in the Oracle community, a day where we can express thanks to OTN for wealth of technical content that makes our life easier.For my tiny contribution to the day here is a little note on detecting change using SQL MINUS, maybe not

OTN Appreciation Day: Looking for Change Read More »

General, Oracle Technology Network, SQL

Influential Women in Technology

To celebrate Women’s History Month, the morning radio program today was asking people to name a woman that has influenced them whom they’ve never met. This question got me thinking. What would you say? Who’s influenced you? The responses on the program ranged from Lady Gaga to Hillary Clinton to Mother Teresa. My response would

Influential Women in Technology Read More »

General

Making Stuff Up

My whole data career has been about finding the truth within data, seeking correlations within and between data sources (and not always relational sources at that). You get to notice patterns in the world and even develop skills to spot outliers on a rapidly scrolling screen. In those early days I used tools like i2

Making Stuff Up Read More »

General, SQL, Tips

User Groups Matter

How many times this week have you googled a technical question and found a blog, an article, a forum post or slides from a presentation? I do this multiple times per day! And while my undergraduate degree taught me a lot, especially how to approach problems, I learned most of what I know about business

User Groups Matter Read More »

Events, General, Red Pill News

Oracle BICS DITL Part 01

Red Pill Analytics recently purchased a license for the Oracle BI Cloud Service (BICS), and with our account being activated, I thought I’d take it for a spin. But rather than write a garden-variety series of how-to articles, I thought I’d give you a first-hand look, or a day-in-the-life (DITL) experience of what it was

Oracle BICS DITL Part 01 Read More »

General, Oracle BICS, Tips

I’m the Best Choice for the ODTUG Board

I’m the Best Choice for the ODTUG Board If you know me well, then the title of this story shouldn’t surprise you. I’m not short on confidence (okay… pun intended). But let’s face it, everyone running for the board believes they are the best choice for ODTUG, or they wouldn’t waste the time and effort.

I’m the Best Choice for the ODTUG Board Read More »

General, Red Pill News

Direct Database Request -Part 2

In Part 1 of my story on OBIEE’s Direct Database Request (DDR), I walked through the basic process of how to use DDR for directly querying a database mapped ino the RPD without using logical SQL, bypassing the metadata layer and going straight to the connection pool. In Part 2, I’ll be pointing out what works differently

Direct Database Request -Part 2 Read More »

General, Tips

Partnering with Peak Indicators

Stewart and I have both conducted training frequently in our past lives, so one of the things we wanted to include within Red Pill Analytics’ offerings is Oracle training. We’ve found over the years that boutiques tend to deliver a better training experience than Oracle because the trainers tend to be people with real world

Partnering with Peak Indicators Read More »

General, Red Pill News