The target audience of this course is for Business Analysts, Report Designers, Team Leads, SharePoint Administrators, Business Intelligence Developers and Project Managers that will be tasked with the implementation, support, management or training needed to rapidly empower the users to take advantage of the exploding world of Data V.
This module explains how the class will be structured and introduces course materials and additional administrative information. What you will get out of this module: Introduction to the instructor and your peers A review of what we mean by NO CODE How to work in the course environment.
What does NO Code mean ?
How to get the most out of this course
The course setup
What is not covered ?
Not available for this module
Lab lessons not available
Understand your course, classroom, classmates, facility and instructor.
This module explains concepts of data visualizations.
Data Visualization Fundamentals
The Microsoft Toolsets for Visualizations
Explore the Microsoft Toolsets
Understand the concept of Data Visualizations.
This module is an introduction to successful design principles for Dashboard design.
Tables or graphs ?
Types of graphs
Key performance indicators
Pitfalls in dashboard design
Group Review of Design Problems
Design Problem 1
Design Problem 2
Design Problem 3
Understand Dashboard Design Principles.
This module covers the Microsoft Business Intelligence stack including SQL 2012, Extract-Transform-Load, Reporting Services, Tabular Data, Analysis Services and SharePoint 2013.
Microsoft Business Intelligence Overview
Business Intelligence in three ways
SQL Integration Services ETL
Master Data Services
Data Quality Services
SharePoint 2013 Business Intelligence
Tour of the Microsoft Business Intelligence Stack
Run a prepared ETL Package
Create a SQL Server Analysis Services Cube
Create a Tabular Database
Examine Master Data Services
Examine Reporting Services as a native install
Examine Reporting Services as an integrated SharePoint install
The SharePoint 2013 Business Intelligence Template
Understand the role of the Microsoft Business Intelligence Stack.
This module explains Report Builder 3.0 wizards, basics of report design, intermediate reports with report parameters and report expressions, report visualizations including graphs, charts, images, and gauges, advanced reporting including the utilization of maps, interactive reports, Report Parts and sub-reports.
Introduction to Report Builder 3.0
Report Builder 3.0 Wizards
Report Builder 3.0 Graphics
Report Builder 3.0
Report Builder Wizards
Understand the role of the Report Builder 3.0.
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. Sounds powerful? It is! Well cover everything you need to know to get you up, running, and analyzing.
PowerPivot and PowerView
Create a Pivot Table
Create Calculated Columns
Create Calculated Fields
Save to SQL
Create PowerView Reports
Deploy to SharePoint
Understand how to use PowerPivot and PowerView
In this module, we will go over all the new 2013 Excel Services features, and we will explore the core components of Excel Services. We will cover Excel Web Access and its capabilities along with any differences you may encounter in the browser as opposed to the desktop client. There is coverage of the Power View add-in for Excel, and then lastly we will explain the save and share process and have a look at best practices.
New 2013 Excel Services Features
Excel Web Access (EWA)
What Excel Web Access is Not
Differences in the Browser vs. Desktop
SharePoint Libraries to Store Workbooks
Power View Add-in for Excel
The Save and Share Process
Excel Web App
SharePoint 2013 Excel Services
Creating a Library to Hold Excel Workbooks
Exploring the Power View Add-in for Excel
Save and Share an Excel Workbook to a SharePoint Document Library
Add an Excel Web App to a Webpage
Understand SharePoint 2013 Excel Services.
In this module, we will give you an overview of the new 2013 PerformancePoint Services features. Dashboard Designer is explored along with many of the objects and connections available within.
New 2013 Overview of PerformancePoint Services
PerformancePoint Services Dashboard Designer Introduction and Data Source Configuration
Standard or Blank KPI Demonstration
Leaf KPI Demonstration
Objective KPI Demonstration
PerformancePoint Cascading Filters
Time Intelligence Filters
Scorecards Filtered Using the Wizard
Understand SharePoint 2013 PerformancePoint Services.