CiAgICA8IS0tIExpbmtlZEluIC0tPgogICAgPHNjcmlwdCB0eXBlPSJ0ZXh0L2phdmFzY3JpcHQiPgogICAgICAgIF9saW5rZWRpbl9wYXJ0bmVyX2lkID0gIjEyMzUwNzMiOwogICAgICAgIHdpbmRvdy5fbGlua2VkaW5fZGF0YV9wYXJ0bmVyX2lkcyA9IHdpbmRvdy5fbGlua2VkaW5fZGF0YV9wYXJ0bmVyX2lkcyB8fCBbXTsKICAgICAgICB3aW5kb3cuX2xpbmtlZGluX2RhdGFfcGFydG5lcl9pZHMucHVzaChfbGlua2VkaW5fcGFydG5lcl9pZCk7CiAgICA8L3NjcmlwdD48c2NyaXB0IHR5cGU9InRleHQvamF2YXNjcmlwdCI+CiAgICAgICAgKGZ1bmN0aW9uKCl7dmFyIHMgPSBkb2N1bWVudC5nZXRFbGVtZW50c0J5VGFnTmFtZSgic2NyaXB0IilbMF07CiAgICAgICAgICAgIHZhciBiID0gZG9jdW1lbnQuY3JlYXRlRWxlbWVudCgic2NyaXB0Iik7CiAgICAgICAgICAgIGIudHlwZSA9ICJ0ZXh0L2phdmFzY3JpcHQiO2IuYXN5bmMgPSB0cnVlOwogICAgICAgICAgICBiLnNyYyA9ICJodHRwczovL3NuYXAubGljZG4uY29tL2xpLmxtcy1hbmFseXRpY3MvaW5zaWdodC5taW4uanMiOwogICAgICAgICAgICBzLnBhcmVudE5vZGUuaW5zZXJ0QmVmb3JlKGIsIHMpO30pKCk7CiAgICA8L3NjcmlwdD4KICAgIDxub3NjcmlwdD4KICAgICAgICA8aW1nIGhlaWdodD0iMSIgd2lkdGg9IjEiIHN0eWxlPSJkaXNwbGF5Om5vbmU7IiBhbHQ9IiIgc3JjPSJodHRwczovL3B4LmFkcy5saW5rZWRpbi5jb20vY29sbGVjdC8/cGlkPTEyMzUwNzMmZm10PWdpZiIgLz4KICAgIDwvbm9zY3JpcHQ+CiAgICA8IS0tIEVuZCBMaW5rZWRJbiAtLT4KICAgIA==
Generic filters
Exact matches only
Search in title
Search in excerpt
Search in content
Lade Events

Meet the Experts – Modellierung (20.04.2023)

20. April 2023, 14:0016:00 Uhr, Bissantz Campus (virtuell)
480EUR

Ein Expertengespräch mit Schwerpunkten nach Ihrer Wahl, zum Beispiel aus dem folgenden Themenkatalog:

OLAP – Modellierung mit Microsoft SQL Server und Analysis Services
Von den Rohdaten zur fertigen Anwendung: Aufbau einer kompletten BI-Lösung mit Microsoft BI Development Studio/Data Tools.

  • OLAP: Konzept und Terminologie
  • Extraktion und Laden mit SQL Server Integration Services (SSIS)
  • Attributbasierter Dimensions- und Hierarchieaufbau
  • Cubes und Measure Groups
  • Calculated Members
  • Aggregationen, Partitionen und Writeback
  • Semiadditivität und Diskretisierung
  • Administration: Backup/Restore, Berechtigungskonzept

Dauer
Frei vereinbar, typischerweise: 2 Stunden.

Kosten
480,- EUR je zweistündiges Expertengespräch, zzgl. MwSt.


Terminanfrage

ICAgICAgICA8aW5wdXQgdHlwZT0iaGlkZGVuIiBuYW1lPSJmcm9tIgogICAgICAgICAgICAgICB2YWx1ZT0iaHR0cHM6Ly93d3cuYmlzc2FudHouZGUvdmVyYW5zdGFsdHVuZy9tZWV0LXRoZS1leHBlcnRzLW1vZGVsbGllcnVuZy0yMDIzLTA0LTIwLyI+CiAgICAgICAgPGlucHV0IHR5cGU9ImhpZGRlbiIgbmFtZT0icmVjYXB0Y2hhX3Jlc3BvbnNlIiBpZD0icmVjYXB0Y2hhUmVzcG9uc2UiPgoKCQk8c2NyaXB0IHNyYz0iLy93d3cuZ29vZ2xlLmNvbS9yZWNhcHRjaGEvYXBpLmpzP3JlbmRlcj02TGN4ZThNVUFBQUFBRmNEYTB6N3doQ1pySzFQWXBCOVM3WmotS1JhJm9ubG9hZD1yZWNhcHRjaGFPbmxvYWQiPjwvc2NyaXB0PgoJCTxzY3JpcHQ+CiAgICAgICAgICAgIHZhciBiaXNzUmVjYXB0Y2hhID0gewogICAgICAgICAgICAgICAgZm9ybVNlbGVjdG9yOiBudWxsLAogICAgICAgICAgICAgICAgc3VibWl0QnV0dG9uOiBudWxsLAoKICAgICAgICAgICAgICAgIGdldFBhZ2VUb2tlbihzdWJtaXQpIHsKCiAgICAgICAgICAgICAgICAgICAgLy8gU3RvcmUgYSByZWZlcmVuY2UgdG8gdGhlIGN1cnJlbnQgc2NvcGUKICAgICAgICAgICAgICAgICAgICB2YXIgdGhhdCA9IHRoaXM7CgogICAgICAgICAgICAgICAgICAgIC8vIENoZWNrIGlmIHRoZSBmb3JtIHNob3VsZCBiZSBzdWJtaXR0ZWQgYXMgd2VsbAogICAgICAgICAgICAgICAgICAgIGlmICh0eXBlb2Ygc3VibWl0ID09PSAnYm9vbGVhbicgJiYgc3VibWl0ID09PSB0cnVlKSB7CgogICAgICAgICAgICAgICAgICAgICAgICAvLyBTdG9yZSB0aGUgc3VibWl0IGJ1dHRvbgogICAgICAgICAgICAgICAgICAgICAgICB0aGlzLnN1Ym1pdEJ1dHRvbiA9IGRvY3VtZW50LnF1ZXJ5U2VsZWN0b3IoJyNzYy05MTYzNiBmb3JtIFt0eXBlPSJzdWJtaXQiXScpOwoKICAgICAgICAgICAgICAgICAgICAgICAgLy8gRGlzYWJsZSB0aGUgYnV0dG9uCiAgICAgICAgICAgICAgICAgICAgICAgIHRoaXMuc3VibWl0QnV0dG9uLmNsYXNzTmFtZSArPSAnIGJ1dHRvbi0tZGlzYWJsZWQnOwogICAgICAgICAgICAgICAgICAgIH0KCiAgICAgICAgICAgICAgICAgICAgLy8gRXhlY3R1ZSB0aGUgcmVjYXB0Y2hhIGNhbGwKICAgICAgICAgICAgICAgICAgICBncmVjYXB0Y2hhLmV4ZWN1dGUoJzZMY3hlOE1VQUFBQUFGY0RhMHo3d2hDWnJLMVBZcEI5Uzdaai1LUmEnLCB7YWN0aW9uOiAnTWVldF90aGVfRXhwZXJ0c19fTW9kZWxsaWVydW5nXyd9KS50aGVuKGZ1bmN0aW9uKHRva2VuKSB7CgogICAgICAgICAgICAgICAgICAgICAgICAvLyBTZXQgdGhlIHJlY2FwdGNoYSB0b2tlbgogICAgICAgICAgICAgICAgICAgICAgICBkb2N1bWVudC5nZXRFbGVtZW50QnlJZCgncmVjYXB0Y2hhUmVzcG9uc2UnKS52YWx1ZSA9IHRva2VuOwoKICAgICAgICAgICAgICAgICAgICAgICAgLy8gQ2hlY2sgaWYgdGhlIGZvcm0gc2hvdWxkIGJlIHN1Ym1pdHRlZCBhcyB3ZWxsCiAgICAgICAgICAgICAgICAgICAgICAgIGlmICh0eXBlb2Ygc3VibWl0ID09PSAnYm9vbGVhbicgJiYgc3VibWl0ID09PSB0cnVlKSB7CgogICAgICAgICAgICAgICAgICAgICAgICAgICAgLy8gUmUtZW5hYmxlIHRoZSBidXR0b24KICAgICAgICAgICAgICAgICAgICAgICAgICAgIHRoYXQuc3VibWl0QnV0dG9uLmNsYXNzTmFtZS5yZXBsYWNlKCdidXR0b24tLWRpc2FibGVkJywgJycpOwoKICAgICAgICAgICAgICAgICAgICAgICAgICAgIC8vIFN1Ym1pdCB0aGUgZm9ybQogICAgICAgICAgICAgICAgICAgICAgICAgICAgdGhhdC5mb3JtU2VsZWN0b3Iuc3VibWl0KCk7CiAgICAgICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIH0sCgogICAgICAgICAgICAgICAgZ2V0UGFnZVRva2VuUHJvbWlzZWQoKSB7CgogICAgICAgICAgICAgICAgICAgIC8vIEV4ZWN0dWUgdGhlIHJlY2FwdGNoYSBjYWxsCiAgICAgICAgICAgICAgICAgICAgcmV0dXJuIGdyZWNhcHRjaGEuZXhlY3V0ZSgnNkxjeGU4TVVBQUFBQUZjRGEwejd3aENacksxUFlwQjlTN1pqLUtSYScsIHthY3Rpb246ICdNZWV0X3RoZV9FeHBlcnRzX19Nb2RlbGxpZXJ1bmdfJ30pOwogICAgICAgICAgICAgICAgfSwKCiAgICAgICAgICAgICAgICBiaW5kaW5nKCkgewoKICAgICAgICAgICAgICAgICAgICAvLyBTdG9yZSBhIHJlZmVyZW5jZSB0byB0aGUgY3VycmVudCBzY29wZQogICAgICAgICAgICAgICAgICAgIHZhciB0aGF0ID0gdGhpczsKCiAgICAgICAgICAgICAgICAgICAgLy8gQWRkIHRoZSBmb3JtIGxpc3RlbmVyCiAgICAgICAgICAgICAgICAgICAgdGhpcy5mb3JtU2VsZWN0b3IuYWRkRXZlbnRMaXN0ZW5lcignc3VibWl0JywgZnVuY3Rpb24oZXZlbnQpIHsKCiAgICAgICAgICAgICAgICAgICAgICAgIC8vIFByZXZlbnQgdGhlIHN1Ym1pdCBwcm9jZXNzCiAgICAgICAgICAgICAgICAgICAgICAgIGV2ZW50LnByZXZlbnREZWZhdWx0KCk7CgogICAgICAgICAgICAgICAgICAgICAgICAvLyBHZXQgdGhlIHBhZ2Uga2V5IGFuZCBzdG9yZSBpdAogICAgICAgICAgICAgICAgICAgICAgICB0aGF0LmdldFBhZ2VUb2tlbih0cnVlKTsKICAgICAgICAgICAgICAgICAgICB9LCBmYWxzZSk7CiAgICAgICAgICAgICAgICB9LAoKICAgICAgICAgICAgICAgIGluaXQoKSB7CiAgICAgICAgICAgICAgICAgICAgLy8gU3RvcmUgZm9ybSBzZWxlY3RvcnMKICAgICAgICAgICAgICAgICAgICB0aGlzLmZvcm1TZWxlY3RvciA9IGRvY3VtZW50LnF1ZXJ5U2VsZWN0b3IoJyNzYy05MTYzNiBmb3JtJyk7CgogICAgICAgICAgICAgICAgICAgIC8vIE1ha2Ugc3VyZSB0aGUgZm9ybSBzZWxlY3RvciBleGlzdHMKICAgICAgICAgICAgICAgICAgICBpZiAodGhpcy5mb3JtU2VsZWN0b3IgIT09IG51bGwpIHsKCiAgICAgICAgICAgICAgICAgICAgICAgIC8vIEJpbmQgdGhlIHN1Ym1pdCBldmVudAogICAgICAgICAgICAgICAgICAgICAgICB0aGlzLmJpbmRpbmcoKTsKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICB9LAoKICAgICAgICAgICAgICAgIHJlY2FwdGNoYUhhbmRsZXIoKSB7CiAgICAgICAgICAgICAgICAgICAgLy8gSWYgcmVjYXB0Y2hhIGlzIGRlZmluZWQKICAgICAgICAgICAgICAgICAgICBpZiAodHlwZW9mIGdyZWNhcHRjaGEgIT09ICd1bmRlZmluZWQnKSB7CiAgICAgICAgICAgICAgICAgICAgICAgIGdyZWNhcHRjaGEucmVhZHkoZnVuY3Rpb24oKSB7CgogICAgICAgICAgICAgICAgICAgICAgICAgICAgLy8gSW5pdGlhbGl6ZSByZWNhcHRjaGEKICAgICAgICAgICAgICAgICAgICAgICAgICAgIGJpc3NSZWNhcHRjaGEuaW5pdCgpOwoKICAgICAgICAgICAgICAgICAgICAgICAgICAgIC8vIEluaXRpYWxseSB0cnkgdG8gZ2V0IHRoZSBwYWdlIGtleQogICAgICAgICAgICAgICAgICAgICAgICAgICAgYmlzc1JlY2FwdGNoYS5nZXRQYWdlVG9rZW4oKTsKICAgICAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgfSwKICAgICAgICAgICAgfTsKCiAgICAgICAgICAgIGZ1bmN0aW9uIHJlY2FwdGNoYU9ubG9hZCgpIHsKICAgICAgICAgICAgICAgIGJpc3NSZWNhcHRjaGEucmVjYXB0Y2hhSGFuZGxlcigpOwogICAgICAgICAgICB9CiAgICAgICAgPC9zY3JpcHQ+CgkJ





* Pflichtangaben

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








PGJyIC8+CjxidXR0b24gY2xhc3M9ImJ1dHRvbiBidXR0b24tLWZpbGxlZCBidXR0b24tLWNvbG9yLXByaW1hcnkiIHR5cGU9InN1Ym1pdCI+QW5mcmFnZW48L2J1dHRvbj48YnIgLz4K

Ähnliche Veranstaltungen