• Lead the implementation of data initiatives, from conceptualization to delivery, incorporating the principles of digital transformation. • Develop information governance strategies that ensure the quality, security, and accessibility of information in complex environments. • Evaluate technological innovations in the processing of massive volumes of information and business intelligence for decision-making. • Manage the architecture of transactional and informational systems, optimizing the collection and processing of corporate data. • Develop strategic plans and roadmaps based on advanced business intelligence methodologies to foster innovation. • Master the design and construction of robust data warehouses, using relational databases and SQL for efficient management. • Analyze the impact of business intelligence solutions on operational optimization and the anticipation of market trends. • Generate valuable insights about the market and customers to drive business differentiation and growth.
Methodology
At Educa PHAROS, we use a highly practical methodology focused on the direct application of knowledge in the student’s professional environment, combining theoretical content with real-world cases, digital tools, and support from a team of specialized instructors.
Program
Introduction to Big Data
Data as an Asset
Technological Enablers
Key Concepts in Big Data
Big Data vs. Business Intelligence
Elements of a Big Data Architecture
What are IaaS, PaaS, and SaaS?
Open Source Technologies
Public Cloud and Private Cloud
Visualization Tools
What Digital Transformation Is and Isn't
Customer-Centric
The Role of Technology as an Enabler
Use Case: User Experience
Use Case: People Analytics
Data Governance and Data Quality
Data Strategy
GDPR and Privacy
How to Become a Data-Driven Company
Planning a Data Project
Introduction
The Need for a Business Intelligence System
Benefits of a Business Intelligence System
Data, Information, and Knowledge
Data Transformation Model
Introduction to Business Systems
Transactional Systems and Their Characteristics in Today's World
Information Systems
Other Models for Classifying Information Systems
BI Systems in Companies
The Need to Establish a Plan and Measure Its Progress
Master Plan, Strategic Plan, and Operational Plan
Strategic Maps
The Balanced Scorecard
Key Performance Indicators (KPIs)
Introduction to Business Plan Methodologies
The 10 Keys to Developing a Business Case
Canvas Methodology
SWOT Analysis
The Importance of Data-Driven Decision Making
Introduction to SQL
Database Management
Data Types
Standardization
Creating Tables in SQL
Working with Tables
Querying Tables in SQL
Joining Tables in SQL
Combinations of Tables and Views
Other SQL Commands
Functions for Strings and Numeric Functions (I)
Numerical Functions (II)
Date and Time Functions
Other features
Loops, Conditionals, and Triggers in SQL
Introduction to Data Warehousing
Databases in a Data Warehouse. Stage
Databases in a Data Warehouse: ODS (I)
Data in a Data Warehouse. ODS (II)
Databases in a Data Warehouse. DDS
Concepts of NoSQL Databases
Advantages and Disadvantages of NoSQL Databases
Key Features of NoSQL Databases
Document Databases
Column Databases
Key-Value Databases
Graph Database
Introduction to MongoDB
MongoDB Features and Architecture
Data Modeling in MongoDB
Queries and Operations in MongoDB
Scalability and Performance in MongoDB
Apache Cassandra
CouchDB
Redis
Amazon DynamoDB
NeoJS
Data Structure Design
Setting Up the Development Environment
Installing and Configuring MongoDB
Creating and Manipulating Collections in MongoDB
Importing and Exporting Data in MongoDB
Indexes and Query Optimization in MongoDB
Data Aggregation in MongoDB
Transactions in MongoDB
Replication and High Availability in MongoDB
Backups and Recovery in MongoDB
Web and Mobile Apps
Big Data and Data Analysis
Internet of Things (IoT)
Recommendation Systems
Social media and social networks
Introduction to Data Integration
Integration with programming languages (Python, Java, etc.)
Integration with Business Intelligence (BI) Tools
Integration with cloud storage systems
Security Concepts in NoSQL Databases
Authentication and Authorization in MongoDB
Data Encryption in NoSQL Databases
Auditing and Access Control in NoSQL Databases
Information Systems
Introduction to BI
Business Intelligence Phases
Business Intelligence Users
History and Future of BI
BI System Operations
Using Qlik I
Qlik II Tool Guide II
Power BI Tool Management I
Power BI Tool Management II
Introduction to KPIs and the Balanced Scorecard
Basic Visualization Theory
Advanced Visualization Theory
Complete QlikView BI Project I
Complete QlikView BI Project II
Introduction to ETL
ETL Tools
ETL Process Components
ETL Microsoft SSIS
ETL Tools Comparison
References
Introduction and Data Trends
Relational Databases
Relational Databases II
NoSQL Databases
SQL vs. NoSQL Comparison
Data Organization Models
Columnar Databases
Optimize Database Queries
Optimizing Database Queries II
Designing a Relational Database
Data warehouse
Inmon vs. Kimbal
Mine Data from the DWH
Data mart
Amazon Redshift
Introduction to Power BI
Different Types of Power BI: Is It Really Free?
Let's dive right in: First Simple Report
Power Query: Data Source
Data Transformation
Data Modeling
Getting Started with DAX (I)
Getting Started with DAX (II)
Mastering the DAX (I)
Mastering the DAX (II)
Table and Matrix
Trends
How to Filter Your Data Properly
Bookmarks
Obtaining Details
Understanding the Power BI Service
Sharing Content in Power BI Service
Comparing Power BI Service and Power Report Service
Integrating Python and R into Power BI Desktop
Introducing Bravo for Power BI Desktop
Probability Distributions
Hypothesis Testing and Confidence Intervals
Data Preparation and Descriptive Analysis
Analysis of Missing Values and Outliers
Case Study: Data Preprocessing and Statistical Inference
Simple Linear Regression
Multiple Linear Regression
Generalized Linear Models (GLM)
Regression Trees
Case Study: Building and Evaluating Regression Models
Binary Logistic Regression
Multinomial Logistic Regression
Classification Trees
Random Forest
Case Study: Building and Evaluating Classification Models
Principal Component Analysis (PCA)
Classification: Discriminant Analysis
Classification: K-means
Time Series: Smoothing Methods and Temporal Decomposition
Educa PHAROS is a training solution for businesses that centralizes learning, simplifies user management, and allows you to track progress through dashboards and reports.
It is designed for organizations that want to develop internal skills, standardize role-based training, and have traceability and learning metrics.
It includes learning paths by profile, user and permission management, progress reports, certification, and access to masterclasses or live sessions (depending on the plan).
It is based on best practices in security, access control, learning traceability, and implementation support. Customize this text according to your commitments (SLA, compliance, etc.).
Educa PHAROS is a next-generation training model that places a company’s human capital at the forefront. Through a platform that adapts to each company’s corporate identity and offers a total of more than 900 courses, it provides tailored training for each organization. The unlimited flat-rate plan provides each company with the number of courses that best suits its needs, as well as the ability to determine which employees will have access.
Download the master's program brochure
Enter your information, and we'll give you instant access to the full PDF.
Digital Transformation and Smart Infrastructure 
Spanish 
Credits: 60 ECTS
Industry, Energy, and the Environment 
English
60 ECTS