Back to Projects

Market Potential
Study

Python SQL Power BI DAX
Project Preview

Problem

The challenge with unstructured data at scale.

This was one of the most complex projects. We needed to map 3 distinct fronts: executive branch, judiciary, and direct market clients. We didn't know exactly who we already had vs. the total acquisition potential in each region and organization.

Solution

An intelligent, automated extraction pipeline.

This project required a very deep study of the entire universe of potential clients. I integrated several data sources simultaneously, including public government data, the company's internal base, and market files. I developed Python scripts to automate extraction and used SQL to fetch data from Databricks.

  • Automated public data scraping and treatment
  • Regional analysis by UF, city, and organization
  • Intensive communication with several business areas

Tech Stack

Python
SQL
Databricks
Power BI
DAX

Results

10k+

New Clients

3

Analysis Fronts

100%

Automation Level

This study provided the foundation for strategic expansion, allowing the commercial team to target high-potential organizations with precision.

Next Project

AI Job Matcher