IDEAS home Printed from https://ideas.repec.org/a/eee/jbrese/v63y2010i2p191-206.html
   My bibliography  Save this article

Utilizing and teaching data tools in Excel for exploratory analysis

Author

Listed:
  • Palocsay, Susan W.
  • Markham, Ina S.
  • Markham, Steven E.

Abstract

In this article we offer Excel as an introductory tool to high end business intelligence (BI) and decision support system (DSS) applications. Because it is ubiquitous, Excel can be used by all managers and business students for exploratory data analysis. We provide three key points in this utilization of Microsoft® Excel 2003: (1) manipulating records using Excel as a database, (2) creating PivotTables® and PivotCharts® using Excel for analysis, and (3) importing data using Excel as an automation container. The basic skill set defined by the above three items allows users to begin to use Excel to its full potential in finding information in business data, and it offers a key tool for future research in improving the utilization of information across organizations.

Suggested Citation

  • Palocsay, Susan W. & Markham, Ina S. & Markham, Steven E., 2010. "Utilizing and teaching data tools in Excel for exploratory analysis," Journal of Business Research, Elsevier, vol. 63(2), pages 191-206, February.
    • Handle: RePEc:eee:jbrese:v:63:y:2010:i:2:p:191-206
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S0148-2963(09)00064-2
    Download Restriction: Full text for ScienceDirect subscribers only
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Tihanyi, Laszlo & Thomas, Wayne B., 2005. "Information-processing demands and the multinational enterprise: a comparison of foreign and domestic earnings estimates," Journal of Business Research, Elsevier, vol. 58(3), pages 285-292, March.
    2. Koschat, Martin A., 2005. "A Case for Simple Tables," The American Statistician, American Statistical Association, vol. 59, pages 31-40, February.
    3. Cliff T. Ragsdale, 2001. "Teaching Management Science with Spreadsheets: From Decision Models to Decision Support," INFORMS Transactions on Education, INFORMS, vol. 1(2), pages 68-74, January.
    4. Rau, Devaki, 2006. "Top management team transactive memory, information gathering, and perceptual accuracy," Journal of Business Research, Elsevier, vol. 59(4), pages 416-424, April.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Abhijit Sharma, 2015. "Use of Bloomberg Professional in support of finance and economics teaching," Cogent Economics & Finance, Taylor & Francis Journals, vol. 3(1), pages 1115618-111, December.
    2. Roxana POPA STRAINU & Mircea GEORGESCU, 2015. "Support Management Decisions In Small And Medium Companies," Review of Economic and Business Studies, Alexandru Ioan Cuza University, Faculty of Economics and Business Administration, issue 16, pages 167-181, December.
    3. Néstor Rodríguez-Padial & Marta Marín & Rosario Domingo, 2017. "An Approach to Integrating Tactical Decision-Making in Industrial Maintenance Balance Scorecards Using Principal Components Analysis and Machine Learning," Complexity, Hindawi, vol. 2017, pages 1-15, October.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Ole‐Kristian Hope & Wayne B. Thomas, 2008. "Managerial Empire Building and Firm Disclosure," Journal of Accounting Research, Wiley Blackwell, vol. 46(3), pages 591-626, June.
    2. Baik, Kibok & Kim, Kyoung Yong & Patel, Pankaj C., 2019. "The internal ecosystem of high performance work system and employee service-providing capability: A contingency approach for servitizing firms," Journal of Business Research, Elsevier, vol. 104(C), pages 402-410.
    3. Christoph Markmann & Alexander Spickermann & Heiko A. von der Gracht & Alexander Brem, 2021. "Improving the question formulation in Delphi‐like surveys: Analysis of the effects of abstract language and amount of information on response behavior," Futures & Foresight Science, John Wiley & Sons, vol. 3(1), March.
    4. Matolcsy, Zoltan & Wakefield, James, 2017. "Multinational headquarter control of wholly owned foreign subsidiaries," The British Accounting Review, Elsevier, vol. 49(3), pages 275-293.
    5. Chiang, Yun-Hwa & Shih, Hsi-An & Hsu, Chu-Chun, 2014. "High commitment work system, transactive memory system, and new product performance," Journal of Business Research, Elsevier, vol. 67(4), pages 631-640.
    6. Liao, Jenny & O'Brien, Anne T. & Jimmieson, Nerina L. & Restubog, Simon Lloyd D., 2015. "Predicting transactive memory system in multidisciplinary teams: The interplay between team and professional identities," Journal of Business Research, Elsevier, vol. 68(5), pages 965-977.
    7. Luo, Xueming & Zheng, Qinqin, 2018. "How firm internationalization is recognized by outsiders: The response of financial analysts," Journal of Business Research, Elsevier, vol. 90(C), pages 87-106.
    8. Patrick Regnér & Udo Zander, 2011. "Knowledge and Strategy Creation in Multinational Companies," Management International Review, Springer, vol. 51(6), pages 821-850, December.
    9. Rebecca Piekkari & Phillip C. Nell & Pervez N. Ghauri, 2010. "Regional Management as a System," Management International Review, Springer, vol. 50(4), pages 513-532, August.
    10. Feng, Cong & Patel, Pankaj C. & Sivakumar, K., 2020. "Chief global officers, geographical sales dispersion, and firm performance," Journal of Business Research, Elsevier, vol. 121(C), pages 58-72.
    11. Schaberl, Philipp D., 2014. "The influence of disclosure policy on analyst behavior: The case of segment data," Advances in accounting, Elsevier, vol. 30(2), pages 440-451.
    12. Daniel B. McLaughlin & John R. Olson, 2017. "Teaching the Use of Systems Dynamics for Strategic Decision Making in Healthcare," INFORMS Transactions on Education, INFORMS, vol. 17(3), pages 99-106, May.
    13. Moser, Roger & Kuklinski, Christian Paul Jian-Wei & Srivastava, Mohit, 2017. "Information processing fit in the context of emerging markets: An analysis of foreign SBUs in China," Journal of Business Research, Elsevier, vol. 70(C), pages 234-247.
    14. Aime, Federico & Meyer, Christopher J. & Humphrey, Stephen E., 2010. "Legitimacy of team rewards: Analyzing legitimacy as a condition for the effectiveness of team incentive designs," Journal of Business Research, Elsevier, vol. 63(1), pages 60-66, January.
    15. Andreas P. J. Schotter & Maximilian Stallkamp & Brian C. Pinkham, 2017. "MNE Headquarters Disaggregation: The Formation Antecedents of Regional Management Centers," Journal of Management Studies, Wiley Blackwell, vol. 54(8), pages 1144-1169, December.
    16. María M. Gea & Jocelyn D. Pallauta & Carmen Batanero & Silvia M. Valenzuela-Ruiz, 2022. "Statistical Tables in Spanish Primary School Textbooks," Mathematics, MDPI, vol. 10(15), pages 1-17, August.
    17. Li, Peng-Yu, 2018. "Top management team characteristics and firm internationalization: The moderating role of the size of middle managers," International Business Review, Elsevier, vol. 27(1), pages 125-138.
    18. Koschat, Martin A., 2008. "Store inventory can affect demand: Empirical evidence from magazine retailing," Journal of Retailing, Elsevier, vol. 84(2), pages 165-179.
    19. Mauri, Alfredo J. & Lin, Jing & Neiva De Figueiredo, João, 2013. "The influence of strategic patterns of internationalization on the accuracy and bias of earnings forecasts by financial analysts," International Business Review, Elsevier, vol. 22(4), pages 725-735.
    20. Ciaran Heavey & Zeki Simsek, 2015. "Transactive Memory Systems and Firm Performance: An Upper Echelons Perspective," Organization Science, INFORMS, vol. 26(4), pages 941-959, August.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:eee:jbrese:v:63:y:2010:i:2:p:191-206. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Catherine Liu (email available below). General contact details of provider: http://www.elsevier.com/locate/jbusres .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.