Here is the class outline:
|
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
|
Facebook analysis information
|
Google play apps
|
Exercise
|
|
|
Week 3 - Data Warehouse: Design and ETL Processes
|
News - BBVA, digital business
|
Create dashboard
|
|
|
Week 4 - OLAP: Design and Analysis
|
Excel Tutorial
|
Data Handling with Excel
|
|
|
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
|
Taxi companies analysis
|
|
|
Week 8 - Power BI Reports: Case Study
|
Old recordings
|
Games investment analysis
|
Flights Delay
|
Customer & Product Analysis
|
crime analysis
|
|
|
Week 9 - Dashboards
|
Trading analysis
|
Black Friday Sales Dashboard
|
football
|
|
|
Weeks 10 and 11 - Power BI Dashboard
|
Old recordings
|
Exam simulation
|
moscow mortatility
|
|
|
Week 12 - Power BI Dashboard: Case Study
|
old recording
|
Income/Revenue analysis dataset
|
Cryptocurrencies value: normal distribution analysis
|
|
|
Week 13 - Balanced Scoreboard
|
Web crawling
|
Price simulation
|
Smart city
|
|
|
Week 14 - Recapitulation, Remarks, Doubts
|
tableau
|
|