The free online course named as “Data Analysis: Visualization and Dashboard Design” is provided by Delft University of Technology (DelftX). The course is aimed to learn about how to turn raw data into visual insights using Excel to help support business decisions. This course is part of the Data Analysis XSeries.
This course covers the main tasks required from data analysts today, including importing, summarizing, interpreting, analyzing and visualizing data. It aims to equip you with the tools that will enable you to be an independent data analyst.The course will starts on February 1, 2017.
Course At A Glance
- Length: 6 weeks
- Effort: 4-6 hours/week
- Subject: Data Analysis & Statistics
- Institution: Delft University of Technology (DelftX)
- Languages: English
- Price: Free-Self Paced
- Certificate Available:
- Session: The course will start on February 1, 2017
Providers Details
The Delft University of Technology is the largest and oldest technological university in the Netherlands. Their research is inspired by the desire to increase fundamental understanding, as well as by societal challenges. They encourage their students to be independent thinkers so they will become engineers capable of solving complex problems.Their students have chosen the Delft University of Technology because of our reputation for quality education and research.
Requirements
- High school basic mathematics concepts.
- They strongly recommend EX101xas a prerequisite for this MOOC, but learners with prior experience with spreadsheets will be able to follow the course as well.
About This Course
- The course providing you advanced techniques for robust data analysis in a business environment. Most techniques will be taught in Excel with add-ons and free tools available online. They encourage you to use your own data in this course but if not available, the course team can provide. The language of the course is English.
- Data analysis is important to businesses will be an understatement. In fact, no business can survive without analyzing available data. The importance of data analytics is truly amazing. It can make a business bigger and bigger. Having a small business is also a difficult task to handle and manage, but if you have the proper business tool being used, you can be sure enough that you can enhance your business in the right ways.
How to Join This Course
You should register yourself through the given link to join this free on-line course: https://courses.edx.org/register?course_id=course-v1%3ADelftX%2BEX102%2B1T2017&enrollment_action=enroll&email_opt_in=true
Course Format
Week 1: Importing Data (import)
Within a company, data is often stored in many different places, from a database to an ERP system to an attachment in an email. Sometimes you may even want to get data from the web, like information on the stock market or trending topics on Twitter. In this week they will show you how to get data ‘live’ into your spreadsheet. Never copy-paste again. Note: This week includes the use of a little VBA, and the Expector plugin.
Week 2: Power Up (analysis, visualization, design)
This week, they explore the power of PivotTables in more depth, by adding their own columns to PivotTables, and adding visual beauty with Pivot Charts and interactive slicers.
Week 3: PivotCharts (analysis, visualization)
In week 3, they will introduce spark lines and conditional formatting, to visualize the data immediately. Easy insights without the effort of making graphs.
Week 4: Decision Making (analysis)
The previous weeks concerned analyzing and visualizing existing data, but of course, you can use data to make decisions too. Week 4 talks about how to decide based on data. Predict a trend or figure out what happened when sales increase but demand would drop.
Week 5: Testing (analysis)
How to make sure your data is correct? they will use TU Delft plugin Expector to validate input and assumptions, so quality is guaranteed!
Week 6: Dashboard (Design)
Now you know different types of visualization, you can put it all together in a beautiful dashboard. You will create a dashboard based on real-time data of a specific domain.
Why Take This Course
- Advantage of course: If you have already sharpened your spreadsheet skills in EX101x Data Analysis: Take It to the MAX(), this course will help you dig deeper. You will learn advanced techniques for robust data analysis in a business environment. This course covers the main tasks required from data analysts today, including importing, summarizing, interpreting, analyzing and visualizing data.
- Certificate: You can buy a Verified Certificate for $70 to highlight the knowledge and skills you gain, Add the certificate to your CV or resume, or post it directly on LinkedIn
Learning Outcomes
In this course you will learn
- How to make data come to life with well-known types of visualizations such as line and bar graphs and new types of visualizations such as spark lines, contour plots and population pyramids.
- How to create dashboards in Excel based on live data that can meet managerial and business needs.
- How to connect data from different sources, such as the web and exports from your CRM, ERP, SAP or data warehouse.
- Some hands-on data science and how to use actionable analysis tools.
- Deep dive into known tools like PivotTables and introduce new ones like the analysis toolpak.
Instructors
Felienne Hermans: She 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.
Suggested Reading
High school basic mathematics concepts
You Might Also Be Interested In
You can also join Analyzing and Visualizing Data with Excel free online course.
Conclusion
- If you are looking to enhance your efficiency in the office and improve your performance by making sense of data faster and smarter, then this advanced data analysis course is for you.
- Receive an instructor-signed certificate with the institution’s logo to verify your achievement and increase your job prospects, add the certificate to your CV or resume.
Detailed Information
For more information about the course, you can check the given link:
https://www.edx.org/course/data-analysis-visualization-dashboard-delftx-ex102x-1#!
