BI & DWH
English
Which, of course, stands for Business Intelligence & Data Warehousing. When Ralph Kimball published his first book on the subject of Data Warehousing in 1996, the output component of it was simply called “reporting”. Over the years “reporting” became Business Intelligence as possibilities to present the information contained in the data were greatly improved, leading to more knowledge about a business. Hence the term.
In 1997, I was involved in a pilot project to obtain information using an extraction tool which was able to generate SQL queries, send these to a relational database, and report the results in all kinds of tables and diagrams. And I was really pleased. The tool was called Business Objects and was a product by a French company by the same name. Nowadays, the tool still exists and is owned by SAP. I found out later that quite a few more tools existed and were collectively called Business Inteligence tools.
I have worked on many Business Intelligence projects from 1997 onwards. In below table I list some mentionable ones.
| Period | Role | Project | Tools |
|---|---|---|---|
| 2019/Q4 - 2020/Q2 | Initiator | Investigate whether Kibana and Elastic Stack can be a viable open-source Business Intelligence & Data Warehousing tool for certain business cases | Elastic Stack (Elasticsearch, Kibana, Logstash, and Beats) on Ubuntu Linux |
| 2012/Q4 - 2014/Q1 | Project Manager / Consultant | Project Re-establish LDW : reworked and improved Data Warehouse Project Enhance LDW : enhanced content and better authorization for more departments at Alphabet International - BMW Group (Car Leasing) / Breda - Munich | IT Project Management (BMW internal), SAP Business Objects, Oracle RDBMS |
| 2012/Q2 - 2012/Q4 | Strategy consultant | Strategic report: Management Information AS-IS situation and improvement scenarios at Alphabet International - BMW Group (Car Leasing) / Breda - Munich | Common sense and a sound knowledge of BI & DWH |
| 2012/Q2 | Consultant | Pilot project aimed at comparing different Business Intelligence tools at Otto Workforce (Employment Agency) / Venray | Microsoft SQL Server 2012, SSIS, SSAS, SSRS, Excel Powerpivot, Qlikview |
| 1998/Q4 - 2009/Q1 | Project Manager / Developer / Instructor | Many different BI & DWH projects at Wegener (now DPG Media), SOS International, Custodial Institutions Agency / Ministry of Justice, and several other organizations | Mostly Business Objects with either Oracle or Microsoft databases |
| 1997/Q1 - 1998/Q1 | Developer | Pilot project with my first Business Intelligence software at Getronics Transaction & Card Systems | Business Objects version 4.0 |
Nederlands
Wat natuurlijk staat voor Business Intelligence & Data Warehousing. Toen Ralph Kimball in 1996 zijn eerste boek uitbracht over Data Warehousing, heette de output component nog gewoon “rapportage”. Na verloop van tijd veranderde “rapportage” in Business Intelligence, aangezien de mogelijkheden om de informatie die opgesloten zat in de data op steeds geavanceerdere wijze te presenteren, hetgeen leidde tot meer kennis van de business. Vandaar dus die term.
In 1997 was ik betrokken bij een pilot project om informatie te verkrijgen met een extractie tool die in staat was om SQL queries te genereren, deze af te vuren op een relationele database en de resultaten ervan in allerlei soorten tabellen en diagrammen af te beelden. En ik was daar erg van gecharmeerd. De tool heette Business Objects en was een product van een Frans bedrijf met dezelfde naam. Tegenwoordig bestaat de tool nog steeds en is eigendom van SAP. Ik ontdekte later dat er behoorlijk wat meer van dat soort tools bestonden die in het algemeen Business Inteligence tools genoemd werden.
Ik heb op veel Business Intelligence projecten gewerkt vanaf 1997. In de onderstaande tabel heb ik enkele vermeldenswaardige opgesomd.
| Periode | Rol | Project | Tools |
|---|---|---|---|
| 2019/Q4 - 2020/Q2 | Initiator | Onderzoek of Kibana en Elastic Stack een open-source Business Intelligence & Data Warehousing tool kan zijn voor bepaalde business cases | Elastic Stack (Elasticsearch, Kibana, Logstash en Beats) op Ubuntu Linux |
| 2012/Q4 - 2014/Q1 | Project Manager / Consultant | Project Re-establish LDW : een stabieler en verbeterd Data Warehouse Project Enhance LDW : meer content en betere autorisatie voor meer afdelingen bij Alphabet International - BMW Group (Auto Leasing) / Breda - München | IT Project Management (BMW internal), SAP Business Objects, Oracle RDBMS |
| 2012/Q2 - 2012/Q4 | Strategie consultant | Strategic report: Management Information AS-IS situation and improvement scenarios bij Alphabet International - BMW Group (Auto Leasing) / Breda - Munich | Common sense and a sound knowledge of BI & DWH |
| 2012/Q2 | Consultant | Pilot project om verschillende Business Intelligence tools onderling te vergelijken bij Otto Workforce (Uitzendbureau) / Venray | Microsoft SQL Server 2012, SSIS, SSAS, SSRS, Excel Powerpivot, Qlikview |
| 1998/Q4 - 2009/Q1 | Project Manager / Developer / Cursusleider | Veel verschillende BI & DWH projects bij Wegener (nu DPG Media), SOS International, Dienst Justitiële Inrichtingen / Ministerie van Justitie, en enkele andere organisaties | Vaak Business Objects met Oracle of Microsoft databases |
| 1997/Q1 - 1998/Q1 | Developer | Pilot project met mijn eerste Business Intelligence software bij Getronics Transaction & Card Systems | Business Objects versie 4.0 |