Webinar: Selfservice mit DeltaMaster und Microsoft Excel

9. Juli 2025, 10:00 – 11:00 Uhr

Nicht immer liegen die Daten, die man für die Managementinformation benötigt, bereits vollständig im Data Warehouse vor. Manchmal muss man sie noch ergänzen oder erst zusammenstellen, spontan, zum Beispiel aus Excel- oder Access-Dateien. „Selfservice-BI“ nennt man das heute. Für solche Aufgaben ist DeltaMaster bestens geeignet – nicht nur für das Analysieren und Visualisieren von Daten, sondern auch für das Modellieren neuer Datenbestände. Dafür braucht es weder die IT noch technische Spezialkenntnisse. In dem Webinar zeigen wir, wie auf Basis einer Excel-Tabelle eine DeltaMaster-Anwendung entsteht.
 

Jetzt Aufzeichnung ansehen

 

ICAgICAgICA8aW5wdXQgdHlwZT0iaGlkZGVuIiBuYW1lPSJmcm9tIgogICAgICAgICAgICAgICB2YWx1ZT0iaHR0cHM6Ly93d3cuYmlzc2FudHouZGUvdmVyYW5zdGFsdHVuZy93ZWJpbmFyLXNlbGZzZXJ2aWNlLW1pdC1kZWx0YW1hc3Rlci11bmQtbWljcm9zb2Z0LWV4Y2VsLTIwMjUtMDctMDkvIj4KICAgICAgICA8aW5wdXQgdHlwZT0iaGlkZGVuIiBuYW1lPSJyZWNhcHRjaGFfcmVzcG9uc2UiIGlkPSJyZWNhcHRjaGFSZXNwb25zZSI+CgoJCTxzY3JpcHQgc3JjPSIvL3d3dy5nb29nbGUuY29tL3JlY2FwdGNoYS9hcGkuanM/cmVuZGVyPTZMY3hlOE1VQUFBQUFGY0RhMHo3d2hDWnJLMVBZcEI5Uzdaai1LUmEmb25sb2FkPXJlY2FwdGNoYU9ubG9hZCI+PC9zY3JpcHQ+CgkJPHNjcmlwdD4KICAgICAgICAgICAgdmFyIGJpc3NSZWNhcHRjaGEgPSB7CiAgICAgICAgICAgICAgICBmb3JtU2VsZWN0b3I6IG51bGwsCiAgICAgICAgICAgICAgICBzdWJtaXRCdXR0b246IG51bGwsCgogICAgICAgICAgICAgICAgZ2V0UGFnZVRva2VuKHN1Ym1pdCkgewoKICAgICAgICAgICAgICAgICAgICAvLyBTdG9yZSBhIHJlZmVyZW5jZSB0byB0aGUgY3VycmVudCBzY29wZQogICAgICAgICAgICAgICAgICAgIHZhciB0aGF0ID0gdGhpczsKCiAgICAgICAgICAgICAgICAgICAgLy8gQ2hlY2sgaWYgdGhlIGZvcm0gc2hvdWxkIGJlIHN1Ym1pdHRlZCBhcyB3ZWxsCiAgICAgICAgICAgICAgICAgICAgaWYgKHR5cGVvZiBzdWJtaXQgPT09ICdib29sZWFuJyAmJiBzdWJtaXQgPT09IHRydWUpIHsKCiAgICAgICAgICAgICAgICAgICAgICAgIC8vIFN0b3JlIHRoZSBzdWJtaXQgYnV0dG9uCiAgICAgICAgICAgICAgICAgICAgICAgIHRoaXMuc3VibWl0QnV0dG9uID0gZG9jdW1lbnQucXVlcnlTZWxlY3RvcignI3NjLTY0NTc4IGZvcm0gW3R5cGU9InN1Ym1pdCJdJyk7CgogICAgICAgICAgICAgICAgICAgICAgICAvLyBEaXNhYmxlIHRoZSBidXR0b24KICAgICAgICAgICAgICAgICAgICAgICAgdGhpcy5zdWJtaXRCdXR0b24uY2xhc3NOYW1lICs9ICcgYnV0dG9uLS1kaXNhYmxlZCc7CiAgICAgICAgICAgICAgICAgICAgfQoKICAgICAgICAgICAgICAgICAgICAvLyBFeGVjdHVlIHRoZSByZWNhcHRjaGEgY2FsbAogICAgICAgICAgICAgICAgICAgIGdyZWNhcHRjaGEuZXhlY3V0ZSgnNkxjeGU4TVVBQUFBQUZjRGEwejd3aENacksxUFlwQjlTN1pqLUtSYScsIHthY3Rpb246ICdFdmVudFRleHRfX0Zvcm11bGFyX1dlYmluYXJfZGVzX01vbmF0c19FeGNlbCd9KS50aGVuKGZ1bmN0aW9uKHRva2VuKSB7CgogICAgICAgICAgICAgICAgICAgICAgICAvLyBTZXQgdGhlIHJlY2FwdGNoYSB0b2tlbgogICAgICAgICAgICAgICAgICAgICAgICBkb2N1bWVudC5nZXRFbGVtZW50QnlJZCgncmVjYXB0Y2hhUmVzcG9uc2UnKS52YWx1ZSA9IHRva2VuOwoKICAgICAgICAgICAgICAgICAgICAgICAgLy8gQ2hlY2sgaWYgdGhlIGZvcm0gc2hvdWxkIGJlIHN1Ym1pdHRlZCBhcyB3ZWxsCiAgICAgICAgICAgICAgICAgICAgICAgIGlmICh0eXBlb2Ygc3VibWl0ID09PSAnYm9vbGVhbicgJiYgc3VibWl0ID09PSB0cnVlKSB7CgogICAgICAgICAgICAgICAgICAgICAgICAgICAgLy8gUmUtZW5hYmxlIHRoZSBidXR0b24KICAgICAgICAgICAgICAgICAgICAgICAgICAgIHRoYXQuc3VibWl0QnV0dG9uLmNsYXNzTmFtZS5yZXBsYWNlKCdidXR0b24tLWRpc2FibGVkJywgJycpOwoKICAgICAgICAgICAgICAgICAgICAgICAgICAgIC8vIFN1Ym1pdCB0aGUgZm9ybQogICAgICAgICAgICAgICAgICAgICAgICAgICAgdGhhdC5mb3JtU2VsZWN0b3Iuc3VibWl0KCk7CiAgICAgICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIH0sCgogICAgICAgICAgICAgICAgZ2V0UGFnZVRva2VuUHJvbWlzZWQoKSB7CgogICAgICAgICAgICAgICAgICAgIC8vIEV4ZWN0dWUgdGhlIHJlY2FwdGNoYSBjYWxsCiAgICAgICAgICAgICAgICAgICAgcmV0dXJuIGdyZWNhcHRjaGEuZXhlY3V0ZSgnNkxjeGU4TVVBQUFBQUZjRGEwejd3aENacksxUFlwQjlTN1pqLUtSYScsIHthY3Rpb246ICdFdmVudFRleHRfX0Zvcm11bGFyX1dlYmluYXJfZGVzX01vbmF0c19FeGNlbCd9KTsKICAgICAgICAgICAgICAgIH0sCgogICAgICAgICAgICAgICAgYmluZGluZygpIHsKCiAgICAgICAgICAgICAgICAgICAgLy8gU3RvcmUgYSByZWZlcmVuY2UgdG8gdGhlIGN1cnJlbnQgc2NvcGUKICAgICAgICAgICAgICAgICAgICB2YXIgdGhhdCA9IHRoaXM7CgogICAgICAgICAgICAgICAgICAgIC8vIEFkZCB0aGUgZm9ybSBsaXN0ZW5lcgogICAgICAgICAgICAgICAgICAgIHRoaXMuZm9ybVNlbGVjdG9yLmFkZEV2ZW50TGlzdGVuZXIoJ3N1Ym1pdCcsIGZ1bmN0aW9uKGV2ZW50KSB7CgogICAgICAgICAgICAgICAgICAgICAgICAvLyBQcmV2ZW50IHRoZSBzdWJtaXQgcHJvY2VzcwogICAgICAgICAgICAgICAgICAgICAgICBldmVudC5wcmV2ZW50RGVmYXVsdCgpOwoKICAgICAgICAgICAgICAgICAgICAgICAgLy8gR2V0IHRoZSBwYWdlIGtleSBhbmQgc3RvcmUgaXQKICAgICAgICAgICAgICAgICAgICAgICAgdGhhdC5nZXRQYWdlVG9rZW4odHJ1ZSk7CiAgICAgICAgICAgICAgICAgICAgfSwgZmFsc2UpOwogICAgICAgICAgICAgICAgfSwKCiAgICAgICAgICAgICAgICBpbml0KCkgewogICAgICAgICAgICAgICAgICAgIC8vIFN0b3JlIGZvcm0gc2VsZWN0b3JzCiAgICAgICAgICAgICAgICAgICAgdGhpcy5mb3JtU2VsZWN0b3IgPSBkb2N1bWVudC5xdWVyeVNlbGVjdG9yKCcjc2MtNjQ1NzggZm9ybScpOwoKICAgICAgICAgICAgICAgICAgICAvLyBNYWtlIHN1cmUgdGhlIGZvcm0gc2VsZWN0b3IgZXhpc3RzCiAgICAgICAgICAgICAgICAgICAgaWYgKHRoaXMuZm9ybVNlbGVjdG9yICE9PSBudWxsKSB7CgogICAgICAgICAgICAgICAgICAgICAgICAvLyBCaW5kIHRoZSBzdWJtaXQgZXZlbnQKICAgICAgICAgICAgICAgICAgICAgICAgdGhpcy5iaW5kaW5nKCk7CiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgfSwKCiAgICAgICAgICAgICAgICByZWNhcHRjaGFIYW5kbGVyKCkgewogICAgICAgICAgICAgICAgICAgIC8vIElmIHJlY2FwdGNoYSBpcyBkZWZpbmVkCiAgICAgICAgICAgICAgICAgICAgaWYgKHR5cGVvZiBncmVjYXB0Y2hhICE9PSAndW5kZWZpbmVkJykgewogICAgICAgICAgICAgICAgICAgICAgICBncmVjYXB0Y2hhLnJlYWR5KGZ1bmN0aW9uKCkgewoKICAgICAgICAgICAgICAgICAgICAgICAgICAgIC8vIEluaXRpYWxpemUgcmVjYXB0Y2hhCiAgICAgICAgICAgICAgICAgICAgICAgICAgICBiaXNzUmVjYXB0Y2hhLmluaXQoKTsKCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAvLyBJbml0aWFsbHkgdHJ5IHRvIGdldCB0aGUgcGFnZSBrZXkKICAgICAgICAgICAgICAgICAgICAgICAgICAgIGJpc3NSZWNhcHRjaGEuZ2V0UGFnZVRva2VuKCk7CiAgICAgICAgICAgICAgICAgICAgICAgIH0pOwogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgIH0sCiAgICAgICAgICAgIH07CgogICAgICAgICAgICBmdW5jdGlvbiByZWNhcHRjaGFPbmxvYWQoKSB7CiAgICAgICAgICAgICAgICBiaXNzUmVjYXB0Y2hhLnJlY2FwdGNoYUhhbmRsZXIoKTsKICAgICAgICAgICAgfQogICAgICAgIDwvc2NyaXB0PgoJCQ==






