Author
André Petry Gonçalves
André Petry Gonçalves is a data scientist and the head of bi19 Business Intelligence. An actor and psychologist by training, he has worked with data for more than 12 years: he builds BI areas, data pipelines and web portals that put the numbers in front of the people who make the decisions.
Experience
For six years he built, from scratch, the business intelligence area of a consulting firm that serves private schools in Brazil. He moved every report to Power BI, took the data out of Excel and into SQL Server, automated data processing in Python and built a web portal with Power BI Embedded so clients could reach their own reports. He tells that story in the series Six years building a BI practice.
In partnership with one of Brazil's largest education consultancies, he built a data ecosystem that keeps at least ten Big Data and data science projects constantly up to date and processes more than 59,000 satisfaction surveys on schools and education every year. He has worked with managers at brands such as Bunge, GE HealthCare, Nubank, Kroton, Ajinomoto and JBS, and he launched Mais Alunos CRM, a tool for private schools that now serves more than 90 clients.
What he works with
- Data science: processing, cleaning and crossing large datasets in Python (pandas, NumPy), with automation where people used to work by hand.
- Geomarketing: demographic and economic data within a radius, to read the market around a location.
- Business intelligence: Power BI, semantic models and client portals with Power BI Embedded.
- Databases: SQL Server and the data models behind fast reports.
- Surveys at scale: satisfaction surveys processed by the tens of thousands every year.
- Web apps: Flask, JavaScript, HTML and CSS around the data.
For companies, this work becomes data science and geomarketing studies at bi19.