![profile pic](https://preparesh-arbpfvdsfpcdg8a0.z01.azurefd.net/images/technologies/tableau.png)
![profile pic](https://preparesh-arbpfvdsfpcdg8a0.z01.azurefd.net/images/technologies/tableau.png)
Given a dataset containing customer transaction records in a CSV format, describe how you would create a data quality dashboard to track key metrics like missing values, duplicate entries, and data type mismatches. Specify the tools and technologies you would use.
Please sign-in to view the solution
What is the difference between Tableau, Power BI, and other BI tools? Do you have any knowledge of Machine Learning?
Please sign-in to view the solution
Write a SQL query to calculate the total revenue generated per product per month over the last year. Explain how you would visualize this data in Tableau, mentioning the types of charts you would use and why.
Input Data:
sales
table:
| sale_id | product_id | sale_date | quantity | price |
|---------|------------|------------|----------|--------|
| 1 | 101 | 2023-01-10 | 10 | 15.00 |
| 2 | 102 | 2023-02-15 | 5 | 20.00 |
| 3 | 101 | 2023-01-20 | 7 | 15.00 |
| 4 | 103 | 2022-12-10 | 3 | 30.00 |
| 5 | 101 | 2022-11-10 | 12 | 15.00 |
Output: The query should return the total revenue generated per product per month over the last year.
Please sign-in to view the solution
What steps are involved in creating a dashboard in Tableau?
Please sign-in to view the solution
What is the difference between Extract and Live in Tableau?
Please sign-in to view the solution
What is a xyz
in Tableau and what does it do?
Please sign-in to view the solution
How would you diagnose and resolve issues when a business intelligence report breaks in a production environment?
Please sign-in to view the solution