OTC CatchUp Dashboard

A Power BI/Google Studio dashboard analyzing OTC CatchUps.

File Contents

*
├───data
    ├───old summaries
        ─── *.md
    ├─── *.csv
├───scripts
    ├─── *.ipynb
├───results
└───

• data folder
  • Contains markdown files of CatchUp summaries starting from CatchUp #11 to CatchUp #53 with a few missing.
  • Final csv files used to make visualizations.
• OTC CatchUp summary scraper.ipynb - Code to scrape OTC catchup summaries from CatchUp #54 available on the OTC website.
• old otcs.ipynb - Code to extract relevant data from the summaries and saving it to old_otcs.csv.
• data cleaning.ipynb - Code to merge the csv files and get all the columns in the right format for visualization.

Results

• The first graph shows the duration of the sessions in descending order. OTC CatchUp #61 was the longest session which went on for 14.08 hours i.e. 14 hours 6 minutes
• The second graph displays the duration of the session as per the date of the session.
• The average duration of the sessions is found to be 7.65 hours i.e. 7 hours 39 minutes.
• The number of attendees v/s the number of session is plotted in the third graph.
• OTC CatchUp #62 was found to have most number of attendees with 43 attendess.
• The number of sessions attended and the number of projects showcased by a person can be viewed by applying the respective filters.

Note: The data regarding attendees consists of data from OTC CatchUp #54 to CatchUp #63 only.

Special mentions to Dheeraj Lalwani for providing the data for CatchUp #11 to CatchUp #53 summaries.

Some issues were faced while making the Power BI Dashboard public, therefore a static image of the report is presented. It can be found here

Same dashboard was recreated in Google Data Studio. It can be found here