David Baldwin has been providing consulting in the business intelligence sector for 22 years. His experience includes Tableau training and consulting, developing BI solutions, project management, technical writing, and web and graphic design. His vertical experience includes financial, healthcare, human resources, aerospace, energy, education, government, and entertainment industries.
Read more
Marleen Meier
Marleen Meier
Marleen Meier
Marleen Meier is an accomplished analyst and author with a passion for statistics and data. By using traditional methodologies and approaches such as Machine Learning and AI, Marleen is dedicated to driving meaningful insights. Currently working as the APAC Data CoE Lead for ABN AMRO Clearing, Marleen is at the forefront of innovation and implementing data-driven strategies in a global financial environment. She has lived and worked in multiple countries, including Germany, the Netherlands, the USA, and Singapore, allowing her to bring a diverse and global perspective to her work. Through her writing and speaking engagements, she aims to empower individuals and organizations to unlock the full potential of their data assets.
We will now create a dashboard that allows the end user to choose between the various maps we just discussed. The technique used for this exercise is known as sheetswapping. However, a deeper dive into this technique is presented in Chapter 11, Visualization Best Practices and Dashboard Design.
Let's look at the necessary steps:
Navigate to the sheet MapSwap in the workbook associated with this chapter. Double-click on State Set the Marks card view to Map, click on Colour, set Opacity to 0%, and lastly set Border to Automatic:
Figure 9.51: Colour
Duplicate the MapSwap sheet twice:
Figure 9.52: Duplicate MapSwap sheet
Select the MapSwap sheet and navigate to Map | Background Maps | Normal
Select the MapSwap (2) sheet and navigate to Map | Background Maps | Dark
Select the MapSwap (3) sheet and navigate to Map | Background Maps | Satellite.
Create a parameter called Show Sheet like so:
...
The rest of the chapter is locked
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Marleen Meier is an accomplished analyst and author with a passion for statistics and data. By using traditional methodologies and approaches such as Machine Learning and AI, Marleen is dedicated to driving meaningful insights. Currently working as the APAC Data CoE Lead for ABN AMRO Clearing, Marleen is at the forefront of innovation and implementing data-driven strategies in a global financial environment. She has lived and worked in multiple countries, including Germany, the Netherlands, the USA, and Singapore, allowing her to bring a diverse and global perspective to her work. Through her writing and speaking engagements, she aims to empower individuals and organizations to unlock the full potential of their data assets.
David Baldwin has been providing consulting in the business intelligence sector for 22 years. His experience includes Tableau training and consulting, developing BI solutions, project management, technical writing, and web and graphic design. His vertical experience includes financial, healthcare, human resources, aerospace, energy, education, government, and entertainment industries.