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.

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