Connor Theodorakakos

Self-motivated Business Intelligence Analyst offering strong organizational and technical skills. Experienced with business intelligence tools like Power Bi and SQL, pursuing a full-time role intersecting business and data analytics.

Policy Detail Report 

Scope:
Led the development of a comprehensive policy detail report for a dedicated department within the company. The previous reporting system relied on manual data entry into Excel spreadsheets, with outputs generated by outdated reporting software, which was subsequently phased out post-implementation of my report.

Key Responsibilities:

• Conducted two months of rigorous data modeling and validation.
• Collaborated closely with stakeholders to gather requirements and ensure alignment with organizational objectives.

Achievements:

• Successfully streamlined the reporting process, resulting in substantial cost savings of $2.4 million annually by sunsetting the outdated reporting system.
• Delivered a robust and automated reporting solution, replacing manual data entry with efficient data gathering and validation processes.

Tools & Technologies Used:

• Power BI for advanced data modeling and visualization.
• Power Query for intricate data transformations and manipulation.

Crowdfunding Analysis

Scope:
Our client, a screenwriter aiming to raise $10,000 for their play, sought to utilize crowdfunding platforms for financing. Prior to launch, they wished to identify crucial factors influencing successful campaigns and the likelihood of cancellation. Leveraging Microsoft Excel and client-supplied data, we conducted a comprehensive analysis.

Analysis:
Focusing on two key factors—launch date and funding goals—we utilized pivot tables and line charts to organize and visualize data trends efficiently. Our analysis aimed to uncover insights into campaign outcomes.

Results:
The data revealed that campaign success and cancellation were minimally impacted by launch dates. However, a significant inverse correlation was observed between campaign success and funding goals. Surprisingly, no such correlation was found regarding cancellation likelihood.

• Link to Github files: https://github.com/Connor-Theo/Kickstarter_Analysis-Excel