Oracle VM Consulting
view counter

Data Warehousing Feed

Oracle Data Warehousing, reporting, online analytics, and data mining resources, news, and support articles.

Better Data Modeling: The Book

Trying to be as productive as possible during my infrequent down time, I just published another Kindle book with some of my best tips for Oracle Data Modeler. it is called Better Data Modeling: Tips for Enhancing Your Use of Oracle SQL Developer Data Modeler. If you are one of the 3.5 million users (or […]

End Your Data Modeling Pain

Tired of hand drawn data models, or models drawn in Visio or even PowerPoint? Still limping along on an old Oracle Designer repository? Can’t afford the license for your current modeling tool anymore? Or maybe your shop has no documented data model diagrams at all (horrors!). Well, if you were an Oracle Designer user and […]

Meet me in Austin?

Late breaking news (aka I forgot to post this earlier)! I will be speaking at the first meeting of the Austin Oracle Users Group for 2015. It will be this coming Friday February 27, 2015 starting at 11:00 AM. I will give an intro talk on Oracle SQL Developer Data Modeler (the FREE data modeling […]

The 12 Steps to Faster Data Warehouse Success

Announcement! I have exciting news! With the help of my good friend Dan Linstedt (of fame), we have just launched my first online training video based on my very popular white paper and talk: Agile Methods and Data Warehousing: How to Deliver Faster. Most of you will agree that data warehousing and business intelligence […]

Better Data Modeling: The Data Warrior Speaks 2015

Great news, I have confirmed three major events, and one local event so far this year where you can come out and hear me speak about some of my favorite topics: #DataModeling, #SQLDevModeler, and #DataVault. So, line up your training budget and get registered for at least one of these great events. DAMA Houston My […]

New Year, New Name, Same Mission

Happy New Year! Looks like it will be another busy one. So, let’s get going! Yes, I just changed the name of my blog from “Oracle Data Warrior” to “The Data Warrior.” Why? Well, for one, my company name is Data Warrior LLC, so it seemed to make sense. Plus over the last few years […]

Are you ready to learn something new in 2015?

We all know the saying: When the student is ready, the teacher will appear My advice is to empty your cup, daily, so that when the teacher appears you will recognize them. Unless we are humble in our hearts and in our spirit, we are not open to new things and to learning. The teacher […]

Data Warrior 2014 in Review

The stats helper monkeys prepared a 2014 annual report for my blog. Not as many posts as 2013 (I was way busy), but sure got a lot more traffic than I realized! Here’s an excerpt: The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 58,000 times in […]

Weird Results When Calculating Percentages or Ratios…

While I was looking into a calculation issue today for a calculated percentage, let’s say the formula is ((b-a)/c)*100, the numbers just were not coming out correctly. Actually they were all coming out to 0!!! I know this was not right, so I investigated. I looked at my physical query and noticed OBI was creating that formula as FLOOR((b-a)/nullif(c,0))*100. Well, that explains it! Why was the BI Server adding this FLOOR function? It did not make sense to me. So how do I make or trick the BI Server to not do this. I asked my friend google. He had no answers.

Early Christmas Present: Oracle SQL Developer Data Modeler 4.1 Beta is here! (Still FREE)

Just saw this tweet from Oracle Product Manager Ashly Chen: Happy Wednesday! Data Modeler 4.1 Beta is available for download. — Ashley Chen (@ashleychen5) December 3, 2014 Get thee to the site and download away! Did I say, it is FREE? (Do remember it is BETA as use it accordingly) Cheers! Kent The Oracle […]

view counter