________________________________________________________________
Do you want to take this course remotely or in person?
Contact us by email: info@nanforiberica.com , phone: +34 91 031 66 78, WhatsApp: +34 685 60 05 91 , or contact Our Offices
________________________________________________________________
Course Description: Business Intelligence
This course is taught in online mode and consists of 3 units and guided practices .
The duration of the course is 50 hours which is distributed between content and collaboration tools. Upon completion, the student will receive a certificate of completion.
Training is done through our Virtual Campus : with this option you will have access to all the educational content on the course platform and it will be accessible, from the start of the course, 24 hours a day, 7 days a week. Students will also have access to participation forums, as well as continuous tutoring.
The course fee applies to the virtual mode (100% bonus option) In-person and remote training actions can be carried out on demand.
Course content
Unit 1. BUSINESS INTELLIGENCE
- Introduction.
- The organizational pyramid.
- Business intelligence tools.
- Datawarehouse Fundamentals.
- Characteristics.
- Advantages.
- OLTP systems.
- Datawarehouse Implementation.
- OLAP Analysis (Drill Down, Drill Up).
- OLAP servers (ROLAP, MOLAP, HOLAP, Data Mining, Data Mining Definitions).
- Data Mining Categories.
- Data Mining Process.
- Methodology.
- Reports.
- Consultations.
- Alerts.
- Analysis.
- Forecasts.
Unit 2. BUSINESS INTELLIGENCE PROJECT MANAGEMENT
- Project management.
- Project planning.
- Risks.
Unit 3. BUSINESS INTELLIGENCE PROJECT ARCHITECTURE
- Extraction, Transformation and Loading Processes.
- The Data Warehouse.
- Visualization and query tools: Reports.
- Visualization and query tools: Dashboards.
- Visualization and query tools: OLAP.
- Visualization and query tools: Data Mining.
- ETL processes.
- Creating multidimensional cubes.
Guided practices
- Practice 1. Visualizing a data model from SQL Analysis Services
- Practice 2. How to build a cube from scratch using SQL Server Analysis Services (SSAS)
Final evaluation
Quality Questionnaire
Prerequisites
There are no technical prerequisites required to take this course. However, basic computer skills and knowledge of environments related to Information Technology are recommended.
