Data Analysis: Visualization and Dashboard Design
list 6 séquences
assignment Niveau : Intermédiaire
chat_bubble_outline Langue : Anglais
card_giftcard 18 points
Envie de partager ce MOOC dans votre entreprise ?
My Mooc
For Business
- /5
Avis de la communauté
0 avis

Les infos clés

credit_card Formation gratuite
verified_user Certification payante
timer 24 heures de cours

En résumé

Struggling with data at work? Wasting valuable time working in multiple spreadsheets to gain an overview of your business? Find it hard to gain sharp insights from piles of data on your desktop?

If you are looking to enhance your efficiency in the office and improve your performance by making sense of data faster and smarter, then this advanced data analysis course is for you.

If you have already sharpened your spreadsheet skills in EX101x Data Analysis: Take It to the MAX(), this course will help you dig deeper. You will learn advanced techniques for robust data analysis in a business environment. This course covers the main tasks required from data analysts today, including importing, summarizing, interpreting, analyzing and visualizing data. It aims to equip you with the tools that will enable you to be an independent data analyst. Most techniques will be taught in Excel with add-ons and free tools available online. We encourage you to use your own data in this course but if not available, the course team can provide.

This course is part of the Data Analysis XSeries.


The course materials of this course are Copyright Delft University of Technology and are licensed under a Creative Commons Attribution-NonCommercial-ShareAlike (CC-BY-NC-SA) 4.0 International License.

  • How to make data come to life with well-known types of visualizations such as line and bar graphs and new types of visualizations such as spark lines, contour plots and population pyramids.
  • How to create dashboards in Excel based on live data that can meet managerial and business needs.
  • How to connect data from different sources, such as the web and exports from your CRM, ERP, SAP or data warehouse.
  • Some hands-on data science and how to use actionable analysis tools.
  • Deep dive into known tools like PivotTables and introduce new ones like the analysis toolpak.

more_horiz Lire plus
more_horiz Lire moins

Les prérequis

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


Le programme

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.

Les intervenants

Felienne Hermans
Assistant Professor
Delft University of Technology


Le concepteur

Delft University of Technology

La plateforme

EdX est une plateforme d'apprentissage en ligne (dite FLOT ou MOOC). Elle héberge et met gratuitement à disposition des cours en ligne de niveau universitaire à travers le monde entier. Elle mène également des recherches sur l'apprentissage en ligne et la façon dont les utilisateurs utilisent celle-ci. Elle est à but non lucratif et la plateforme utilise un logiciel open source.

EdX a été fondée par le Massachusetts Institute of Technology et par l'université Harvard en mai 2012. En 2014, environ 50 écoles, associations et organisations internationales offrent ou projettent d'offrir des cours sur EdX. En juillet 2014, elle avait plus de 2,5 millions d'utilisateurs suivant plus de 200 cours en ligne.

Les deux universités américaines qui financent la plateforme ont investi 60 millions USD dans son développement. La plateforme France Université Numérique utilise la technologie openedX, supportée par Google.

Vous êtes le concepteur de ce MOOC ?
Quelle note donnez-vous à cette ressource ?