Qlik Sense Business Analyst
A business analyst has a QVD containing Sales, Manager, Date, and Region. The business analyst needs to quickly create a sheet with three visualizations: Total Sales, Sales By Manager, and Sales by Date. The sheet must allow for analysis by Region. In the search bar, the analyst enters "Sales", "Manager", and "Date", and adds the objects to the sheet. Which steps should the business analyst perform to finish creating the sheet?
1. Add two filter panes: Date and Manager 2. Drag and drop Sales from the Fields list onto the sheet 3. Add a line chart with Manager as the dimension and Sales as the measure
A business analyst creates a KPI visualization to show the total global sales for a large organization. When an expression is written the default format appears as shown. The business users must be able to see the actual number to the last dollar value (e.g., $19,169,020) whenever this KPI is used. Which actions should the business analyst take to meet the requirement?
1. Change the number format to money 2. Check Remove Decirrfal Points under Appearance > Presentation 3. Add the KPI to the master items
A business analyst needs to create an app showing sales data. The app requirements are as follows: - Compare sales for the current year (CY Sales) versus last year (LY Sales)- CY Sales must always be displayed in blue- LY Sales must always be displayed in yellow Which steps should the business analyst take to meet these requirements?
1. Create CY Sales and LY Sales measures as master items and set the required color for each measure2. Create one KPI from the two master item measures
A business analyst uses the data manager to load customer data from a QVD file. The data manager automatically profiles the data, and recognizes City and Country values as Geo data. The app must meet the following requirements:- Country field should be in Geo data format- City should NOT be allowed as a mapping option for the users- There must be an association between the Country and City fields Which actions should the business analyst take to meet these requirements?
1. In the Associations view, select the City field2. Change the format from 'Geo data' to 'General'
A business analyst is building an app for a customer: The customer wants to be able to: - Show row-level transaction details- Access an overview of the most important numbers- Analyze data How should the business analyst order the sheets to meet these requirements?
1. Report: sheet for the row-level details 2. Dashboard: sheet for the overview 3. Analysis: sheet for the analysis
A company is starting to use a new customer account system. The business analyst must include this data in an existing app. Data from the legacy customer account system is already available in the app. Both tables have similar data, but the columns have different names. Which actions should the business analyst take to merge data from both systems?
1. Select Legacy Accounts 2. Click Concatenate tables 3. Select New Customer Accounts 4. Map the tables 5. Click Apply
To analyze current office space utilization, a business analyst must create an office floor plan to show employee density and movements. What are the requirements to create the office floor plan?
A KML file with the floor plan shapes, the office movements, and employee location
Which of the following statements is correct?
A KPI object uses color-coding and glyphs to indicate how actual results relate to expected results.
A hospital billing department is concerned with the performance of the cardiology and orthopedic departments. The billing department wants to add a visualization to an existing app to analyze billing for these two departments. The business analyst must consider the hierarchy of: - The department- The physicians in each department- The procedure performed by the physicians What should the business analyst create to meet the requirements?
A bar chart using master items drill-down A bookmark for the departments
A marketing company must analyze the age of customers who view movies at a theater at least once a month, and where those customers are located. The business analyst must consider several requirements: - Age of customers- Addresses of customers- Frequency of theater visits Which objects should a business analyst use to visualize these requirements?
A histogram and map
Refer to the exhibits. A business analyst must improve the first chart shown to make it look like the second chart. Which two actions should the business analyst take to meet this requirements?
Add Year as an additional dimension Replace the three measures with one measure that calculated Total Sales
A business analyst needs to make a complex pie chart easier to understand. The pie chart shows the total number of customers by customer type. There are 12 customer types. Some customers do NOT have a type assigned. The business analyst needs to: - Show all customers including those without a customer type- See the total number of customers in each customer type Which two visualizations could the business analyst use to meet these requirements?
Bar Chart Treemap
A business analyst must create a bar chart to show the total value of orders processed per day. The dataset loaded by the data architect only contains the OrderNo, OrderDateTime, and OrderAmount. The business analyst creates a calculated field, OrderDate, using the expression, Date(OrderDateTime). The bar chart does NOT present the information correctly. How should the business analyst fix the error?
Change the OrderDate field type to Date' in the format 'YYYY-MM-DD' in the data manager.
A business analyst creates a bar chart and notices the weekdays are NOT in a US default format. The analyst does NOT have permissions to enter the data load editor and edit the data. The analyst only has a few minutes before the meeting to show the insights to a manager. The business analyst wants to quickly customize the chart to show the weekdays in US format. Which action should the business analyst take to fix the chart?
Change the dimension to a calculated dimension using the REPLACE() function.
A business analyst is NOT familiar with the data and is using insight advisor to create a number of visualizations. Which steps should the business analyst take to add the visualizations to a sheet?
Click Generate insights to find visualizations, then click Add to sheet
A wholesaler needs to show sales and products in a PowerPoint presentation. The dimensions and measures are: - Product Name- Sum of Sales- Number of Orders Which two chart types could the business analyst use to meet these requirements?
Combo Chart Scatter Plot
A sales department has a pie chart that displays the total amount of sales by city. Users have requested several changes to the pie chart: - Display the labels in 'Red'- Increase the font size of the title- Change the color of the values to 'Blue' Which technique should a business analyst use to meet these requirements?
Create a custom theme
A business analyst needs to add a reference line to a bar chart. Which action should the business analyst take to meet this requirement?
Create a reference line using Max(Aggr(Sum(Sales),CompanyName))
A client wants to see a bar chart with a single measure and three dimensions: Region, Product Category, and Month. The business analyst creates a bar chart with the measure, Sum(Revenue). Which final step should the business analyst take to complete the chart?
Create a single master dimension with Region, Product Category, and Month
A business analyst needs to present a one-slide story and be able to make selections in a visualization. How should the business analyst meet this requirement?
Create a story and add a sheet from the sheet library that contains the visualization
A Qlick Sense Enterprise data architect creates and publishes an app to a stream and gives access to users. - The users do NOT have access to Qlick Management Console- All dimensions and measures used in the app are created in the master items library Which two actions can the users perform?
Create charts using dimensions and measures from master items Export stories created in the app to a PDF of PowerPoint format
Qlik GeoAnalytics allows you to...
Create map visualizations and apply location-based analytics and functions.
A manufacturer uses a dashboard for analysis Users created many bookmarks to simplify their workflow. An administrator also created some bookmarks in the app based on user feedback The organization needs to republish the app and maintain both the users' and administrator's bookmarks. Which steps should the business analyst take to meet this requirement?
Duplicate the app in Work Request bookmark owner to publish bookmark Replace the existing app
A business analyst must combine the following bar charts on one sheet in a story: - A bar chart that updates with live data- A bar chart that shows static data from a previous period How should the business analyst meet this requirement?
Embed a sheet with the bar chart for live data, then add a snapshot of the bar chart for the static data
A business analyst must arrange the sheets within an app to logically guide user interactions. Which order should the business analyst use to meet this requirement?
High-level dashboard, interactive analysis, reports
Which of the following statements is correct?
In a data story, you can create two types of slides. Blank and Embedded sheet.
A company has customers in 16 countries. The majority of the customers are in Germany A business analyst creates a fitter pane for Country and wants "Germany" listed first. The rest of the countries should be listed in alphabetical order. Which method should the business analyst use to meet this requirement?
In the data manager edit the table, select Country! then select Order from the data profiling card
A business analyst must analyze sales using an existing sales order app.- The Orders table in the app was added from a QVD file using the data manager- The Orders table in the app and the QVD do NOT contain a SalesAmount field- SalesAmount can be calculated by multiplying the Quantity and UnitPrice How should the business analyst add a SalesAmount field into the Orders table?
In the data manager, add a calculated field named SalesAmount with the expression UnitPrice *Quantity
A large organization with more than 100 departments wants to raise money for a donation in the next 30 days. This year, leadership decides to increase employee participation through a competition. Team members of departments that raise $10,000 or more receive two additional holidays. Leadership needs the following capabilities:- Ability to view the total donation amount- Ability to identify departments that raise $10,000 or more Which two visualizations should the business analyst use without set analysis to meet these requirements?
KPI Bar Chart
Visualization design is about encoding data, that is, mapping data onto graphical elements. What is the most efficient of these encodings?
Length
A bus company wants to analyze customer travel patterns to add additional services or create new routes. The business analyst needs to consider the following data: 190 routes across the cityStart and end location of each routeVolume of customers travelling per hourCustomer complaints when buses are full Which visualization should a business analyst use to meet this requirement?
Line Layer Map
You want to show results in multiple currencies. Select the easiest approach to maintain.
Load currency exchange rates table using Qlik DataMarket
A manufacturer has several requirements for its new sales dashboard: - Deliver analytics to mobile devices- Share data with retail partners via a custom portal- Prevent sensitive data from being shared with competitors- Provide governed reusable assets Which capabilities should a business analyst use to meet these requirements?
Mashups Master items Responsive design Configurable security rules
Which of the following statements is true about master items?
Master items reusable assets that can be used throughout the app.
A range of colors between red (using code RGB(229,20,0)) and green (using code RGB(164,196,23)) needs to be used as a gradient in a scatter plot that displays sales and cost by store. The gradient needs to produce visualization shown in the exhibit. What is the most efficient method a business analyst should use to meet this requirement?
Modify the visualization to set a color for the data points with an expression based on a Colormix 1 function
A business analyst is building a dashboard to track customer loyalty. The app has several requirements: A table that shows the total number of purchases by customer A scatter plot that shows the correlation between the number of purchases and total spent by customer A bar chart that shows the top five customers by sales Which two measures should the business analyst use to meet these requirements?
Number of Purchases Purchase Amount
A business analyst wants to develop a Qlick Sense app with some key performance indicators on the dashboard. The analyst decides to use two KPI objects to represent key metrics for the organization. Which two measures should the business analyst use to meet these requirements?
Number of products sold Number of customers
A business analyst must create an interactive table to analyze sales performance for the selected year and the previous year. Which are the correct expressions to meet this requirement?
Option A Selected Year: Sum ({$<Year={$=Only(Year))}>}Sales) Previous Year: Sum({$<Year={$(=Only(Year) -1)}>}Sales)
A business analyst must provide a visualization to show the trends of the number of orders generated per employee. The Customer must be searchable. EmployeeID, EmployeeName, OrderID, and CustomerID will be included in the load. Which additional fields must be loaded to meet this requirement?
OrderDate, Customer
After the latest data reload, a business analyst notices the value for CategoryID 'B321 appears to be different from the other values. What is causing this difference?
Pre-aggregated data is being used
Which three actions can a business analyst complete in the Qlick Sense Enterprise hub?
Publish an app into a stream Publish a sheet into the Community section Load data from multiple sources
A business analyst creates a scatter plot and wants to save it for reuse by colleagues. The business analyst must remain the owner of this scatter plot, and should be the only person allowed to make changes. These changes should be applied automatically to all instances of this visualization. Which two actions should the business analyst take to meet these requirements?
Publish the app to the Everyone stream Add the finished scatter plot to the master items
A business analyst must create a set of managed reports that: - Can be distributed via email- Has a central resource so users can view historical reports- Will have a format so that the users can add content- Will refresh and distribute reports on a schedule- Enables users to manage their own report subscriptions Which Qlik capability should the business analyst use to meet these requirements?
Qlik NPrinting
The sales department requests a new Qlick Sense app to show the amount of sales in each territory. The app must: - Allow analysis of aggregate views of big data stores- Include objects that allow the user to jump to a specific sheet- Provide a way to send a report through email Which three products or features should the business analyst use to meet these requirements?
Qlik NPrinting On Demand App Generation Bookmarks
A business analyst develops apps for users to independently visualize their data to gain insights. The users have desktop computers, tablets, and mobile devices. When creating the apps, the business analyst does NOT need to know the specific device on which it will be consumed.
Responsive design
A business analyst must create new master items for quarterly calendar measures with company-specific naming conventions based on: - The Date field and the Sum of Sales- The new master items will calculate QTD Sales, Current QTD Sales, Last QTD Sales, Current Quarter Sales, Last Year Current Quarter Sales, and Last Quarter Sales Which three steps should the business analyst take to meet these requirements?
Save to master items, rename master items Right-click the Sales field in the assets panel and select Create calendar measures Select Date, Sales, Sum, and Quarterly
A retailer with 300 locations worldwide needs to analyze its workforce to prepare for its next board meeting. The two most important items to the board members are total compensation and number of employees by city. Which visualization should a business analyst use to meet this requirement?
Scatter plot
A business analyst must update an app by adding a new table called 'Invoices'. This table must be associated to the existing model via reference code values. There is NO column available with reference codes in the Invoices table. This information can only be retrieved by splitting a field called 'Full Invoice No' from the Invoices table 'Full Invoice No' includes the 'CostCenter Code', the 'Department Code', and a 'Reference Code' The CostCenter Code is NOT relevant for further analysis, so the analyst must split this new field into two new columns. Which set of actions should the business analyst take to meet these requirements?
Select the split marker Click All instances Uncheck the first column Rename the fields Click Create fields
A printing company has several requirements for a new Qlick Sense app: - Report of daily work orders- Total number of print jobs- Print jobs based on region- Total number of print jobs by month The app will be used by executives, sales managers, sales representatives, and press workers. Which sheets should a business analyst build to meet these requirements?
Sheet 1: Details page that shows the daily print jobs in a tableSheet 2: Dashboard with a KPI visualization of total print jobs by month, customer, sales representative, and regionSheet 3: Report page that shows the daily print jobs
A business analyst is creating a dashboard to analyze supply chains. The app must contain several elements: - A bar chart that shows a number of products and product groups handled by shipper- A map that shows the number of shipments sent from factory locations- A bar chart that shows average delivery costs by shipper Which dimensions should the business analyst use for this app?
Shipper, FactoryLocation
Which two features/functions are enabled by the Qlik Associative Engine?
Smart search and data profiling
What does the color light gray indicate in the selections tool?
The field value is an alternative selection
Which of the following statements is correct?
The grouping, by which you want to show results in a chart is known as the dimension.
A business analyst is testing an existing app that returns unexpected results. Using the selection tool, the business analyst observes the following behavior. Select a CompanyName and the associated OrderID records are white Select a Year and all OrderID records are gray Select an OrderID and the Quarter values are all gray, but the CompanyNames are white Select a ProductID and the associated ShipperName and OrderDates are white, but the Year is gray What is causing these results?
The logical model is NOT a star schema
A business analyst needs to create a new application for an organization. The new application should enable sales data analysis at the year, month, week, and day level based on the date of individual transactions. The application should also enable users to analyze transactions by regions and products. The organization has operations worldwide. Each region represents a group of different countries. The sales department defines these ad-hoc groups. An existing QVD file that contains all the data needed has been identified as a potential source. What are the minimum fields that the analyst should expect to find in the QVD file?
Transaction Date, Country, Sales Amount, and Product_ID
A retailer with 300 locations worldwide needs to analyze revenue to prepare for its next board meeting. The retailer needs to view the distribution of its total revenue by continent and country. A business analyst has created a bar chart that provides a drill-down option from continents to countries. However, the board wants to visualize all data in one chart without drill down or scrolling. Which visualization should the analyst use?
Treemap
A marketing team needs to analyze current sales by age groups in a bar chart. The following age groups are created in the data manager and the field is named AgeGroup: - Children 16 years old and younger- YoungAdult: 17 to 30 years old- Adult: 31 years old and older The business analyst will use an expression to set the colors for the bars: If ( [AgeGroup] = 'Children', Red() , If ([AgeGroup] = ' Your.gAdult', Blue () , Green())) Which steps must be completed to apply the correct colors in the visualization'?
Under Appearance in the properties panel, select Color then select Color by expression and make sure that The expression is a color code is checked
A business analyst is using a box plot to show distribution. The data scientist provides the formulas to configure a custom box plot. Which action(s) should the business analyst take to meet these requirements?
Under Box plot elements, disable Use presets and enter the given formulas in the expressions field
A business analyst needs to add some images to a slide in a story in their personal workspace in Qlik Sense Enterprise. What should the business analyst do to meet this requirement?
Upload the images to the media library and add to the story slide
A CEO of an automotive manufacturing company wants a single dashboard sheet to track the company's sales. The app must meet several requirements: - All charts must be on one sheet - Show summary charts of key performance data - Ability to scroll up and down the sheet Which set of actions should the business analyst use to meet these requirement?
Use KPI objects Activate Extend sheet
Which of the following statements is correct?
When you use Qlik Sense on a very small screen (480 pixels wide or smaller), you can make selections and navigate between apps, sheets, visualizations, and stories, but you cannot create new content or take snapshots.