Font size
WorksheetsData Sourcing, Security & Modelling
Total questions: 12
Worksheet time: 7mins
A folder containing video files is an example of what type of data ?
Unstructured - Nominal Data
Structured -Discrete Data
Unstructured - Ordinal Data
Structured - Continuous Data
Which of the Following are included in the 5 V's of Big Data, and as such all of our Data ?
Veracity
Voluptuous
Value
Volume
Variation
SAP and Hi-Next are examples of what type of systems ?
(a)
Which of the images below represent an optimal model ?
A good data model makes reporting.... ?
time consuming and just adds time to development
and analysis easy for analysts and end users
easier by ensuring all your data is stored in one table
possible when many to many relationships are used
__ Are tables that change often, with a new row every time there is a new transaction and support the summarisation of information.
Frankentables
Measures
Dimension Tables
Relationships
Fact Tables
You have a table in your model with a number of employees and need to know how many, what is the best practice way to find out when building your report?
Drag the Employee Number column into a Card Visual to show the total number
Drag the Employee Name column into a table and add a Total Row
Manually counting the rows, in groups of 10 if helpful
Create an explicit measure using DAX to count distinct employees
Create an explicit DAX calculated column to count the number of instances of a name
Where should you go first when you need data to build your model ?
The data source
The data catalogue
SAP BW
The BI Team
If the data you need is not catalogued which of the following steps should you follow ?
Identify the source of the data and collection method
Request access to the dataflow from the data owner
Liaise with the BI team to develop Extract Transform and Load and add to catalogue
Identify the dataflow owner
At what stage of the development process should you consider data security and access ?
All the way through your development process
At the end as you are about to publish your reports
Security does not need to be considered, it's important
At the scoping stage to consider the design from the start
____________is Information that, if disclosed, could result in harm or loss to the individual to whom it concerns
Non-Sensitive Data
Deliberate Data
Accidental Data
Sensitive Data
Why do we use Dataflows ? (Select all that apply)
Slowest Run-Time
Consistent Definition
Timeliness
Security & Permissions
Optimising Load
