• LOGIN
  • No products in the cart.

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

4.9

4.9
8 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

15 STUDENTS ENROLLED
©2021 Edukite. All Rights Resereved
Edukite is A Part Of Ebrahim College, Charity Commission
Reg No 110841