Todays challenge what about Census data from ABS. The topic selected what Data Mapping of Languages across Australia. And I decide to  build a dashboard that will allow you to get a quick overview of the most common languages spoken in Australia. Moreover, you could select from greet capital cities, regions, or suburbs to filter the results.

Why is important a corporate language strategy?
It is crucial for government to understand the spread of languages across regions in regional Victoria and the level of English proficiency among particular language groups to inform communication and
engagement strategies that are targeted to areas of greatest need.

The census data
When it comes to get data from Census, its always a challenging task. The header are encode and record are not in row level. So first its important to prepare the data in Alteryx. Here it ts. I spend most of my time finding pattern to clean the data on a smart way.

Finally, after lots of effort my data is ready to use in Tableau.

Before

After

All right, that’s all. Now you’re able to identified the most common languages spoken depending of your selection. Thanks for checking it out! I hope you enjoy it. I look forward to seeing you soon. You can see it in Tableau Public here.   See you soon on my next blog, and if you’re looking for new tunes while learning new cool stuff or preparing for your Alteryx certification, check out my Spotify playlist here.

Antoneely Calizaya
Author: Antoneely Calizaya

Antoneely is a curious and lifelong learner, and she has become fascinated by a wide variety of business challenges she has encountered throughout her career. She is currently pursuing a Master’s in Business Analytics and has a Bachelor’s in Management and Marketing. She is passionate about data-driven decision making and enjoys working with complex data problems. She has six years of experience including a mid-level position in management, developing projects and implementing strategies. When she matched her passions and interests, it was clear that she wanted to learn as much as she could about data analysis, data science, machine learning, and new technologies. Her favourite new platforms are Alteryx and Tableau. She’s constantly seeking new things to learn and is always up for new ways to challenge herself. She finds fascinating books about the brain, creativity, subconscious mind, and mindfulness. She enjoys hosting meetups related to fun outdoor activities. The latest hobbies she enjoys are pole fitness, video editing, illustrating with her Wacom, and she’s looking to join a footy team. Antoneely’s long-term goal is to use all her data superpowers to contribute to improving access to equitable and quality education, emphasising rural areas, and vulnerable populations.