Ali Bagheri MSIS 3223 Exam 1 Questions With 100% Correct Answers.

Ali Bagheri MSIS 3223 Exam 1 •Common mathematical operators are used - -addition (+) -subtraction ( -) -multiplication (*) -division (/) -exponentiation (^) Absolute references - $A$2, $C5, D$10 Advanced Filter - provides a way of explicitly defining criteria by which to filter a database. •First, copy the headers from the database to an open location in the worksheet. Under the headers, specify the criteria that you want to use to filter the data. -Multiple criteria in the same row are logically joined by "and," while criteria in rows are joined by "or." Advantages of Using Tableau - Fantastic Visualizations -You can now work with a lot of data that doesn't have any order to it and create a range of visualizations. Well, thanks to the in -built features of Tableau which help you create visualizations that stand out from the crowd. You al so have the option of switching between different visualizations to bring about a greater context, ways of drilling down data, and exploring the data at a minute level. Advantages of Using Tableau (cont.) - -Tableau can help enterprises futuristically to: ▪Analyze data without any specific goals in mind. ▪Explore visualizations and have a look at the same data from different angles. ▪Frame 'what if' queries and work with data by hypothetically visualizing it in a different manner and dynamically adding components for comparison and analysis.. Area Charts - •An area chart combines the features of a pie chart with those of line charts. -Area charts present more information than pie or line charts alone but may clutter the observer's mind with too many details if too many data series are used; thus, they should be used with care. Assumptions are made to - -simplify a model and make it more tractable; that is, able to be easily analyzed or solved. -better characterize historical data or past observations. •The task of the modeler is to select or build an appropriate model that best represents the behavior of the real situation. Benefits - reduced costs, better risk management, faster decisions, better productivity and enhanced bottom -line performance such as profitability and customer satisfaction. Big data - refers to massive amounts of business data (volume) from a wide variety of sources (variety), much of which is available in real time (velocity), and much of which is uncertain or unpredictable (veracity). Bubble Charts - A bubble chart is a type of scatter chart in which the size of the data marker corresponds to the value of a third variable; consequently, it is a way to plot three variables in two dimensions Business Analytics - is s the use of:•data, •information technology, •statistical analysis, •quantitative methods, and •mathematical or computer -based models to help managers gain improved insight about their business operations and make better, fact -based decisions. Categorical (nominal) data - sorted into categories according to specified characteristics Categorical variables - naturally define the groups in a frequency distribution. Challenges - lack of understanding of how to use analytics, competing business priorities, insufficient analytical skills, difficulty in getting good data and sharing information, and not understanding the benefits versus perceived costs of analytics studies. coefficient of variation (C V) - provides a relative measure of dispersion in data relative to the mean: -Sometimes expressed as a percentage. -Provides a relative measure of risk to return. Column and Bar Charts - -A clustered column chart compares values across categories using vertical rectangles; -a stacked column chart displays the contribution of each value to the total by stacking the rectangles; -a 100% stacked column chart compares the percentage that each value contributes to a total. •Column and bar charts are useful for comparing categorical or ordinal data, for illustrating differences between sets of values, and for showing proportions or percentages of a whole. Commercial software - -IBM Cognos Express -SAS Analytics -Tableau Concatenation - •To concatenate means to join. In many applications, you might wish to take text data that are in different columns and join them together (for example, first and last names). The Excel function CONCATENATE(text1, text2, . . . , text30) can be used to join up to 30 text strings into a single string.