Microsoft SharePoint 2013 End to End Business Intelligence Course Overview

To ensure a successful learning experience in the Microsoft SharePoint 2013 End to End Business Intelligence course, participants should possess the following minimum prerequisites:

• Basic understanding of databases and familiarity with the concept of a database table.
• Working knowledge of Microsoft Excel, including functions, formulas, and chart creation.
• Familiarity with the Windows operating system and basic navigation of Windows applications.
• Some exposure to data processing concepts, such as data analysis or reporting.
• An interest in learning about business intelligence concepts and tools.

These prerequisites are designed to provide a foundation upon which the course material can build. No advanced technical skills are required, and the course is structured to guide learners through the complexities of SharePoint 2013 Business Intelligence features.

Target Audience for Microsoft SharePoint 2013 End to End Business Intelligence

Microsoft SharePoint 2013 End to End Business Intelligence course equips professionals with key BI skills using SharePoint.

• IT Managers
• Business Analysts
• Data Analysts
• Database Administrators
• Business Intelligence Developers
• SharePoint Developers
• SharePoint Administrators
• Systems Analysts
• Data Engineers
• Report Developers
• Power Users working with data within an organization

Learning Objectives - What you will Learn in this Microsoft SharePoint 2013 End to End Business Intelligence?

Introduction to Learning Outcomes

This course offers comprehensive training in Microsoft SharePoint 2013 Business Intelligence, covering a range of tools and techniques for transforming raw data into actionable insights.

Learning Objectives and Outcomes

• Understand the core components of the SharePoint 2013 Business Intelligence stack and its capabilities.
• Gain proficiency in SQL Server Integration Services (SSIS) 2012 for ETL operations and data transformation.
• Learn to create and manage data warehouses and data marts using SQL 2012 Business Intelligence Semantic Model (Multidimensional Mode).
• Acquire skills in writing Multidimensional Expressions (MDX) and managing OLAP cubes.
• Master the use of SQL 2012 Business Intelligence Semantic Model (Tabular Mode) and Data Analytic Expressions (DAX).
• Develop expertise in creating, deploying, and managing reports with SQL Server 2012 Reporting Services.
• Understand the principles of Master Data Services for ensuring data integrity and consistency across the organization.
• Explore data mining techniques and predictive analytics within Microsoft SharePoint 2013.
• Learn to configure and use SharePoint 2013 Excel Services for data analysis, including Power View and PowerPivot.
• Gain the ability to create interactive, data-driven dashboards and scorecards using PerformancePoint 2013 and Visio Services.