This course 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.
This course 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.
- Overcome data analysis challenges in your work and research
- Increase your productivity and make better business decisions
- Enhance your data analysis skills using spreadsheets
- Learn about advanced spreadsheet possibilities like array formulas and pivottables
- Learn about Excel 2013 features like PowerPivot & PowerMap
- Learn to organize and test your spreadsheets
The course materials used in this MOOC are available on TU Delft OpenCourseWare and can be viewed and downloaded for free. If you enrol for the MOOC, you will be introduced to up to date techniques in web lectures and webinars. Also you will apply each technique to a case with fellow learners. Ultimately, the combination of these techniques provides a coherent analysis of the problem. If you want to enrol, go to https://online-learning.tudelft.nl/courses/data-analysis-to-the-max/ to learn when the next run will start
- 1. Intro and Conditionals
- 2. Lookup and search
- 3. Pivot tables and Powermap
- 4. Structure and Named Ranges
- 5. Array Formulas and Structure
- 6. Testing
- 7. Alternatives Python
- 8. Alternatives Neo4J
- Additional Concepts of MOSFETs
- Background Knowledge
- Basic MOS Capacitor and MOSFET
- Course Overview
- Heterojunctions and HBTs
- Photonic Devices
- Advanced Device Physics
Data Analysis: Take it to the Max by TU Delft OpenCourseWare is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Based on a work at https://ocw.tudelft.nl/courses/data-analysis-take-it-to-the-max/.