Data Warehouse Survey Update

It’s the end of October now which means that the autumn trade show season is drawing to a close. This year we sponsored and exhibited at the TDWI World Conference in San Diego (and in Chicago earlier in the year), and the Teradata PARTNERS Conference in Nashville. Once again we gathered survey responses in our booth, so I took a look at how things have changed, or not, since last year’s update.
Read more

Building the Data Warehouse Semantic Layer

Kimball Group puts out some fantastic design tips, and one I especially liked in the last year was one from Joy Mundy (Design Tip #158 Making Sense of the Semantic Layer).  The arrival of this in my inbox was extremely timely because I was at the time involved in a disagreement with a BI consultant who was currently specialized in one of the new breed of BI tools.  His position was that semantic layers were unnecessary and the realm of “traditional, IT-centric reporting environments.”  If I didn’t understand that, well, I just didn’t understand the niche that particular product was fulfilling towards the goal of enabling ad-hoc end user reporting without IT involvement.  The argument started because I was inquiring about the capability of third-party solutions like Kalido of preconfiguring the semantic layer for the tool rather than having to manually configure it. Read more

The Agile BI Ship Has Sailed – are you on a Tanker or a Jet Boat?

I recently took a very touristy outing in Boston when we went on the “Codzilla” boat ride in Boston Harbor. On a hot day, it is great. The boat goes out of the harbor, gains speed, and then tries to get everyone wet by turning sharply and quickly, stopping short and diving forward, and generally stirring up the water until it is falling over the decks and spraying the crowd. On the day we went there was at least one tanker moored in the distance – quite the opposite of the fast and agile boat we were on. Read more

Breaking through the wall – a race won before it even starts

“Breaking through the wall,” the metaphor used by runners to describe the moment when they break the shackles of fatigue and their practice and determination pay-off, seems apropos as my “fitter” Magnitude Software colleagues recently tackled the London and Brighton Marathons. Congratulations to our runners and their amazing achievement! Read more

Announcing Magnitude Software

We’ve had a busy few weeks that have led up to today’s announcement that Kalido and Noetix have joined forces to become Magnitude Software. Everyone here in the new company is excited by the future we’ve planned for ourselves and for our customers. This combination of a strong and established set of BI, reporting, analytics, data warehousing and MDM products creates economies of scale which will increase our competitiveness and profitability and attract additional investments, which will enable us to invest more in our products and our customers.  Read more

A Common Explaining Language Leads to Understanding

“I can explain it to you, but I can’t understand it for you.”

A good friend of mine recently alienated the person that pays his salary with the above statement. While you might question his wisdom – I know I did (after a quiet chuckle) – I’m reminded of how often the same thought has gone unsaid when business and IT “collaborate” on traditional data warehouse projects. The business is baffled by the technical jargon that IT uses, and the IT team wishes the business could articulate their requirements in a form from which they can build the solution. The lack of a common language to explain what each side means hinders this understanding. Read more

Get Ready for a Major New Release

Wow!  The Kalido-sphere is buzzing with excitement these days.  Between the recent briefing with the BBBT, the multi-city Qlik to Discover Roadshow with Qlik with just completed stops in Jersey City, Chicago, Philadelphia and Toronto, and the upcoming, much anticipated new release of the Kalido Information Engine, there’s no shortage of news around here. Read more

Modeling Efficiencies Using The Kalido Approach

I took my first Kalido training class in October of 1997 and I’ve been involved with Kalido ever since.  Because I’ve used Kalido for so long, it’s often easy for me to forget all of the things people had to do manually prior to Kalido coming around.  I recently saw a book by Oracle ACE Kent Graziano called “A Check List for Doing Data Model Design Reviews” on Amazon, so I grabbed a copy. Read more

What’s The Real Burden in ETL?

Readers of our corporate blog and followers of the Kalido message know we have been promoting “No ETL” in the context of data warehousing. Inevitably this leads to ETL tool vendor outrage at the notion that you don’t need ETL. So let me be clear: we believe you will always need the concept of Extract, Transform and Load. However, most ETL tools do not automate many data integration concepts – they just provide a mechanism for a human to create that manually. Our approach is to keep the concept of ETL – extract data from multiple sources, transform it and then load that data into the data warehouse tables – but to automate this process. With Kalido, you don’t always need a separate ETL tool to do it. Read more

The less things change, the more they stay the same

In 2012, we surveyed attendees at TDWI World Conferences regarding topics related to data warehousing: how they handle change, how long it takes to deploy new data, costs associated with supporting the data warehouse and so on. Over this period we received well over 500 responses and have blogged about it and shared information in other places such as infographics on our website. Read more