PUBLICERAT
Material som Top of Minds specialister producerar publiceras här. Våra konsulter ingår i internationella standardiseringsorgan där vi bidrar till vidareutvecklingen inom datawarehouse och Business Intelligence-området. Vi samarbetar med och gästföreläser på högskolor i Sverige och Nordamerika samt föreläser frekvent på internationella konferenser och seminarier.
-
ToM Report Series on Data Warehouse – A Snowflake and Synapse comparison
2020-03-09This white paper is directed at decision makers and data architects who are thinking about implementing a cloud data warehouse solution. It presents the result of a detailed comparison between two large products in this space, Snowflake and Microsoft Synapse (formerly known as Azure SQL Data Warehouse). This comparison has … Read More
-
Musings on Data Modelling
2018-10-02What is the fundamental purpose of Data Modelling? In my mind, it is about creating an understanding on how things work in real world, in a specific context, and draw a picture of it, the picture is the Data Model. To do that we need to define the things we … Read More
-
Analytical Systems architecture and design patterns – Part 2
2018-08-06This is the second part of the design pattern of an analytical system, for more background read the previous blog post –Link– The blog series is aiming at explaining how and why we need to build an Analytical Systems in a specific way, if we want them to have maintainability, … Read More
-
ToM Focal – Introduction to Focal implementation
2016-11-08The Focal pattern was implemented the first time as a Data Warehouse in the year 1998. That Data Warehouse is still running on the same base code today. Over the years the Focal pattern has been used and improved on many different implementations. Today at Top of Minds Focal company, we work … Read More
-
ToM Report Series on Data Warehouse – Removing duplicates using Informatica Powercenter
2015-09-28There is more than one way to skin a cat, and there are four ways to choose one distinct row of several possibilities in an Informatica PowerCenter mapping; Rank, Sort, Aggregate and the sorted Expression-filter technique. Each method has its own pros and cons, and a good developer should know … Read More
-
ToM Report Series on Data Warehouse – Write generic code to limit codebase and gain performance in Informatica PowerCenter
2014-11-20Ever changing business needs and requirements are forcing BI-projects to be more agile than ever before. The value of “seeing the data” can’t be emphasized enough in a BI-project which is why too rigid implementation processes and long delivery sprints should be avoided. Data Vault is one of the most … Read More
-
ToM Report Series on Data Warehouse – The six levels of integration
2013-05-24In the previous report – ToM Report Series on Data Warhouse – Definitions for integration we looked at defintions and the usage of them from an integration perspective. In this report we will look closer on what levels of integration a Data Warehouse should support. Ladda ner dokument här
-
ToM Report Series on Data Warehouse – Definitions for integration
2013-05-24Data Warehouse is about integration of different sources of data, to achieve integration we need definitions of concepts. In this report we will look at definitions from a Data Warehouse perspective, and break down what we need and how to think when working with them. Ladda ner dokument här
-
ToM Report Series on Data Warehouse – Using Informatica Powercenter to automate your Data vault
2012-01-18With the ongoing success and sustained rapid growth of the Data vault modelling standard, the need for robust and easy-to-use code for loading and extracting data is ever increasing. However, many companies struggle with non-reusable ETL-solutions that cost too much to maintain and doesn’t scale effectively. By the end of … Read More
-
ToM Report Series on Information Integration – Hyper Agile Design Pattern
2012-01-18In the Report “ToM Report Series on Information Integration – IT Support of Business Agility” we looked at the idea of building flexible information integration solutions, on a high level, that could Quickly adapt too today’s fast moving business environment “Absorb” new business information requirements Give the business users the … Read More