Hi! I’m Divina Dador, and I’m a Data Analyst, SEO and Copywriter.

Let's collaborate to unlock the power of your data and drive smarter decisions to elevate your business.

Discover the magic of data analytics as I weave storytelling with SEO and copywriting skills. I'll turn complex numbers into engaging narratives, guiding strategic decisions.

Come along on a journey of exploration and experience the incredible transformation of data through my eyes as an adept SEO specialist, skilled copywriter, and insightful data analyst.

<aside> 📊 Let’s work together!

Send me an Email! ✉️

DM me on Skype: Divina Dador

</aside>

<aside> <img src="/icons/arrow-down_gray.svg" alt="/icons/arrow-down_gray.svg" width="40px" /> View My Resume

My Resume

</aside>

Data Analytics Skills

DATA CLEANING & PREPARATION

• Removing duplicates
• Identifying and handling Data
• Correcting inconsistent data
• Formatting data for consistency

FORMULA PROFICIENCY

• SUM, AVERAGE, COUNT,
• Apply logical functions like (IF, AND, OR) for Conditional Calculations
• VLOOKUP, HLOOKUP, INDEX-MATCH for data retrieval.

DATA VISUALIZATION

• Creating various types of charts (BAR, LINE, PIE, etc..)
• Using trendlines and Error bars to enhance insights

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 like COUNT, SUM, AVG, MIN, AND MAX
• Filtering grouped data using HAVING clause
• Grouping data using GROUP BY clause

DATA JOINING, RELATIONSHIPS, & MODIFICATION

• Understanding different types of JOINS (INNER JOIN, LEFT JOIN, RIGHT JOIN)
• INSERT INTO, UPDATE, & DELETE.

DATA MODELING & RELATIONSHIPS

• Creating a well-structured data model
• Understanding how to design relationships between tables
• Creating calculated columns

DAX (DATA ANALYSIS EXPRESSIONS) CALCULATIONS

• Creating custom calculations and aggregations
• Build advanced 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
• Filters, and creating cohesive and visually appealing reports and dashboards

Other SaaS Skills

MS EXCEL & Google Sheets Project

✈️ Air Passenger Analysis for Travel Agency

The objectives of this study was to help a travel agency for the next big travel sale in Visayas by exploring the Air Passenger Data.

The Travel agency used this ANALYSIS to understand which airlines are dominant players in certain Provinces. This study will help the travel agency to strategically set pricing for packages that feature flights with the top Airline Operators.

<aside> <img src="/icons/view_gray.svg" alt="/icons/view_gray.svg" width="40px" /> View More Details

Air Passenger Analysis

</aside>