Edreen Bryan Valdeavilla

Edreen Bryan Valdeavilla Branding Data Maximizer Quezon City Philippines , PH | (- |- LinkedIn | Portfolio Profile Summary | Video Introduction | Process | Deliverables Results-driven and highly analytical Data Analyst with over 5 years of expertise in digital marketing, LinkedIn marketing, and branding. Proven track record of solving complex problems, delivering data driven insights, and optimizing processes. Proficient in Microsoft Excel, SQL, Power BI, and Python. Experienced in web scraping, data visualization, and business intelligence. Passionate about continuous improvement and contributing to organizational success. Key Skills       Data Analysis: Microsoft Excel, SQL, Power BI, Python Marketing Expertise: Branding, LinkedIn Profile Optimization, LinkedIn Marketing Data Management: Data Scraping, Power Query Problem-Solving: Proven ability to tackle complex challenges Time Management: Efficient project and task management Team Collaboration: Effective communication and teamwork Working Experience Power BI Masterclass 2.0, DataSense Analytics | Power BI Portfolio October - November 2023        Data Preparation: Utilizing Power Query to clean and organize data effectively. Extract, Transform, and Load in Power BI: Removing duplicates, split complex columns, and combine multiple columns for readability. Data Modeling: Implementing a star schema design for high performance and usability. Data Analysis: Understanding the differences between calculated columns and measures in Power BI models. Time Intelligence: Utilizing DAX functions for summarizations over time and date range operations. Data Visualization: Design layouts with consideration for placement, balance, proximity, and color usage. Power BI Report Designs: Enhance interactivity with buttons and bookmarks for a guided user experience. Business Intelligence with Power BI, DataSense Analytics August 2023       Data Integration: Combined data from multiple sources and established data relationships to create a unified dataset. Data Modeling: Designed data models aligned with business requirements and analytical needs. Data Visualization: Created charts, graphs, tables, and maps for effective data representation. Report Design: Structured and designed reports and dashboards. Advanced Analysis: Implemented calculated columns and measures using DAX to generate insights. User-Friendly Dashboards: Built interactive reports and dashboards using Power BI’s intuitive interface. Web Scrapping Project, DataSense Analytics July 2023      Data Collection Strategy: Strategically planned and executed data collection. Data Transformation: Cleaned and structured data, ensuring accuracy and consistency. Code Testing: Rigorously tested web scraping code for accuracy and functionality. Data Extraction: Ensured efficient and reliable data extraction from web sources. Responsible Data Handling: Maintained data ethics and ensured responsible data utilization. Data Analyst Final Project, Refocus April 2023 - June 2023       Comprehensive Analysis: Leveraged Excel, SQL, Power BI, and Python for in-depth data analysis. Data Transformation: Cleaned and transformed complex datasets for analysis. Data Visualization: Created compelling visual narratives to convey insights. Statistical Analysis: Conducted statistical analysis using Excel and SQL. Business Intelligence: Produced informative dashboards to guide decision-making. KPI Assessment: Utilized business metrics and KPIs to evaluate company performance. Data Analyst Group Project, Refocus November 2023 - December 2023      Data Processing: Cleaned and prepared data using Excel and SQL. Database Queries: Executed SQL queries to retrieve information from databases. Pivot Tables: Created pivot tables in Excel for insightful data analysis. Collaboration: Communicated effectively with stakeholders to deliver relevant information. Teamwork: Worked collaboratively in a team, managing tasks efficiently. Education Master of Science in Electronics Engineering , July 2010 Chung Yuan Christian University, Taoyuan, Taiwan Bachelor of Science in Electronics Engineering, November 2007 Mapua University, Intramuros, Manila , Philippines Training and Certification       Certificate of Completion, Refocus, Dec. 12, 2022 Certificate of Graduation, Refocus, June 8, 2023 Web Scraping, DataSense Analytics, July 20, 2023 Data Analytics Foundation, DataSense Analytics, Aug. 3, 2023 Business Intelligence with Power BI, Aug. 25, 2023 Google Data Analytics Certification, Sept. 19, 2023 Software and Tools      Microsoft Excel PostgreSQL Microsoft Power BI Power Query Jupyter References Available Upon Request