The data architect has been tasked with building a sales reporting application.Part way through the year, the company realigned the sales territoriesSales reps need to track both their overall performance, and their performance in their current territoryRegional managers need to track performance for their region based on the date of the sale transactionThere is a data table from HR that contains the Sales Rep ID, the manager, the region, and the start and end dates for that assignmentSales transactions have the salesperson in them, but not the manager or region.What is the first step the data architect should take to build this data model to accurately reflect performance?
A company's analytics team is migrating from QlikView to Qlik Sense. During the transition there is an opportunity to improve overall reporting.Which set of criteria must the data architect consider while planning for the migration?
A data architect needs to upload data from ten different sources, but only if there are any changes after the last reload. When data is updated, a new file is placed into a folder mapped to E:\486396169. The data connection points to this folder.The data architect plans a script which will:
A data architect needs to load large amounts of data from a database that is continuously updated.New records are added, and existing records get updated and deleted.Each record has a LastModified field.All existing records are exported into a QVD file.The data architect wants to load the records into Qlik Sense efficiently. Which steps should the data architect take to meet these requirements?
A company needs to analyze daily sales data from different countries. They also need to measure customer satisfaction of products as reported on a social media website. Thirty (30) reports must be produced with an average of 20,000 rows each. This process is estimated to take about 3 hours.Which option should the data architect use to build this solution?