Tags

Joining It All Up

September 14, 2017

|

by: pete.scott

|

Categories: Oracle 12c, SQL, 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 […]

Date Spread

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

Is Oracle BICS For You?

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

OTN Appreciation Day: Looking for Change

October 11, 2016

|

by: pete.scott

|

Categories: General, OTN, SQL

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

Kicking with JSON in the Snow

September 29, 2016

|

by: Mike Fuller

|

Categories: OBIEE, Snowflake, SQL

Kicking with JSON in the Snow

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

Making Stuff Up

March 8, 2016

|

by: pete.scott

|

Categories: General, SQL, Tips

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