Duration: 5 Days
Delivery Method: Instructor-led (in-class & virtual)
Software Assurance Value:
What do we mean by no code? It is a matter of perspective. In today’s world the successful software vendor needs to develop software that is easily customizable by casual users. In the realm of business intelligence that means offering a variety of tools to different types of users that, depending on their experience, they can utilize to rapidly create the visualization of data that suits their needs. Microsoft has produced a great array of such tools that target different users. These tools are various Wizards, Dialog Boxes, Forms, Web Pages Designers and so forth. In this course we utilize the 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. You don’t have the time or maybe the inclination to learn how to code but you need answers. I.T., if you haven’t already noticed, is always working through a backlog but your business situation is dynamic and rapidly changing and will not wait for any backlog. In this course you will learn how to get those answers without submitting a request and waiting.
After completing this course, students will be able to:
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.
Why this course may be for you:
Module 1: Introduction
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:
Module 2: Data VisualizationsThis module explains concepts of data visualizations.
Lab: Data Visualizations
Module 3: Dashboard Design PrinciplesThis module is an introduction to successful design principles for Dashboard design.
Lab: Group Review of Design Problems
Module 4: Microsoft Business Intelligence StackThis module covers the Microsoft Business Intelligence stack including SQL 2012, Extract-Transform-Load, Reporting Services, Tabular Data, Analysis Services and SharePoint 2013.
Lab: Tour of the Microsoft Business Intelligence Stack
Module 5: 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.
Lab: Report Builder 3.0
Module 6: PowerPivot and PowerViewIn 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. Soundspowerful? It is! We’ll cover everything you need to know to get you up, running, and analyzing.
Lab: PowerPivot and PowerView
Module 7: SharePoint 2014 Excel Services
Lab: SharePoint 2014 Excel Services
Module 8: SharePoint 2013 PerformancePoint ServicesIn 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.
Lab: PerformancePoint 2013