Hands on design oriented Power BI Data Analyst, with 18 months of business experience and data exposure to customer profile and behavior, finance and sales. Experienced in business analysis techniques to create data and reporting requirements with skills in business process modelling notation. Intermediate skills in using SQL Queries to discover data to research and validate requirements.
As skilled analyst with hands experience in extracting data from source systems into the Power BI eco system, I have a reliable set of analyst skills that can benefit any team. Adapt at paying close attention to detail, I am skilled at using skills in SQL, Power Query, Data Modelling, Power BI Dax and Azure Synapse Pipelines to support data discovery, analysis, engineering and science initialises. I have an in-depth knowledge of market trends and industry insights, and a track record of delivering data-driven insights to support informed decision-making.
I have a high level of proficiency in shaping data from source to transformation using Power Query, a high level of understanding in Row and Filter context and complex DAX calculations and experience gained with AI Darwin, enabling data discovery systems using Data Lakes to Power BI Datamarts.
Expertise in data visualisation, utilises unique blend of technical and creative skills to deliver report templates and UX design concepts to translate complex data into compelling visual stories. With a deep understanding of data structures, algorithms and analytical methods combined with principles of visual design, I bring a edge to any data analysis team.
I have experience in working within a large company structure, with a proven track record of managing complex operations for organizations with over 100,000 employees and 200 branches. I have worked collaboratively with cross-functional teams, and participated in negotiations at various project stages. Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills.
Overview
3
3
years of professional experience
Work History
Data Analyst
AI Darwin
03.2023 - Current
Attained Certification (PL-300 – Power BI Data Analyst)
DAX – Creating Customer Profiling and Segmentation calculations for Analysts
PowerBI & Power Query – Applied New and Linked Power BI Data flows caching data to datasets. Built reports for 5+ project.
SQL – Experienced running SQL Queries in SSMS, Power BI Datamart Queries, SQL On Demand
Data Science – Demonstrated techniques for more complex data analysis using R and Python such as customer profile and churn models
Report Design - Design system and Report Templates for not for profit with Finance and Sales Requirements
Effective Communication - Engaged with clients and stakeholders to gather requirements and understand their needs.
Game Designer / Data Analyst
TikTok
05.2021 - 08.2022
Use of data analysis techniques to cooperate with the commercialisation team to optimise game store update pace and improve game user retention rate.
Use of real-time dashboards to make adjustments in game performance.
Responsible for game system design, produced and coordinated programs to implement 7 game systems within half a year, designed system UI logic to improve user experience
Designed and configured 100 character skills within 2 months and making adjustments based on feedback from players.
Planned work in weekly sprints using TikTok's internal agile platform
Coordinated with art team to design 3 hero character models and gaming effects; 3 advanced pet models and special effects to increase game commercialisation revenue.
Education
Master of Business Analytics -
Kaplan Business School
Brisbane
06.2024
Bachelor of Japanese Language and Literature -
Xiamen University
Xiamen
06.2021
International Exchange Student of Humanities -
University of Tsukuba
Tsukuba
03.2020
Skills
Power BI
SQL
Time management
Data Story Telling and Visualization
Problem-solving
Critical Thinking
Work under pressure
Efficient communication
Team collaboration
Customer Focused
Leadership Experiences
TikTok, Beijing, 07/2021 - 09/2021, Chief Game Designer: Responsible for the system, interaction and gameplay design, led a 12-members team and spent 3 months to make a mini-game, which is released on the TAPTAP platform and received 111K player attention, with a 8.7/10 score from reviews
Employment Service Department, School of Foreign Languages, Xiamen University, Xiamen, China, 11/2017 - 07/2019, Minister: Responsible for planning, promotion writings, promotion activities and contacting guests, Participated in the planning and organisation of experience sharing activities of employment and further education, additionally, a total of 21 mini-talk sessions with an average number of participants of 70, In December 2018, planned and held the first job-hunting skills competition within the college and had over 200 audiences