Data Warehouse Design (1Day)

O Understanding BI

o Understanding Data Warehouse Design

o Stages of Making a BI System

o Designing Data Warehouse

• OLAP Modeling
•  Star Schema
•  Snowflake Schema
•  Constellation Schema
• Designing Dimension
• Designing Fact

Extract, Transform & Load Data (2Day)

• Introduction to SSIS
• Getting Started
• Creating SSIS Packages and Data Sources
• Creating and Editing Control Flow Objects
• Using the Maintenance Plan Tasks
• Using Containers
• Sequence Container
• For Loop Container
• For each Loop Container
• Using Expressions & Variables
• Using Parameters
• Loading a Data Warehouse
• Data Extraction
• Data Transformation
• Changing Data Types with the Data Conversion Transform
• Creating Columns with the Derived Column Transform
• Rolling Up Data with the Aggregate Transform
• Ordering Data with the Sort Transform
• Joining Data using Lookup/Merge Join
• Combining Multiple Inputs with the Union All
• Auditing Data with the Row Count Transform
• Separating Data with the Conditional Split Transform
• Altering Rows with the OLE DB Command Transform
• Using Cache Transform Component
• Dimension Table Loading
• Using SCD (Slowly Changing Dimensions)
• Fact Table Loading
• Using CDC (Change Data Capture)
• SSAS processing

Implementing Multi-Dimensional Model (3Day)

• Designing DSV(Data Source View)
• Dimensions: Attributes & Members
• Dimensions: Hierarchies
• Measure Group & Measures
• Demonstrate Using Excel Pivot Table
• Advanced Dimension Designing
• Introduction to MDX language (Multi-Dimensional Expressions)
• MDX Query
• MDX Expressions
• Using Calculations
• Calculated Member
• Named Set
• Script Command
• Implementing KPI
• Adding Translation
• Using Perspectives
• Managing Data Warehouse
• Elementary Partitioning
• Elementary Processing
• Deployment
• Managing Security

Implementing Tabular Model (1Day)

• Tabular Model Concepts
• Tabular Model Concepts
• Comparison of Multidimensional and Tabular Models
• Tabular Model Implementation
• Fetching the Data
• Designing Data Model
• Introduction to DAX language (Data Analysis Expressions)

• تماس با IT HOUSE     آدرس: تهران، سهروردی شمالی،کوچه تهمتن، پلاک 6 واحد 7 تلفن:                                    88731466 21 (0) 98 + فکس:                                86031447 21 (0) 98 + وبسایت:                                  www.it-house.me ایمیل:                                    [email protected]

  • Demonstrate Using Excel Pivot Table
  • Implementing KPI
  • Implementing Hierarchy
  • Using Perspectives
  • Managing Data Warehouse
  • Elementary Partitioning
  • Elementary Processing
  • Deployment
  • Managing Security
  • Self Service BI (Power Pivot)
  • Self Service BI Concepts
  • Power Pivot Implementation Using Excel

  Reporting & Dashboard Design (1Day)

  • Configuring SSRS
  • Implementing Reports
  • Implementing Parameterized Reporting
  • Implementing Graphical Dashboard
  • Implementing Power View for Excel

  Elementary Data Mining (1Day)

  • Understanding Data Mining
  • Data mining in Excel using the Table Analyze Ribbon
  • Analyze Key Influencer
  • Detect Categories
  • Fill From Example
  • Forecasting
  • Highlight Exceptions
  • Scenario Analysis
  • Goal Seek
  • What-If
  • Prediction Calculator
  • Shopping Basket Analysis

  Data Mining Concepts

  • The Data Mining Process
  • Understanding Key Concepts
  • Attribute
  • State
  • Case
  • Keys
  • Inputs & Outputs

  Implementing Mining Structure

  • Implementing Case Table
  • Implementing Nested Table
  • Partitioning Sets

  Implementing Mining Model

  • Introduction to Data Mining Algorithms

  Browsing & Querying Mining Models

  • Using Mining Model Viewer
  • Elementary Prediction with Mining Model Predictions

  Data Mining Client in Excel using the Data Mining Ribbon