Discussion-4.1

Discussion-4.1

University of the Potomac

CBSC520 Data Analytics

I would select Chapter-3 which is finding relation among Variables

Sub Topic – Pivot Tables and charts

As we all know that pivot tables and charts are the powerful excel tool for statisticians to breakdown the data into categories and it will be helpful to list counts, sums, averages, and other summary measures. Based on the business requirement we can manipulate the data and create reports by using pivot tables and charts in excel (Albright & Winston, 2017, p.108).

Any data science professional or any programmer who are working on data will have an idea on these concepts. Personally I as a clinical SAS programmer would work extensively on clinical data where I would manly deal with many variables which in turn have many observations in each variable, sometimes I would need to merge the datasets to get few variable from one table to the other and create a data set, in this situation I would see for the relation ship in the datasets to merge the tables and sort them in an order and then create the dataset. If the relationship of the variables are not well defined then the sorting order will be messed up an I wont be presentable to the federal authority and won’t be understandable.

References:

Albright, S. C., & Winston, W. L. (2017). Business Analytics – Data Analysis and Decision Making. Cengage Learning.