Data Sourcing, Security & Modelling

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 ?

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