Entries by Geoff Speare

, ,

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

Gantt Charts Using Cognos 10.2.1 RAVE Technology

The IBM Rapidly Adaptive Visualization Engine (RAVE) is a new tool introduced in Cognos 10.2.1. The engine can run on the server or the client, allowing for the dynamic creation of both static and active charts. Additionally, visualizations can be tweaked to allow for new charting options on the fly. IBM’s AnalyticsZone website provides a […]

Building Effective IBM Cognos Active Reports: Part 3

Part 1 of Building Effective IBM Cognos Active Reports, described Active Report variables, connections, and how they work together to make dynamic content possible in Cognos 10 Active Reports. Part 2 began a discussion of static controls and how to make larger changes to an Active Report display. This article, Part 3, continues that discussion […]