[DW] Data Warehouses: The First Step in Embedding Intelligence into BI Solutions

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.

Join or login to comment.

  • Borivoj M.

    Thank you for attending today’s session, I hope you enjoyed it and you'll find it useful. PowerPoint slides will be uploaded in a couple of days. Cheers

    1 · September 17

  • Tony F.

    Congratulations to Mohammad on winning Feedback Form Draw Prize - a $50 JB Hi-Fi Gift Card.

    September 17

  • Tony F.

    Good foundation presentation for future presentations to build on. Thanks to Varigence Australia and Agile BI for their presence and support.

    1 · September 17

  • Maneesh H.

    Good

    September 17

  • Hussain K.

    I am new to business to business marketing I want to gather specific leads for my business

    September 17

Our Sponsors

  • Varigence Australia

    Varigence is the creator of Business Intelligence Markup Language (Biml)

  • Agile BI

    Microsoft Business Intelligence, Power BI and Agile experts.

  • Hilmax Solutions

    Equip clients with BI solutions to extract insights from business data.

  • SQL Tools

    SQL Tools distribute and support Idera's SQL Server management tools.

  • SQL PASS Chapter

    Professional Association for SQL Server Chapter

People in this
Meetup are also in:

Imagine having a community behind you

Get started Learn more
Bill

I started the group because there wasn't any other type of group like this. I've met some great folks in the group who have become close friends and have also met some amazing business owners.

Bill, started New York City Gay Craft Beer Lovers

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy