| | Implementing Reports and Data Models with Microsoft SQL Server 2012 |
| Untertitel | |
| Kurszeiten | 08:30 - 17:00 |
| Kursort | | Der Kurs findet in der Schweiz in der Regel in Zürich statt (Technopark, ideal mit Auto und ÖV erreichbar). Bei mehreren Anmeldungen aus Bern oder Basel kann der Kurs auch in unseren Schulungsräumen Bern oder Basel durchgeführt werden. Firmenkurse können in Ihren Räumlichkeiten oder in einem unserer Schulungszentren stattfinden. | Ich wünsche anderen OrtIch habe Frage zum Ort |
|
| Einleitung | |
| Herstellerkurs | Microsoft Nr. 10778 |
| Inhalt | Introduction to business intelligence and data modeling
- Introduction to business intelligence
- The Microsoft business intelligence platform
Implementing reports with reporting services
- Introduction to reporting services
- Creating a report with report designer
- Grouping and aggregating data in a report
- Showing data graphically
- Filtering reports using parameters
Supporting serf-service reporting
- Introduction to report builder
- Creating reusable report items
Managing a reporting infrastructure
- Managing report execution
- Delivering reports with subscription
- Troubleshooting reporting services
Creating multidimensional databases
- Introduction to multidimensional analysis
- Creating data sources and data source views
- Overview of cube security
Working with cubes and dimensions
- Defining attribute hierarchies
- Sorting and grouping attributes
Working with measures and measure groups
- Working with measures groups
Introduction to MDX
- Adding calculations to a cube
- Using MDX to query a cube
Customizing cube functionality
- Implementing key performance indicators
- Implementing perspectives
- Implementing translations
Implementing a tabular data model by using Microsoft PowerPivot
- Introduction to tabular data models and PowerPivot technologies
- Creating a tabular data model by using PowerPivot for
- Sharing a PowerPivot workbook and using PowerPivot gallery
Introduction to data analysis expression (DAX)
- Using DAX to create calculated columns and measures in a tabular data model
Implementing an analysis services tabular data model
- Introduction to analysis services tabular data model projects
- Implementing an analysis services tabular data model in business intelligence development studio
- Creating Data Visualizations with power view
- Introduction to power view
- Visualizing data with power view
- Performing predictive analysis with data mining
- Overview of Data Mining
- Using the data mining add-in for excel
- Creating a custom data mining solution
- Validating a data mining model
- Consuming a data mining model
|
| Teilnehmerbeitrag | Der Teilnehmerbeitrag versteht sich rein netto. Das ZFI ist (gemäss MwSt-Gesetz) nicht Mehrwertsteuerpflichtig und erhebt somit keine MwSt. Bei länger als einen Monat dauernden Lehrgängen ist die Zahlung des Teilnehmerbeitrages in mehreren Raten möglich (pro rata temporis). |
| | Zentrum für Informatik,  Schweiz, Basel, Bern, Zürich
Zentrum für Informatik,  Deutschland, Berlin, Frankfurt, Hamburg, Köln, München, Nürnberg, Stuttgart
Zentrum für Informatik,  Österreich, Wien |
