Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Delft University of Technology

Data Analysis: Take It to the MAX()

Delft University of Technology via edX

This course may be unavailable.

Overview

EX101x is for all of those struggling with data analysis. That crazy data collection from your boss? Megabytes of sensor data to analyze? Looking for a smart way visualize your data in order to make sense out of it? We’ve got you covered!

Using video lectures and hands-on exercises, we will teach you cutting-edge techniques and best practices that will boost your data analysis and visualization skills.

We will take a deep dive into data analysis with spreadsheets: PivotTables, VLOOKUPS, Named ranges, what-if analyses, making great graphs - all those will be covered in the first weeks of the course. After that, we will investigate the quality of the spreadsheet model, and especially how to make sure your spreadsheet remains error-free and robust.

Finally, once we have mastered spreadsheets, we will demonstrate other ways to store and analyze data. We will also look into how Python, a programming language, can help us with analyzing and manipulating data in spreadsheets.

EX101x is created using Excel 2013 and Windows. Most assignments can be made using another spreadsheet program and operating system as well, but we cannot offer full support for all configurations.

The goal of this course is to help you to overcome data analysis challenges in your work, research or studies. Therefore we encourage you to participate actively and to raise real data analysis problems that you face in our discussion forums.

LICENSE
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.

Taught by

Felienne Hermans

Reviews

3.6 rating, based on 12 Class Central reviews

Start your review of Data Analysis: Take It to the MAX()

  • The difficulty of the course, appropriate level and hours spent per week really varied between the first half and second half of the course. I really found the first half useful and interesting, while being challenging at the same time. Unfortunately, the second half of the course was not as well taught and the course became very frustrating.
  • The instructor, Felienne Hermans, is very a very enthusiastic and engaged teacher. Also the TA team was very involved in the discussion forum. I thought the format of the lectures, Felienne standing full size in the foreground and the spreadsheet in…
  • Fernando Martin
    Very disappointing course.

    I was interested in the programming techniques that the course offered by linking Python and Excel.
    I spent around 6-5 weeks watching videos about excel (functions, vlookup, etc..) and when the programming part arrived I just learned that you had to download a paid programme in order to follow programming part of the course.

    Even though there was a trial period to test the programme, the final goal of the course is to sell one product which from my point of view is totally opposite to open education's goals.
  • I wondered why so many people rated this course so low. There are some reasons that may explain, and one of which is the lack of clarity (or support maybe) for the 2 final weeks of the course where students are exposed to datanitro and neo4j database. But I think the team did their job pretty well in general, and the lecturer was also enthusiastic in every video lecture. I actually learned a lot of Excel (Google Spreadsheet actually since I don't have Excel) and thus became well-prepared for the Supply Chain Management Fundamentals taught by MIT (which I passed recently).
  • great course with a engaging and fun approach, useful to learn specific techniques, it also helps to show further possibilities
  • Aniket Shah
  • Nicole DeBonet
  • M S
  • Dennis B. Mendiola

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.