Ditching the Database

Susan Andre Articles

Each introduction of the grandest, biggest and latest database comes with a promise in the line of “this database will make all the data available to all your users in a flash”. Brilliant advances in technology ranging from in-memory, ACID-compliant databases, HADOOP, Hana, super-fast, petabyte-handling databases do provide grounds for database administrators becoming hugely excited. Yet in the BI world, …

Time to Expel Excel

Susan Andre Articles

Does your business show symptoms of spreadsheet abuse? On the one hand you may shudder at the thought of “expelling” Excel because you find it difficult to imagine how else to delve into your business data. On the other hand you may be experiencing the side effects of long term over-use of this tool but you dread ditching those formidable …

Toss the technology Part 2

Susan Andre Articles

It is crucial to first bed down the methodology, concepts and techniques before implementing a Data Warehouse / Business Intelligence solution using software tools.  Software should not govern the design of a BI / DW solution. It should not matter which platform and software is used.  Following suitable and trusted principles together with a tried and tested methodology is the …

Toss the technology Part 1

Susan Andre Articles

Technology should not be the prevailing factor when designing a Business Intelligence or Data Warehousing solution. The Alicornio Africa team understands the intricacies of designing these types of initiatives. Such projects typically involve in-depth requirements analysis that will form the cornerstone of the design. Careful planning, project managing, specialized design techniques plus orchestration of a potentially complex implementation necessitate thorough …

Single Customer View

Susan Andre Articles

Better decisions depend on a single view. Finally, a fully integrated 360-degree view is within your grasp. Accurate, enriched and accessible, Pitney Bowes delivers the comprehensive Single View of Customer you require – when and where you need it. The basics sound easy: name, address, account numbers. Yet, sometimes, getting that right is a challenge. Sadly, most organizations can’t capitalize …

Importance of Business Intelligence Technology

Susan Andre Articles

Business Intelligence: A need for transaction processing systems Why is Business Intelligence required? In short: transaction processing systems do not provide adequately for the analytical and reporting requirements of business people. There is often a lack of ways to analyze and report on all the valuable data that is embedded in our everyday applications (also referred to as transactional processing …

A Badge for the Biggest Data Warehouse

Susan Andre Articles

The effectiveness of the measurement portfolio of a company either in terms of timeliness, historical depth or quality could be greatly enhanced by assembling a consolidated base of information commonly referred to as a Data Warehouse. However, simply storing terabytes of data does not necessarily contribute to this end. One essential function of a data warehouse is to integrate and …

The very short version of: Why, What and How of Data Warehousing

Susan Andre Articles

Why a Data Warehouse: To enable Business Users to answer their business questions faster, easier and accurately in order to improve business decisions based on information. What is a Data Warehouse? It is a consolidated, integrated and central point of information. Usually it consists of data that is integrated, cleaned, de-duplicated and structured in such a way that makes it …

Business Intelligence: A necessity for transaction processing systems

Susan Andre Articles

Why is Business Intelligence required? In short: transaction processing systems do not provide adequately for the analytical and reporting requirements of business people. There is often a lack of ways to analyze and report on all the valuable data that is embedded in our everyday applications (also referred to as transactional processing systems or OLTP). It is true that without …

Big Data or Big Hype?

Susan Andre Articles

If “big data” is the catalyst for businesses to finally only now start engaging in BI initiatives, it comes as a late wake-up call! Large, mid-size and small businesses are all deserving of Business Intelligence benefits. Business Intelligence has been around for ages and it has always been supposed to be a business issue. Sadly though BI is often driven …