50561A Visualizing SharePoint Business Intelligence with No Code

750€

Nici o vizualizare a codului nu înseamnă utilizarea structurilor de date care există deja. Nu aveți timp sau poate înclinația de a învăța cum să codificați, dar aveți nevoie de răspunsuri,  situația dvs. de afaceri este dinamica și se schimbă rapid. În acest curs veți învăța cum să obțineți aceste răspunsuri fără a trimite o solicitare și a aștepta.

Publicul țintă al acestui curs este format din Power Analysts, Report Designers, Team Leads, SharePoint Administrators, Business Intelligence Developers și Project Managers care vor avea sarcina de a implementa, de a sprijini, de a gestiona sau de a pregăti instruirea necesară pentru a împuternici rapid utilizatorii să profite de lumea explozivă a inteligenței în afaceri.

După finalizarea acestui curs, participantii vor putea să efectueze toate acțiunile și să răspundă la toate întrebările enumerate în „De ce acest curs poate fi pentru dvs.”:

•Aveți infrastructura, dar obțineți rapoarte generate care durează mult.
•Lipsa de înțelegere a ceea ce sa întâmplat vă împiedică capacitatea de a merge mai departe.
•Aveți nevoie sau doriți să utilizați browserul web ca sursă de informații, astfel încât să fie la fel de accesibil ca și internetul.
•Doriți să profitați de implementarea SharePoint pentru a gestiona conexiunile de date, obiectele de raportare, tablourile de bord KPI etc.
•Aveți nevoie de prototipuri rapide de rapoarte pentru schimbarea condițiilor.
•Doriți să treceți de la rapoartele textuale la raportarea grafică.
•Sunteți însărcinat cu implementarea rapoartelor tip Six Sigma utilizând obiecte Visio Data Driven
•Organizația dvs. dorește să pună în aplicare analiza bazată pe actualizarea automată a datelor
•Trebuie să implementați o structură „Single Source of The Truth”.
•Trebuie să înțelegeți eficiența rapoartelor și a tablourilor de bord din perspectiva consumatorilor printr-un sistem ușor de interogare a rețelelor sociale.
•Aveți nevoie de o înțelegere a instrumentelor disponibile și a stabili care este publicul țintă pentru aceste instrumente.
•Trebuie să implementați tablouri de bord care să poată fi acționate, pentru a permite managerilor de linii să acționeze rapid.

Detalii curs

  • Durata 5 zile
  • Nivel 200
  • Limba curs Engleza/Romana
  • Limba suport Engleza
  • Cursanti/grupa 10
  • Examen
  • Certificare
Course Outline

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:
Introduction to the instructor and your peers.
A review of what we mean by NO CODE.
How to work in the course environment.

Lessons

  • Welcome
  • What does NO Code mean?
  • How to get the most out of this course
  • The course setup
  • What is not covered

Lab : Introduction

Module 2: Business Intelligence Overview

This module brings everybody up to the same point in their knowledge of Business Intelligence, what it is capable of, problems you may encounter and encouraging case studies.
What you will get out of this module:
What Business Intelligence can do for your organization.
What to watch out for in implementation.
What is a Business Intelligence Time Scope and what types of tools address each?
An understanding and appreciation for the effort I.T. put into the project.

Lessons

  • Why Business Intelligence
  • Why do Business Intelligence Projects fail?
  • The Three Types of Business Intelligence Projects
  • Business Intelligence Time Scopes
  • Some Great Features in SQL for Business Intelligence

Lab : Business Intelligence Overview

Module 3: How to Match the Tool to the User

What you will get out of this module:
A set of taxonomies for classifying your users.
Think through your organization and determine where they are in the implementation cycle.
Knowing the two above will guide you in the tools to use for each group.

Lessons

  • Determine the type(s) of users
  • Determine the maturity of your organizational Business Intelligence
  • The target of the tools
  • High level overview of each tool

Lab : How to Match the Tool to the User

Module 4: The Data Mart/Warehouse

What you will get out of this module:
An understanding of the terminology.
Why a DatamartWarehouse is the best data storage mechanism for Business Intelligence .
An overview of SQL Server Analysis Services.
How to use SQL Management Studio to examine data.

