Juliet Ruan
Juliet’s educational journey has taken her to different parts of the world. She obtained her Bachelor of Arts in Shanghai, China, followed by her two Masters of Teaching from the University of Edinburgh, and the University of Melbourne. With her extensive teaching experience across countries, Juliet has cultivated a strong passion for sharing knowledge and learning.
Juliet’s interest in data stems from her utilisation of data to enhance her teaching practices, where she was amazed by the positive changes it brought. In her educational research, she has found that data has led her to insightful findings. Therefore, she embarked on a career transition to become a data analyst consultant at The Data School. Driven by her passion for learning, Juliet embraces every opportunity to explore and further hone her knowledge and skills in data warehousing, cleaning, modelling, and visualisation.
In her personal time, Juliet enjoys playing piano, guitar, and ukelele. She also embraces an active and mindful lifestyle through activities such as Pilates, yoga, hiking and enjoying her time in the outdoor with her friends and family.
Splitting Column into Rows in SQL (MS SQL Server)
This week I have been practising my SQL skills with the Week 2 Case Pizza Run in 8 Week SQL Challenge. In this blog I would like to introduce you to the function of STRING_SPLIT to split a column into rows (with MS SQL Server).When preparing the data for analysis, we...
How to Calculate Percentage of Total – From Tableau (Table Calc & LOD) to Power BI (DAX)
Both Tableau and Power BI offer powerful calculation capabilities. Tableau emphasizes table calculations and LOD (Level of Details) expressions for interactive visualizations, while Power BI relies on DAX measures and calculated columns for dynamic, context-aware...
Parsing Text with ‘Extract’ Function in Power Query (Power BI)
Shaping data in Power Query, when working within the Power BI ecosystem, is a foundational concept that underpins the process of data transformation and preparation. It serves as the backbone for structuring, cleansing, and enriching your data before it's used for...
3 Ways to Use Regex (Regular Expression) in Alteryx – Empowering Data Transformation and Analysis
Regular Expressions, commonly known as Regex, is a powerful tool that enhances data transformation and analysis capabilities in Alteryx. Regex is a versatile technique that allows users to define complex patterns to match, locate, and manipulate specific text or data...
5-Step Approach for Dashboard Design – Learn What the Data School Learns
Couple of weeks ago, we have got the chance to be the trainer and give tableau workshops to the others who share the passion of data viz! The topic of my session is about Dashboard Design, which I find very interesting and requires ongoing improvement - there is no...
5 Tips to Prepare for the Tableau Certified Data Analyst Exam
As our graduation approaching, I successfully passed my Tableau Certified Data Analyst Exam last week. This blog will go through couple of the tips in terms of preparing for the exam as well as setting up your test environment if you are testing through OnVUE from...
Data Scaffolding – Dashboard Week Day 4 API & Spatial Challenge
On Day 4 of the Dashboard Week, we have been given the task of getting spatial data from the City of Melbourne Open Data through API to answer a business question of our own interest. I decided to look at the nearby On street Parking bays and the parking restrictions...
Dashboard Week Day 2 – 3 Tips for Dashboard Development
As Day 2 of dashboard week almost come to the end, we have finished our second dashboard - Sports Day, within a limited timeframe. We were given the datasets about different sports and need to find interesting insights from the numbers. I picked the Winter Olympic...
Dashboard Week Day 1!!
Today we have entered Week 14 for our training - three more weeks to go! And this week is our dashboard week, which is a legendary week that we have been told from the very first week to be both challenging and rewarding. This blog marks the finish of my first...
Embedding Worksheets into Tooltips
Have you ever come across the problem that there are too many sheets you would like to squeeze into a dashboard which makes it almost impossible to see clearly or organize them in a logical way. Here are a simple tip to solve the problem which can keep the dashboard...