Data Visualization

Introductory week to data visualization: what it is, where it comes from, what it is used for, why it is so important in the current setting. Types of visualizations and their most effective use.

General aspects of communication and visual perception, critical issues in the creation of visualizations and in the presentation of information, will also be discussed.

Index

• History of data visualization
• Data visualization basics
• Open Data
• Visualization types and tools
• Communicate your message effectively
• Visual perception

Specific objectives

• Learn the basics of visualization (problems to which it responds, real utility...)
• Learn the types of charts and when to use each one.
• Understand the visual problems of the graphs to know how to avoid them, or use them to reinforce the message

Power BI is one of the leading tools in the Business Intelligence sector and one of the most complete, with links to a multitude of data sources and very powerful data transformation and analysis possibilities, as well as dynamic dashboard generation capabilities. and very versatile.

In this module, the tool will be studied in depth, from the ingestion and basic treatment of data to the creation of reports and the most complex modeling to get the best performance out of Power BI.

All this will be done in a very practical way, with data sets and use cases so that the student understands first-hand the real utility of the tool and its options, and learns how to solve data problems with Power BI and extract information and value from large amounts of data with Power BI.

Index

• ETL process configuration
• Report creation
• Data modeling with DAX
• Report publishing and the Power BI service

Specific objectives

• Learn how to load data into Power BI and the necessary transformations to be able to generate useful dashboards with it.
• Learn about the most comprehensive data modeling options, which allow you to use very large volumes of data in Power BI.
• Perform complete exercises with real datasets in order to understand first-hand the usefulness of the tool.

Another of the great leaders in this sector, apart from Power BI, is Tableau. The experience with Power BI allows us to speed up with Tableau and focus on the differences it has with Power BI and the strengths of Tableau, and when it is more convenient to use the different options that each offers.

One of the great types of data is geographic data, and although the previous tools have some capabilities to work with them, this module also covers one of the most important tools for that scenario: CARTO. The tool will be thoroughly worked on by creating maps with real data and the analytical capabilities, and the most important use cases that CARTO enables will be explored.

Index

• Data transformation with Tableau
• Creating charts and dashboards with Tableau
• Creation of static and dynamic maps with CARTO
• Geographic analytics in CARTO

Specific objectives

• Learn how to load data into Tableau and the transformations required to generate useful dashboards.
• Know the main differences between Tableau, Power BI and other similar tools.
• Learn to load data into CARTO and generate static and dynamic maps
• Know the types of geographic analytics available and their possible uses

In order to consolidate everything learned, from the more theoretical part to the use of the tools, part of this module is dedicated to carrying out a slightly more complete data exercise, in which the student will have to apply, according to their criteria, the analytics and visualization techniques learned that are necessary to solve the project that is proposed.

In addition, in this module, renowned professionals from the Big Data and Business Intelligence sector will present real use cases in companies, which will allow the student to see possible outputs and applications of the content learned in the course.

Index

• Visualization project
• Use case: People Analytics
• Big Data at Telefónica: analysis of business communications
• Big Data at Telefónica: IoT - vehicle fleets
• Use Case: Outliers Collective
• More Big Data use cases to be determined

Specific objectives

• Carry out a complete data project, from data acquisition, to cleaning, transformation and visualization, with one of the tools studied.
• Know use cases in important companies in the sector, to understand possible outputs and the power of what has been studied in the business environment.