<aside> 👋🏻 Hi there! I’m Yi An.(Andrea)

</aside>

Hello! I'm a certified Data Analyst with a passion for turning data into actionable insights that drive smarter business decisions. I hold a Bachelor's degree in Computer Engineering and Information from Chung Yuan Christian University, and I have further honed my skills through a comprehensive data analytics program at The Data Analytics Institute in Australia.

As a naturally curious and detail-oriented professional, I thrive on using data to solve complex problems and uncover hidden patterns. My journey into data analytics stems from a lifelong fascination with numbers and their ability to explain real-world phenomena. This has driven me to continually expand my knowledge and expertise in data analysis, visualisation, and business intelligence.

I have hands-on experience with a variety of tools, including Python, SQL, Tableau, Power BI, and Excel. Recently, I completed a Web Traffic Dashboard project, where I analysed user behaviours and created interactive visualisations to provide actionable insights to improve web traffic and engagement. This project is a key example of how I bring value by leveraging data to inform decision-making and optimise performance.

What Drives Me

• Independent and proactive: I am highly self-motivated and take pride in my ability to work independently and lead projects to completion with excellence.
• Passionate about learning: Whether it's exploring new tools, learning advanced analytics techniques, or diving into a complex dataset, I’m always excited to expand my skill set and apply it to real-world challenges.
• Committed to excellence: In both life and work, I aim for excellence. I bring a meticulous, detail-oriented approach to everything I do, ensuring that my work is not just effective but also meaningful.

Key Skills & Tools

• Programming Languages: Python, SQL, R
• Data Visualisation: Tableau, Power BI, Excel
• Database Management: MySQL, PostgreSQL, Google BigQuery
• Business Intelligence: Web traffic analysis, customer insights, data reporting, project management
• Project Experience: Web Traffic Dashboard, Project Management Dashboard
• Cloud Technologies: Ms Azure, Databricks, Google Cloud Platform

Experience

Freelance Data Analyst (Contract Projects) Jan 2025 - Present

• Cybersecurity Dashboard : Developed a Power BI dashboard to visualise endpoint security metrics (inspired by CrowdStrike data), enhancing visibility into app installs and vulnerabilities.
• Information and Privacy Commission (IPC) : Conducted research and data analysis to support policy and reporting needs, with emphasis on data reliability and structured insights.
• EV Fleet Analytics : Supported data cleaning, preprocessing, and Power BI dashboard development for a government EV fleet performance project.
• Used Python (pandas), SQL, Excel, and Power BI for data wrangling and visualisation.
• Delivered dashboards under strict confidentiality and IP transfer agreements with a Sydney consultancy (DashboardWorx).

Product Data Analyst | DashboardWorx · Internship Aug 2024 - Present

• Created an advanced Web Traffic Dashboard that tracks key metrics such as page views, bounce rates, and user demographics, providing actionable insights for optimising website performance and marketing strategies.
• Developed a Project Management Dashboard in Tableau to streamline project timelines, resource allocation, and progress tracking, enhancing overall project efficiency.
• Leveraged Python, SQL, Power BI, and Tableau for data extraction, cleansing, and in-depth analysis across multiple datasets.
• Collaborated with stakeholders to ensure data-driven decisions aligned with business objectives and delivered clear insights for management reporting.