DAX & GPT4 - Amazing - if you ask the right questions

Подписаться 90 тыс.

Просмотров 6 тыс.

50% 1

👇🏻🔽Description and links here🔽👇🏻
Using a well-structured prompt in GPT4 can dramatically improve the DAX results that GPT 4 generates.
Sign up for GPT4 here
chat.openai.com/
Download the prompt I used here
aasolutions.sharepoint.com/:f...
00:00 Intro
02:18 Solving Events in Progress
08:20 Solving Date of Maximum Sales
12:25 Requesting explanations of formulas
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
pbi.guide/book/
Connect with me
wyn.bio.link/

Хобби

Опубликовано:

12 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 29

@justinbarter5445 Год назад

So helpful, practical and with examples and a template how to use - brilliant

@AccessAnalytic Год назад

Cheers Justin

@Bhavik_Khatri Год назад

Very nice video, and thank you for pointing out that ChatGPT isn't a substitute for learning DAX. People at my work often take shortcuts and think they can ask questions without having any context on the subject matter. I guess they are simply too lazy to learn. I use ChatGPT as a tool to help me, but I believe that learning the subject matter is important. For instance, I have to learn DAX and not rely 100% on ChatGPT.

@AccessAnalytic Год назад

Agreed. Thank you.

@RakamXela Год назад

Brilliant video. I have had a lot of success with ChatGPT 3.5 but it took a lot of practice with prompts and I found what you did with table and columns names is the key. It is important to stay consistent with the naming so a model can be determined. It made me think though that it will only be a matter of time that the language model sits natively in BI so it knows the model already. Then they release Co-Pilot! Amazing.

@AccessAnalytic Год назад

Thanks. Yes it will be very interesting to see how co-pilot develops

@utubeAgape Год назад

Really love where you’re going with this! You are convincing me to buy the upgrade. The point is, yes, we have to know DAX, but what a timesaver it is to have the pre-written prompts to getting the code written in clean format and commented on, all at once. Then all we have to do is test it, and make the necessary tweaks. Love it! Thank you again!

@AccessAnalytic Год назад

It’s hard to imagine where this will take us in the next 12 months

@lucappelmans9056 Год назад

Great video, thanks. As a trainer I sometimes have difficulty to explain difficult DAX formulas to trainees. I guess I could use GPT4 to get explanations of self-built formulas.

@AccessAnalytic Год назад

Definitely. It's great at doing that

@chrism9037 Год назад

Excellent video Wyn!

@AccessAnalytic Год назад

Cheers Chris

@Acrnl Год назад

It is quite impressive. Great video cheers.

@AccessAnalytic Год назад

Thank you

@LearningPowerBI Год назад

Excelent Video!!! Thanks

@AccessAnalytic Год назад

You're welcome

@andysuzhou7956 Год назад

I tried it with Google Bart and it came up with the following DAX: // Create a variable for the reservations table var reservations = CALCULATETABLE('Reservations'); // Create a variable for the calendar table var calendar = CALCULATETABLE('Calendar'); // Create a variable for the number of rooms booked on each day var roomsBooked = CALCULATE( SUM(reservations[Room]), // Filter the reservations to only include days that are in the calendar table WHERE( reservations[Arrival]

@AccessAnalytic Год назад

Hah! That's pretty awful

@josecarlosconejo5724 Год назад

Amazing 😮

@neo1tom Год назад

Great video, thanks i will try this out

@AccessAnalytic Год назад

Thank you

@engahmedelbendary1566 Год назад

thx for your Effort bu the problem here in saudia arabia there is no chatgpt inn saudia arabia

@AccessAnalytic Год назад

Ah, that’s a shame

@PaulBailey3 11 месяцев назад

Maybe asking for concurrent guests/bookings would work?

@AccessAnalytic 11 месяцев назад

Is that just a question Paul or suggesting a change to something in the video

@avivkoren527 Год назад

It's amazing for now, but I think we are on the way which machines will replace humans :(

@AccessAnalytic Год назад

I think it’s initial impact will be to massively improve the efficiency of those that use it. It will also reduce but not remove the need for many specialist areas, which has been steadily the case for many years now.

@ivanxdxd Год назад

GPT is nowhere near to being as good at DAX as it is with other languages because DAX is typically contained in PBIX files and those are not source code. There are barely any GitHub repos containing DAX code. The model could never learn it properly.

@AccessAnalytic Год назад

Interesting point. The huge challenge also is it’s so dependent on the data model and structure of underlying tables