Implementing Data Models and Reports with Microsoft SQL Server 2012 (cours 10778)
Cours disponible en français ou en anglais - Training available in French or in English
Durée: 5 jours
Objectifs du cours :
Business intelligence (BI) is becoming increasingly important for companies of many different sizes and types because of the competitive edge it can help to give them. The combined capabilities of Microsoft SQL Server 2012 and Microsoft SharePoint 2010 make it easier than ever for companies to develop a BI solution that meets their specific needs, provides reduced total cost of ownership (TCO), and achieves a faster time to solution.
This five-day instructor-led course teaches students how to empower information workers through self-service analytics and reporting. Students will learn how to implement multidimensional analysis solutions, create PowerPivot and tabular data models, deliver rich data visualizations with PowerView and SQL Server Reporting Services, and discover business insights by using data mining. This course helps people prepare for exam 70-466.
Compétences acquises :
Les stagiaires seront à même d'effectuer les tâches suivantes :
- Describe common BI scenarios and current BI trends.
- Describe the main technologies that make up the Microsoft BI platform
- Describe the key features of Reporting Services.
- Use Report Designer to create a report.
- Group and aggregate data in a report.
- Use charts and other visualizations to show data graphically in a report.
- Use parameters to filter data in a report.
- Publish and view a report
- Support self-service reporting with Report Builder.
- Create shared data sources and datasets for self-service reporting scenarios.
- Use report parts as reusable report elements
- Configure security settings for a report server.
- Configure report execution settings to optimize performance.
- Use subscriptions and alerts to automate report and data delivery.
- Troubleshoot reporting issues
- Describe the considerations for a multidimensional database.
- Create data sources and data source views.
- Create a cube.
- Implement security in a multidimensional database
- Configure dimensions.
- Define attribute hierarchies.
- Sort and group attributes
- Describe measures.
- Describe measure groups
- Describe MDX.
- Add calculations to a cube.
- Describe how to use MDX in client applications
- Describe Key Performance Indicators.
- Implement Actions.
- Explain Perspectives.
- Describe Translations
- Describe the key features and benefits of tabular data models and PowerPivot technologies.
- Create a PowerPivot for Excel workbook.
- Share a PowerPivot for Excel workbook to PowerPivot Gallery and use a PowerPivot for Excel workbook as a data source
- Describe the fundamentals of DAX.
- Use DAX to create calculated columns and measures
- Describe Analysis Services tabular data model Projects.
- Implement an Analysis Services tabular data model by Using SQL Server Data Tools
- Describe the Power View and its place in the BI ecosystem.
- Create data visualizations by using Power View
- Describe the key data mining concepts and use the Data Mining Add-ins for Excel.
- Create a Data Mining solution.
- Validate data mining models.
- Use data mining data in a report.
Connaissances requises :
Pour suivre ce cours, les stagiaires doivent disposer des connaissances suivantes :
- At least 2 years’ experience of working with
relational databases, including:
- Designing a normalized database.
- Creating tables and relationships.
- Querying with Transact-SQL.
- Some exposure to basic programming constructs (such as looping and branching).
- An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
Copyright © 2012 Colombus.com - All rights reserved
Tel : +41 21 661 1675 - Fax : +41 21 661 1673 - Email : email@example.com