Font size
WorksheetsDATA ANALYTICS BASICS
Total questions: 75
Worksheet time: 38mins
Statistical Techniques
Collect
Store
Process
Analyze
Visualize
Load Data to one source to another
Collect
Store
Process
Analyze
Visualize
methodical exploration of an organization's data through statistical analysis
Business Process
Business Outsourcing
Business Management
Business Analytics
According to evolution of analytics about volume of data 10X data growth by 2016 90% ______
Structured
Unstructured
Sensors
Text
Type of Business Analytics refers to "what happened?"
Prescriptive
Diagnostic
Descriptive
Predictive
Below are sample of analytic tools except?
Micro strategy
Statistics
Google Analytics
Tableu
Understand reason behind happening some event.
Diagnostic
Predictive
Descriptive
Prescriptive
Type of Analytics refer to future outcomes
Predictive
Prescriptive
Diagnostics
Descriptive
Type of analytics tells "what should I do?"
Diagnostics
Descriptive
Predictive
Prescriptive
Following are analytics techniques except
Telecom
Text Mining
Forecasting
Steaming
The fifth phase in Customer Life Cycle
Acquisition
Defection
Reach
Conversion
Graduation of acquired customer to actual customers is called
Acquisition
Defection
Reach
Conversion
Average Sale Value = 25
Number of Transactions per year = 3
Retention Period = 2
Profit Margin = 22% CLV is
35
150
33
155
If CLV is $233 and marketing for retention is $50 annually, how long might a company want to maintain a relationship with this customer?
2 years
3 years
4 years
5 years
__________________ Analysis is the process of analyzing the subjectivity/objectivity of a statement or a comment or a response.
Regression
Sentiment
Predictive
Statement
Number of Comments is 2000, the reach is 20000, what is the conversation rate?
5 percent
15 percent
.10 percent
10 percent
Number of Likes - 1000, Number of Reach - 5,00,000 then the applause rate is?
0.5 percent
10 percent
0.2 percent
0.8 percent
___________ is the percentage of page visitors who click on a link in your post, only to quickly leave the page they land on without taking an action
Click through Rate
Conversion Rate
Conversation Rate
Bounce Rate
In this attribution model, equal weightage is given to all channels
Last Interaction
Linear
Time Decay
Position Based
The account structure of google analytics is
Property-View-Account
Account-View-Property
Account-Property-View
Account-Property-Data
Why was Python (TM) developed?
To go back to the old way of programming
To create a programming language for students in grade school
To make it easier to learn Java
Python was developed by accident
Python (TM) is owned and managed by
Microsoft (c)
Sun Microsystems (c)
Python (TM) is open source and free to use
Google (c)
Python is ___________ level programming language and is ___________.
High, compiled
High, interpreted
Low, compiled
Low, interpreted
Generally speaking, a low level programming language is easier to read, write and maintain over a high level programming language
True
False
The syntax in Python (TM) is one of the main advantages over other high level programming languages.
True
False
A statement in programming
Expresses an action to be carried out
Always returns results like expressions
Rules controlling how components in a program are combined
An instruction to perform a task, usually one word
A string
carries out an action
the elements of a command
a collection of characters
how elements in a commad are arranged
A block is
a statement including elements of a command
the structure and form of the code
source code that is grouped together
meaning assigned to symbols, characters and words
What symbol comes before a comment?
$
>>
#
!
An exception is
the structure of form of the code
the meaning of the characters and words in the code
the statement that is missing from the instructions
an event occurring during execution of a program which disrupts the flow of the program's instructions
Debugging is
how characters are arranged in a statement
detecting or removing errors from a program
removing viruses from a computer
the meaning of each of the characters and symbols in the program
A disadvantage of Python is it is harder to debug than other higher level programming languages.
True
False
In programming, a (n) _______________ is a value that can change, depending on conditions or on information passed to the program
string
block
instruction
variable
Generally speaking Python (TM) would run _____________ than C++ and take ____________ time to create
faster, less
faster, more
slower, less
slower, more
Since Python (TM) is open source,
Support for using Python (TM) is easy to find
It is free
There is a large catalog of supporting documents
it is a less powerful programming languange
At the heart of computer is its central processing unit. The CPU's job is:
To fetch instructions
To carry out the operations commanded by the instructions
To produce some outcome or resultant information
All of these
An Integrated Development Environment typically consists of:
A text editor
A compiler
A debugger
All of these
___ is used to translate source code instructions into the appropriate machine language instructions
Module
Library routine
Compiler
Preprocessor directives
The program written by the programmer with high level language is called:
Object Code
Syntax
Source Code
Runtime Library
Computer programs are also known as:
Hardware
Software
Firmware
Silverware
Which of the following is not a high level programming language?
Assembly
C++
Java
Python
A ____ is a set of instructions that the computer follows to solve a problem.
Compiler
Linker
Operator
Program
What is the extension of C++ program source code?
.c
.cpp
.py
.java
Common errors in C++ consist of:
Compile error
Run time error
Logic error
All of the above
Which one of the following is not a valid variable name?
_examveda
exam_veda
1examveda
examveda1
Who is the parent company of Tableau?
Microsoft
Salesforce
Workday
Which of these is NOT a tableau file format?
twb
twbx
tde
tdb
Tableau can connect to both local and on server files
True
False
Where can you change chart type, color, size, and other aspects of your visualization?
Show Me
Dimensions
Measure
Marks card
In Hans Rosling's video in the Virtual digital academy, what did he visualize?
GDP per capita, Child survival %, Country, Year, Total GDP
GDP per capita, Internet user per 100, Country, Year, Total internet users
Income per person, Life expectancy, Country, Year, Population
Health spend per person, Life expectancy, Country, Year, Population
Problem, Data, Question, _______ , and Format are the 5 points of the guiding star for any visualization
Timeline
Audience
Complexity
Visualization
A _____ can be used to replace a constant value in a calculation, filter, or reference line.
Parameter
Variable
Token
Change
Which of the following is NOT a Tableau Field data type?
Number (whole)
String
Boolean
Float
Do you really want this training to be interactive and useful?
Yes, definitely!
No, I am used these lectures!
Who is going to be the first to ask a question / share their screen and walk us thro the exercise?
Me!
No way, I was just kidding in the previous question.
A dashboard object that organizes multiple sheets side by side is called a:
Vertical container
Floating object
Text object
Horizontal container
What activity can you NOT do from the Layout Panel?
Add a new sheet or object
Adjust a sheet's position or size
Add a border
Adjust outer or inner padding
A single filter can only be applied to ONE sheet in a dashboard or it must be applied to ALL sheets in a dashboard.
True
False
For showing metrics trended over time, it is best practice to use which chart type?
Bar chart
Line graph
Pie chart
Box and whisker plot
For comparing metrics between groups, it is best practice to use which chart type?
Bar chart
Line graph
Pie chart
Box and whisker plot
There are three kinds of actions that can be applied to dashboard components. Which of the below is NOT a dashboard action?
Highlight
Calculation
Filter
URL
Which of the below is NOT considered a Best Practice for dashboard creation?
Make your dashboard interactive
Keep your dashboard current
Give the user as much information as you possibly can
Include visually descriptive components
When creating a dashboard, ________ objects can be placed anywhere on the page, regardless of fit or overlapping.
Image
Tiled
Button
Floating
Filter actions that are sourced from sheets in one dashboard can be made to apply to target sheets in another dashboard in the same workbook.
True
False
The only way to add a title to your dashboard is to use a text object.
True
False
How can you format a piece of text so that the user knows it is a hyperlink?
Increase the text point size
Underline it and color it blue
Enclose it with a border
Place its view in a vertical container
A Web Page object displays:
A view of the web page
A hyperlink to an internet site in a new browser
A list of web pages relevant to the content of the dashboard
A full web browser (i.e., Firefox, Chrome, etc.)
Which boxplot is skewed?
CC
CT
Calculate the IQR for each box and whisker plot.
(IQR = Qu - QL)
CC=16
CT=7
CC=7
CT=16
CC=108
CT=116
CC=8
CT=17
Which boxplot has the largest median?
CT
CC
Both are the same
Are there any outliers?
Yes
No
The minimum value of boxplot CC is 90, true or false?
True
False
The Q1 value of boxplot CT is just below 100, true or false?
True
False
Does the two boxplot have the same shape?
yes
no
The boxplot CC is short this suggests that
the results were in a high level of agreement
the results were in a low level of agreement
nothing