* Pflichtangaben

Diese Seite ist durch reCAPTCHA von Google geschützt. Es gelten die Datenschutzrichtlinien und Nutzungsbedingungen von Google.








PC9wPgo8cD48YnV0dG9uIGNsYXNzPSJidXR0b24gYnV0dG9uLS1maWxsZWQgYnV0dG9uLS1jb2xvci1wcmltYXJ5IiB0eXBlPSJzdWJtaXQiPldlYmluYXJhdWZ6ZWljaG51bmcgYW5mb3JkZXJuITwvYnV0dG9uPjxiciAvPgo=

Terminanfrage

ICAgICAgICA8aW5wdXQgdHlwZT0iaGlkZGVuIiBuYW1lPSJmcm9tIgogICAgICAgICAgICAgICB2YWx1ZT0iaHR0cHM6Ly93d3cuYmlzc2FudHouZGUvdmVyYW5zdGFsdHVuZy93ZWJpbmFyLXNlbGZzZXJ2aWNlLW1pdC1kZWx0YW1hc3Rlci11bmQtbWljcm9zb2Z0LWV4Y2VsLTIwMjUtMDctMDkvIj4KICAgICAgICA8aW5wdXQgdHlwZT0iaGlkZGVuIiBuYW1lPSJyZWNhcHRjaGFfcmVzcG9uc2UiIGlkPSJyZWNhcHRjaGFSZXNwb25zZSI+CgoJCTxzY3JpcHQgc3JjPSIvL3d3dy5nb29nbGUuY29tL3JlY2FwdGNoYS9hcGkuanM/cmVuZGVyPTZMY3hlOE1VQUFBQUFGY0RhMHo3d2hDWnJLMVBZcEI5Uzdaai1LUmEmb25sb2FkPXJlY2FwdGNoYU9ubG9hZCI+PC9zY3JpcHQ+CgkJPHNjcmlwdD4KICAgICAgICAgICAgdmFyIGJpc3NSZWNhcHRjaGEgPSB7CiAgICAgICAgICAgICAgICBmb3JtU2VsZWN0b3I6IG51bGwsCiAgICAgICAgICAgICAgICBzdWJtaXRCdXR0b246IG51bGwsCgogICAgICAgICAgICAgICAgZ2V0UGFnZVRva2VuKHN1Ym1pdCkgewoKICAgICAgICAgICAgICAgICAgICAvLyBTdG9yZSBhIHJlZmVyZW5jZSB0byB0aGUgY3VycmVudCBzY29wZQogICAgICAgICAgICAgICAgICAgIHZhciB0aGF0ID0gdGhpczsKCiAgICAgICAgICAgICAgICAgICAgLy8gQ2hlY2sgaWYgdGhlIGZvcm0gc2hvdWxkIGJlIHN1Ym1pdHRlZCBhcyB3ZWxsCiAgICAgICAgICAgICAgICAgICAgaWYgKHR5cGVvZiBzdWJtaXQgPT09ICdib29sZWFuJyAmJiBzdWJtaXQgPT09IHRydWUpIHsKCiAgICAgICAgICAgICAgICAgICAgICAgIC8vIFN0b3JlIHRoZSBzdWJtaXQgYnV0dG9uCiAgICAgICAgICAgICAgICAgICAgICAgIHRoaXMuc3VibWl0QnV0dG9uID0gZG9jdW1lbnQucXVlcnlTZWxlY3RvcignI3NjLTExODQ0NyBmb3JtIFt0eXBlPSJzdWJtaXQiXScpOwoKICAgICAgICAgICAgICAgICAgICAgICAgLy8gRGlzYWJsZSB0aGUgYnV0dG9uCiAgICAgICAgICAgICAgICAgICAgICAgIHRoaXMuc3VibWl0QnV0dG9uLmNsYXNzTmFtZSArPSAnIGJ1dHRvbi0tZGlzYWJsZWQnOwogICAgICAgICAgICAgICAgICAgIH0KCiAgICAgICAgICAgICAgICAgICAgLy8gRXhlY3R1ZSB0aGUgcmVjYXB0Y2hhIGNhbGwKICAgICAgICAgICAgICAgICAgICBncmVjYXB0Y2hhLmV4ZWN1dGUoJzZMY3hlOE1VQUFBQUFGY0RhMHo3d2hDWnJLMVBZcEI5Uzdaai1LUmEnLCB7YWN0aW9uOiAnV2ViaW5hcl9TZWxmc2VydmljZV9taXRfRGVsdGFNYXN0ZXJfdW5kX01pY3Jvc29mdF9FeGNlbCd9KS50aGVuKGZ1bmN0aW9uKHRva2VuKSB7CgogICAgICAgICAgICAgICAgICAgICAgICAvLyBTZXQgdGhlIHJlY2FwdGNoYSB0b2tlbgogICAgICAgICAgICAgICAgICAgICAgICBkb2N1bWVudC5nZXRFbGVtZW50QnlJZCgncmVjYXB0Y2hhUmVzcG9uc2UnKS52YWx1ZSA9IHRva2VuOwoKICAgICAgICAgICAgICAgICAgICAgICAgLy8gQ2hlY2sgaWYgdGhlIGZvcm0gc2hvdWxkIGJlIHN1Ym1pdHRlZCBhcyB3ZWxsCiAgICAgICAgICAgICAgICAgICAgICAgIGlmICh0eXBlb2Ygc3VibWl0ID09PSAnYm9vbGVhbicgJiYgc3VibWl0ID09PSB0cnVlKSB7CgogICAgICAgICAgICAgICAgICAgICAgICAgICAgLy8gUmUtZW5hYmxlIHRoZSBidXR0b24KICAgICAgICAgICAgICAgICAgICAgICAgICAgIHRoYXQuc3VibWl0QnV0dG9uLmNsYXNzTmFtZS5yZXBsYWNlKCdidXR0b24tLWRpc2FibGVkJywgJycpOwoKICAgICAgICAgICAgICAgICAgICAgICAgICAgIC8vIFN1Ym1pdCB0aGUgZm9ybQogICAgICAgICAgICAgICAgICAgICAgICAgICAgdGhhdC5mb3JtU2VsZWN0b3Iuc3VibWl0KCk7CiAgICAgICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIH0sCgogICAgICAgICAgICAgICAgZ2V0UGFnZVRva2VuUHJvbWlzZWQoKSB7CgogICAgICAgICAgICAgICAgICAgIC8vIEV4ZWN0dWUgdGhlIHJlY2FwdGNoYSBjYWxsCiAgICAgICAgICAgICAgICAgICAgcmV0dXJuIGdyZWNhcHRjaGEuZXhlY3V0ZSgnNkxjeGU4TVVBQUFBQUZjRGEwejd3aENacksxUFlwQjlTN1pqLUtSYScsIHthY3Rpb246ICdXZWJpbmFyX1NlbGZzZXJ2aWNlX21pdF9EZWx0YU1hc3Rlcl91bmRfTWljcm9zb2Z0X0V4Y2VsJ30pOwogICAgICAgICAgICAgICAgfSwKCiAgICAgICAgICAgICAgICBiaW5kaW5nKCkgewoKICAgICAgICAgICAgICAgICAgICAvLyBTdG9yZSBhIHJlZmVyZW5jZSB0byB0aGUgY3VycmVudCBzY29wZQogICAgICAgICAgICAgICAgICAgIHZhciB0aGF0ID0gdGhpczsKCiAgICAgICAgICAgICAgICAgICAgLy8gQWRkIHRoZSBmb3JtIGxpc3RlbmVyCiAgICAgICAgICAgICAgICAgICAgdGhpcy5mb3JtU2VsZWN0b3IuYWRkRXZlbnRMaXN0ZW5lcignc3VibWl0JywgZnVuY3Rpb24oZXZlbnQpIHsKCiAgICAgICAgICAgICAgICAgICAgICAgIC8vIFByZXZlbnQgdGhlIHN1Ym1pdCBwcm9jZXNzCiAgICAgICAgICAgICAgICAgICAgICAgIGV2ZW50LnByZXZlbnREZWZhdWx0KCk7CgogICAgICAgICAgICAgICAgICAgICAgICAvLyBHZXQgdGhlIHBhZ2Uga2V5IGFuZCBzdG9yZSBpdAogICAgICAgICAgICAgICAgICAgICAgICB0aGF0LmdldFBhZ2VUb2tlbih0cnVlKTsKICAgICAgICAgICAgICAgICAgICB9LCBmYWxzZSk7CiAgICAgICAgICAgICAgICB9LAoKICAgICAgICAgICAgICAgIGluaXQoKSB7CiAgICAgICAgICAgICAgICAgICAgLy8gU3RvcmUgZm9ybSBzZWxlY3RvcnMKICAgICAgICAgICAgICAgICAgICB0aGlzLmZvcm1TZWxlY3RvciA9IGRvY3VtZW50LnF1ZXJ5U2VsZWN0b3IoJyNzYy0xMTg0NDcgZm9ybScpOwoKICAgICAgICAgICAgICAgICAgICAvLyBNYWtlIHN1cmUgdGhlIGZvcm0gc2VsZWN0b3IgZXhpc3RzCiAgICAgICAgICAgICAgICAgICAgaWYgKHRoaXMuZm9ybVNlbGVjdG9yICE9PSBudWxsKSB7CgogICAgICAgICAgICAgICAgICAgICAgICAvLyBCaW5kIHRoZSBzdWJtaXQgZXZlbnQKICAgICAgICAgICAgICAgICAgICAgICAgdGhpcy5iaW5kaW5nKCk7CiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgfSwKCiAgICAgICAgICAgICAgICByZWNhcHRjaGFIYW5kbGVyKCkgewogICAgICAgICAgICAgICAgICAgIC8vIElmIHJlY2FwdGNoYSBpcyBkZWZpbmVkCiAgICAgICAgICAgICAgICAgICAgaWYgKHR5cGVvZiBncmVjYXB0Y2hhICE9PSAndW5kZWZpbmVkJykgewogICAgICAgICAgICAgICAgICAgICAgICBncmVjYXB0Y2hhLnJlYWR5KGZ1bmN0aW9uKCkgewoKICAgICAgICAgICAgICAgICAgICAgICAgICAgIC8vIEluaXRpYWxpemUgcmVjYXB0Y2hhCiAgICAgICAgICAgICAgICAgICAgICAgICAgICBiaXNzUmVjYXB0Y2hhLmluaXQoKTsKCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAvLyBJbml0aWFsbHkgdHJ5IHRvIGdldCB0aGUgcGFnZSBrZXkKICAgICAgICAgICAgICAgICAgICAgICAgICAgIGJpc3NSZWNhcHRjaGEuZ2V0UGFnZVRva2VuKCk7CiAgICAgICAgICAgICAgICAgICAgICAgIH0pOwogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgIH0sCiAgICAgICAgICAgIH07CgogICAgICAgICAgICBmdW5jdGlvbiByZWNhcHRjaGFPbmxvYWQoKSB7CiAgICAgICAgICAgICAgICBiaXNzUmVjYXB0Y2hhLnJlY2FwdGNoYUhhbmRsZXIoKTsKICAgICAgICAgICAgfQogICAgICAgIDwvc2NyaXB0PgoJCQ==





* Pflichtangaben

Dieses Formular ist durch reCAPTCHA und die Datenschutzrichtlinie von Google geschützt. Es gelten die Nutzungsbedingungen.








PGJyIC8+CjxidXR0b24gY2xhc3M9ImJ1dHRvbiBidXR0b24tLWNvbG9yLWJsYWNrIGJ1dHRvbi0tZmlsbGVkIGJ1dHRvbi0tZmlsbGVkLXJvdW5kZWQiIHR5cGU9InN1Ym1pdCI+QW5mcmFnZW48L2J1dHRvbj48YnIgLz4K

Ähnliche Veranstaltungen

Meet the Experts
On-Demand-Webinar 14. Januar 2025 Webinar: Selfservice mit DeltaMaster und Microsoft Excel

Mit Selfservice-BI lassen sich Manage­ment­infor­mationen ergänzen, z. B. aus Excel- oder Access-Dateien. Wie auf Basis einer Excel-Tabelle eine DeltaMaster-Anwendung entsteht, sehen Sie im Webinar [...]
Anmeldung