A complete DevOps solution for simplifying Oracle BI development.


    Red Pill Analytics contributors publish their stories on Medium.  Follow our collection.


    Here is a recent story on Medium by one of our writers.


    Below are some featured blogs, if you do not see what you are looking

    for here check out all of our published stories on Medium

    June 16, 2016

    Phil Gordt, BI consultant, petrolhead, traveler, foodie, geek.

    One thing that is for certain is that the cloud is here to stay. With more and more offerings having a cloud component, managing data and applications that are not on-premises will become commonplace. Some applications are optimized for this brave new world we’re living in (Oracle BICS comes to mind), but the old guard still remains, and we will need to be ready for integrating these new technologies into the old

    July 25, 2016

    Lauren Prezby, Red Pill Analytics

    Will you be heading to San Francisco this September for the largest Oracle Conference of the year? Red Pill Analytics will be there presenting five sessions! Oracle OpenWorld is full of great opportunites to talk about new technologies, learn more about the ones you use daily, and see where the world of Oracle is headed.

    July 13, 2016

    Michelle Kolbe, Red Pill Analytics

    This is a topic that I was teaching about last night in my Digital Analytics class at University of Utah and instead of only sharing what I found with my students, I thought I’d share here in the blogosphere.

    Forecast: Partly Cloudy (Part 2)

    June 6, 2016

    Phil Gordt, BI consultant, petrolhead, traveler, foodie, geek.

    If you’re reading this post, you’ve probably seen my other post on connecting OBIEE to Amazon Web Services’ Redshift database offering. If not, thanks for joining in for this part of the adventure. To summarize the last post, cloud applications are becoming increasingly more common, and because of this fact, more of the data that is produced and consumed will be in the cloud.

    May 24, 2016

    Stewart Bryson, Owner and Co-founder of Red Pill Analytics, Oracle ACE Director, BI consultant, writer and speaker

    This blog post is an entry in the ODTUG Kscope16 Cross-Track Blog Hop, an exercise for Kscope expert regulars to take a walk on the wild side, and talk about must-see sessions in a foreign content track.

    May 19, 2016

    Greg Suk, Red Pill Analytics

    The other day I was playing around with the Direct Database Request (DDR) feature within OBIEE. The reason I did this is I wanted to create a report that utilized columns from the database that were not exposed in OBIEE, yet still utilize the functionality of OBIEE.

    April 27, 2016

    Phil Gordt, BI consultant, petrolhead, traveler, foodie, geek.

    OBIEE is a big step up from the earlier versions, and there are plenty of great things to appreciate about it. However, one thing that I am not that excited about is an error that crops up from time to time in Enterprise Manager. 

    April 25, 2016

    Pete Scott, DWH Expert that writes stuff

    At work last week I lifted the covers on the Red Pill Analytics Slowly Changing Dimension ODI IKM for Oracle. If you haven’t heard about this knowledge module, it was specifically written to take a dimension source table and transform it to a slowly changing dimension target table.

    April 14, 2016

    Pete Scott, DWH Expert that writes stuff

    In the depths of time before ODI 12c, ODI Studio had a fairly simple canvas to design our interfaces. We dropped on our datastores (tables) and then dragged columns between tables to create joins, and columns to the canvas to make filters.

    March 30, 2016

    Frank Davis, Red Pill Analytics

    The Big difference between Oracle BI Applications 7.9.X and 11g is the Integration or ETL tier. 11g no longer uses DAC or Informatica. Instead Oracle Data Integrator replaces those components. This cross-reference I created here is for those thinking of or moving to 11g from 7.9.X.

    March 16, 2016

    Frank Davis, Red Pill Analytics

    A look at OBIA’s shift to use SCD1_WID in place of ROW_WID for Slowly Changing Dimensions. A little primer on Slowly Changing Dimensions (SCD). Slowly Changing Dimensions are a star schema design principle and design pattern used to reflect how source data field changes are handled in dimension tables.

    March 16, 2016

    Lauren Prezby, Red Pill Analytics

    The snow is melting and Spring is almost here… which sounds like the perfect time to make a trip to Utah. Stewart Bryson, Oracle ACE Director and Red Pill Analytics Founder, is headed there at the end of March for UTOUG Training Days.


    Check out recent presentation by some of our speakers.

    Kevin McGinley, Red Pill Analytics


    More and more organizations are realizing the value Big Data technologies contribute to the return on investment in Analytics. But as an increasing variety of data types reside in different data stores, organizations are finding that a unified Analytics layer can help bridge the divide in modern data architectures. This session will examine how you can enable Oracle Business Intelligence Enterprise Edition (OBIEE) to play a role in a unified Analytics layer and the benefits and use cases for doing so.

    Stewart Bryson, Red Pill Analytics


    with Kevin & Stewart



    Submit the form below to join the Red Pill Community and receive cool info and offers!


    Follow us...we'll lead.






    info (at) redpillanalytics.com




    Toll Free