The 4 day M20467 course teaches delegates how to implement self-service Business Intelligence (BI) & Big Data analysis solutions using the Microsoft data platform. The rationale for self-service BI, how to use SQL Server Reporting Services, Excel, SharePoint, and Office 365 Power BI to create self-service data models & reports. Includes...
This 5-day instructor led course provides delegates with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.
The 5 day M20463 course describes how to implement a data warehouse platform to support a BI solution. Delegates will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
This course will provide more advanced T-SQL knowledge for those who have attended the QATSQL or M20761A courses. This is not a beginner course. For those requiring a basic level of T-SQL for reporting then please review the QATSQL course first.
This course will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures.
This three-day instructor-led course is aimed at database professionals who manage Business Intelligence (BI) operations. This course looks at various options that provide the ability of business users to analyze data and share their findings, starting with managed BI data sources and expanding to personal and external/public data sources.
This 3 day instructor-led M20768 course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS.
This 5 day instructor led M20767 course on how to implement a data warehouse platform to support a BI solution. You will learn to create a data warehouse with SQL Server 2016 & Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, & validate and cleanse data with SQL Server Data Quality Services and SQLServer Master Data Services.
The focus of the 5 day M20466 course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.
This two-day instructor-led course provides delegates with the knowledge and skills to produce reports using Report Designer. The course focuses on teaching individuals how to use the product features and tools related to data retrieval, visualisations and deployment.
Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources.
In this course, the students will implement various data platform technologies into solutions that are in line with business and technical requirements including on-premises, cloud, and hybrid data scenarios incorporating both relational and No-SQL data. They will also learn how to process data using a range of technologies and languages for both...