Business Intelligence

Business Intelligence Course

Course contents

This course is taught online and consists of 3 units plus guided practices. The approximate duration of the course is 40 hours distributed between the course content and collaboration tools and upon completion, the student will receive an accrediting diploma. The training is carried out through our Virtual Campus, with this modality you will have all the didactic content on the course platform and it will be accessible, from the start day of the course, 24 hours a day, every day of the week. The student will also have participation forums, as well as continuous tutoring.


Index

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. ARCHITECTURE OF A BUSINESS INTELLIGENCE PROJECT

  • Extraction, Transformation and Loading Processes.
  • The Data warehouse.
  • Visualization and consultation tools: Reports.
  • Visualization and consultation tools: DashBoards.
  • Visualization and consultation tools: OLAP.
  • Visualization and consultation tools: Data Mining.
  • ETL processes.
  • Creation of multidimensional cubes.

Guided practices

  • Practice 1. View 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.

Previous requirements

No prior technical requirements are necessary to take this course. However, basic computer skills and knowledge of environments related to Information Technology are recommended.

Average access duration for a participant without any knowledge: 50 hours

Access allowed: For 8 weeks.

€295.00
| /

Información relacionada a la formación

Soporte siempre a tu lado

Soporte de formación: Siempre a tu lado

Formación presencial y telepresencial

¿Necesitas otra modalidad formativa?

bonificaciones

Bonificaciones para empresas