MPN Competency: Business Intelligence for Data Analytics MPN14350 (April 2017)

Learning path description

Technical Assessment: Technical Assessment for Microsoft Power BI Data Analytics

Keywords

MPN Competency : Data Analytics
Partner Type : Licensing Solution Providers (LSPs)
Role : Technical
Country : Global
SQL Server BI: Analysis and Reporting Services [2 h 4 m]

This module discusses tools to help you provide useful, flexible summarized views of that data, or even basic reporting, over large volumes of data. SQL Server Analysis Services (SSAS) is an online analytical data engine used in decision support and business analytics. It provides analytical data for business reports and client applications such as Reporting Services reports, Power BI, Excel, and other third-party data visualization tools. SSAS supports two modelling modes—multidimensional and tabular. This course provides an high-level overview of SQL Server 2016 Analysis Services and then delivers details on new SSAS features, deprecated and discontinued features. It then describes upgrading to SSAS 2016 and finally describes supported SSAS features by edition. Reporting Services (SSRS) delivers enterprise, web-enabled reporting functionality. Implemented as a Report Server, in one of two modes—Native and SharePoint—it can scale to support thousands of users. SSRS 2016 is extended with a new capability to deliver mobile reports, and is enhanced with a new modern web portal. This course provides a high-level overview of Reporting Services and then delivers details on new SSRS features, deprecated and discontinued features. It then describes upgrading to SSRS 2016 and finally describes supported SSRS features by edition.

Launch course
SQL Server BI: Integration and Master Data Services [1 h 25 m]

This module discusses tools that help you achieve a single version of the truth, or a single point of reference as it relates to the metadata and standards for the critical data of your organization. SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformation solutions. It is primarily designed to implement ETL processes, and its capabilities are useful in many other scenarios such as assessing data quality, cleansing and standardizing data, merging data from heterogeneous data stores, implementing ad hoc data transfers, automating administrative tasks, and orchestrating Azure data processes. This course provides a high-level overview of SQL Server 2016 Integration Services (SSIS) and then delivers details on new, deprecated and discontinued SSIS features. It then describes upgrading to SSIS 2016 and finally describes supported SSAS features by edition. Master Data Services (MDS) is the SQL Server solution for master data management. In business, master data management (MDM) comprises the processes, governance, policies, standards and tools that consistently define and manage the critical data of an organization to provide a single point of reference. Master Data Management (MDM) enables an organization to discover and define non-transactional lists of data, and to compile maintainable, reliable master lists. MDS was first released with SQL Server 2008 R2. This course provides a high-level overview of Master Data Services (MDS) and then delivers details on new, deprecated and discontinued MDS features. It then describes upgrading to MDS 2016 and finally describes supported SSRS features by edition.

Launch course
Microsoft Power BI for Data Analytics [1 h 58 m]

This module discusses tools to help you see a complete picture of your business, even if your data is in disparate locations, or if your data resides in SaaS solutions, or other external locations. Introducing Microsoft Power BI. Experience your data. Any data, any way, anywhere. This module discusses how Power BI enables fast and easy access to data; a live 360º view of the business; data discovery and exploration; insights from any device, collaboration across the organization; and it allows anyone to visualize and analyze data. We also discuss how Power BI also allows you to access and refresh data securely and on a regular basis and how different Power BI caters for the different needs of various roles. The module includes a Power BI overview, and sections on working with the Power BI service, connecting to Power BI data sources, creating Power BI desktop solutions, Power BI for the developer.

Launch course
Technical Assessment Business Intelligence for Data Analytics [1 h 0 m]

Technical Assessment Business Intelligence for Data Analytics

Launch course

Saving please wait...

containiner