September 14, 2017

|

by: pete.scott

|

Categories: Oracle 12c, SQL, Tips

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 […]

November 16, 2016

|

by: GregSuk

|

Categories: Analytics, OBIEE, Oracle, Repositories, SQL

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 […]

October 17, 2016

|

by: GregSuk

|

Categories: BICS, Cloud, Oracle, SQL

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 easiest [...]

October 11, 2016

|

by: pete.scott

|

Categories: General, OTN, SQL

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 […]

September 29, 2016

|

by: Mike Fuller

|

Categories: OBIEE, Snowflake, SQL

Employees at the Minneapolis Red Pill Analytics office recently had the luxury of sitting with Snowflake’s Steve Herskovitz for some on-site education. Among other things, one of my key takeaways from the exercise was how simple it is to query JSON data in the Snowflake Data Warehouse. The syntax is straightforward and makes the process […]

March 8, 2016

|

by: pete.scott

|

Categories: General, SQL, Tips

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 […]

0
0
without
http://redpillanalytics.com/wp-content/themes/vanguarda/
https://redpillanalytics.com/
#b63524
style1
paged
Loading posts...
/home/redpil9/public_html/
#
on
none
loading
#
Sort Gallery
on
yes
yes
off
Newsletter Input text
off
off