MCSE: Business Intelligence
Request a Class
10:00am - 6:00pm
The MCSE: Business Intelligence boot camp is 6 days of an intense deep dive into advanced concepts of SQL Server including implementing data models, reports & designing BI solutions with SQL Server. Student will take two exams, which will incorporate Microsoft Courses: 10778 Implementing Data Models and Reports with Microsoft SQL Server and 10780: Designing Business Intelligence Solutions with Microsoft SQL Server. Prove that you have the skills and techniques needed to design, build, and deploy solutions that deliver more data to more people across the organization.
AUDIENCE AND PREREQUISITES
Earning an MCSE: Business Intelligence certification will qualify you for a position as a BI and reporting engineer.
Option 1: $3,245, Option 2: $3,995 (includes *travel & lodging )
Save 10% on Online/VLT enrollments, *Contiguous US flights only
This boot camp is intended for business intelligence (BI) developers who focus on creating BI solutions that require implementing multidimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making.
It is also intended for business intelligence (BI) architects, who are responsible for the overall design of a BI infrastructure and how it relates to other data systems in use.
MCSA: SQL Server
Course Cost listed does not include the cost of courseware or lunch. Please refer to your Invoice for the additional cost. This course is subject to minimum enrollment and may run as a Live Distance Learning session as a result. Please contact us at firstname.lastname@example.org with any questions.
70466: Implementing Data Models and Reports with Microsoft SQL Server
70467: Designing Business Intelligence Solutions with Microsoft SQL Server
After completing this boot camp, students will be able to: Describe the components, architecture, and nature of a BI solution. Create reports with Reporting Services Create reusable report items that simplify selfservice reporting. Manage report execution and delivery. Create a multidimensional database with Analysis Services. Implement dimensions in a cube. Implement measures and measure groups in a cube. Use MDX Syntax, Implement a Tabular Database. Implement a Tabular Data Model in PowerPivot Use DAX to query a tabular model Use PowerView to create interactive data visualizations. Use Data Mining for Predictive Analysis.Build an analysis services database Design dimensions and measures Implement and configure dimensions in a cube Design a schema to support cube architecture Create measures, Implement a cube Create Multidimensional Expressions (MDX) queries Implement custom logic in a data model Implement storage design in a multidimensional model Select an appropriate model for data analysisManage, maintain, and troubleshoot an SSAS database Analyze data model performance. Process data models Troubleshoot data analysis issues Deploy SSAS databases Install and maintain an SSAS instanceBuild a tabular data model Configure permissions and roles in Business Intelligence Semantic Model (BISM) Implement a tabular data model Implement business logic in a tabular data model Implement data access for a tabular data modelBuild a report with SQL Server Reporting Services (SSRS) Design a report Implement a report layout Configure authentication and authorization for a reporting solution Implement interactivity in a report Troubleshoot reporting services issues Manage a report environment Configure report data sources and datasetsPlan business intelligence (BI) infrastructure Plan for performance Plan for scalability Plan and manage upgrades Maintain server healthDesign BI infrastructure Design a security strategy Design a SQL partitioning strategy Design a backup strategy Design a logging and auditing strategyDesign a reporting solution Design a Reporting Services dataset Manage Excel Services/reporting for SharePoint Design a data acquisition strategy Plan and manage reporting services configuration Design BI reporting solution architectureDesign BI data models Design the data warehouse Design a schema Design cube architecture Design fact tables Design BI semantic models Design and create MDX calculationsDesign an ETL solution Design SSIS package execution Plan to deploy SSIS solutions Design package configurations for SSIS packages