- From www.edx.org
Análisis de datos: Diseño y Visualización de Tableros
- Self-paced
- Free Access
- Fee-based Certificate
- 6 Sequences
- Intermediate Level
- Субтитры доступны на English, Spanish
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.
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
L’université de technologie de Delft (en néerlandais : Technische Universiteit Delft), plus connue sous le nom de TU Delft est la plus ancienne et importante université publique des Pays-Bas.
Elle est implantée à Delft, aux Pays-Bas. Elle est positionnée dans le classement mondial des universités QS en 2022 parmi les 10 premières universités en ingénierie et technologie dans le monde. En architecture et génie civil, elle était classée 2e dans le monde, après le MIT (Massachusetts Institute of Technology)
Platform
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.
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