October 27, 2017 was our second annual U Girls Code event at University of Utah. The idea for this event came from Tyra Crockett, from Oracle Academy, and I. We convinced University of Utah’s TEK Club to host the event as it is good exposure for their program to have the girls in a university […]
Teaching Girls to Code at U Girls Code — Year 2 Read More »
Coding, Events, Oracle, Women In Tech, workshops
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
Double down on Red Pill Analytics at Collaborate 2018 Read More »
Analytics, Big Data, Business Intelligence, Cloud Computing, Data Analytics, Industry Events, Oracle, Red Pill NewsI have a report that works fine in OBIEE 11g but when upgraded to 12.2.1.2, it gives an error stating: [nQSError: 22025] Function TimestampAdd is called with an incompatible type. This report has a SQL Expression in a filter that states: TimestampAdd(SQL_TSI_HOUR, 4.5, CURRENT_DATE) The problem is that we are trying to add hours onto
TimestampAdd Error in OBIEE Migration from 11g to 12c Read More »
OBIEE, OracleThis post is part 1 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE). Overview of BVT With the 12c release of OBIEE, Oracle released a new tool called the Baseline Validation Tool or BVT. This tool allows you to run specific tests against your OBIEE reports, dashboards, and BI Publisher
Using Oracle’s Baseline Validation Tool with OBIEE — Part 1 Read More »
Coding, OBIEE, Oracle, Oracle 12cAs I’ve been discussing in my last few blogs, it’s possible to start using OBIEE for analytics, rather than the standard operational reporting and BI that is commonplace. Data science has been quite the buzz the last few years, and no doubt about it, data scientists can bring great value and understanding to an organization,
Clustering. Whether we’re talking about headaches, compute nodes, or uh, well, I’ll let you fill in the blank… isn’t anything worth doing, worth doing together? Clustering can be a powerful tool for understanding the relationships between data, and in this post I’ll walk through how to use the OBIEE 12c Advanced Analytics Cluster Function. As
Recently I had a couple of interesting situations pop up in OBIEE 11g regarding dates. No not the edible kind, but the calendar kind. Specifically where it involves fact measures that are valid for a period of time beyond what the date id(s) on the rows in the table allow. The first scenario I will
[vc_row][vc_column][vc_column_text] In this series I have been exploring various cloud Buisness Intelligence product offerings from companies like Domo and Tableau. Now it is time to review Oracle’s newish offering Business Intelligence Cloud Service (BICS). First of all, if you are going to combine data sources for your analysis, versus having, say, a single spreadsheet to load, the
Is Oracle BICS For You? Read More »
BICS, Cloud, Oracle, SQLI know it sounds like I am writing about 1980s technology, and I am, but the fact remains that Excel is still a widely used tool in the business world. Besides, what else would you put your data dumps into? Often Excel reports get used for management reporting, which comes with a number of issues.
How to get BI with Excel Read More »
Analytics, BICS, Business Intelligence, Cloud, Coding, Data Visualization, Excel, Oracle, Tips, VBA