At INVESTOR CLINIC (REAL ESTATE), I analyzed CRM and sales data in Excel to identify conversion patterns, prospect trends, and high-potential opportunities. I built and maintained pipeline trackers that gave leadership a consolidated view of pipeline status and conversion.
For my Real Estate Sales and Lead Funnel Analytics Dashboard project, I analyzed 6,120 sample CRM records and found that 81.6% of open leads had no follow-up within 14 days. I built a Power BI dashboard on a star schema with DAX KPIs, and my findings supported a recommendation to shift effort toward referrals.
At SMITH LAW FIRM, I automated recurring operational reports with Excel formulas and Google Sheets scripting, and validated data integrity across internal systems. I also built a customer shopping behavior analysis project using Python, SQL, and Power BI, with a written report and recommendations.
