This 5 day instructor-led training class is presented by Microsoft training partners to their end customers. Training partners in North America and the UK hire proven AMS Subject Matter Expert Microsoft Certified Trainers (MCT’s) to teach on-site and on-line classes.
In this class we utilize built in tools and do not write a single line of code! No Code visualization means using the data structures that exist already to get the job done.
Class Audience:
The target audience of this class is 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 class will help students learn how to rapidly prototype reports on their own. Students can move from textual reports to graphical reporting, Six Sigma type reports using Visio Data Driven objects. Students will be able to assist their organizations with the implementation of analysis based on automatically updating data and with implementing a “Single Source of The Truth” structure. Students will understand the effectiveness of the reports, dashboards and the tools that are available to determine which is the target audience for those tools as well as implement actionable dashboards to allow line managers to rapidly take action.
Prerequisites: There are no prerequisites for this class.
Course Outline
I. Introduction
This module explains how the class will be structured and introduces course materials and additional administrative information.
A. What you will get out of this module:
B. Introduction to the instructor and your peers
C. A review of what we mean by NO CODE
D. How to work in the course environment
E. What does NO Code mean?
F. How to get the most out of this course
G. The course setup
H. What is not covered?
Lab: Introduction
• Explore the Course Environment
II. Data Visualizations
This module explains concepts of data visualizations.
A. Data Visualization Fundamentals
B. The Microsoft Toolsets for Visualizations
Lab: Data Visualizations
• Explore the Microsoft Toolsets
III. Dashboard Design Principles
This module is an introduction to successful design principles for Dashboard design.
A. Successful dashboards
B. Quantitative relationships
C. Summary numbers
D. Tables or graphs?
E. Types of graphs
F. Key performance indicators
G. Dashboard taxonomies
H. Pitfalls in dashboard design
Lab: Group Review of Design Problems
• Design Problem 1
• Design Problem 2
• Design Problem 3
IV. Microsoft Business Intelligence Stack
This module covers the Microsoft Business Intelligence stack including SQL 2012, Extract – Transform – Load, Reporting Services, Tabular Data, Analysis Services and SharePoint 2013.
A. Microsoft Business Intelligence Overview
B. Business Intelligence in three ways
C. SQL Integration Services ETL
D. Reporting Services
E. Master Data Services
F. Data Quality Services
G. SharePoint 2013 Business Intelligence
Lab: 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
V. Report Builder 3.0
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.
A. Introduction to Report Builder 3.0
B. Report Builder 3.0 Wizards
C. Report Builder 3.0 Graphics
D. Intermediate Reports
Lab: Report Builder 3.0
• Report Builder Wizards
• Basic Reports
• Intermediate Reports
• Graphics
VI. PowerPivot and PowerView
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! We’ll cover everything you need to know to get you up, running, and analyzing.
A. PowerPivot
B. DAX
C. PowerView
Lab: PowerPivot and PowerView
• Create a Pivot Table
• Import Data
• Create Relationships
• Create Calculated Columns
• Create Calculated Fields
• Save to SQL
• Create PowerView Reports
• Deploy to SharePoint
To Hire an AMS Microsoft Report Builder Subject Matter Expert Consultant and Instructor who also teaches this class, call 800-798-3901 today!