Prerana Amatya
Prerana holds a bachelor’s degree in Environmental Engineering. She began her journey into data analytics as a research assistant, dedicating two years to climate change research at an international research institute.
Seeking to broaden her horizons in business and technology, she transitioned to software development. Over two years, she honed her skills as a UX designer, specializing in crafting analytical dashboards for various clients.
With a keen eye for detail and a passion for uncovering insights, Prerana is eager to merge her analytical prowess and creativity in her new role in data analytics. She is excited to embark on this journey at The Data School, where she aims to apply her expertise to drive impactful business solutions. In her free time, Prerana enjoys cultivating plants in pots and expressing her creativity through painting.
Dashboard Week-Day 5- Harry Potter:A Spellbinding Analysis of Harry Potter’s Enchantments!
Dashboard Day 5 and we had only 5 hours to complete the dashboard for this week. But the good thing is that it's HARRY POTTER, which is both fun and a favorite for me. This made it a bit easier to do the analysis. The dataset given to us included characters, movies,...
Day 4 of Dashboard Week: Towards the Light Understanding Global Electricity Access
For today's Day 4 of the dashboard week, we were given the task of choosing our own dataset from the World Data Bank World Data Bank SDGs for an SDG goal we were interested in. I was immediately drawn to Goal 7: Ensure access to affordable, reliable, sustainable, and...
Day 3 of Dashboard Week: Web Scraping Crime Data
On Day 3 of Dashboard Week, we were tasked with scraping crime data for cities worldwide from Numbeo. We also needed to supplement our analysis with another dataset from the site. I chose the quality of life dataset because it provides a holistic view of factors that...
Dashboard Week – Day 2 – Casino vs. Gaming Machine Comparison
After overcoming the challenges of the first day, I tackled a gambling dataset that provided insights into different gambling forms and their measures such as turnover, real expenditure, government revenue, and other key metrics related to gambling activities across...
Dashboard Week – Day 1 – Australia’s Hospital Dashboard
Dashboard week started this week, known for being the most intense of all training weeks. Being sick didn't help my situation. I began by diving deep into Alteryx, which took up a lot more time than I anticipated. The dataset was to be downloaded by an API call which...
Detecting Languages from Text Using Alteryx: API and Macro
Intro Dearest gentle reader, have you ever come across comments on the internet in a language you don't recognize? Or maybe you're curious to learn what language a piece of text is in? This blog will guide you through the process of detecting languages from any text...
Exploring Different Approaches with the 25 days of DAX Challenge
Last week, we were assigned to tackle the 25 Days of DAX Challenge. This challenge has been an incredible opportunity for me to get my hands dirty with DAX. I realized there were multiple ways to approach one problem with DAX. Let me walk you through my journey. I...
Best Practices for Power BI and Intro to Dimension and Fact Tables
We DSAU25 have been fortunate to learn about Power BI, Query Editor, Data Modeling and DAX so far from our expert instructors namely Rachid, Grace and Ross. In this blog post, I am going to talk about some best practices to use Power BI effectively that I have learned...
Learning DAX for the First Time and my Power BI’s First Report
Last week, we DSAU25 were introduced to Power BI and Power Query, and this week, we were introduced to DAX in Power BI. DAX, the formula language in Power BI, serves as the powerhouse behind its front-end functionalities. Distinct from Tableau, DAX presents a unique...
LOD Expressions: Tackling the Workout Wednesday Challenge in Tableau
At data school, each week presents an opportunity for us to delve deeper into our training learnings. In the end of Week 3, we were tasked with taking on the Workout Wednesday challenge of our choice and presenting our solutions. Among the myriad challenges available,...