Implementing Data Models and Reports with Microsoft SQL Server 2012 Training in Plantation
We offer private customized training for groups of 3 or more attendees.
|
||
Course Description |
||
This five-day instructor-led course teaches students how to build a
multi-dimensional data model, and create reports and data visualizations
for business users. This course maps to the skills and knowledge
measured by Microsoft Exam 70-466, and in conjunction with on-the-job
experience, can help prepare you for the exam.
Course Length: 5 Days
Course Tuition: $2560 (US) |
Prerequisites |
|
Knowledge of how to write SQL Queries |
Course Outline |
Module 1: Introduction to Business Intelligence and Data ModelingThis module provides an introduction to Business Intelligence (BI). It describes common BI scenarios, current trends in BI, and the typical roles involved in creating a BI solution. It also introduces the Microsoft BI platform, and describes the roles that SQL Server Denali and SharePoint 2010 play in Microsoft BI solutions.Lessons
Lab : Reporting and Analyzing Data
Describe the key BI concepts and the Microsoft BI product suite.
Module 2: Implementing Reports with Reporting ServicesThis module describes how to create reports with Reporting Services.Lessons
Lab : Implementing Reports with Reporting Services
Create reports with Reporting Services.
Module 3: Supporting Self-Service ReportingThis module describes how to create reusable report items that simplify self-service reporting.Lessons
Lab : Supporting Self-Service Reporting
Create reusable report items that simplify self-service reporting.
Module 4: Managing a Reporting InfrastructureDescribes how to manage a reporting infrastructure.Lessons
Lab : Implementing Report Subscriptions
Manage a reporting infrastructure.
Module 5: Creating Multidimensional DatabasesThis module provides an introduction to multidimensional databases and introduces the core components of an OLAP cube.Lessons
Lab : Creating a Multidimensional Database
Create a multidimensional database with Analysis Services.
Module 6: Working with Cubes and DimensionsThis module describes how to create multidimensional databases and introduces the core components of an OLAP cubeLessons
Lab : Working with Cubes and Dimensions
Implement dimensions in a cube.
Module 7: Working with Measures and Measure GroupsThis module describes how to implement measures and measure groups in a cube.Lessons
Lab : Configuring Measures and Measure Groups
Implement measures and measure groups in a cube.
Module 8: Introduction to MDXIn this module, students will learn the fundamentals of Multidimensional Expressions. Students will also learn about building calculations, such as calculated members and named sets.Lessons
Lab : Using MDX
Use MDX Syntax.
Module 9: Customizing Cube FunctionalityIn this module describes how to customize cube functionality by using several technologies available to you in Microsoft SQL Server Denali Analysis Services.Lessons
Lab : Customizing a Cube
Customize a cube.
Module 10: Implementing a Tabular Data Model by Using Microsoft PowerPivotThis module explains how to install and use the PowerPivot for Excel add-in and the PowerPivot for SharePoint gallery. It also provides an introduction to the concepts underlying these technologies, such as the BI Semantic Model and Tabular Data Models.Lessons
Lab : Using PowerPivot for Excel
Implement a Tabular Data Model in PowerPivot.
Module 11: Introduction to Data Analysis Expression (DAX)
This module explains the fundamentals of the DAX language. It also explains how you can use DAX to create calculated columns and measures, and how you can use these in your Tabular Data Models.
Lessons
Lab : Creating Calculated Columns and Measures by Using DAX
Use DAX to create measures and calculated columns in a tabular data model.
Module 12: Implementing an Analysis Services Tabular Data ModelThis module describes Analysis Services Tabular Data Models and explains how to develop a Tabular Data Model by using the Business Intelligence Development Studio.Lessons
Lab : Working with an Analysis Services Tabular Data Model
Implement a Tabular database.
Module 13: Creating Data Visualizations With Power ViewThis module describes how to use Power View to create interactive data visualizations.Lessons
Lab : Creating Interactive Reports with Power View
Use Power View to create interactive data visualizations.
Module 14: Performing Predictive Analysis with Data MiningThe module describes how to use Data Mining for Predictive Analysis.Lessons
Lab : Performing Predictive Analysis with Data Mining
Use Data Mining for Predictive Analysis.
|
Course Directory [training on all levels]
- .NET Classes
- Agile/Scrum Classes
- Ajax Classes
- Android and iPhone Programming Classes
- Blaze Advisor Classes
- C Programming Classes
- C# Programming Classes
- C++ Programming Classes
- Cisco Classes
- Cloud Classes
- CompTIA Classes
- Crystal Reports Classes
- Design Patterns Classes
- DevOps Classes
- Foundations of Web Design & Web Authoring Classes
- Git, Jira, Wicket, Gradle, Tableau Classes
- IBM Classes
- Java Programming Classes
- JBoss Administration Classes
- JUnit, TDD, CPTC, Web Penetration Classes
- Linux Unix Classes
- Machine Learning Classes
- Microsoft Classes
- Microsoft Development Classes
- Microsoft SQL Server Classes
- Microsoft Team Foundation Server Classes
- Microsoft Windows Server Classes
- Oracle, MySQL, Cassandra, Hadoop Database Classes
- Perl Programming Classes
- Python Programming Classes
- Ruby Programming Classes
- Security Classes
- SharePoint Classes
- SOA Classes
- Tcl, Awk, Bash, Shell Classes
- UML Classes
- VMWare Classes
- Web Development Classes
- Web Services Classes
- Weblogic Administration Classes
- XML Classes
- 20483: Programming in C#
25 July, 2022 - 29 July, 2022 - Object-Oriented Programming in C#
25 July, 2022 - 29 July, 2022 - Introduction to Spring 5, Spring Boot, and Spring REST (2021)
17 October, 2022 - 21 October, 2022 - Intermediate - Advanced Java 11
3 October, 2022 - 7 October, 2022 - DP-100: DESIGNING AND IMPLEMENTING A DATA SCIENCE SOLUTION ON AZURE
15 August, 2022 - 17 August, 2022 - See our complete public course listing