Data Visualisation principals and Practice in under one Hour

Focused View

Manish Gupta

1:04:10

80 View

1. Introduction to the course

1. Introduction to the course.mp4

04:14

2. Data Visualisation Process in Excel.mp4

02:37

3. Process of Data Visualisation.mp4

08:12

4. Key Principals of Data Visualisation.mp4

04:32

5. Formatting principals (Color).mp4

00:37

6. Formatting Principals (Clarity).mp4

00:35

7. Examples of Good Charts.mp4

01:09

8. Examples of Bad Charts.mp4

01:14

9. Examples of Ugly Charts.mp4

02:22

2. Common Charts used for Data Visualisation and their limitations

1. Bar and Column Charts.mp4

07:50

2. Bar Chart Example and Practice.mp4

11:32

3. Area Charts Principals.mp4

03:19

4. Stacked Area Charts.mp4

01:21

5. Geographical Charts.mp4

00:26

6. Line Chart.mp4

02:14

7. Line Chart - Inserting trendline.mp4

01:24

8. HistoGram and Pereto Charts.mp4

01:27

9. Pie and Donut Charts.mp4

02:40

10. LImitations of Pie Charts and Donut charts.mp4

01:23

11. Scatter Plot Charts.mp4

01:27

12. Treemap and Suburst Charts.mp4

02:43

13. Waterfall Charts.mp4

00:52

Description

Learn Quick Principals, limitations and benefits of data visualisation principals for most used charts in just an hour

What You'll Learn?

Principals of Data Visuation
When to use and not to use key Charts
Sample how to create these charts
practical problems

Who is this for?

finance professionals who need to learn basics of data visualisation

What You Need to Know?

Basic understanding of excel

More details

Description
Data visualization is a crucial skill for professionals working with data in various fields, and Excel provides a powerful platform for creating visually appealing and informative charts. In this comprehensive course, we will dive deep into the world of data visualization using Excel charts, covering a wide range of chart types, including bar charts, line charts, pie charts, histograms, treemaps, and more.
Throughout the course, you will learn the fundamental principles of data visualization and how to effectively represent data using different chart types. We will explore the purposes and use cases of each chart type, helping you understand when to utilize a specific chart to showcase different types of data, such as comparing values, identifying trends over time, displaying proportions, or analyzing distribution patterns.
You will gain hands-on experience in creating, customizing, and formatting various charts using Excel's intuitive interface. We will cover essential techniques for enhancing the visual impact of your charts by applying appropriate color schemes, labels, legends, and annotations. Moreover, we will delve into advanced features like adding trendlines, error bars, and data labels to provide deeper insights into your data.
Additionally, we will discuss best practices for effective data visualization, including principles of design, data storytelling, and ensuring clarity and accuracy in presenting information. You will also learn how to create interactive dashboards using slicers and sparklines, allowing you to filter and dynamically update your charts based on user inputs.
By the end of this course, you will have a solid foundation in data visualization using Excel charts, enabling you to confidently present your data in visually compelling ways. Whether you are a business analyst, financial professional, researcher, or data enthusiast, this course will equip you with the skills and knowledge to transform raw data into impactful visual representations that drive understanding and decision-making.
Who this course is for:
finance professionals who need to learn basics of data visualisation

User Reviews

Rating

average 0

Total votes0

Focused display

PROFILE & STRENGTHS Mr Manish Gupta is an experienced hospitality finance professional, having a blend of financial core expertise with hands-on training in managing hotel operations and business development.Having worked as an Auditor for 7 years, he moved into finance management for brands like Parsvnath Developers and Shangri-La Hotels & Resorts and currently serving as the CFO of HTOO Hospitality.His role is to spread the finance function for the largest hospitality in Myanmar owned and managed by one of the biggest business houses in Myanmar. They have 16 operational and underdevelopment High-end boutique resorts (covering an overall room inventory of 800+ rooms), 2,000 employees. Most of the properties are leaders in their region on trip advisor and won various travel awards over a period of time.He has proven experience in setting up the foundation for sustainable growth (in the form of management information systems, restructuring), ERP implementation, gear towards IPO readiness & IFRS convergence. With such a great skill set, the students can be assured about the quality of training with his expertise.He has been teaching at various institutions in Myanmar such as Swiss Business School, American Hospitality Institute of Myanmar with students ranging from directors to CEO of various companies.ACADEMIC & PROFESSIONAL CREDENTIALS Chartered Accountant – 2005 (Member of the ICAI) form Institute of Chartered Accountant of India Company Secretary – 2005 from Institute of Company Secretaries of India DISA (Diploma in Information System Audit) Supervisory Excellence (Online) & Business Leadership form e-Cornell University Strategic Leadership from Shangri-La Global University

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.