Til forsiden Login kursusudbydere Annoncering Kontakt

Implementing Data Models and Reports with Microsoft SQL Server [20466]

Kursusinfo
Pris: 19.975 kr
Varighed: 5 dage
Kviknummer: 18156 Udbyder: Teknologisk Institut. Uddannelse
Tilmelding

Vælg dato:

Afholdelsessted
Teknologisk Institut
Gregersensvej
2630 Taastrup

På dette kursus lærer du, at oprette administrerede løsninger i SQL Server 2014. Du lærer at implementere multidimensionelle og tabulare datamodeller, levere rapporter med Reporting Services, oprette dashboard med SharePoint Server PerformancePoint Services samt få indblik i forretningen ved brug af data mining.

Du får fuldt udbytte af kurset, hvis du benytter SQL Server 2012 eller 2008 R2.

Fleksibel IT-læring

Kurset afholdes efter Teknologisk Instituts koncept, Fleksibel IT-læring, der er tilrettelagt til at give dig de bedste rammer for optimal læring, så du får mest muligt ud af dit kursus. Du får blandt andet et opdelt kursusforløb, og du har mulighed for at få testet dit vidensniveau inden eksamen. Læs mere om Fleksibel IT-læring her.

Forudsætninger

This course requires that you meet the following prerequisites:
  • At least 2 years' experience of working with relational databases, including:
  • Designing a normalized database.
  • Creating tables and relationships.
  • Querying with Transact-SQL - Writing Queries with Microsoft SQL Server 2014Transact-SQL [20461].
  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

Deltagerprofil

Kurset henvender sig primært til databaseudviklere, der som BI udviklere skal have ansvaret for at oprette analysis og rapporteringsløsninger. Dine ansvarsområder vil typisk være:

  • Implementering af rapporteringsløsninger ved brug af SQL Server Reporting Services
  • Implementering af multidimensionelle databaser ved brug af SQL Server Analysis Services
  • Oprette tabulare semantiske datamodeller til analyser ved brug af SQL Server Analysis Services
  • Oprette visualisering af data ved brug af Power View

Indhold

Module 1: Introduction to Business Intelligence and Data Modeling
  • Elements of an Enterprise BI Solution
  • The Microsoft Enterprise BI Platform
  • Planning an Enterprise BI Project
Module 2: Creating Multidimensional Databases
  • Introduction to Multidimensional Analysis
  • Creating Data Sources and Data Source Views
  • Creating a Cube
  • Overview of Cube Security
Module 3: Working with Cubes and Dimensions
  • Configuring Dimensions
  • Defining Attribute Hierarchies
  • Sorting and Grouping Hierarchies
Module 4: Working with Measures and Measure Groups
  • Working with Measures
  • Working with Measure Groups
Module 5: Introduction to MDX
  • MDX Fundamentals
  • Adding Calculations to a Cube
  • Using MDX to Query a Cube
Module 6: Enhancing a Cube
  • Working with Key Performance Indicators
  • Working with Actions
  • Working with Perspectives
  • Working with Translations
Module 7: Implementing an Analysis Services Tabular Data Model
  • Introduction to Analysis Services Tabular Data Models
  • Creating a Tabular Data Model
  • Using an Analysis Services Tabular Data Model in the Enterprise
Module 8: Introduction to DAX
  • DAX Fundamentals
  • Enhancing a Tabular Data Model with DAX
Module 9: Implementing Reports with SQL Server Reporting Services
  • Introduction to Reporting Services
  • Creating a Report with Report Designer
  • Grouping and Aggregating Data in a Report
  • Publishing and Viewing a Report
Module 10: Enhancing Reports with SQL Server Reporting Services
  • Showing Data Graphically
  • Filtering Reports by Using Parameters
Module 11: Managing Report Execution and Delivery
  • Managing Report Security
  • Managing Report Execution
  • Subscriptions and Data Alerts
  • Troubleshooting Reporting Services
Module 12: Delivering BI with SharePoint PerformancePoint Services
  • Introduction to SharePoint Server as a BI Platform
  • Introduction to PerformancePoint Services
  • PerformancePoint Data Sources and Time Intelligence
  • Reports, Scorecards, and Dashboards
Module 13: Performing Predictive Analysis with Data Mining
  • Overview of Data Mining
  • Creating a Data Mining Solution
  • Validating a Data Mining Model
  • Consuming Data Mining Data

Microsoft Software
Assurance Vouchere

Kurset kan betales med 5 SA Vouchere.

Certificering

Kurset leder hen til exam 70-466: Implementing Data Models and Reports with SQL Server 2012 / 2014. Eksamen bestilles og betales særskilt. Find og bestil din certificering her.

Underviser

Undervisningen varetages af en erfaren underviser fra Teknologisk Instituts netværk bestående af branchens dygtigste undervisere.



Om Teknologisk Institut. Uddannelse

Kurser i IT, Projektledelse, Ledelse, Energi, HR m.m
- Teknologisk Institut er det naturlige valg af kursusudbyder

Teknologisk Institut har leveret uddannelse til det danske erhvervsliv siden 1906, og har derfor over 100 års erfaring med kurser og uddannelser. Hvert år deltager flere end 15.000 personer på Teknologisk Instituts arrangementer, der dækker en bred vifte af... Læs mere