The point of Dashboard Week is to get them working very, very quickly through a brand new data set each day. Some days require data prep, some don’t. Some days have complex data, some don’t. It’s a total surprise each morning.
The rules for dashboard week are pretty simple and apply to every day this week:
- They must work independently, unless otherwise specified.
- If data prep is required, they can use Alteryx, Prep, SQL or Power Query, unless otherwise specified.
- They must create a sketch of their plan for their dashboard and show this during their presentation.
- The dashboard they create must be uploaded to Tableau Public or Power BI Service (and embed it into their blog). If no visualisation tool is specified in the challenge, they can choose themselves.
- They must write a blog post detailing their work throughout the day.
- At 3:30 pm, they will present their data prep, sketch, viz, and anything else they would like to present.
The Task Today for DS52
Scrape travel cost data from the Backpacker Index site to help travellers find the best-value destinations. You’ll collect both summary and detailed information from each city’s page and build a dashboard to support planning an unforgettable budget-friendly adventure.
Source: https://www.priceoftravel.com/cheapest-places-visit
What you need to do:
- Scrape the main Backpacker Index page
- Scrape each city’s detail page (hint: focus on the tables)
- Build your dashboard in Power BI
- Prepare for your Presentation (10 mins max)
- Write your blog post, include your plan, challenges, key finding and surprises and a link (embed your public Power BI report in your blog).
Time Limit
9:00 AM – 3:30 PM
Treat this like a real-time client brief.