Visualizing Data with Efficient Dashboards

A picture is worth a thousand words and... data itself!

However, it's essential to select illustrations carefully, considering the types of variables and the researcher's objectives.

This workshop will cover various types of charts and how to structure them into an attractive dashboard. It will compare different possibilities using common proprietary tools such as Excel, Power BI, and Tableau, as well as open-source tools like Python and two of its charting libraries: Matplotlib and Seaborn.

Workshop Overview

Learning Outcomes

• Translate any case study into a comprehensive database.

• Learn to create various types of tables including counts/frequencies and percentages.

• Understand the importance and effectiveness of using graphs.

• Present data in an innovative and efficient manner.

• Compare the usage of Excel, Power BI, and Tableau with Python.

• Interpret charts accurately.

• Gain knowledge of the basics of color harmony.

• Introduction to Creating Infographics.

• Mastering related AI prompt engineering.

Detailed Course Schedule

• Day 1:

  • Designing Efficient Data Sets and Pivot Tables for Excel charting

• Day 2:

  • Pies

  • Doughnuts

  • Bars

  • Histograms

  • Waterfall

• Day 3:

  • Illustrating data with Power BI and Tableau

• Day 4:

  • AI prompting for automated Python coding with DALL-E and Julius

• Comprehensive colored PPT booklet

• The multiple ways of generating charts

• Group applications with adequate software

• Pivot Tables

• 360 exploration of data representation

• Case studies from A to Z complete

• Proprietary tools for data visualization

• Open-source tools for data visualization

• Infographics

What will it be about?