Business Intelligence (BI)

از جمله اصلی ترین اهداف این دوره ی آموزشی راه اندازي سیستم هاي BI و ساخت داشبوردهاي مدیریتی برای سازمان ها می باشد.

ندارد.

این دوره برای تمامی افراد ذیل جذاب می باشد. این افراد شامل موارد ذیل هستند:

• مدیران ارشد
• تحلیل گران داده
• مدیران فناوری اطلاعات
• مدیران طرح و برنامه

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)
• 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

دردوره هاي Non-Accredit شركت كنندگان در دوره هاي آموزشي ازسوي مرجع اعتبار دهی
IT HOUSE  تحت اعتبار شرکت PECB کانادا گواهي حضوردردوره ي آموزشي دريافت خواهند نمود

تماس بگیرید

ندارد.