Book Image

The Future of Finance with ChatGPT and Power BI

By : James Bryant, Aloke Mukherjee
2.5 (4)
Book Image

The Future of Finance with ChatGPT and Power BI

2.5 (4)
By: James Bryant, Aloke Mukherjee

Overview of this book

In today's rapidly evolving economic landscape, the combination of finance, analytics, and artificial intelligence (AI) heralds a new era of decision-making. Finance and data analytics along with AI can no longer be seen as separate disciplines and professionals have to be comfortable in both in order to be successful. This book combines finance concepts, visualizations through Power BI and the application of AI and ChatGPT to provide a more holistic perspective. After a brief introduction to finance and Power BI, you will begin with Tesla's data-driven financial tactics before moving to John Deere's AgTech strides, all through the lens of AI. Salesforce's adaptation to the AI revolution offers profound insights, while Moderna's navigation through the biotech frontier during the pandemic showcases the agility of AI-focused companies. Learn from Silicon Valley Bank's demise, and prepare for CrowdStrike's defensive maneuvers against cyber threats. With each chapter, you'll gain mastery over new investing ideas, Power BI tools, and integrate ChatGPT into your workflows. This book is an indispensable ally for anyone looking to thrive in the financial sector. By the end of this book, you'll be able to transform your approach to investing and trading by blending AI-driven analysis, data visualization, and real-world applications.
Table of Contents (13 chapters)
Free Chapter
1
Part 1: From Financial Fundamentals to Frontier Tech: Navigating the New Paradigms of Data, EVs, and AgTech
6
Part 2: Pioneers and Protectors: AI Transformations in Software, Finance, Biotech, and Cybersecurity

Walk-through use case – analyzing financial ratios using Power BI and ChatGPT

The following is an example that you can try to emulate. It is a simple illustration of how you can integrate Power BI and ChatGPT. (Note: this example is courtesy of Amer Mahmood, who posted this article on medium.com).

In this example, we will create a report in Power BI and feed the data to ChatGPT, asking for insights. Some steps need to be completed before we start:

  1. Install Python and enable Python in Power BI:
    1. First, install Python, if you have not done so already. Please visit the official website (https://www.python.org/downloads/) to download it. We recommend versions 3.9 and 3.10.
    2. Once Python has been installed, enable Python scripting in Power BI. To do so, open Power BI Desktop. Then, click File > Options and go to Settings > Options > Python scripting. Select the checkbox and click OK.
    3. Next, set the Python path in Power BI. Go to File > Options and then to Settings...