Digi Academy

The Microsoft Business Intelligence 2010 Stack

Digi Academy
A Milano

Chiedi il prezzo
Chiedi informazioni a un consulente Emagister

Informazioni importanti

Tipologia Corso
Luogo Milano
Inizio Scegli data
  • Corso
  • Milano
  • Inizio:
    Scegli data
Descrizione

• SQL Analysis Services • SQL Reporting Services • Performance Management Tools • SharePoint 2010 • Multidimensional Space • MDX • Data Mining • Understanding the Terminology • Explore Business Intelligence Development Studio

Strutture (1)
Dove e quando
Inizio Luogo
Scegli data
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa
Inizio Scegli data
Luogo
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa

Cosa impari in questo corso?

Web master
Microsoft Business Intelligence
Server
Management
Business intelligence
SQL
e-Business
Data Mining

Programma

• Connect into a SQL Server Analysis Services Cube


• Use SQL Server Management Studio


• Explore SharePoint 2010


• UDM Defined


• User Experience: Relational vs. UDM


• Advantages


• Trouble in River City


• Creating a Data Mart using Business Intelligence Development Studio.


• Enabling Table Compression


• Major Components


• New or Changed Features


• Script Task


• SSIS and ETL


• Transformers


• Best Practices 1


• Best Practices 2


• Create A SSIS Project


• Add a Data Source


• Create A Data Flow


• Create Another Data Flow


• Load Data via a SQL Statement


• Populating the Fact Table


• Loading Manufacturing Facts


• Handling Errors


• Inventory Fact Flow


• Key Concepts


• Schemas


• Measures


• Dimensions


• Cube Processing


• Partitions


• Proactive Caching


• Aggregations


• Define an OLAP Cube


• Working with Measures and Measure Groups


• Time and Hierarchies


• Relating Dimensions


• Build Deploy and Browse the Cube


• Multiple Partitions


• Set Storage


• Design Aggregations


• Default Members


• Integration with SharePoint


• Report Builder 3.0


• Differences Between Environments


• Tablix


• Charts


• SSRS Projects Report Wizard


• Report Builder 3.0


• Creating Charts


• What is MDX?


• MDX Query Editor


• Select Statement


• Key Concepts


• Sets


• Functions


• Time Intelligence


• Understand the Cell


• Write a Tuple


• MDX Sets


• Write a SELECT statement


• Write a Function


• Implement Time


• Integration with SharePoint Server 2010


• Common Service Application Framework


• New PerformancePoint Features


• Storage Security


• Time Intelligence and Dynamic Filters


• Linking of Web Parts


• KPI Details Report


• Retired Features


• Scorecards in PPS


• KPI Collections


• Dashboard Design Guidelines


• Dashboard Designer Internals


• Dashboard Designer Interface


• First Class Objects


• Main Window


• Properties


• Dashboard Designer Features


• Use SharePoint to create a site collection


• Configure Central Administration for PerformancePoint Services


• Create and Explore a PerformancePoint Business Intelligence Center


• Create a Basic Dashboard


• Deploy the Dashboard


• Explore the Dashboard in PPS


• Integration with SharePoint Server 2010


• Storage Security


• Single version of the truth


• Excel Web Services


• New capabilities in Excell Services


• Business Connectivity Services


• Deploy a Excel spread sheet for a single version of the truth


• Utilize Excel Web Services


• Business Connectivity Services


• Integration with SharePoint Server 2010


• Understanding Modeling


• Explore Excel PowerPivot


• Key Terms in Data Mining


• Types of Data Mining Algorithms


• The Algorithm


• Excel and The BI Extensions


• Visio 2010


• Utilize the Excel Data Mining Tools



Gli utenti che erano interessati a questo corso si sono informati anche su...
Leggi tutto