Corso attualmente non disponibile

MOC 20466 - Implementing Data Models and Reports with Microsoft SQL Server

Corso

A Distanza

1.700 € +IVA

Chiama il centro

Hai bisogno di un coach per la formazione?

Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.

Descrizione

  • Tipologia

    Corso

  • Metodologia

    A distanza

  • Durata

    5 Giorni

Descrivere i componenti, l'architettura e la natura di una soluzione di BI.
Creare un database multidimensionale di Analysis Services.
Implementare dimensioni in un cubo.
Attuare misure e gruppi di misure in un cubo.
Utilizzare la sintassi MDX.
Personalizzare un cubo.
Implementare un modello tabulare dati in SQL Server Analysis Services.
Utilizzare DAX per migliorare un modello tabulare.
Creare report con Reporting Services.
Migliorare i rapporti con grafici e parametri.
Gestire l'esecuzione del report e la sua consegna.
Implementare una dashboard in SharePoint Server con PerformancePoint Services.
Utilizzare il data mining per la Predictive Analysis.

Domande e risposte

Aggiungi la tua domanda

I nostri consulenti e altri utenti potranno risponderti

Inserisci i tuoi dati per ricevere una risposta

Pubblicheremo solo il tuo nome e la domanda

Opinioni

Materie

  • Data Mining
  • SQL
  • Reporting
  • Microsoft SQL Server
  • Server
  • Business intelligence
  • Self Service BI
  • Database
  • MDX
  • DAX

Professori

Trainer  certificato

Trainer certificato

AWS Authorized Instructor

Programma

Module 1: Introduction to Business Intelligence and Data ModelingElements of an Enterprise BI SolutionThe Microsoft Enterprise BI PlatformPlanning an Enterprise BI ProjectLab : Exploring a BI SolutionExploring the Data WarehouseExploring the Analysis Services Data ModelExploring ReportsModule 2: Creating Multidimensional DatabasesIntroduction to Multidimensional AnalysisCreating Data Sources and Data Source ViewsCreating a CubeOverview of Cube SecurityLab : Creating a Multidimensional DatabaseCreating a Data SourceCreating and Modifying a Data Source ViewCreating and Modifying a CubeAdding a DimensionModule 3: Working with Cubes and DimensionsConfiguring DimensionsDefining Attribute HierarchiesSorting and Grouping HierarchiesLab : Defining DimensionsConfiguring Dimensions and AttributesCreating HierarchiesCreating a Hierarchy with Attribute RelationshipsCreating a Ragged HierarchyBrowsing Dimensions and Hierarchies in a CubeModule 4: Working with Measures and Measure GroupsWorking with MeasuresWorking with Measure GroupsLab : Configuring Measures and Measure GroupsConfiguring MeasuresDefining a Regular RelationshipConfiguring Measure Group StorageModule 5: Introduction to MDXMDX FundamentalsAdding Calculations to a CubeUsing MDX to Query a CubeLab : Using MDXCreating Calculated MembersQuerying a Cube by Using MDXModule 6: Enhancing a CubeWorking with Key Performance IndicatorsWorking with ActionsWorking with PerspectivesWorking with TranslationsLab : Customizing a CubeImplementing an ActionImplementing PerspectivesImplementing a TranslationModule 7: Implementing an Analysis Services Tabular Data ModelIntroduction to Analysis Services Tabular Data ModelsCreating a Tabular Data ModelUsing an Analysis Services Tabular Data Model in the EnterpriseLab : Implementing an Analysis Services Tabular Data ModelCreating an Analysis Services Tabular Data Model ProjectConfiguring Columns and RelationshipsDeploying an Analysis Services Tabular Data ModelModule 8: Introduction to DAXDAX FundamentalsEnhancing a Tabular Data Model with DAXLab : Using DAX to Enhance a Tabular Data ModelCreating Calculated ColumnsCreating MeasuresCreating a KPIImplementing a Parent-Child HierarchyModule 9: Implementing Reports with SQL Server Reporting ServicesIntroduction to Reporting ServicesCreating a Report with Report DesignerGrouping and Aggregating Data in a ReportPublishing and Viewing a ReportLab : Creating a Report with Report DesignerCreating a ReportGrouping and Aggregating DataPublishing a ReportModule 10: Enhancing Reports with SQL Server Reporting ServicesShowing Data GraphicallyFiltering Reports by Using ParametersLab : Enhancing a ReportAdding a Chart to a ReportAdding Parameters to a ReportUsing Data Bars and SparklinesUsing a MapModule 11: Managing Report Execution and DeliveryManaging Report SecurityManaging Report ExecutionSubscriptions and Data AlertsTroubleshooting Reporting ServicesLab : Configuring Report Execution and DeliveryConfiguring Report ExecutionImplementing a Standard SubscriptionImplementing a Data-Driven SubscriptionModule 12: Delivering BI with SharePoint PerformancePoint ServicesIntroduction to SharePoint Server as a BI PlatformIntroduction to PerformancePoint ServicesPerformancePoint Data Sources and Time IntelligenceReports, Scorecards, and DashboardsLab : Implementing a SharePoint Server BI SolutionCreating a SharePoint Server Site for BIConfiguring PerformancePoint Data AccessCreating PerformancePoint ReportsCreating a PerformancePoint ScorecardCreating a PerformancePoint DashboardModule 13: Performing Predictive Analysis with Data MiningOverview of Data MiningCreating a Data Mining SolutionValidating a Data Mining ModelConsuming Data Mining DataLab : Using Data Mining to Support a Marketing CampaignUsing Table Analysis ToolsCreating a Data Mining StructureAdding a Data Mining Model to a Data Mining StructureValidating a Data Mining ModelUsing a Data Mining Model in a Report

Chiama il centro

Hai bisogno di un coach per la formazione?

Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.

MOC 20466 - Implementing Data Models and Reports with Microsoft SQL Server

1.700 € +IVA