Szkolenia Microsoft

Cel szkolenia szkolenie zdalne - dlearning

kod: MS-55045 | wersja: A

This seven-day instructor-led course is a complete high-level tour of the Microsoft Business Intelligence stack. It introduces students to the SQL 2012 Business Intelligence and SharePoint 2013 Business Intelligence services including PerformancePoint Service, Excel Services, Business Connectivity Services, Visio Services and the Business Intelligence Center focusing on their interdependency.

After completing the course, students will be able to:

  • Browse the data within the cube using SQL Server Management Studio.
  • Browse data using Visual Studio 2013.
  • Connect to a tabular source, import tables, and explore the data.

Audience profile:

This course is intended for Project Managers, Business Intelligence Developers, SQL Server Developers and IT Professionals that will be involved with the design, development and maintenance of SharePoint 2013 Business Intelligence solutions. The course introduces each of the services and minimizes or eliminates any coding.

Plan szkolenia Rozwiń listę

  1. Course Overview
    • Introduction
    • Course Materials
    • Facilities
    • Prerequisites
    • What We'll Be Discussing
  2. The Business Intelligence Stack
    • Business Intelligence in Three Ways
    • SQL 2012 Business Intelligence
    • New 2013 SharePoint Business Intelligence Features
    • New 2013 PowerPivot in Excel Features
  3. SQL Server Integration Services (SSIS) 2012
    • What’s New?
    • Overview of Extract, Transform, and Load (ETL)
    • SSIS Tools
    • Change Data Capture
    • SQL Server Integration Services Scripting
    • Variables, Parameters, and Expressions
    • Package Deployment
  4. SQL 2012 Business Intelligence Semantic Model (Multidimensional Mode)
    • The Data Warehouse/Data Mart
    • The Tools
    • Key Concepts
    • Data Sources
    • Data Views
    • Cubes
    • Data Profiler
    • Proactive Cache
    • Wizards
  5. Microsoft Multidimensional Expressions
    • Concepts in Multidimensional Space
    • Basic MDX Statements
    • SQL Server Management Studio MDX Query Editor
    • Navigating Hierarchies
    • Working with Time
    • Microsoft Multidimensional Expressions
  6. SQL 2012 Business Intelligence Semantic Model (Tabular Mode)
    • The Tabular Model
    • Data Analytic Expressions (DAX)
    • The Editor
    • Data Connections
    • Creating a Tabular Project
    • Relationships
    • Measures and Calculated Columns
    • Hierarchies
    • Perspectives
    • KPIs
    • Partitions
    • Processing
    • Deployment
  7. SQL Server 2012 Reporting Services
    • Report Lifecycles
    • Installation Modes
    • Report Creation Tools
    • Data Sources
    • Datasets
    • Basic Reports
    • Graphics
    • Maps
    • Report Parts
  8. Master Data Services
    • What is Master Data Management?
    • System Roles
    • Master Data vs. Transactional Data
    • Master Data Services ETL
    • Master Data Services Key Concepts
  9. Data Mining/Predictive Analytics
    • Definitions for Our Purpose
    • Problems Addressed
    • Business Analytics
    • CRISP-DM
    • Key Concepts
    • Microsoft Data Mining Process
    • Data Mining Tasks
    • Microsoft Algorithms
    • Matching the Tasks to the Algorithm
    • Data Mining Add-in for Excel
  10. SharePoint 2013 Business Intelligence Center
    • New 2013 SharePoint Central Administration
    • New 2013 Business Intelligence Center
    • Permissions and Roles
    • Included Document Library and List Apps
  11. SharePoint 2013 Excel Services
    • New 2013 Excel Services Features
    • Core Components
    • 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
    • Best Practices
  12. SharePoint 2013 PerformancePoint 2013
    • New 2013 Overview of PerformancePoint Services
    • Dashboard Designer
    • Data Sources
    • Indicators
    • KPIs
    • Visual Reports
    • Filters
    • Scorecards
    • Dashboards
  13. SharePoint 2013 Visio Services
    • New 2013 Visio Services Features
    • Visio Graphics Service
    • Visio Drawings in the Browser
    • Visio Web Access Web Part
    • SharePoint 2013 Visio Services
  14. PowerPivot
    • New 2013 PowerPivot Features
    • PowerPivot and Excel
    • PowerPivot and SharePoint
    • Enterprise Business Intelligence and PowerPivot
    • Importing Data
    • Enriching Data
    • SharePoint Sharing
  15. SharePoint 2013 Business Connectivity Services
    • New 2013 Business Connectivity Service Features
    • What is Business Connectivity Services?
    • BCS Terminology
    • BCS Security
    • Using SharePoint Designer 2013 with BCS
    • Surfacing the BCS Data
  16. Dashboards
    • Dashboard Migration
    • Three Types of Dashboards
    • Successful Dashboards
    • Tables or Graphs
    • Types of Graphs
    • Choosing a Chart Type
    • Key Performance Indicators
    • Pitfalls In Dashboard Design
    • Microsoft Report Builder 3.0
    • Plan Your Reports
    • Datasets
    • New 2013 SharePoint Designer Features
    • SharePoint Web Apps
Pobierz konspekt szkolenia w formacie PDF

Dodatkowe informacje

Wymagania wstępne

Before attending this course, students must have:

  • An understanding of the benefits of business intelligence.
Poziom trudności
Czas trwania 5 dni
Certyfikat

Certyfikat ukończenia autoryzowanego kursu Microsoft.
Prowadzący

Microsoft Certified Trainer.

Pozostałe szkolenia Microsoft | Microsoft SQL Server

Wszystkie szkolenia Microsoft
Szkolenia powiązane tematycznie

Bazy danych

Java Programming | Capstone Courseware

Databases | Capstone Courseware

Bazy Danych | Compendium CE

Azure | Microsoft

Microsoft SQL Server | Microsoft

SharePoint | Microsoft

Data Platform | Microsoft

MySQL | Oracle

Oracle Database | Oracle

Data Management | Oracle

Oracle E-Business Suite | Oracle

Construction & Engineering | Oracle

Hyperion and Essbase | Oracle

Formularz kontaktowy

Prosimy o wypełnienie poniższego formularza, jeśli chcą Państwo uzyskać więcej informacji o powyższym szkoleniu.





* pola oznaczone (*) są wymagane

Informacje o przetwarzaniu danych przez Compendium – Centrum Edukacyjne Spółka z o.o.

CENA SZKOLENIA OD 3800 PLN NETTO

Najbliższe szkolenia Microsoft

Harmonogram szkoleń Microsoft