Comprehensive Data Analytics Project Using Excel and Tableau for the Sales and Purchases Cycles

2021 ◽  
Author(s):  
Karen Schuele ◽  
Elizabeth Felski
Keyword(s):  
Data Model ◽  
Data Analytics ◽  
Microsoft Excel ◽  
Comprehensive Data ◽  
Accounting Courses ◽  
The Common ◽  
The Right

Using materials from PwC’s data analytics case study with a fictitious company, Pixystems Toy Company, Inc. (PwC, 2017), henceforth Pixystems Toys, the authors developed a comprehensive, multi-part data analytics project applicable in a variety of accounting courses.  The project follows the common data analytics framework (ask the right questions, extract, transform and load (ETL) the data, perform appropriate analyses and present the results).  Students apply this framework to the sales and purchases cycles.  For each students develop relevant questions, build a data model and perform other ETL procedures, perform analytics and prepare a presentation to convey insights and recommendations.  For the sales cycle, Microsoft Excel is the analytics tool; for the purchases cycle, Tableau is used. This project provides an opportunity for students to gain experience with two analytics tools, understand the process of building a data model, and wrestle with how to convey the results of their analysis.

scholarly journals Corporate libraries: The right to life

2018 ◽  
pp. 37-50 ◽  
Author(s):  
I. E. Paramonova
Keyword(s):  
Information Needs ◽  
Social Institution ◽  
Library Science ◽  
Component Library ◽  
Traditional Concept ◽  
Library Development ◽  
The Common ◽  
The Right ◽  
Core Features

The richness of the term “library” is revealed: from the common meaning (a depositary, collection of books and other publications) to that of the library science object (an institution, social institution). The attempt is made to identify whether corporate book collections make a document array, internal book collection, or a library. The case study of the “Laboratory of urban planning” Company (St. Petersburg) is offered. The main stages of the Company’s library development and vectors of work are discussed. Other corporate libraries’ experience is examined. The common features of the corporate and special, e.g. sci-tech, libraries, that satisfy information needs and demands in professional sphere, are revealed.The author also attempts to apply Yury Stoyarov’s four-component library model to the corporate library phenomenon. She speculates on whether the library core features are applicable to a corporate library – namely, collection purpose, document array orderliness, librarian supply. The differences between the traditional concept of a library and a library as a live selforganizing system are revealed. The need to include corporate libraries into the library science subject scope and therefore to expand social influence of librarians is emphasized.

The Challenge of a Corporate Matchmaker

2010 ◽  
pp. 108-120
Author(s):  
Francisco Chia Cua
Keyword(s):  
Single Case ◽  
Business Case ◽  
Single Case Study ◽  
Request For Proposal ◽  
Archival Documents ◽  
The Common ◽  
The Right ◽  
Depth Interviews ◽  
Case Development

The common structured procurement process of the Request for Information (RFI), Request for Proposal (RFP), and Business Case Development (BCD) is thought to establish ties with the right vendors and to strengthen relationships among other stakeholders. This single-case study gathered information through archival documents, observations, and in-depth interviews and examined whether RFI-RFP-BCP processes fostered favourable relationships with vendors. The study revealed certain disadvantages of the process.

Not So Fuzzy Audit Analytics

2020 ◽  
Author(s):  
Jamie Hoelscher ◽  
Trevor Shonhiwa
Keyword(s):  
Data Analytics ◽  
Microsoft Excel ◽  
Comprehensive Data ◽  
Using Data ◽  
Data Analytic

In this case, students are introduced to audit analytics, specifically the use of the fuzzy lookup tool available in Microsoft Excel.  Students will use both conditional formatting and the fuzzy lookup tool to examine a dataset for possible instances of fictitious vendor fraud, a common and often costly type of fraud.  The case takes students through the comprehensive data analytics cycle as students are instructed how to test for fictitious vendors using data analytic techniques.  Students will then rely on the underlying data to analyze potential relationships and trends and communicate results via a memorandum, while being introduced to other common preventive and detective controls related to mitigate the risk of fictitious vendors.

Our Bodies, Whose Property?

2013 ◽  
Author(s):  
Anne Phillips
Keyword(s):  
Labor Markets ◽  
Personal Autonomy ◽  
The Body ◽  
Body Parts ◽  
Complex Issue ◽  
Human Organs ◽  
Property Owners ◽  
The Common ◽  
The Difference ◽  
The Right

No one wants to be treated like an object, regarded as an item of property, or put up for sale. Yet many people frame personal autonomy in terms of self-ownership, representing themselves as property owners with the right to do as they wish with their bodies. Others do not use the language of property, but are similarly insistent on the rights of free individuals to decide for themselves whether to engage in commercial transactions for sex, reproduction, or organ sales. Drawing on analyses of rape, surrogacy, and markets in human organs, this book challenges notions of freedom based on ownership of our bodies and argues against the normalization of markets in bodily services and parts. The book explores the risks associated with metaphors of property and the reasons why the commodification of the body remains problematic. The book asks what is wrong with thinking of oneself as the owner of one's body? What is wrong with making our bodies available for rent or sale? What, if anything, is the difference between markets in sex, reproduction, or human body parts, and the other markets we commonly applaud? The book contends that body markets occupy the outer edges of a continuum that is, in some way, a feature of all labor markets. But it also emphasizes that we all have bodies, and considers the implications of this otherwise banal fact for equality. Bodies remind us of shared vulnerability, alerting us to the common experience of living as embodied beings in the same world. Examining the complex issue of body exceptionalism, the book demonstrates that treating the body as property makes human equality harder to comprehend.

