What the F*K😲, ChatGPT know Power-BI📶 also?
In this post, we will see the capability of ChatGPT to write DAX in Power-BI and help us to solve our assignment.
I already have one article discussing what is ChatGPT, how it is being trained, and how you can use it for your own purpose.
ChatGPT🤖: New Revolution of AI🤯
Hello, folks in this article we are going to talk about the trending word “ChatGPT” which is breaking the internet.
ChatGPT is breaking the internet in the real sense, everyone is talking about the power of an NLP (Natural language processing) based AI (Artificial intelligence) chat Bot developed by the OpenAI group.
I was reading somewhere that you can use this chatbot for any purpose, so I am curious to try if it can help me solve my Power-BI assignment.
▶ Table of content:
3.1. My question❓
3.2. ChatGPT answer📖
3.3. My Views on this🤔
3.4. Score💯
▶Loading the data-set
In our case, we are a “Superstore sales data” (If you want this dataset please drop a note in the comment section).
▶Start ChatGPT instance
If you are new here and don’t know how to set up your account, follow this post. Once you are done you can see a running instance of the chatbot.
▶Start solving Power BI Assignment Questions with ChatGPT
NOTE: Just to give you some context about data, we have two tables here Order and Returns table.
Let’s ask chatGPT to solve these questions for us.
Join the Order table and Returns table
My question❓:
ChatGPT answer📖:
My Views on this🤔:
The answer is very close to right except for one thing in step 2, there is nothing called “combine queries” (maybe it was there in the older version but I am using 2.112.603.0).
The only correction is clicking on “Merge query” in step 2 and everything is correct✅.
Score💯:
95/100
2. Write a DAX to find the sum of total profit only for the state of “Iowa”?
My question❓:
ChatGPT answer📖:
Total Profit for Iowa =
SUMX(
FILTER(Orders, Orders[State] = "Iowa"),
Orders[Profit]
)My Views on this🤔:
Score💯:
100/100 ✔
3. Create a new table that shows the sum of profits by the states?
My question❓:
ChatGPT answer📖:
State Profits =
SUMMARIZE(
Orders,
Orders[State],
"Total Profit", SUM(Orders[Profit])
)My Views on this🤔:
When I tried the way ChatGPT has mentioned I was getting the error.
To get this done I just simply used “New Table” and copy pasted the same code generated by ChatGPT.
Score💯:
70/100 (Only for the code part)
▶Conclusion
To finally conclude we have scored 95+100+70 = 265/300 i.e, 88% which is not bad. ChatGPT was able to get us a good head start😉 to approach a problem and others figure out we can do it by googling or doing our favorite trial-and-error method.
I am a Data Science enthusiast🌺, Learning and exploring how Math, Business, and Technology can help us to make better decisions in the field of data science.
Want to read more: https://medium.com/@ravikumar10593/
Find my all handles: https://linktr.ee/ravikumar10593
If this article helped you, don’t forget to Follow, like, and share it with your friends👍Happy Learning!!