Earning an MCSA: BI Reporting demonstrates knowledge relevant to data analysis, data visualization, modeling, dashboards, and direct connectivity to data sources in Excel and Power BI. It is the first step on your path to becoming a Data Management and Analytics Microsoft Certified Solutions Expert (MCSE).
The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.
This three-day instructor-led 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 4-day instructor led course 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Â® 2016 and with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
This three-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.
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
The MCSA: SQL 2016 Business Intelligence Development Certification validates your extract, transform, and load (ETL) and data warehouse skills, along with those for implementing BI solutions using multidimensional and tabular data models and online analytical processing (OLAP) cubes. This certification will qualify you for a position as a BI developer.
This Unitek Training Boot Camp provides students hands-on experience with SQL Server 2016. The boot camp will highlight what is new in SQL Server 2016 in comparison to SQL Server 2012/2014. It provides guidance on designing, implementing and populating Data Warehouses in SQL 2016. As well as working with cubes and other data models in SQL Server Analysis Services 2016.
Unitek Training’s Designing Self-Service Business Intelligence and Big Data Solutions five-day instructor-led course teaches students how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform. The course discusses the rationale for self-service BI, and describes how to use Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365 Power BI to create self-service data models and reports. The course then goes on to describe how to use Windows Azure HDInsight to perform Big Data analysis.
This course is often taught as part of the FastTrack to MCSE Data Management and Analytics through SQL Business Intelligence.
Unitek Training’s Implementing Data Modules and Reports with Microsoft SQL Server five-day instructor-led 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.
Unitek Training’s Implementing a Data Warehouse with Microsoft SQL Server course 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 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 is often taught as part of the MCSA: SQL Server 2012/2014 Boot Camp.