Difference between revisions of "Connecting the dots"

From Whitespace (Hackerspace Gent)
Jump to: navigation, search
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
 
{{Event
 
{{Event
 
|Event type=Workshop
 
|Event type=Workshop
|Start date=2011/04/30 12:30:00
+
|Start date=2011/04/30 15:00:00
|End date=2011/04/30 17:00:59
+
|End date=2011/04/30 19:00:00
 
|Location=Whitespace
 
|Location=Whitespace
 
|Short description=A 4hr workshop about Business Intelligence and Data Warehousing. Most common concepts and techniques like ETL and MDM will be discussed and you'll also learn a bit about what software is available out there to get started.
 
|Short description=A 4hr workshop about Business Intelligence and Data Warehousing. Most common concepts and techniques like ETL and MDM will be discussed and you'll also learn a bit about what software is available out there to get started.
Line 8: Line 8:
 
|Logo=Datawarehouse.png
 
|Logo=Datawarehouse.png
 
|Presenters=Cedric De Vroey
 
|Presenters=Cedric De Vroey
|Attendees=Koen
+
|Attendees=Koen, Jeroen De Dauw, Bert, Biertie, Sandb
 
}}
 
}}
 
<h2>Topics:</h2>
 
<h2>Topics:</h2>

Latest revision as of 20:03, 2 May 2011

Note: this article is about a passed event.

Connecting the dots
Datawarehouse.png
From 2011/04/30 15:00:00 to 2011/04/30 19:00:00
Presenters (1):
Cedric De Vroey
Attendees (5):
Koen, Jeroen De Dauw, Bert, Biertie, Sandb
Where:
Whitespace Blekerijstraat 75, Gent, Belgium
Loading map...

Costs 0

Cornify

«A 4hr workshop about Business Intelligence and Data Warehousing. Most common concepts and techniques like ETL and MDM will be discussed and you'll also learn a bit about what software is available out there to get started.»

Topics:

- What is Data Warehousing and why do you use it?

- What is ETL?

- What (open-source) software is out there to start with data warehousing?

- What are cool appliances of data warehousing?

- What kind of data models can you use?

- Where can you find loads of free data?

Why would it be interesting to join?

- You'll see how data from different sources is merged and combined together in one informationstream.

- You'll learn about multi dimensional models (time, location, ...)

- You'll learn about Ralph Kimball and Bill Inmon, the two gurus in the scene with contradicting opinions (Basically "Would you collect all available data or only the data that you need?")

- You'll learn about indexing strategies and database performance

- You'll learn how to merge local data with remote data from i.e. Google Maps API and Twitter REST API.

- You can also learn all these things in certified trainings, but they cost lots of money ;-)

Prerequisits

There are no real prerequisits, everybody is free to join. However to grasp the full technical details during the workshop it's recommended you know something about the following topics:

  • SQL (any variant is ok)
  • Relational databases
  • Experience in working with structured data (CSV, XML, ...) can also come in handy

Things to bring

You can join the workshop without anything but if you want to try some stuff out 'a la minute' you'll need the following stuff:

  • A laptop with enough juice to run a VM that needs 1.7GB of RAM.
  • Enough free diskspace to store the VM. I guess about 20GB should be enough
  • You'll need VMWare or VirtualBox installed on your machine

Subpages

"" has no sub pages.


Historical data can not be displayed in a Factbox