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.
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 background was less ideal: sometime it was difficult to see which commands were typed or which buttons clicked. My main criticism is the lack of graded exercises in the course. One learns a software tool by doing and in such the course did not entirely succeed: the graded tests were very minimalistic (small in size and not very challenging; some "challenge" questions were ungraded). Compare e.g. with MIT's Analytic Edge, which does a much better job in this respect. If you have worked with Excel but want to learn some neat tricks, it is an OK course though, where you certainly will learn some new things.
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.
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).
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.