Skills & Portfolio
MARKET RESEARCH & ANALYTICS
Microsoft Power BI
SQL
Relational Database, data types, primary keys, foreign keys, indexes, filtering, sorting, grouping, joins (inner, outer, right, left, cross, aggregate, nested queries, sub queries, data manipulation, query optimization, error handling and data security. You can explore my SQL projects here:
Data cleaning and transformation with power query, data hierarchy, data models, DAX and data visualization, and maintaining row-level security and permission access.
Data cleaning and manipulation with Pandas, numerical and statistic with NumPy, data visualization with matplotlib and web scrapping with beautifulsoup.
Market Research
Skilled in combining statistical analysis with storytelling to interpret data and deliver actionable insights. Possess a deep understanding of consumer behavior, competitive analysis, and digital marketing channels, along with expertise in data visualization. Experienced in designing effective surveys to gather meaningful information, applying both quantitative and qualitative methods, and managing projects with strong budgeting skills.
This report presents an in-depth analysis from a market research project I conducted for a company intending to launch a coworking space. Unfortunately, the project was put on hold due to the pandemic.
In this report, I began by profiling the demographics, behaviors, habits, needs, and lifestyles of digital nomads in Bali. This foundation allowed me to create a detailed digital nomad persona that reflects the target audience's preferences and aspirations.
Subsequently, I conducted a thorough competitive analysis, examining competitors' websites, social media platforms, blogs, and conducting onsite surveys. This approach provided valuable insights into their facilities, ambiance, service offerings, and staff interactions. I also assessed the unique advantages this company possesses over its competitors.
Additionally, I analyzed feedback from dissatisfied customers of other coworking spaces to identify common pain points. By integrating these insights with the distinctive features and services that this company offers, I developed a set of compelling selling points that can effectively inform the marketing strategy.
*Please note that I have removed all company data for confidentiality and provided only general public data.
PHYTON
DIGITAL MARKETING TOOLS
WEBSITE
Free WordPress project for a music school in Bali. Some changes were made to the services page by the website’s owner; however, 90% of the design is still mine.
One of the Squarespace websites that I actively maintain involves creating landing pages, updating website content, and managing payment integration.
One of the Kajabi websites that I actively maintain involves creating landing pages, updating website content, creating online course and managing payment integration.
One of the Wix websites that I created for sample. I think WIX is one of the most user-friendly and easy to use website platform.
EMAIL CAMPAIGNS
I have experience using Mailchimp and Kajabi for email campaigns. In addition to email campaigns, both platforms offer many features, such as email automation that can integrate with payment systems and track customer activity. They also provide valuable features like customer segmentation based on demographics, activity, purchased products, and more.
OTHER DIGITAL MARKETING TOOLS
Canva - for creating social media posts, reels, stories, shorts, website banners, infographic, video thumbnail, proposal, photo collages and more.
Google Trends - for conducting market research, we review popular topics or keywords related to our research topic and check the number of studies using those specific topics or keywords.
Ahref - To conduct keywords research and to review website's performance and SEO.
Hootsuite - To managing and publish social media content to some platforms from one place.
Google Analytics - To review website's performance and traffic.
Similarweb - To conduct competitors' research, review the competitors' website performance and keywords.
BASIC ADMINISTRATIVE TOOLS
Google Workspace - Words, Sheet, Form, Website
Dropbox
Microsoft Office - Words, Excel, Power Point, Publishers
Jotform
Formstack
Shopify
Etsy
Teachable
Stripe
© 2024. All rights reserved.