Data Analyst / SEO / Copywriter

Strong experience in doing the following: - Data Collection - Data Cleaning and Manipulation - Data Analyzation - Visualize and sharing the findings - Creating Report out of the data analysis

Data Cleaning & Preparation: - Identifying & handling missing data - Removing duplicates - Correcting inconsistent data - Formatting data Formula Proficiency: - SUM, AVERAGE, COUNT - Apply Logical Functions (IF, AND, OR) - Conditional Calculations - Data Retrieval (VLOOKUP, HLOOKUP, INDEX MATCH, etc..) Data Visualization - Creating various charts (Bar, Line, Pie, etc..) - Using Trendlines and Error Bars to enhance insights

Creating Report Presentations

Data Modeling & Relationships: - Creating a well-structured data model - Understanding in designs and relationships between tables - Creating calculated columns DAX (Data Analysis Expressions) Calculation: - Creating custom calculations & aggregations - Build advance calculations - Time-based analysis - Complex business logic within the data model Data Visualization & Design: - Create compelling and informative visualizations - Selecting the right types of visuals - Adding interactivity through slicers and filters - Creating cohesive & visually appealing reports and dashboards

Effectively organizing and managing emails

Experience in effective researching - Domain Knowledge - Information Retrieval - Statistical Research - Quantitative and Qualitative Research

Data entry is a fundamental skill for a data analyst. Here are some of my key data entry skills as a Data Analyst: - Maintain Data Accuracy - Keen Attention to Detail - Speed and Efficiency (maintaining accuracy especially when dealing with large datasets) - Data Validation - Data Cleaning - Data Formatting - Software Proficiency (Microsoft Excel, Google Sheets, or any specialized data entry tools) - Data Security & Privacy - Documentation - Data Import/Export - Data Entry Automation - Communication

Data Retrieval with SELECT: - Using the SELECT statement to retrieve data from one or more tables - Specifying columns to be retrieved - Filtering data using WHERE clause - Ordering data using ORDER BY clause Data Filtering & Aggregation: - Using Aggregate Functions (COUNT, SUM, AVG, MIN, and MAX) - GROUP BY - Filtering grouped data with HAVING clause Data JOINING, Relationships, & Modification: - Understanding different types of JOINS (INNER JOIN, LEFT JOIN, RIGHT JOIN) - INSERT INTO, UPDATE, DELETE, etc..