Overview
This course is designed for the end users and analysts that are interested in exploring the new self-service business intelligence tools in Excel and SharePoint Server 2013.
Before attending this course, students should have:
Included with the course and intended for you to take away are videos of each of the critical lessons taught in the course.
This course is intended for all business professionals including IT professional, developers, managers, project leads, project managers, and team leads, but we do not expect coding skills, just thinking skills!
Course Overview Lab 1: Course Overview Microsoft Business Intelligence Vision Lab 1: Microsoft Business Intelligence Vision In this module we will explore PowerPivot and its analytical capabilities. PowerPivot is a data analysis add-on for Microsoft Excel that allows large amounts of data to be collected, aggregated, and analyzed in one workbook. Sound powerful? It is! We’ll cover everything you need to know to get you up, running, and analyzing. Lab 1: Excel 2013 PowerPivot In this module we will cover Power View and the reporting that can be created. From tables to charts and sharing on SharePoint, this module will have you ready to visualize your data in a variety of ways. Lab 1: Power View This module explains how to use Power Query effectively. Lab 1: Power Query This module explores Power Map, a new 3D visualization add-in for mapping, exploring, and interacting with geographical and temporal data, enabling users to discover and share new insights. Lab 1: Power Map This module includes concept reinforcement scenarios to encourage students to use what they’ve learned throughout this course. Scenario solutions are provided. Lab 1: Summary Lab Solutions
At Course Completion
Prerequisites
Videos
Target Student
Course duration
2 Days
Course outline
Module 1: Course Overview