Data Analysis: Take It to the MAX() - Delft University of Technology

edX
Online

Free

Important information

  • Course
  • Online
  • When:
    Flexible
Description

Enhance your data analysis skills using spreadsheets and data visualization. Increase your productivity and make better business decision.With this course you earn while you learn, you gain recognized qualifications, job specific skills and knowledge and this helps you stand out in the job market.

Important information

Requirements: Some experience in working with spreadsheets (with software such as Excel, OpenOffice Calc, Google Spreadsheets and etc.)

Venues

Where and when

Starts Location
Flexible
Online

What you'll learn on the course

Data analysis
Statistics
Mac
Business
Data

Course programme

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.  This course is part of the Data Analysis XSeries. 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.

Additional information

Felienne Hermans Felienne Hermans is an assistant professor at Delft University of Technology. Her team at the Spreadsheet Lab works on making spreadsheets better by designing tools to test and improve them.