California Housing Market Analysis
Cleaned and explored California housing data, engineered household metrics, and translated market patterns into business recommendations using a map, KPIs, and visual analysis.
Open project briefBruno Oliveira is an early-career data analyst with hands-on work across Python, SQL, Excel, Tableau, and Google BigQuery. Explore the analysis behind the work.
Selected work
Cleaned and explored California housing data, engineered household metrics, and translated market patterns into business recommendations using a map, KPIs, and visual analysis.
Open project briefBuilt practical query workflows using joins, aggregations, CASE logic, temporary tables, and subqueries to prepare data for analysis.
Open project briefUsed validation checks, PivotTables, lookup functions, and conditional logic to clean records, surface errors, and summarize performance.
Open project briefDesigned KPI views, readable labels, filters, geographic context, and concise takeaways that help nontechnical stakeholders scan results.
Open project briefApplied the end-to-end analytics process: define a question, prepare and clean data, analyze patterns, share insights, and recommend action.
Open project briefNo samples match that tool yet.
How I work
Validate, clean, and prepare data before looking for patterns.
Use SQL, Python, and spreadsheet logic to test useful questions.
Turn results into dashboards, maps, and clear recommendations.