Microsoft Certified Solutions Expert (MCSE): Business Intelligence

  • E-Learning
  • 721
  • 28:21:04
Microsoft Certified Solutions Expert (MCSE): Business Intelligence
Test scorm
Enquire Now
  • E-Learning
  • 100
  • 04:36:55

Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012

This course is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around implementing a Data Warehouse with Microsoft SQL Server 2012.

This course is preparation for the 70-463 exam and describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. A data warehouse collects needed data and organizes the data in a form that solves the complexities and performance issues that line-of-business applications present.

After completing this course participants will be able to:

  • Design and implement a data warehouse
  • Implement an ETL solution that supports incremental data extraction
  • Describe...read more

  • E-Learning
  • 128
  • 06:57:14

Microsoft 70-462: Administering SQL Server 2012 Databases

This training course was created specifically for those individuals (Database Professionals) who install, maintain and configure as their primary job function.

The 70-462: Administering Microsoft SQL Server 2012 online training course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.

Skills Learned 

  • Installation Planning
  • Installing SQL Server and related services
  • Implementation of a migration strategy
  • How to configure additional SQL Server components
  • Managing the SQL Server Agent
  • Database management and configuration
  • How to configure SQL Server instances
  • Implementing a SQL Server clustered instance
  • SQL Server instances...read more

  • E-COURSE
  • 196
  • 06:54:41

Microsoft 70-461: Querying SQL Server 2012

This course is intended for SQL Server database administrators, implementers, system engineers, and developers. This new SQL 2012 course is focused on anyone interested in the validation of your skills and knowledge with writing queries.

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 and is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The ability to work with Transact-SQL and understand the specifics of querying Microsoft SQL server is a fundamental skill. This new SQL 2012 course is focused on anyone interested in the validation of your skills and knowledge with writing queries.

Skills Learned

  • Work with Data
  • Query data by using SELECT statements.
  • Create Database Objects
  • Create and alter tables using T-SQL syntax (simple statements).
  • Create and...read more

  • E-COURSE
  • 153
  • 04:34:19

Microsoft 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012

This course is specifically for participants to gain the knowledge and skills for making the appropriate job role decisions around designing business intelligence solutions with Microsoft SQL Server 2012.

Business intelligence is an integral part of SQL Server and 70-467 is the certification designed for the associates who are responsible for the business intelligence design and solutions. Having a business intelligence certification is great values in IT as major platforms are designed with BI. The BI not only helps in simplification of solutions but also helps in implementing it effectively.

70-467 Designing Business Intelligence solutions video course is intended for the BI architects who are familiar with overall design and decisions around SQL Server 2012 Business intelligence solutions. The video course will judge the below skills of the professional:

  • Provisioning of hardware and software
  • Data mart design and...read more

  • E-COURSE
  • 144
  • 05:17:55

Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012

This course is specifically for participants to gain the knowledge and skills for making the appropriate job role decisions around implementing data models and reports with Microsoft SQL Server 2012.

The course focuses on creating managed enterprise BI solutions and covers how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server Performance Point Services, and discover business insights by using data mining. It describes how to consolidate SQL Server workloads and how to plan and implement high availability and disaster recovery solutions.

Skills Learned  

  • Designing dimensions and measures
  • Implementing and configuring dimensions in a cube
  • Designing a schema to support a cube architecture
  • Creating measures
  • Implementing a cube
  • Creating Multidimensional...read more