Data analysis to the MAX()

开始时间: 04/22/2022 持续时间: 8 weeks

所在平台: EdxArchive

课程类别: 计算机科学

大学或机构: Delft University of Technology

授课老师: Felienne Hermans

课程主页: https://www.edx.org/archive/data-analysis-max-delftx-ex101x

课程评论:没有评论

第一个写评论        关注课程

课程详情

*Note - This is an Archived course*

EX101x is for all of those struggling with data analysis. That crazy spreadsheet 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 techniques and best practices that will boost your data analysis 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, 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 will be created using Excel 2013, but the course can be followed using another spreadsheet program as well.

The goal of this course is it 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. 

Want to stay up to date with the latest news on EX101x and behind the scenes footage? We have a Twitter account, @EX101x.

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.


This is a past/archived course. At this time, you can only explore this course in a self-paced fashion. Certain features of this course may not be active, but many people enjoy watching the videos and working with the materials. Make sure to check for reruns of this course.

课程大纲

  • 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
     

课程评论(0条)

课程标签

数据分析

1人关注该课程

主题相关的课程