DRAG DROP - (Topic 3)
You have a dataset that contains daily sales by business segment from 2017 to the present You want to use monthly historical trends to predict sales by segment in the future
Which three actions should you perform m order?
(Place the three correct options in order Use the arrows to move Options lo Answer Area I In Answer Area arrows to re order the options.)
Solution:
Does this meet the goal?
Correct Answer:A
- (Topic 3)
In a dataset, a Data Analyst has a string field named Category that contains unnecessary trailing spaces.
Which function should the analyst use to remove the trailing spaces from the Category field?
Correct Answer:A
- (Topic 3)
A colleague provides a Data Analyst with access to a folder that has the following files:
✑ Sales.csv
✑ Book1.json
✑ Sales.tds
✑ Export.mdb
Which file can contain information for connecting to an external data source, such as an SQL Server database?
Correct Answer:A
- (Topic 1)
You have the following line chart that shows the average sales by month.
Which month had the biggest increase in swage sales compared to me previous month in 2019?
Correct Answer:D
- (Topic 3)
You have the following dataset in Microsoft Excel.
You are using Data interpreter to cleans the dataset. Data interpreter provides the following results.
How many rows of data will be ingested into Tableau as values?
Correct Answer:C