BI solutions are typically built on top of many diverse data sets, sourced from different databases and spreadsheets, from various computer systems, often containing data from apparently unrelated business areas. Combining them into a single, meaningful and easy-to-use data union is always a challenge!
In this presentation we’ll cover the data warehousing fundamentals by first explaining why properly prepared data set is a prerequisite for extracting some real intelligence from for the BI solutions. We’ll then cover the important data warehousing concepts, such as measures, dimensions, hierarchies, slowly changing dimensions, usefulness of redundant data, ETL... We will also discuss usual challenges, typical obstacles, some of the best practices and some of the latest trends and “not that great any more” recommendations. All subjects covered will be supported by the real-world examples and demonstrations based on the range of real world projects.
This highly practical presentation is aimed at very wide audience, ranging from data and report analysts, DW and database developers, DBAs, BAs, to front-end BI developers to end-users of BI systems. It is also suitable for virtually all skill levels; from novices to highly experienced DW/BI professionals.