Qlik Sense Business Analyst (QSBA)
Exam Questions and Correct Answers
Data Sources - ANSWER Data connectors, Data files, Manual entry
Data files - ANSWER include Delimited files (csv, txt, tab, qvo, mem, skv,prn,log)
and Excel workbooks (Excel files) (xls,xlw, xlsx, xlsm)
Add data - ANSWER Through Data catalog, drag and drop files or script editor
(Data load editor)
Delimiter - ANSWER identifies the boundaries between values in each field.
to parse - ANSWER divide into parts
Embedded field names are - ANSWER Header in Datatables, the Header size
indicates the number of rows of the header.
Data loaded from the editor - ANSWER Data files loaded from the script editor, present
a preview of the load script, generate automatical a load script, open to use, but the
data must be loaded separately.
Adding data from files and other sources - ANSWER opens the list of connectors, gives
the possibility to drop or select a file or to entry manual data. Large or small tiles and a
search function can be chosen for the connectors.
There is no preview for the load script available. This option also provides a filter or
restriction for the data to be loaded by the fields: Table, Field, Condition and Value.
By clicking the 3 dots to the NEXT button, data profiling can be disabled or enabled.
A locked auto-generated section in the script editor will be created and is indicated by
,the alert Massage: This script section is auto generated by Data Manager and locked
with a padlock symbol. And the load data actions was automatic generated.
delimited file format - ANSWER means, that the fields are separated by a
delimiter, wether a comma, tab, semicolon...
Data Profiling enabled - ANSWER -Date groupoing are automatically derived from
fields containing date or timestamp values to group values by year, month, week, etc...
-Geo data (for use in Map charts) is automatically derived from city names, country
names, country codes, or latitudes and longitude values.
-Before data is loaded, associations between tables must be defined within the
Data manager's bubble-and-link view
Data profiling disabled - ANSWER no derived date groupings, no derived geo data,
Associations are formed between tables using matching field names as key fields.
To create associations - ANSWER use Data manager view
Adding Data from Data Manager - ANSWER Use the Plus symbol to add data (choice
between Data catalog and Files and other Sources) -> Navigate to Manual entry, drop
a file here or connect to a new data source. Choosing drop a file to open a file. Choose
file and a navigation with the preview of the table (file format, field names, delimiters,
Quoting ...) opens.
Bubbles in the data manager - ANSWER One Bubble is representing one table when
tables are loaded, they are generally not associated/related to each other. On the
recommended associations panel the recommended field for the association is shown.
Clicking and holding a bubble indicates green=very confident in reccomendation (or
other circles arround the other bubble(s)) Dragging one bubble over another creates
,an association. The Preview shows the matching fields (green colored) and the rest of
associated tables. To complete the association process, teh data has to be loaded.
An additional load statement will be created in the script editor. The Data model viewer
shows the connection between the tables through the Key field - to be identified with
teh key icon.
Recommended associations can be previewed and clicking on the links between the
bubbles shows the preview of teh associated key fields and associations. After
verifying the associations teh recommendations can be applied.
break the association - ANSWER By clicking on the link/association between the
bubbles and pressing the traschcan icon on the button of the sheets teh association
can be broken (first a window opens "are you sure you want to break this association"?
To execute teh change load data.
Manual entered table - ANSWER is presented as an unassociated bubble after first
load.
Differences of data loads in diverse Qlik Sense Variationen - ANSWER Add Data files
Qlik Sense Enterprise on Windows:
(Plus=drop file or data source connectors/ In app: attach local files, manual entry)
Qlik Sense Desktop:
In App: Manual Entry
Plus:Connectors
My computer: local files
Issue: Bar charts have all the same hight - ANSWER Association between the
dimension and measure is missing.
, Panels in Qlick sense - ANSWER Asset panel on the left(Fields, Master Items, Charts,
Custom objects)
Sheet properties panel on the left side (Titel, Title expression, conditions,
description, thumbnail)
Opening my new sheet - ANSWER A default or advanced sheet editing view is
presented. (depending on the Qlik sense version used). The default sheet editing view
uses the insight advisor for the creation of the sheet. Toggeling the view to the
advanced options shows the (normal views) with an assets panel on teh left and
a properties panel on the right. with a denterspace dedicated to vizualisations.
The example sheet can be deleted.
Add date from the Asset Panel field section - ANSWER Add data (wheather data
catalog or files and other sources). Chose from In App, Manual entry, Data connectors
or data uploads.
Loading an excel workbook with multiple sheets - ANSWER one or multiple tables can
be chosen to be loaded.
Toggle - ANSWER To switch between two options or to turn a feature on or off.
Data load workflows - ANSWER Business analyst: Add data->Select data->Data
profiling disabled (When associations are to be made on matching field names and no
derived date groupings or geodata is wished) or data profiling enabled (will lead to
Data manager to create associations and needs execution of data loading
Data Architect: Script editor->create new connection->select data->insert script->Load
data
Chart suggestion assistance - ANSWER is triggered by dragging and dropping fields
onto the visualization area.
Exam Questions and Correct Answers
Data Sources - ANSWER Data connectors, Data files, Manual entry
Data files - ANSWER include Delimited files (csv, txt, tab, qvo, mem, skv,prn,log)
and Excel workbooks (Excel files) (xls,xlw, xlsx, xlsm)
Add data - ANSWER Through Data catalog, drag and drop files or script editor
(Data load editor)
Delimiter - ANSWER identifies the boundaries between values in each field.
to parse - ANSWER divide into parts
Embedded field names are - ANSWER Header in Datatables, the Header size
indicates the number of rows of the header.
Data loaded from the editor - ANSWER Data files loaded from the script editor, present
a preview of the load script, generate automatical a load script, open to use, but the
data must be loaded separately.
Adding data from files and other sources - ANSWER opens the list of connectors, gives
the possibility to drop or select a file or to entry manual data. Large or small tiles and a
search function can be chosen for the connectors.
There is no preview for the load script available. This option also provides a filter or
restriction for the data to be loaded by the fields: Table, Field, Condition and Value.
By clicking the 3 dots to the NEXT button, data profiling can be disabled or enabled.
A locked auto-generated section in the script editor will be created and is indicated by
,the alert Massage: This script section is auto generated by Data Manager and locked
with a padlock symbol. And the load data actions was automatic generated.
delimited file format - ANSWER means, that the fields are separated by a
delimiter, wether a comma, tab, semicolon...
Data Profiling enabled - ANSWER -Date groupoing are automatically derived from
fields containing date or timestamp values to group values by year, month, week, etc...
-Geo data (for use in Map charts) is automatically derived from city names, country
names, country codes, or latitudes and longitude values.
-Before data is loaded, associations between tables must be defined within the
Data manager's bubble-and-link view
Data profiling disabled - ANSWER no derived date groupings, no derived geo data,
Associations are formed between tables using matching field names as key fields.
To create associations - ANSWER use Data manager view
Adding Data from Data Manager - ANSWER Use the Plus symbol to add data (choice
between Data catalog and Files and other Sources) -> Navigate to Manual entry, drop
a file here or connect to a new data source. Choosing drop a file to open a file. Choose
file and a navigation with the preview of the table (file format, field names, delimiters,
Quoting ...) opens.
Bubbles in the data manager - ANSWER One Bubble is representing one table when
tables are loaded, they are generally not associated/related to each other. On the
recommended associations panel the recommended field for the association is shown.
Clicking and holding a bubble indicates green=very confident in reccomendation (or
other circles arround the other bubble(s)) Dragging one bubble over another creates
,an association. The Preview shows the matching fields (green colored) and the rest of
associated tables. To complete the association process, teh data has to be loaded.
An additional load statement will be created in the script editor. The Data model viewer
shows the connection between the tables through the Key field - to be identified with
teh key icon.
Recommended associations can be previewed and clicking on the links between the
bubbles shows the preview of teh associated key fields and associations. After
verifying the associations teh recommendations can be applied.
break the association - ANSWER By clicking on the link/association between the
bubbles and pressing the traschcan icon on the button of the sheets teh association
can be broken (first a window opens "are you sure you want to break this association"?
To execute teh change load data.
Manual entered table - ANSWER is presented as an unassociated bubble after first
load.
Differences of data loads in diverse Qlik Sense Variationen - ANSWER Add Data files
Qlik Sense Enterprise on Windows:
(Plus=drop file or data source connectors/ In app: attach local files, manual entry)
Qlik Sense Desktop:
In App: Manual Entry
Plus:Connectors
My computer: local files
Issue: Bar charts have all the same hight - ANSWER Association between the
dimension and measure is missing.
, Panels in Qlick sense - ANSWER Asset panel on the left(Fields, Master Items, Charts,
Custom objects)
Sheet properties panel on the left side (Titel, Title expression, conditions,
description, thumbnail)
Opening my new sheet - ANSWER A default or advanced sheet editing view is
presented. (depending on the Qlik sense version used). The default sheet editing view
uses the insight advisor for the creation of the sheet. Toggeling the view to the
advanced options shows the (normal views) with an assets panel on teh left and
a properties panel on the right. with a denterspace dedicated to vizualisations.
The example sheet can be deleted.
Add date from the Asset Panel field section - ANSWER Add data (wheather data
catalog or files and other sources). Chose from In App, Manual entry, Data connectors
or data uploads.
Loading an excel workbook with multiple sheets - ANSWER one or multiple tables can
be chosen to be loaded.
Toggle - ANSWER To switch between two options or to turn a feature on or off.
Data load workflows - ANSWER Business analyst: Add data->Select data->Data
profiling disabled (When associations are to be made on matching field names and no
derived date groupings or geodata is wished) or data profiling enabled (will lead to
Data manager to create associations and needs execution of data loading
Data Architect: Script editor->create new connection->select data->insert script->Load
data
Chart suggestion assistance - ANSWER is triggered by dragging and dropping fields
onto the visualization area.
