55103-A: Creating and Sharing Interactive Dashboards with PowerPivot, Power View and SharePoint Server Course Overview

To ensure that participants can successfully engage with and derive maximum benefit from the 55103-A: Creating and Sharing Interactive Dashboards with PowerPivot, Power View and SharePoint Server course, the following are the minimum required prerequisites:

• Basic understanding of databases and familiarity with Microsoft Excel functionality.
• Experience in creating Excel workbooks and working with Excel formulas and functions.
• Knowledge of basic data concepts such as rows, columns, tables, and filtering.
• Familiarity with charting concepts and how charts are used in Excel.
• Some exposure to PivotTables and PivotCharts would be beneficial, though not strictly required.
• Basic understanding of SharePoint and its role in managing documents and providing shared services within an organization.
• Access to the necessary software and hardware to follow along with course material, including Microsoft Excel, PowerPivot, Power View, and SharePoint Server.

Please note that while previous experience with PowerPivot and Power View is advantageous, it is not mandatory as the course is designed to introduce these tools. The key is to have a willingness to learn and a fundamental grasp of Excel and data management concepts.

Target Audience for 55103-A: Creating and Sharing Interactive Dashboards with PowerPivot, Power View and SharePoint Server

1. The course 55103-A equips professionals with skills to create and manage interactive dashboards using PowerPivot, Power View, and SharePoint.

   
   

2. Target audience for the course:

   
   
   • Business Analysts
   • Data Analysts
   • Business Intelligence Professionals
   • Data Scientists
   • Report Developers
   • BI Developers
   • IT Professionals working with data visualization tools
   • Project Managers involved in data projects
   • SharePoint Administrators
   • Excel Power Users
   • Database Professionals looking to improve reporting capabilities

Learning Objectives - What you will Learn in this 55103-A: Creating and Sharing Interactive Dashboards with PowerPivot, Power View and SharePoint Server?

Introduction to Learning Outcomes and Concepts Covered

The 55103-A: Creating and Sharing Interactive Dashboards with PowerPivot, Power View, and SharePoint Server course equips learners with the skills to build and manage dynamic dashboards for data analysis and sharing.

Learning Objectives and Outcomes

• Understand the principles of effective dashboard design and the ability to develop, deploy, and update multiple dashboards.
• Learn how to import, relate, enrich, and perform time calculations on data for insightful dashboards.
• Gain proficiency in creating Excel dashboards with tabular and visual data, and understand how to link tables for coherent reporting.
• Acquire skills in adding interactivity to dashboards, including drill-through capabilities and using Power View for enhanced visualizations.
• Familiarize with SharePoint Excel Services for dashboard sharing, including deployment techniques and setting up automatic data refreshes.
• Develop strategies to monitor dashboard utilization and provide interactive help to dashboard users.
• Learn to control dashboard updates and change deployed dashboards based on user feedback or data changes.
• Master the art of sourcing data from various repositories and transforming it into meaningful information.
• Enhance your ability to provide actionable insights through well-structured and interactive dashboards.
• Acquire the necessary skills to maintain and manage dashboards in a SharePoint environment, ensuring data integrity and accessibility.