Hi, I'm Lisette!
Hi, I'm Lisette!
Embedded Files
I am an HR professional with practical experience across various HR functions and a strong interest in HR and data analytics. I leverage SQL, Power BI, and Python to clean, analyze, and visualize HR data, enabling stakeholders to make informed, evidence-based decisions.
With a blend of HR domain knowledge and technical analytical skills, I focus on uncovering trends in workforce data, improving reporting processes, and delivering insights that support organizational goals. I am continuously developing my skills to grow as an Analyst and contribute value through data-driven insights.
SELECTED WORKS
SELECTED WORKS
Microsoft Power BI
Microsoft Power BI
Created a multi-page dashboard using Maven Analytics data, reinforcing strong analytical foundations and consistency in achieving project objectives.
Adventure Works Data Report
Adventure Works Data Report
Leveraging AdventureWorks Cycles data, an interactive dashboard was built to transform raw data into meaningful insights. By highlighting revenue trends, seasonal demand, and product performance, the dashboard enables stakeholders to make informed, actionable business decisions.
Key Takeaway:
Key Takeaway:
Revenue shows a strong seasonal pattern, peaking in June 2020 and June 2022, with a sharp increase from June to July in 2021. Since most customers are from the United States, the start of summer appears to significantly drive higher bike sales.
Recommendation:
Recommendation:
Leverage the summer demand by launching promotions, increasing inventory, and strengthening marketing campaigns from May to July to maximize revenue during peak season.
Key Takeaway:
Key Takeaway:
Despite being the most ordered product with high revenue and low return rates, the water bottle did not meet monthly order, revenue, and profit targets, indicating a gap between demand volume and target performance.
Recommendation:
Recommendation:
A 10% downward price adjustment, supported by targeted summer marketing, could improve competitiveness and increase the likelihood of meeting sales and profit targets, especially during peak cycling season.
Bonus Project
Bonus Project
This project uses data from Maven Market, a multinational grocery chain, to create interactive visuals that compare monthly transactions, profit, and returns and support data-driven business decisions.
Key Takeaway:
Key Takeaway:
In Mexico, both monthly transactions and profit failed to meet targets, declining by 5.49% and 6.27% respectively, unlike the other two states. At the same time, the return rate also decreased, indicating that product quality or customer satisfaction is not the primary issue.
Additionally, sales reached their lowest point during the last week of each month, suggesting that the absence of firm end-of-month deadlines may be limiting sales momentum and real-time performance tracking.
Recommendation:
Recommendation:
Implement firm end-of-month sales deadlines and weekly checkpoints to improve real-time sales monitoring and help the sales team take corrective action before month-end.
Data Field Happiness Survey
Data Field Happiness Survey
Key Takeaway:
Key Takeaway:
- Data Scientists showed the highest overall happiness (~6.18/10) and highest average salary ($94k), leading across nearly all satisfaction factors in the survey.
- Participants categorized as “Student / Looking / None” recorded both the lowest average salary and the lowest overall happiness score (~3.70/10), suggesting the challenges often experienced when entering the data field.
- Despite having one of the lower average salaries among the job titles, Data Analysts recorded the highest number of participants, which may indicate how saturated and competitive it is
Overall, the survey appears to show a relationship between salary, job satisfaction, and role saturation. The survey also suggests that entry-level roles in data may experience lower satisfaction due to increased competition and lower salary expectations.
Google Spreadsheet
Google Spreadsheet
I applied what I learned in SQL and other data analysis tools to Google spreadsheet. Integrating data managing into HR roles.
Using the QUERY function and integrating SQL, this automatically generates a list based on the reference of an active cell. This helps improve the HR system by making it easier to identify patterns in employees’ attendance and coordinate with account managers, payroll, and suspension processes.
By combining conditional formatting and the IF function, another sheet is automatically updated. This is used to track high-volume recruitment while ensuring the desired deployed applicant is noted for each store.
Utilized the Query function to automatically generate employees’ positions, departments, and responses from the 1st-month and 6th-month interviews regarding their pre-regularization experience. Leveraged ARRAYFORMULA() and VALUE() functions to efficiently aggregate and process the data retrieved from the query, ensuring accuracy and scalability.
Fun Learning With Python
Fun Learning With Python
With the help of Udemy, I learned some basic projects using Python, from printing "hello world!" to Python functions.
ROCK-PAPER-SCISSOR
ROCK-PAPER-SCISSOR
Using If, Else if, and Else statements, I made a basic game - rock, paper, scissor.
Maze Game
Maze Game
With a more complex structure of If, Else if, and Else function, I made a maze game called "Pokemon Island"
Calculator
Calculator
A simple calculator was made with different operations.
Get in touch with me at moriel.lisette06@gmail.com or kindly click the LinkedIn icon!
(63) 932 5205 850 | Quezon City, Philippines
Page updated
Google Sites
Report abuse