Skip to content
Fall semester - BA - IBM - Year 4 Calendar view

Business intelligence and Decision-Making (Core 10 ECTS)


Class
Eduardo Rivera
No access code required
Enrol

Lessons

Here is the class outline:

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
Create dashboard

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
Old recordings

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
Old recordings
Games investment analysis
Flights Delay
Customer & Product Analysis
crime 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
Old recordings
Exam simulation
moscow mortatility

Week 12 - Power BI Dashboard: Case Study

Week 12 - Power BI Dashboard: Case Study
old recording
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
tableau