Connecting the dots
| Line 38: | Line 38: | ||
<h2>Prerequisits</h2> | <h2>Prerequisits</h2> | ||
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> | |
| − | + | <il>SQL (any variant is ok)</il> | |
| − | + | <il>Relational databases</il> | |
| + | <il>Experience in working with structured data (CSV, XML, ...) can also come in handy</il></ul> | ||
{{Subpages}} | {{Subpages}} | ||
{{EventImages}} | {{EventImages}} | ||
Revision as of 14:56, 30 March 2011
Note: this article is about a passed event.
| Connecting the dots |
|---|
|
| From 2011/04/30 12:30:00 to 2011/04/30 17:00:59 |
| Presenters ({{#arraydefine:p|Cedric De Vroey}}{{#arraysize:p}}warning.png"{{#arraysize:p}}" is not a number.): |
| Cedric De Vroey |
| Where: |
| Whitespace
Blekerijstraat 75, Gent, Belgium Loading map...
Costs 0 |
|
«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.»
Contents |
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:
-
<il>SQL (any variant is ok)</il>
<il>Relational databases</il>
<il>Experience in working with structured data (CSV, XML, ...) can also come in handy</il>
Subpages
| Has cost | 0 + |
| Has 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. |
| Has end date | 30 April 2011 17:00:59 + |
| Has event type | Workshop + |
| Has location | Whitespace + |
| Has presenter | Cedric De Vroey + |
| Has presenter amount | |
| Has start date | 30 April 2011 12:30:00 + |
