Microsoft MSBI2016

At ITBMS, we recognize that different customers have different training needs. ITBMS meets the specific customer requirements by offering tailored training courses.


To fully benefit from the power of data, organizations need to make it easy for all users to get access to the right data, at the right time, so they can make more informed decisions, while also giving IT the tools to manage data access, quality and compliance. User expectations, however, are changing, and they are demanding self-service access to more types of data than ever before. A BI solution is not complete if it can not pull in external data from a marketplace, or unstructured data from Hadoop, and easily combine it with existing enterprise data that may live on premises or in the cloud.

Microsoft Business Intelligence- MS BI 2016

Course 20767B Implementing a SQL Data Warehouse

                                                                                                             Duration: 40 hours

       Introduction to Data Warehousing
       Planning Data Warehouse Infrastructure
       Designing and Implementing a Data Warehouse
       Column store Indexes
       Implementing an Azure SQL Data Warehouse
       Creating an ETL Solution
       Implementing Control Flow in an SSIS Package
       Debugging and Troubleshooting SSIS Packages
       Implementing a Data Extraction Solution
       Enforcing Data Quality
       Using Master Data Services
       Extending SQL Server Integration Services (SSIS)
       Deploying and Configuring SSIS Packages
       Consuming Data in a Data Warehouse

Course 20768A Developing SQL Data Models

                                                                                                             Duration: 40 hours

       Introduction to Business Intelligence and Data Modeling
       Creating Multidimensional Databases
       Working with Cubes and Dimensions
       Working with Measures and Measure Groups
       Introduction to MDX
       Customizing Cube Functionality
       Implementing a Tabular Data Model by Using Analysis Services
       Introduction to Data Analysis Expression (DAX)
       Performing Predictive Analysis with Data Mining


       Exam 70-767 Implementing a SQL Data Warehouse
       Exam 70-768 Developing SQL Data Models


Disclaimer: Course content, version and duration are subject to change without notice as a part of constant upgrade of the product by MICROSOFT TRAINING.