Building a dashboard in Power BI from scratch with ChatGPT: 15 minutes!

hello everyone today I'll show you how to make a dashboard with chat GPT first of all we have to define the data so let's imagine the situation I'm a beginner analyst and I want to apply for a job at a company that sells online courses I need to attach some work to my CV that's related to this field of activity the first thing I need to do is gather data that I can practice with and build a case study here's how the query for the neural network will look like let's break down its components first who I am and where I'm from next what I need and why I need it we specify that we need only the rows in the data set we describe that we want the data in CSV format and we remind the network about the specific data set we're interested in analytics of online courses to start I'll check my query using five rows so I'll slightly modify my query great now I see the data with columns like order number purchase date course ID course name student name Heiser her mail course price discount total purchase amount if needed you can ask the chat to add more columns that you require but I see that the existing data set is sufficient for my practice now I'll ask the chat to create a complete data set with 50 rows to do that I'll repeat the same query but change the condition from five records to 50 that's how quick and easy it was to get our data make a copy of it and post it to Power by I've I've already uploaded it now my task is to build a report for the director in powerbi which will give an understanding of which course is selling best can you tell me what charts I need to build and what Fields I need to use for each chart great he's asking me to build a bar chart which makes sense and he's pointing out specific fields for chart construction pie chart line chart stake chart and a matrix and he even described the cards to me right away suggesting four indicators overall his proposal looks reasonable I understand that we can build a dashboard from this let's get started and try to create a dashboard for online course analytics to create the dashboard I'll be using our product product guideline because I know it will be much easier for me with chart templates and dashboard grids after all I'll just be copying the charts and changing the data on them I'm moving to the products main page and selecting the layout option these are preconfigured dashboard grids and the most suitable one for us is the 2x two grid with four cards and four charts I'm copying this sheet for myself now I'll rearrange all my charts on it I'll rename the sheet to AI dashboard and let's start building the first chart is a bar chart and right away there are prepared Fields course name and total amount I'm going to the compass sheet this is our chart Chooser that helps select the right chart I'm looking for our bar chart going to its page then copying the chart card and pasting it onto the dashboard sheet and that's it I'll place it in the top right corner of the sheet grid next I'll connect the necessary data I'll remove all the existing data and replace it with the data that GPT kindly provided me great the first chart is ready let's move on to the next next chart next we have a pie chart but I see that we are displaying the same data as in the bar chart so let's get started on the next chart a line chart I'll return to the compass sheet and then to the line chart guideline provides two options with and without fill I'll copy and paste the one with fill onto the sheet because I prefer it I'll put it in the Grid's upper left corner I'll modify the fields to allow you to select date by month quarter or year total amount I'll reestablish the connection the next chart is a stacked bar chart okay I'll duplicate our bar chart actually if you look at the name of the visualization panel you'll notice that it's the same stacked bar chart the neural network advises adding discount to the same fields we currently have let's move on to the table or Matrix I'm going to Compass is table here we have a simple table and a matrix I think I'll go for the Matrix and even add one more category in addition to what we already have in gpt's suggestion I'll paste the Matrix place it in the bottom right corner and disable the extra fields course name student name it will expand in The Matrix and seems much more informative total amount order ID average discount I'll stretch the fields of our table to eliminate any empty space I'll enable histograms for total amount I'm turning on data bars and selecting blue as their color similarly for order I'm enabling a bar chart and making it yellow actually I've come up with how I'll modify the Stacked bar chart I'm not quite satisfied with its appearance I think I'll turn it into a tree map which I believe will be more intuitive than this current breakdown I'm copying the tree map and adding the discount category to [Music] it I'll increase the font size and remove that Dreadful stacked bar chart now all that's left is to assemble the kpi cards chat GPT has picked four cards for us I'm heading to Compass and finding the indicators there actually you can copy any of them whichever you like best I'll take the most basic one and paste it onto my dashboard now I need to replace the value with total amount I'm still thrilled that the neural network labels each field for the visual our next card is for order ID I'll copy it again the field this time is average discount and the last card is for the best selling course I'll use the course name field make the data label smaller so that all the text fits within the card now some final touches I'll change the titles of our charts [Music] and that's it our dashboard is ready you could finish here but I'd like to make a few tweaks to the appearance of the charts first I want to make the text on the cards black [Music] [Music] next if you look at the Dynamics chart it's in red while the same sales data on the bar chart is in blue and in the table it's also in blue the logic of data en coding should be consistent so I'll change the color of the Dynamics chart to Blue [Music] I'll adjust the font sizes a bit on the tree map [Music] [Music] I'll add a dollar sign dimension to all the chart titles now everything is truly ready thanks for watching

Channel: Data2speak

Views: 4,218

Keywords: #bi, #Alex_Kolokolov, #powerbi, #Power_BI_dashboard, #Power_BI_desktop, #course_Power_BI, #Business_Analytics, #excel, #microsoft

Id: tIXMrpv31no

Length: 15min 47sec (947 seconds)

Published: Thu Oct 12 2023