Posts

Modeling to Support Agile Data Warehouses: Hyper Normalization and Hyper Generalization

I was in Las Vegas recently for The Data Warehousing Institute conference helping out with our Magnitude Software booth, and I noticed one of the classes being taught there was “Agile Data Engineering:  New Data Modeling Techniques that Readily Adapt to Constant Change.”

Read more

Essential Thinking for BI Requirements

In a recent TDWI interview, Jonathan Geiger, executive VP of Intelligent Solutions Inc, discussed how to improve the process of requirements gathering for BI projects.  Several things immediately stood out from the interview as his suggestions were quite consistent with the methodology and technology at Kalido.

Read more

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

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

Estimating Velocity

Velocity is perhaps the most important concept in agile development. In his recent Agile 101 class at the TDWI BI Summit in San Diego, Ralph Hughes defined velocity as “The number of story points that can be delivered comfortably in an iteration.” That estimate effects many other estimates, such as the size and mix of your teams, as well as the number of iterations needed to deliver the full project scope—all of which impact the budget. Read more

Data Efficiency and Agility Explained

We have written a lot about data agility and efficiency in the Kalido blog. I recently provided the results of our ETL-based Data Warehouses survey, and Allen Johnson wrote about the recent report “Measuring the Half Life of Data” by Nucleus Research. Read more

Business Intelligence Trends for 2013

Halloween is over, retail stores are hanging holiday garlands, and the BI analysts are serving up their annual predictions for next year’s top technology trends.  It looks like some exciting and impactful technology innovations are coming our way. Read more

Survey Results on ETL-Based Data Warehouses

During 2012 we have been surveying TDWI World Conference attendees about their data warehousing investments. We wanted to know their thoughts and experiences on a variety of topics, ranging from whether they felt like IT and “the business” are on the same page in terms of keeping the warehouse up to date with the latest requirements, how long it takes to keep the warehouse current, and how many resources they expended on supporting their environment. We’ve received a little over 400 responses from events in Las Vegas, Chicago, San Diego and Boston. Read more

Visit us at TDWI San Diego

We’ll be attending the TDWI World Conference San Diego, and showing visitors to booth #108 how we lower the barriers to creating the agile foundation you’ll need for big data analytics. Here are a few items we’ll be sharing there and are happy to share with you here. Read more