Laserfiche WebLink
I " t 'e-Pro sinning SLFLm atab se coir you1117earn"'ho r ti=cdnFgure and • anage SQ'LServer dfabases ='= "" <br />both on -premises and in SQL Azure. <br />Acquired Skills <br />Provision a database server <br />Upgrade SQL Server <br />Configure SQL Server <br />Manage shared databases and files <br />Set up, migrate and manage databases in the cloud <br />20767 Implementing a SQL Data Warehouse <br />Description <br />In the "Implementing a SQL Data Warehouse course", you'll learn how to provision a Microsoft SQL Server <br />database both on -premises and in Azure. <br />Acquired Skills <br />Describe the main hardware required to build a data warehouse <br />Execute logical and physical design for a data warehouse <br />Create column store indexes and dynamic packages that include variables and parameters <br />Implement an Azure SQL Data Warehouse <br />Represent the key features of SSIS <br />Apply control flow by using tasks and precedence constraints <br />Debug and deploy SSIS projects <br />Understand the considerations to implement an ETL solution <br />Enable Data Quality Services and a Master Data Services model <br />Interpret how to use custom components to extend SSIS <br />Define common BI scenarios <br />20768 Developing SQL Data Models <br />Description <br />In the Developing SQL Data Models course, you will learn how to implement multidimensional databases and <br />create tabular semantic data models for analysis using SQL Server Analysis Services (SSAS). <br />Acquired Skills <br />Describe the components, architecture and nature of a BI solution <br />Create a multidimensional database with analysis services <br />Implement dimensions and measures in a cube <br />Customize a cube <br />Apply MDX syntax <br />Implement a tabular database <br />Work with DAX to query a tabular model <br />Use data mining for predictive analysis <br />20778 Analyzing Data with Power BI <br />Description <br />The main purpose of the course is to give students a good understanding of data analysis with Power BI. The <br />course includes creating visualizations, the Power BI Service, and the Power BI Mobile App. <br />Acquired Skills <br />Perform Power BI desktop data transformation. <br />Describe Power BI desktop modelling. <br />Create a Power BI desktop visualization. <br />Implement the Power BI service. <br />Describe how to connect to Excel data. <br />Describe how to collaborate with Power BI data. <br />Connect directly to data stores. <br />Describe the Power BI developer API. <br />Describe the Power BI mobile app. <br />20779 Analyzing Data with Excel <br />