Data Analyst with a strong foundation in analytical thinking and strategic planning, complemented by a recent Data Science Bootcamp. Experienced in financial transactions, digital marketing, and operations management, with proficiency in Power BI, Python, SQL Server, and data analysis methodologies for reports and dashboards. > Real Estate Investment Analysis Project Objective: create actionable insights for an investor interested in purchasing houses in Bontos to rent to tourists via Airbnb. The analysis focused on identifying the best neighborhoods, optimal night prices, projected revenue, ROI, and associated costs.1. Data Extraction and Preparation: - SQL Queries: Wrote SQL queries to join tables and select the relevant columns and data for the analysis. - Data Cleaning: Cleaned and standardized the data in Excel by removing outliers and correcting errors.2. Data Modeling and Visualization: - Power BI Import: Imported the cleaned dataset into Power BI. - Data Modeling: Used Power Query to create relationships between the tables and ensure a cohesive data model.3. Dashboard Creation: - Visualization: Developed a comprehensive dashboard in Power BI that showcased graphs and key metrics (night prices, revenue, ROI, and costs). - DAX Measures: Utilized DAX to create new measures that provided deeper insights.4. Conclusion: - Data-driven decisions: Enabled stakeholders to make data-driven decisions regarding real estate investments. - Outcome: Identified the best neighborhoods for investment based on potential ROI and other financial metrics.> Technical Skills:• Data visualization with Power BI: Planning, creating, and generating insights with reports and dashboards.• Python: Proficient in using libraries such as Pandas and NumPy for data analysis.• SQL: Experienced in data cleaning, performing joins, and writing complex queries.• Measurement projects: Descriptive, predictive, prescriptive, and diagnostic analysis.• Testing: A/B testing, RCT (Randomized Control Trial).• Proficient in Excel and Google Spreadsheet.• Knowledge of Tableau and Looker.> Languages:• English: Fluent. Spanish: Intermediate Portuguese: Native> Philanthropy:As the owner volunteer of the Iluminar Project in Brazil, I organized monthly campaigns to support children, the elderly, and individuals in vulnerable situations. Over two years, our efforts positively impacted thousands of lives, enhancing my leadership, organizational, and empathy skills.
Listed skills include Microsoft Office, Microsoft Excel, Powerpoint, Microsoft Word, and 1 others.