In this course, students 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. It aims to equip with the tools that will enable students to be an independent data analyst and how to create dashboards in Excel based on live data.
Assessment
This course does not involve any written exams. Students need to answer 5 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work.
Certification
Edukite courses are free to study. To successfully complete a course you must submit all the assignment of the course as part of the assessment. Upon successful completion of a course, you can choose to make your achievement formal by obtaining your Certificate at a cost of £49.
Having an Official Edukite Certification is a great way to celebrate and share your success. You can:
- Add the certificate to your CV or resume and brighten up your career
- Show it to prove your success
Course Credit: TU Delft
Course Curriculum
Module: 01 | |||
Introduction Data Analysis: Visualization and Dashboard Design | 00:02:00 | ||
1.2 Copy paste | 00:02:00 | ||
1.3 Load from file | 00:03:00 | ||
1.5 Combine script | 00:02:00 | ||
1.6 a Data types | 00:06:00 | ||
1.6 b Data types | 00:06:00 | ||
Module: 02 | |||
2.1 Introduction Data Exploration | 00:02:00 | ||
2.2 Pivot Tables and Charts | 00:02:00 | ||
2.3 Pivot Charts Continued | 00:01:00 | ||
2.4 Power Pivot | 00:03:00 | ||
Module: 03 | |||
3.1 Introduction to Trends | 00:01:00 | ||
3.2 Conditional formatting | 00:03:00 | ||
3.3 Spark lines | 00:02:00 | ||
3.4 Trend plotting | 00:03:00 | ||
Module: 04 | |||
4.1 Introduction: Goal seek and solver | 00:01:00 | ||
4.2 Goal seek | 00:04:00 | ||
4.3 Profit | 00:03:00 | ||
4.4 Data Table | 00:02:00 | ||
4.5 Solver | 00:04:00 | ||
Module: 05 | |||
5.1 Introduction Data Analysis | 00:01:00 | ||
5.2 Show me the numbers | 00:07:00 | ||
5.2.2 Show me the numbers | 00:07:00 | ||
5.3 Table Design: Structural Design | 00:05:00 | ||
5.4 Table design: Best Practices | 00:07:00 | ||
5.7.2 The downside of fast fashion | 00:02:00 | ||
5.6 Graph Design: Best Practise | 00:09:00 | ||
Module: 06 | |||
6.1 Dashboard Design | 00:02:00 | ||
6.2 Dashboard Overview | 00:05:00 | ||
6.3 Bar Chart | 00:07:00 | ||
6.4 Column Chart | 00:07:00 | ||
6.5 Mixed Chart Type | 00:06:00 | ||
6.6 Thermometer Chart | 00:07:00 | ||
6.8 profit & Loss Table | 00:05:00 | ||
6.9 Sparklines | 00:06:00 | ||
6.10 bonus: slider | 00:04:00 | ||
6.11 Bonus: automatic refresh | 00:08:00 | ||
Assessment | |||
Submit Your Assignment | 00:00:00 | ||
Certification | 00:00:00 |
Course Reviews
No Reviews found for this course.