Master's Degree in Continuing Education in Business Intelligence and Big Data
PRESENTATION
The Master's in Business Intelligence and Big Data is an advanced specialization for professionals seeking to lead data strategy and business decision-making. This program immerses you in the fundamentals and applications of business intelligence and the processing of large volumes of data—essential tools for agile and accurate decision-making in today’s business environment. You will explore state-of-the-art technology, from data governance to the implementation of transactional and informational systems—all essential for any large-scale data analysis project. You will develop the ability to design strategic plans and roadmaps, applying advanced methodologies to extract value from massive volumes of data. You will delve into relational databases, master SQL, and specialize in designing a robust data warehouse—key elements for building scalable and efficient data infrastructures. This master’s program equips you to assess the impact of your analyses, optimize operations, and anticipate market trends, thereby solidifying your role as an information architect capable of driving innovation and efficiency within your organization. You will acquire the ability to generate valuable insights about the market and customers—a fundamental asset for any company seeking to differentiate itself and maintain its competitiveness.
Objectives
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
- Time Series: Forecasting Methods
- Introduction
- Data Literacy
- Working with Data
- Data Processing Solutions and Techniques
- Data Quality Management
- Working with Data in Excel
- Dataset (DATASET)
- Data Cleaning with Excel
- Data Wrangling with Excel
- Data Blending in Excel
- Installing Talend Data Preparation Desktop
- Working with Data in Talend
- Data Cleansing with Talend
- Data Wrangling with Talend
- Data Blending with Talend
- Sign Up for Dataprep by Trifacta
- Working with Data Using Dataprep by Trifacta
- Data Cleansing with Trifacta
- Data Wrangling with Dataprep by Trifacta
- Data Blending with Dataprep by Trifacta
Featured Master's Programs
Master's Degree in Continuing Education in Human Resources Leadership and Strategic Management
Continuing Education Master's Degree in Virtual Reality Architect: Virtual Reality Architect
Take the next step in your career
Your training already counts. Now turn it into a college degree.