Difference between revisions of "Connecting the dots"

From Whitespace (Hackerspace Gent)
Jump to: navigation, search
Line 39: Line 39:
 
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:
 
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:
 
<ul>
 
<ul>
<il>SQL (any variant is ok)</il>
+
<li>SQL (any variant is ok)</li>
<il>Relational databases</il>
+
<li>Relational databases</li>
<il>Experience in working with structured data (CSV, XML, ...) can also come in handy</il></ul>
+
<li>Experience in working with structured data (CSV, XML, ...) can also come in handy</li></ul>
 
{{Subpages}}
 
{{Subpages}}
 
{{EventImages}}
 
{{EventImages}}

Revision as of 14:57, 30 March 2011

Note: this article is about a passed event.

Connecting the dots
Datawarehouse.png
From 2011/04/30 12:30:00 to 2011/04/30 17:00:59
Presenters (1):
Cedric De Vroey
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 € 1800,00/day ;-)

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

Subpages

"" has no sub pages.


Historical data can not be displayed in a Factbox