Data Analytics to Help Improve Hydraulic Fracture Geometry Prediction Using Support Vector Regression: Case Study

2020 ◽  
Author(s):  
Avinash Wesley ◽  
Bharat Mantha ◽  
Ajay Rajeev ◽  
Aimee Taylor ◽  
Mohit Dholi ◽  
...  
Keyword(s):  
Support Vector Regression ◽  
Hydraulic Fracture ◽  
Data Analytics ◽  
Support Vector ◽  
Fracture Geometry

Ameloblastic Fibroma Associated With Impacted 3rd Molar: A Case Report

2017 ◽  
Vol 1 (7) ◽  
pp. 18-21
Author(s):  
K Indira Priyadarshini ◽  
Karthik Raghupathy ◽  
K V Lokesh ◽  
B Venu Naidu
Keyword(s):  
Relative Frequency ◽  
Posterior Region ◽  
Radiographic Examination ◽  
Dental Eruption ◽  
Ameloblastic Fibroma ◽  
Odontogenic Origin ◽  
The Common ◽  
The Times ◽  
The Right ◽  
Slow Growing

Ameloblastic fibroma is an uncommon mixed neoplasm of odontogenic origin with a relative frequency between 1.5 – 4.5%. It can occur either in the mandible or maxilla, but predominantly seen in the posterior region of the mandible. It occurs in the first two decades of life. Most of the times it is associated with tooth enclosure, causing a delay in eruption or altering the dental eruption sequence. The common clinical manifestation is a slow growing painless swelling and is detected during routine radiographic examination. There is controversy in the mode of treatment, whether conservative or aggressive. Here we reported a 38 year old male patient referred for evaluation of painless swelling on the right posterior region of the mandible associated with clinically missing 3rd molar. The lesion was completely enucleated under general anesthesia along with the extraction of impacted molar.

Penerapan Metode Klasifikasi Decision Tree dan Algoritma C4.5 dalam Memprediksi Kriteria Nasabah Kredit Mega Auto Finance

2020 ◽  
Vol 7 (2) ◽  
pp. 200
Author(s):  
Puji Santoso ◽  
Rudy Setiawan
Keyword(s):  
Data Mining ◽  
Decision Tree ◽  
Microsoft Excel ◽  
Customer Data ◽  
Data Mining Techniques ◽  
C4.5 Algorithm ◽  
Marketing Costs ◽  
Excel Format ◽  
Data Mining Application

One of the tasks in the field of marketing finance is to analyze customer data to find out which customers have the potential to do credit again. The method used to analyze customer data is by classifying all customers who have completed their credit installments into marketing targets, so this method causes high operational marketing costs. Therefore this research was conducted to help solve the above problems by designing a data mining application that serves to predict the criteria of credit customers with the potential to lend (credit) to Mega Auto Finance. The Mega Auto finance Fund Section located in Kotim Regency is a place chosen by researchers as a case study, assuming the Mega Auto finance Fund Section has experienced the same problems as described above. Data mining techniques that are applied to the application built is a classification while the classification method used is the Decision Tree (decision tree). While the algorithm used as a decision tree forming algorithm is the C4.5 Algorithm. The data processed in this study is the installment data of Mega Auto finance loan customers in July 2018 in Microsoft Excel format. The results of this study are an application that can facilitate the Mega Auto finance Funds Section in obtaining credit marketing targets in the future

Methodology for Analysis of Schottky Diode Failures

2010 ◽  
Author(s):  
Bhanu P. Sood ◽  
Michael Pecht ◽  
John Miker ◽  
Tom Wanek
Keyword(s):  
Failure Mode ◽  
Schottky Diode ◽  
Failure Modes ◽  
Schottky Diodes ◽  
Failure Mechanisms ◽  
Forward Voltage ◽  
Fast Switching ◽  
Voltage Drops ◽  
The Common

Abstract Schottky diodes are semiconductor switching devices with low forward voltage drops and very fast switching speeds. This paper provides an overview of the common failure modes in Schottky diodes and corresponding failure mechanisms associated with each failure mode. Results of material level evaluation on diodes and packages as well as manufacturing and assembly processes are analyzed to identify a set of possible failure sites with associated failure modes, mechanisms, and causes. A case study is then presented to illustrate the application of a systematic FMMEA methodology to the analysis of a specific failure in a Schottky diode package.

The Calculation of Turbulent Diffusion Coefficients in Aquatic Ecosystems

2019 ◽  
Vol 70 (11) ◽  
pp. 3903-3907
Author(s):  
Galina Marusic ◽  
Valeriu Panaitescu
Keyword(s):  
Transport Equation ◽  
Turbulent Diffusion ◽  
Diffusion Coefficients ◽  
Aquatic Ecosystems ◽  
Specific Area ◽  
Left Bank ◽  
The Right ◽  
Prut River

The paper deals with the issues related to the pollution of aquatic ecosystems. The influence of turbulence on the transport and dispersion of pollutants in the mentioned systems, as well as the calculation of the turbulent diffusion coefficients are studied. A case study on the determination of turbulent diffusion coefficients for some sectors of the Prut River is presented. A new method is proposed for the determination of the turbulent diffusion coefficients in the pollutant transport equation for specific sectors of a river, according to the associated number of P�clet, calculated for each specific area: the left bank, the right bank and the middle of the river.

Sign in / Sign up

Export Citation Format

Share Document