Power BI vs GPT4 Code interpreter - Amazingly Quick Analysis

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

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

50% 1

The Power BI Report and Sample data sets can be downloaded from pbi.guide/book/
A few folks for the tip, pointed out that I could load a single zipped file, and I gave it a go - pretty amazing results
/ wynhopkins_2-sentences...
Also you can export the image or the summarised data.
While this is not something I'd use in real life yet, it's clear what's already possible is truly astounding and only a matter of months rather than years until this type of functionality is core to the way we work.
Sign up for OpenAI here openai.com/
00:00 Intro
00:27 The Power BI Report and Data Structure
01:27 Enabling Code Intepreter
02:20 The Initial Prompt and Uploading Files
03:30 Building the Visual
05:47 Amending the Visual
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/

Хобби

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

6 авг 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@utubeAgape Год назад

This is really incredible and Yes, please keep these videos coming! I am amazed and will be piecing together ways to optimize how I work using your findings as a foundation of where to start with using ChatGPT. Thank you Wyn!

@AccessAnalytic Год назад

Thanks Irene. Glad you’re finding these useful. I’m astounded each day by how quickly these advances are happening

@utubeAgape Год назад

@@AccessAnalytic - have you been looking into MS 365 Copilot? There is some talk about it at my Organization - if you could share anything you might be learning about it that would be great too👍

@AndyHart1204 Год назад

@@utubeAgape I think they just announced it will cost $30 per month per user, so it must be getting ready for a roll out

@utubeAgape Год назад

@@AndyHart1204 - Yes, my understanding is it will be a limited rollout so they can learn from users to work out the bugs. Security of data is the main concern, I hear. Once it gets out there in full force, white collar work will be forever changed. Scary and yet exciting - sort of feels like we’re waiting in line to go on a new roller coaster ride.

@AccessAnalytic Год назад

Yep private preview currently

@SirHiss17 Год назад

One major problem with ChatGPT is that you have to load your data in there to get that analysis which is not something most companies allow. Until private instances of GPT are available, this will just be something cool to mess around with and learn but you won't be doing analysis with actual company data.

@AccessAnalytic Год назад

Agreed. You shouldn’t be putting sensitive data in there

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

Is there a way to overlay you company data with keys or data in similar format but not the actual data and will the GPT4 code be able to output code that can be pasted into the Power Query Advanced Editor or similar?

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

Yep it could potentially do that. I’ve used GPT4 multiple times to create Power Query code.

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

I don't see it as a problem at all, cause if it must analyze your data than must read on somewhere...isn't it??? You must be careful on what data you give to it

@alexama8703 Год назад

Great video! Thanks!

@AccessAnalytic Год назад

You're welcome!

@JuanIArana Год назад

This is impressive! This August, I am going to try ChatGPT-4 myself to see it with my own eyes. In the next video, it would be great to se how to integrate the code in Python with PowerBI, just an idea...

@AccessAnalytic Год назад

Cheers, yeah it’s something I’m looking into. I’ve never used Python so it’s going to be a learning experience

@carkawalakhatulistiwa Год назад

You can use zip file if the document is more than one. the full version of this not limited to only using the Python language.

@AccessAnalytic Год назад

Thanks, what do you mean by the full version?

@abdelouahedelmaazouzi6102 Год назад

Great Video. Can you send the result from chatgpt to Excel?

@AccessAnalytic Год назад

Yes, Check this out... you can export the the summarised data and image www.linkedin.com/posts/wynhopkins_2-sentences-saves-2-hours-of-work-activity-7088006117074612224-1Wwg

@McIlravyInc Год назад

This is what I envisioned when I ventured into Powe query and low code dev. I can get the program to do what I know it can with what I provide, without having to know how it does it. Manage instead of manual! Very cool and more efficient....but as with all ai stuff if you don't have the experience to truth the output then you are in dangerous territory....like the horror stories about rogue excel files that give bad data.

@AccessAnalytic Год назад

Totally agree that you must be able to review, understand and amend the code in order to trust the results.

@AndyHart1204 Год назад

if you put all your files in a zip folder you can upload them in one go, saving you precious tokens

@AccessAnalytic Год назад

Thanks for the tip, someone else also pointed that out and I gave it a go - pretty amazing results www.linkedin.com/posts/wynhopkins_2-sentences-saves-2-hours-of-work-activity-7088006117074612224-1Wwg Also you can export the image or the summarised data

@abdulsaidmkamara7305 Год назад

Love it

@AccessAnalytic Год назад

Thanks 😀

@jawadahmadehssan6251 Год назад

Great video and appreciate your efforts. Looking forward to more cool capabilities of this tool.

@AccessAnalytic Год назад

Cheers Jawad

@joseagundis1 Год назад

Increíble

@hideweapon1361 Год назад

Hello sir, thx for this tuto, can understand that data analyst will desapear? AI feild will replace it ?

@AccessAnalytic Год назад

Not disappear but work quicker, get insights faster. You still need to be able to check, verify and interpret. But these tools will massively boost the productivity of those that can use them well

@Question_Mark454 Год назад

Thank you for the video. I have a question. I know dax but I want to improve my knowledge. Is it worth it to learn dax when chat GPT can power Bi reports.

@AccessAnalytic Год назад

Yep, there’s no avoiding having to learn the core principals so that you can validate and amend the code that GPT4 produces. It can certainly help you write DAX quicker and provide options for you to assess rather than come up with the thoughts yourself. I’m imagining that within a few years Co-pilot in Power BI will be amazing at helping us with DAX, M, and visual choices.

@Bhavik_Khatri Год назад

Please share prompts that generated the greatest joy in terms of the required output, just like these videos.

@AccessAnalytic Год назад

Hi, you’ll notice that I only type in about 4 sentences in the whole video. This one didn’t need prompts.

@chintanpatel_za Год назад

Can the end result (the chart created) be exported out in any way?

@AccessAnalytic Год назад

Check this out... you can export the image or the summarised data www.linkedin.com/posts/wynhopkins_2-sentences-saves-2-hours-of-work-activity-7088006117074612224-1Wwg

@MrMsmith1 Год назад

Can Chat GPT code interpreter return the excel files with the new formats? Can it return the actual chart or do you just have to take a screen shot?

@AccessAnalytic Год назад

Check this out... you can export the image or the summarised data www.linkedin.com/posts/wynhopkins_2-sentences-saves-2-hours-of-work-activity-7088006117074612224-1Wwg

@AZ_German Год назад

How would you then get this into a PBIX file for use in Power BI. Is the future that code interpreter will be inside Power BI or some sort of plug-in?

@AccessAnalytic Год назад

This particular code is Python so there may be a way of using Fabric to actually make this re-usable. Yes I think the future will ultimately involve this type of thing living inside Power BI

@cezaryczajka9198 Год назад

Hello, what plugin should be installed to be able to add Excel files

@AccessAnalytic Год назад

Hi, I show at the beginning turning on the beta feature called Code Interpreter. That’s it ( not a plug-in)

@cezaryczajka9198 Год назад

@@AccessAnalytic Thank you for the hint. Done! :)😀

@tinaflemons263 Год назад

Have you tried asking ChatGPT to provide the DAX formulas for this same analysis

@AccessAnalytic Год назад

DAX couldn’t do this. You’d need to transform the data with Power Query, build a data model and then write 2 simple DAX Sum measures and then build the visuals. I did however do a DAX and GPT4 video here… it’s really a helpful assistant! DAX & GPT4 - Amazing - if you ask the right questions ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-FxU8nfhyYc0.html