Lessons

  • What is a Data Mart?
  • What is Microsoft Analysis Services?
  • Business Intelligence Terminology
  • A fast and easy way as a proof of concept

Lab : The Data Mart/Warehouse

Module 5: Data Sources

What you will get out of this module:
An understanding of the concept of trusted data and why it is a must have concept.
The potential sources for data we can use in analytics.
The potential problems or costs that are associated with the data sources.
An examination of the creation process for a data source.

Lessons

  • What is Trusted Data?
  • Where can we pull data from?
  • What might we have to do?
  • Using Social Networks
  • The Data Sources

Lab : Data Sources

Module 6: Business Intelligence in SharePoint

What you will get out of this module:
What the management features of SharePoint bring to the table for you.
Why SharePoint security simplifies your life.
How to use workflows in your Business Intelligence.

Lessons

  • What does SharePoint add?
  • How can workflows be used in Business Intelligence?
  • Quick tour of terms

Lab : Business Intelligence in SharePoint

Module 7: SharePoint Business Center

What you will get out of this module:
Understanding why the Business Center is the correct template for use in Business Intelligence.
How to link other sites in your organization back to the Business Center.
How to use Social Networking in your Business Center to see how the users feel about the site and dashboards.
How and why you might want to add Sub sites into your Business Center.
How to customize the look and feel of the site.

Lessons

  • Exploring the Business Center
  • The built in features
  • Adding other features
  • Adding social network features to your internal Business Intelligence
  • Creating Sub-Sites
  • Customizing the Business Center

Lab : SharePoint Business Center

Module 8: PerformancePoint Services

What you will get out of this module:
An understanding of why PerformancePoint services is a service and not a server.
A good working knowledge of the excellent tool Dashboard Designer.
How to create each of the first class objects including the new cascading filter added by Service Pack 1.
How to deploy a Dashboard .

Lessons

  • What is PerformancePoint Services (with Service pack 1)
  • Dashboard Designer
  • KPIs
  • Filters
  • Scorecards
  • Dashboards
  • Further Study

Lab : PerformancePoint Services

Module 9: Excel Services

What you will get out of this module:
An understanding of why Excel Services is and what it is not.
How to use a Single Source of the Truth for your workbooks.
How to use a workbook as a data source for a KPI.
How to Publish workbooks to Excel Services.
How to utilize parameters in published workbooks.

Lessons

  • What is Excel Services
  • A Single Source of the Truth
  • What Excel Services is not
  • Publishing with Excel Services
  • Interacting with published Excel workbooks

Lab : Excel Services

Module 10: PowerPivot in Excel and SharePoint

What you will get out of this module:
An understanding of what PowerPivot adds to Excel.
The advantages of using PowerPivot in SharePoint.
Publishing PowerPivot to SharePoint.

Lessons

  • What is PowerPivot
  • Using the Excel PowerPivot add in
  • Using PowerPivot for SharePoint

Lab : PowerPivot in Excel and SharePointModule 11: Visio and Visio Services

What you will get out of this module:
An understanding of what Visio services enables in dashboards.
How to create and deploy a data driven Visio drawing.

Lessons

  • What is Visio Services
  • Using Data Connected Visio Drawings

Lab : Visio and Visio Services

Module 12: SQL Reporting Services

What you will get out of this module:
The advantages of a Integrated installation between SQL Reporting Services and SharePoint Services.
How to utilize Report Builder 3.0.
How to create Graphs.
How to create Gauges.
How to generate Reusable Report Parts.
How to utilize maps in your reports.

Lessons

  • Advantages of Integrated Installation
  • Report Builder 3.0
  • Creating Graphs
  • Creating Maps
  • Creating Gauges
  • Creating reusable Report Parts

Lab : SQL Reporting Services

Module 13: Business Connectivity Services

What you will get out of this module:
Understand Business Connectivity Services.
Implement a BCS deployment.

Lessons

  • What is Business Connectivity Services?
  • Using BCS in SharePoint

Lab : Business Connectivity Services