User:Jan Aertsen

From Business Intelligence Compendium

Jan Aertsen has worked in IT and decision support for the past 10 years. Since the beginning of his career he specialized in data warehouse design and business intelligence projects. He has worked on numerous global data warehouse projects within the fashion industry, retail, banking and insurance, telco and utilities, logistics, automotive and public sector.

Jan holds the degree of Commercial Engineer in international business affairs from the Catholic University of Leuven (Belgium) and extends his further knowledge in the field of business intelligence through a master in Artificial Intelligence.

In 1999 Jan started up the business intelligence activities at IOcore (now: SysOpenDigia) together with some of his colleagues, rapidly making this the most important revenue area of the Belgian affiliate. They quickly gained access to a range of customers as KPN Belgium, Orange (now Base), Mobistar and others.

After this experience Jan joined CapGeminiErnst&Young in Italy and rapidly became one of their top BI project managers. After having managed some large BI projects (up to 1 million € projects) Jan decided to leave the company an pursue his own ambitions.

In 2002, he founded kJube as an independent platform to develop his ambitions in the world of business intelligence. Since then this has resulted in collaborations with numerous companies as Volvo, Fendi-LVMH, ING, MSC, Securex, SDWorx, Blinck and Beate Uhse.

Over the years Jan has worked his way through every possible aspect of business intelligence from KPI and strategy definition over budgeting, tool selection and software investments acquisition to project management and all implementation aspects with most of the available tools. He knows the business side as well as the IT side of the business intelligence, and therefore is one of the rare persons that is able to give you a sound, all-round, vendor independent advice on business intelligence.

Contents 1 Specialties/skills 2 Short career overview 3 Compendium contributions 4 BI links 5 Todo list 5.1 Weekly/Monthly recurring 5.2 One time 6 Test area

Specialties/skills

• BI project management
• BI business consulting
• Data modeling: ER modeling & [dimensional modeling]
• ETL & data integration (Informatica, Datastage, Pentaho - kettle, Oracle Warehouse Builder, SAS)
• Databases: Oracle, SQL server, MySQL
• OLAP: MS Analysis Service, Pentaho (Mondrian)
• Reporting tools/suites: Pentaho, MS Reporting Services, Business Objects, SAS, Cognos, ...

Short career overview

To be completed

Compendium contributions

• Business intelligence & Data warehouse
• Business Intelligence News
• BI technical architecture: Extract, transform, load
• Dimensional Modelling: Fact table, Dimension table, Date dimension

For full list, check here:Special:Contributions/Jan_Aertsen

BI links

• kJube
• LinkedIn

Todo list

On my current todo list for Business Intelligence compendium:

Weekly/Monthly recurring

• Update news section
• Follow up new users
• Check Maintenance pages

One time

Content creation:

• Finalize article on date dimension
• Remove Newspages 2008, 2007, ... that aren't categories / Add PAGENAME to Categories
• Update news section (revise 01/01 - 31/07/2009) and update last weeks
• Add this

Technical work:

• Improved SPAM filtering
• Anysite - to include external website
• Delete SPAM users
• Enable interwiki (to WikiPedia)

 INSERT INTO interwiki (iw_prefix, iw_url, iw_local, iw_trans) VALUES ('wp', 'http://en.wikipedia.org/wiki/$1', '0', '0');

• User Merge and Delete
• Google Adsense
• Customer namespace for news: http://www.mediawiki.org/wiki/Manual:Using_custom_namespaces
• Categories --> http://www.mediawiki.org/wiki/Help:Categories
• Template/Sample pages
  • Company
  • Software Vendor
  • Service company - Add kJube as an example page for a company to the compendium. (Add also to WikiP)
  • Product

Test area

The below text is just for testing MediaWiki text formatting only.