Events Search and Views Navigation
October 2019
PBIE Power BI Essentials – Melbourne
This one-day instructor led course concentrates on the Power BI components available in Microsoft Office 2016 and the Power BI Desktop. The participants will learn how to gather and analyse data from a variety of sources and surface visualisations using the Power BI tools to construct compelling insights into business data.
Find out more »PBIE Power BI Essentials – Brisbane
This one-day instructor led course concentrates on the Power BI components available in Microsoft Office 2016 and the Power BI Desktop. The participants will learn how to gather and analyse data from a variety of sources and surface visualisations using the Power BI tools to construct compelling insights into business data.
Find out more »SSISE SQL Server Integration Services Essentials – Sydney
This one-day hands-on, instructor led course guides you through the numerous features of SQL Server Integration Services (SSIS) using real-world exercises structured around the components provided by the SQL Server Data Tools development environment. You will learn a practical approach to solving real-world problems using SSIS, which will provide you the ability to collect enterprise data from various sources such as SQL Server OLTP databases, Access databases, Excel worksheets and more, and transform the data for OLAP analysis, mining, and reporting.
Find out more »Azure Data Services Essentials – Brisbane
This one-day workshop is designed to introduce the various data storage and analysis capabilities of the Microsoft Azure platform. Starting with an introduction to cloud computing and a description of traditional data warehouses, comparisons are made with modern cloud computing technologies in mind.
Find out more »SSASE SQL Server Analysis Services Essentials – Sydney
This one-day instructor-led course teaches participants how to develop, deploy and implement an analytical and reporting solution using SQL Server Analysis Services. The course provides a practical approach to solve real-world reporting and analytical scenarios and teaches participants how to use the Analysis Services development tools to create an Analysis Services database and an On-Line Analytical Processing (OLAP) cube, and how to manage an Analysis Services solution.
Find out more »ADAE Azure Data Analytics Essentials – Brisbane
This course is designed to introduce the various data analytics feature and capabilities of the Microsoft Azure platform. Beginning with an overview of the Modern Data Warehouse and how various data analytics features are used to provide a complete solution, from ingesting data, performing analytics on that data and using various services to provide in depth insights to using Machine learning, IoT hubs and streaming data. Finally, the course introduces using Power BI to report on various models and analytic…
Find out more »SSRSA SQL Server Reporting Services Advanced – Sydney
This one-day hands-on course covers advanced techniques in development of Microsoft’s SQL Server Reporting Services reports using SQL Server Reporting Services.
The course provides an overview of the advanced features of Reporting Services, which includes creating reports with multiple cascading parameters, drill-through, linked and subreports, custom code and advanced graphics.
Throughout this course, you gain extensive experience creating and managing reports using real-world, commercial scenarios in Reporting Services.
Find out more »SSQWE SQL Server Query Writing Essentials – Brisbane
The goal of this course is to provide participants with the technical skills and knowledge to write Transact-SQL statements for Microsoft SQL Server. Upon completion, participants will be able to retrieve and modify data from SQL Server and understand how to perform these operations whilst maximising query performance. This course is designed for all SQL Server versions.
Find out more »SSISE SQL Server Integration Services Essentials – Brisbane
This one-day hands-on, instructor led course guides you through the numerous features of SQL Server Integration Services (SSIS) using real-world exercises structured around the components provided by the SQL Server Data Tools development environment. You will learn a practical approach to solving real-world problems using SSIS, which will provide you the ability to collect enterprise data from various sources such as SQL Server OLTP databases, Access databases, Excel worksheets and more, and transform the data for OLAP analysis, mining, and reporting.
Find out more »SSASE SQL Server Analysis Services Essentials – Brisbane
This one-day instructor-led course teaches participants how to develop, deploy and implement an analytical and reporting solution using SQL Server Analysis Services. The course provides a practical approach to solve real-world reporting and analytical scenarios and teaches participants how to use the Analysis Services development tools to create an Analysis Services database and an On-Line Analytical Processing (OLAP) cube, and how to manage an Analysis Services solution.
Find out more »