Análisis de datos: Diseño y Visualización de Tableros

Análisis de datos: Diseño y Visualización de Tableros

Course
es
Spanish
Subtitles available
24 h
This content is rated 4.2 out of 5
Source
  • From www.edx.org
Conditions
  • Self-paced
  • Free Access
  • Fee-based Certificate
More info
  • 6 Sequences
  • Intermediate Level
  • Subtitles in English, Spanish

Their employees are learning daily with Edflex

  • Safran
  • Air France
  • TotalEnergies
  • Generali
Learn more

Course details

Syllabus

Week 1: Importing Data (import)Within a company, data is often stored in many different places, from a database to an ERP system to an attachment in an email. Sometimes you may even want to get data from the web, like information on the stock market or trending topics on Twitter. In this week we will show you how to get data ‘live’ into your spreadsheet. Never copy-paste again.Note: This week includes the use of a little VBA, and the Expector plugin.
 Week 2: Power Up (analysis, visualization, design)Now that we have some feeling for the data, we want to dive into analyzing deeper. This week, we explore the power of PivotTables in more depth, by adding our own columns to PivotTables, and adding visual beauty with PivotCharts and interactive slicers.Week 3: PivotCharts (analysis, visualization)In week 3, we will introduce spark lines and conditional formatting, to visualize the data immediately. Easy insights without the effort of making graphs.
 Week 4: Decision Making (analysis)The previous weeks concerned analyzing and visualizing existing data, but of course, we can use data to make decisions too. Week 4 talks about how to decide based on data. Predict a trend or figure out what happened when sales increase but demand would drop. Week 5: Testing (analysis)How to make sure your data is correct? We will use TU Delft plugin Expector to validate input and assumptions, so quality is guaranteed! Week 6: Dashboard (Design)Now we know different types of visualization, we can put it all together in a beautiful dashboard. We will create a dashboard based on real-time data of a specific domain.

Prerequisite

High school basic mathematics concepts.We strongly recommend  as a prerequisite for this MOOC, but learners with prior experience with spreadsheets will be able to follow the course as well.

Instructors

Felienne Hermans
Assistant Professor
Delft University of Technology

Editor

Delft University of Technology (in Dutch: Technische Universiteit Delft), better known as TU Delft, is the oldest and largest public university in the Netherlands. 

It is based in Delft, in the Netherlands. In the QS World University Rankings 2022, it is ranked among the top 10 engineering and technology universities in the world. In architecture and civil engineering, it was ranked 2nd in the world, after MIT (Massachusetts Institute of Technology).

Platform

Harvard University, the Massachusetts Institute of Technology, and the University of California, Berkeley, are just some of the schools that you have at your fingertips with EdX. Through massive open online courses (MOOCs) from the world's best universities, you can develop your knowledge in literature, math, history, food and nutrition, and more. These online classes are taught by highly-regarded experts in the field. If you take a class on computer science through Harvard, you may be taught by David J. Malan, a senior lecturer on computer science at Harvard University for the School of Engineering and Applied Sciences. But there's not just one professor - you have access to the entire teaching staff, allowing you to receive feedback on assignments straight from the experts. Pursue a Verified Certificate to document your achievements and use your coursework for job and school applications, promotions, and more. EdX also works with top universities to conduct research, allowing them to learn more about learning. Using their findings, edX is able to provide students with the best and most effective courses, constantly enhancing the student experience.

This content is rated 4.2 out of 5
(no review)
This content is rated 4.2 out of 5
(no review)
Complete this resource to write a review