Data Analysis for Corporate Finance
eBook - ePub

Data Analysis for Corporate Finance

Building financial models using SQL, Python, and MS PowerBI

Mariano F. Scandizzo CFA CQF

  1. 520 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

Data Analysis for Corporate Finance

Building financial models using SQL, Python, and MS PowerBI

Mariano F. Scandizzo CFA CQF

Book details
Book preview
Table of contents
Citations

About This Book

Have you ever tried to learn to code or to use advanced visualization tools? If so, I am sure you know how daunting it is to learn by yourself.

Generally, tools and books follow an encyclopedism approach, i.e., books attempt to teach every feature about a coding language or tool. This implies hundreds, if not thousands of pages simply to tackle a single topic, whether SQL, Python, MS Excel, MS PowerBI, you name it. The journey from zero to hero to become proficient using numerical and visualization tools to take your career to the next level becomes an ordeal that requires years and thousands of pages just to begin putting the pieces of the puzzle together. However, the reality is that you do not need to learn absolutely every available feature to use those tools and deliver a superior project.

Rather than teaching you about the forest, I will discuss specific trees. Why? Because once you become familiar and confident nurturing a few trees, growing a forest becomes a simple process of planting new trees. This book provides the fundamental blocks so that you can learn about financial data science and take these tools and start using them tomorrow. The scope of the selected tools will empower you to see a considerable improvement in your financial modeling skills.

The book is designed to provide corporate finance professionals the ability to start immediately using advance tools for concrete real-world tasks.

Therefore, this book is all about functionalism. It is about providing you with tools that will put you to work and dramatically change the way you analyze data. Once you see the benefits, it will become natural to keep expanding your domain knowledge, leveraging today's endless available educational resources.

Frequently asked questions

How do I cancel my subscription?
Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
Can/how do I download books?
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
What is the difference between the pricing plans?
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
What is Perlego?
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Do you support text-to-speech?
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Is Data Analysis for Corporate Finance an online PDF/ePUB?
Yes, you can access Data Analysis for Corporate Finance by Mariano F. Scandizzo CFA CQF in PDF and/or ePUB format, as well as other popular books in Negocios y empresa & Finanzas corporativas. We have over one million books available in our catalogue for you to explore.

Information

Year
2021
ISBN
9781649527226
Chapter 5
Pandas
“The goal is to turn data into information, and information in insight.”
Carly Fiorina
Introduction
We have reached the cornerstone of our data science applied to finance journey. It is as certain as death and taxes that anything you do regarding numerical analysis, visualizations, machine learning, simulations, etc. will be related in one way or the other to a Pandas dataframe. In line with that fundamental aspect of the Python’s state of the art, this chapter will be fully dedicated to exploring Pandas. There are three clear aspects which summarize dataframe operations:
  1. Importing and exporting data into/ from a dataframe
  2. Manipulating data
  3. Table manipulations such as merge, join or concatenate
We will touch each of the above topics in great detail to ensure a good understanding of this de facto library.
I will begin by formally introducing pandas. Pandas is named after the panel data econometric term. In a sense, Pandas is built on top of NumPy. For example, NumPy universal functions will generally work on Pandas objects as well. On a rather fundamental level, the dataframe class is designed to manage indexed and labeled data.
Dataframes can be created in the following ways...

Table of contents

Citation styles for Data Analysis for Corporate Finance

APA 6 Citation

Scandizzo, M. (2021). Data Analysis for Corporate Finance ([edition unavailable]). Fulton Books, Inc. Retrieved from https://www.perlego.com/book/3182775/data-analysis-for-corporate-finance-building-financial-models-using-sql-python-and-ms-powerbi-pdf (Original work published 2021)

Chicago Citation

Scandizzo, Mariano. (2021) 2021. Data Analysis for Corporate Finance. [Edition unavailable]. Fulton Books, Inc. https://www.perlego.com/book/3182775/data-analysis-for-corporate-finance-building-financial-models-using-sql-python-and-ms-powerbi-pdf.

Harvard Citation

Scandizzo, M. (2021) Data Analysis for Corporate Finance. [edition unavailable]. Fulton Books, Inc. Available at: https://www.perlego.com/book/3182775/data-analysis-for-corporate-finance-building-financial-models-using-sql-python-and-ms-powerbi-pdf (Accessed: 15 October 2022).

MLA 7 Citation

Scandizzo, Mariano. Data Analysis for Corporate Finance. [edition unavailable]. Fulton Books, Inc., 2021. Web. 15 Oct. 2022.