RunQL Challenge

RunQL Outline The dataset we worked with had records of investment transactions from 2019-2024 on a quarterly basis, capturing key details such as investment size, funding rounds, investor participation, industry distribution, and regional trends. It provides insights into how investment behaviors have evolved over time, which sectors attract the most funding, and how different regions contribute to the overall funding landscape. To ensure data integrity and accuracy, we had to transform the data we were given in the following manner: Duplicate values were removed to prevent under counting deals in similar industries Null and missing values were removed, as minimal analysis could be done Typos from data were corrected Data cleaning was conducted using Power Query in Power BI, and SQL queries on RunQL, allowing for efficient transformations and preparation of the dataset for analysis. To visualize our data we used Tableau, taking advantage of various visuals including heatmaps, pie charts, and stacked bar charts to accurately illustrate stories with numbers.