Skip to content
MA (2 years) International Relations Calendar view

Advanced Data Visualization and Decision-Making


Class
Eugenio Clavijo
No access code required
Enrol

Lessons

Here is the class outline:

Join the class online

Meeting

Week 1 - Introduction to Business Intelligence

Week 1 - Introduction to Business Intelligence
Exercise 1: Understanding data
Exercise 2: Study case
solution exercise 1
First Dashboard
First questions to solve in first Assignment

Week 2 - Data Sources. Data Warehouse, OLAP, Metadata

Week 2 - Data Sources. Data Warehouse, OLAP, Metadata
Facebook analysis information
Google play apps
Exercise

Week 3 - Data Warehouse: Design and ETL Processes

Week 3 - Data Warehouse: Design and ETL Processes
News - BBVA, digital business

Week 4 - OLAP: Design and Analysis

Week 4 - OLAP: Design and Analysis
Excel Tutorial
Data Handling with Excel

Week 5 - Reports in Business Intelligence

Week 5 - Reports in Business Intelligence
E-commerce
Trend line and forecast
News - New kinds of work

Weeks 6 and 7 - : Power BI Reports

Weeks 6 and 7 - : Power BI Reports
Taxi companies analysis

Week 8 - Power BI Reports: Case Study

Week 8 - Power BI Reports: Case Study
Games investment analysis
Customer & Product Analysis

Week 9 - Dashboards

Week 9 - Dashboards
Trading analysis
Black Friday Sales Dashboard
football

Weeks 10 and 11 - Power BI Dashboard

Weeks 10 and 11 - Power BI Dashboard
Exam simulation

Week 12 - Power BI Dashboard: Case Study

Week 12 - Power BI Dashboard: Case Study
Income/Revenue analysis dataset
Cryptocurrencies value: normal distribution analysis

Week 13 - Balanced Scoreboard

Week 13 - Balanced Scoreboard
Web crawling
Price simulation
Smart city

Week 14 - Recapitulation, Remarks, Doubts

Week 14 - Recapitulation, Remarks, Doubts