primus-club
ενδοεπιχειρησιακή εκπαίδευση
εκπαιδευση security
διεθνή-λογιστικά-πρότυπα-με-πιστοποίηση-cpa-international

DEVELOPING SQL DATA MODELS

Πρόσθετες Πληροφορίες

  • Συνοπτικό πρόγραμμα:

    Προαπαιτούμενα:

    • Εμπειρία στη χρησιμοποίηση Transact-SQL

    1. Introduction to Business Intelligence and Data Modeling
    a. Introduction to Business Intelligence
    b. The Microsoft business intelligence platform
    c. Exploring a BI Solution

    • Exploring a Data Warehouse
    • Exploring a data model

    2. Creating Multidimensional Databases
    a. Introduction to Multidimensional Analysis
    b. Creating Data Sources and Data Source Views
    c. Creating a Cube
    d. Overview of Cube Security
    e. Configure SSAS
    f. Monitoring SSAS
    g. Creating a multidimensional database

    • Creating a Data Source
    • Creating and Modifying a data Source View
    • Creating and Modifying a Cube

    3. Working with Cubes and Dimensions
    a. Configuring Dimensions
    b. Defining Attribute Hierarchies
    c. Sorting and Grouping Attributes
    d. Slowly Changing Dimensions
    e. Working with Cubes and Dimensions

    • Configuring Dimensions
    • Defining Relationships and Hierarchies
    • Sorting and Grouping Dimension Attributes

    4. Working with Measures and Measure Groups
    a. Working with Measures
    b. Working with Measure Groups
    c. Configuring Measures and Measure Groups

    • Configuring Measures
    • Defining Dimension Usage and Relationships
    • Configuring Measure Group Storage

    5. Introduction to MDX
    a. MDX fundamentals
    b. Adding Calculations to a Cube
    c. Using MDX to Query a Cube
    d. Using MDX

    • Querying a cube using MDX
    • Creating a Calculated Member

    6. Customizing Cube Functionality
    a. Introduction to Business Intelligence
    b. The Implementing Key Performance Indicators
    c. Implementing Actions
    d. Implementing Perspectives
    e. Implementing Translations
    f. Customizing a Cube

    • Implementing a KPI
    • Implementing an action
    • Implementing a perspective
    • Implementing a translation

    7. Implementing a Tabular Data Model by Using Analysis Services
    a. Introduction to Tabular Data Models
    b. Creating a Tabular Data Model
    c. Using an Analysis Services Tabular Data Model in an Enterprise BI Solution
    d. Working with an Analysis Services Tabular Data Model

    • Creating an Analysis Services Tabular Data Model
    • Configure Relationships and Attributes
    • Configuring Data Model for an Enterprise BI Solution.

    8. Introduction to Data Analysis Expression (DAX)
    a. DAX Fundamentals
    b. Using DAX to Create Calculated Columns and Measures in a Tabular Data Model
    c. Creating Calculated Columns and Measures by using DAX

    • Creating Calculated Columns
    • Creating Measures
    • Creating a KPI
    • Creating a Parent - Child Hierarchy

    9. Performing Predictive Analysis with Data Mining
    a. Overview of Data Mining
    b. Creating a Custom Data Mining Solution
    c. Validating a Data Mining Model
    d. Connecting to and Consuming a Data-Mining Model
    e. Using the Data Mining add-in for Excel
    f. Using Data Mining

    • Creating a Data Mining Structure and Model
    • Exploring Data Mining Models
    • Validating Data Mining Models
    • Consuming a Data Mining Model
    • · Using the Excel Data Mining add-in
  • Εισηγητής/ές:

    Με πολυετή διδακτική και εργασιακή  εμπειρία σε όλους τους τομείς της Πληροφορικής

  • Διάρκεια: 21 Ώρες
  • Κόστος: 550€
  • Ημερομηνίες διεξαγωγής: 1,2,3/4
  • Ημερομηνία έναρξης: 1/4/2019
  • Ώρες διεξαγωγής: 09:30-16:30
  • Πόλη: Αθήνα
Τελευταία τροποποίηση στις Τρίτη, 29 Ιανουαρίου 2019 13:19

Σας ενδιαφέρει ;

Name: *


Email: *


Company


Phone


Subject: *


Message:

Send a copy of the email to your email address


Περισσότερα σε αυτή την κατηγορία: ANALYZING & VISUALIZING DATA WITH POWER BI »

Αθήνα

PRIMUS Business & IT Training
Λεωφ. Πειραιώς 108 ΤΚ 11854, Γκάζι, ΑΘήνα
Τηλ. 210-95.37.370-9 Fax. 210-95.37.369
Λιοσίων 281 ΤΚ 10445 , Αθήνα
Τηλ. 210-8547970 Fax. 210-8547969

 

 

 

Social links

Θεσσαλονίκη

Εκπαιδευτικό Κέντρο Θεσσαλονίκης
Β.Τσορλίνη 26
ΤΚ 54626, Θεσσαλονίκη
Τηλ. 2310-56.73.52
Fax. 2310-56.73.52

Πάτρα

Εκπαιδευτικό Κέντρο Πάτρας
NEO Πατρών Αθηνών 35
ΤΚ 26443, Πάτρα
Τηλ. 2610-45.20.87
Fax. 2610-43.93.12

Πως θα μας βρείτε

Αθήνα Θεσσαλονίκη Πάτρα
 athensmap  primusthess  primus patra