دوره‌های آموزشی

دوره‌های آموزشی داتسا، نگاهی کارآمد به مباحث

Create and modify Oracle Business Intelligence analyses
Use hierarchical columns in analyses and views
Perform administration tasks related to the development and configuration of dashboards
Build and use views and graphs in analyses
Combine analysis criteria using set operations and execute direct database requests
Perform pre- and post-aggregate filtering using filters, groups, and selections
Add geographical mapping to analyses
Use Oracle Business Intelligence Mobile to view BI content on a mobile device
Create and modify dashboards
Use Oracle BI for Microsoft Office to integrate Oracle BI analysis and dashboard content
Configure Agents using Delivers to get the results of analyses and deliver them to subscribers

Model partitions and fragments to improve application performance and usability
Use variables to streamline administrative tasks and modify metadata content dynamically
Use time series functions to support historical time comparison analyses
Set up security to authenticate users and assign appropriate permissions and privileges
Apply cache management techniques to maintain and enhance query performance
Set up query logging for testing and debugging
Set up a multiuser development environment
Use the Administration Tool wizards and utilities to manage, maintain, and enchance repositories
Enable usage tracking to track queries and database usage, and improve query performance
Perform a patch merge in a development-to-production scenario
Use Business Application Archive (BAR) files to move Oracle BI between environments
Build the Physical, Business Model and Mapping, and Presentation layers of a repository
Build and run analyses to test and validate a repository
Build simple and calculated measures for a fact table
Create logical dimension hierarchies and level-based measures
Check the model and then model aggregate tables to speed query processing

Define the terminology and explain the basic concepts of data warehousing
Describe methods and tools for extracting, transforming, and loading data
Identify some of the tools for accessing and analyzing warehouse data
Identify the technology and some of the tools from Oracle to implement a successful data warehouse
Define the decision support purpose and end goal of a data warehouse
Describe the benefits of partitioning, parallel operations, materialized views, and query rewrite in a data warehouse
Explain the implementation and organizational issues surrounding a data warehouse project
Use materialized views and query rewrite to improve the data warehouse performance
Develop familiarity with some of the technologies required to implement a data warehouse

Explain basic data mining concepts and describe the benefits of predictive analysis
Understand primary data mining tasks, and describe the key steps of a data mining process
Use the Oracle Data Miner to build, evaluate, and apply multiple data mining models
Use Oracle Data Mining's predictions and insights to address many kinds of business problems, including: Predict
individual behavior, Predict values, Find co-occurring events
Learn how to deploy data mining results for real-time access by end-users

Describe ODI Model concepts
Describe architecture of Oracle Data Integrator 12c
Apply ODI Topology concepts for data integration
Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations
Explore, audit data, and enforce data quality with ODI
Administer ODI resources and setup security with ODI
Implement Changed Data Capture with ODI
Use ODI Web services and perform integration of ODI with SOA

پیش ثبت نام دوره‌های آموزشی