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

Online Course

Data Analysis: Take It to the MAX()

Delft University of Technology via edX

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

Related Courses

Reviews

3.4 rating, based on 13 reviews

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

  • Bart completed this course, spending 2 hours a week on it and found the course difficulty to be medium.

    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 the...
  • Fernando Martin

    Fernando Martin completed this course, spending 2 hours a week on it and found the course difficulty to be easy.

    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.
  • Thong Buu Tran completed this course, spending 5 hours a week on it and found the course difficulty to be medium.

    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).
  • Adelyne Chan completed this course, spending 6 hours a week on it and found the course difficulty to be medium.

    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.
  • Raja Ali is taking this course right now.

    is there video Lectures available for This course???
    if they are then any one can please wrote the link in comment box
  • Miguel completed this course, spending 4 hours a week on it and found the course difficulty to be medium.

    great course with a engaging and fun approach, useful to learn specific techniques, it also helps to show further possibilities
  • Aniket Shah completed this course.

  • Matteo Ferrara completed this course.

  • Nicole DeBonet completed this course.

  • M S

    M S is taking this course right now.

  • Ashlynn Pai completed this course.

  • Dennis B. Mendiola

    Dennis B. Mendiola completed this course.

  • Ty Hayles is taking this course right now.

Never stop learning Never Stop Learning!

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

Sign up for free