Entries by Geoff Speare

,

Modern Analytics Framework Series – Part 1: Things to know if you’ve been delaying analytics modernization

Today’s companies have no shortage of data. In fact, they have more than ever before. And they know that, hiding in that data, are insights for better business decisions and competitive superiority.  But even with all the investments they’ve already made, in everything from data marts and warehouses to operational data stores, companies suspect the […]

, ,

Data & Analytics Governance: Change is Happening. Are You Ready?

Governance is the ongoing process of creating and managing processes, policies, and information. This includes strategies, processes, activities, skills, organizations, and technologies for the purpose of accelerating business outcomes. It also involves creating organizations, roles and responsibilities to perform this management. In our experience, many organizations address governance once and often without completing the necessary […]

Agile Data Warehousing with Spark

Data discovery is a “new” technique that takes a less formal and more agile approach to analyzing data. Okay, well, it’s not really new — people have been doing this with spreadsheets for decades — but the products that support it have improved greatly and have forced a more formal consideration of these techniques. The […]

Bimodal Analytics Defined: Balancing Your Approach

Data discovery tools and techniques represent the largest change to traditional business intelligence in the last decade. Instead of being a replacement for enterprise reporting, however, data discovery is a new approach that augments the old methods. Understanding when to use each and how they work together are key elements in implementing a strategy for […]

,

Evolve or Die: Business Intelligence’s Future

Business intelligence has been around for a long time. From decision support systems in the 1960s through Ralph Kimball’s books on dimensional modeling in the 1980s, the core concepts of the discipline are decades old. As these concepts and the products built around them mature, more advanced techniques and technologies come to light that evolve […]

,

ETL vs. ELT – What’s the Big Difference?

ELT is a term heard increasingly in today’s analytic environments. Understanding what it means, and how you can make use of it, requires understanding the traditional nature of how data warehouses are loaded and how data movement tools work. That’s why we’ve pulled this article together: to break down the ETL vs. ELT divide and […]

,

Data Warehousing Basics

Cognos makes extensive use of data warehousing concepts. Most data warehouses are built using dimensional modeling techniques (also known as the “Kimball style”). Data is divided into fact and dimension tables, which are joined together in star schemas. Restructuring data in this fashion takes a great deal of effort, both in planning and implementation. These […]