R flexdashboard - Data Dashboards | Mark Gingrass | Skillshare

R flexdashboard - Data Dashboards

Mark Gingrass, Citizen Data Science

R flexdashboard - Data Dashboards

Mark Gingrass, Citizen Data Science

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
3 Lessons (37m)
    • 1. Flexdashboard intro

    • 2. Flexdashboard 01

    • 3. Flexdashboard 02 smaller

  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.





About This Class

flexdashboard - Easy interactive dashboards for R

  • Use R and R Markdown to publish a group of related data visualizations to a dashboard.

  • Support for a wide variety of components including; grids, graphics; tabular data; gauges and value boxes; and text annotations.

    Flexible and easy to specify row and column-based layouts.

Very little to no programming experience required. Take your business analytics to the next level. 

Meet Your Teacher

Teacher Profile Image

Mark Gingrass

Citizen Data Science


Class Ratings

Expectations Met?
  • Exceeded!
  • Yes
  • Somewhat
  • Not really
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Your creative journey starts here.

  • Unlimited access to every class
  • Supportive online creative community
  • Learn offline with Skillshare’s app

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.



1. Flexdashboard intro: in this project. I'm assuming that you've downloaded are in our studio or you're about to before you begin this project and they both free software. So that being said, you don't need tohave any programming experience whatsoever. But a little bit of smidgen of programming experience would help, especially in our and I want to show you how to build this dashboard like So as you can see , I have a chart on the left hand side with multiple tabs, car A and a two, two different charts that air appearing here that is, navigate herbal through the tabs. I have a value box. I'm gonna show you how to create value boxes. I have a gauge chart, see is a gauge. And then I have a place where I can add some narrative if I choose or anything else. It's another spot to put things. And then under expert, I have the actual underlying data that's viewable, searchable and exportable. To see his fee, you could print or copy it and more. This is just an introduction toe. What flex dashboards conducive for you and your projects. This is definitely a way to portray information in a nice easy, aesthetically pleasing manner. So in about 20 minutes, with no programming experience whatsoever, you can follow along and create this exact same project. And hopefully your project will be this modified with your own actual data. So jump on a board and follow along. I'll see you in the next 20 minutes. 2. Flexdashboard 01: today, I'm gonna show you how to create some cool dashboards to show off your your work that you've done so far. So this is a blank sort of dashboard that I just created. Quickly, we're gonna make this actually a little bit more extensive, but you can see I have different areas. We have chart A, B and C. We have a little about section here, and I have multiple pages, and I have a title here called On Title. We're gonna fix all that as we go, but I want to show you this is the basic layout. We're gonna throw some graphs in here. We're gonna put some data in there to be able to download. And I'm gonna show you the process on how to do that with the simple tool called Flex Dashboard. So that being said, let's go back to our our create a fresh new project file new project. You don't have to create a new project. I just want to start from scratch for anybody that's jumping in right now. Um, so we want to create in a new directory, most likely and a new project here. We're gonna call this our flex dashboard project. What do you want to call it? But we're gonna create new so we can all start off on the same page and I'm gonna go fairly quickly because I want to get right to it. I think once you see the results, you're going to be amazed and say, You know what? I can use this. I don't need excel anymore. You know, things like that. So we have our project. Now. What you want to do is probably first of all, install a couple of things here. So let's go to packages. Install and type in flex dashboard flex dashboard and you see it pops up. It's in the Cran library. Install that already have it installed. But I'll click the button again and, uh, get a couple warnings. No big deal. Another thing that download is probably this thing called D T data table. If you don't already have that install that that's going to allow us to create some tables that have some functionality, like filtering and search and capabilities like that. Any more than that, I will walk you through as we as we need them. So okay, we have our our project open. Let's go to file new file. And if you didn't download flex dashboard or install it like I just did, you're not gonna have this option. So when you get a file, new go to are marked down. So it seems like a normal mark down until you get down to this from template menu. Click on that and you'll see I have an option here called Flex Dashboard. We're gonna use that one. So click on flex dashboard and hit, OK, And again, if you don't have that there, make sure you did the packages install Flex dashboard. All right, so we come up here and we have a template layout. Now, I showed you this this file right here. Let's close. I'm gonna close this one, and I show you how this one works. It's already pre filled out with some examples. So before we can actually use this, we have to save it. So let's just do a quick save. I'll save There we go file save, and we'll just call this our report. Dashboard, what have you call report Dashboard. It's under my flex dashboard project directory. So is there cool? We saved it. Now let's run this thing. And by running, I mean, let's render this into an HTML file so we can use it like a dashboard. So right out of the box without doing any code. And we're gonna go down here to the console. We're type in, um, are marked down colon colon render and then we'll put in our flex. If I hit the tab button, it'll auto populate. I don't want that. No, no, no, no, no. This is called report dashboard. I'm sorry. Getting all mixed up here. So in quotes report, dashboard are dot arm D. So we're gonna run that just like this. So are mark down Colon, colon render report dashboard. And it says output created Cool. That was simple. Let's click on our files over here, and then we're gonna click on report dashboard dot html. You should have an html found now because we just rendered we knitted this into an HTML. So when I click on view in Web browser and I'll pull that over so you could see it. I haven't multiple screens, So this is what we just created with without doing anything. This is out of the box. So we have our layout here. Chart a sharp beach Artsy. We haven't entitled here. Let's leave this open if you'd like. You don't have to close it. Let's go back to our are marked down and I'll show you a couple things that weaken Tweak right off the bat, for example. This title entitled Let's Call That Are Are TPS Report So and I'm gonna hit Save a lot command s just to make sure I capture everything and let's grow down a little bit. It's kind of C and dissect what we're seeing here online. 13. We have column and it says data with equal 6 50 What can you imagine that is? Well, it's a column here, and it looks like 650 out of 1000 pixels or whatever unit of measure it is, but it's basically 2/3 of the page is charred A and then sharp B and C are on the right hand side. So let's just keep that in mind as we go down here. So 6 50 for that column and you see, I have these three Hashtags and chart A so its third indentation, or 1/3 header culture today we saw a was on the left hand side, and now we go down and it says Column and it has data with 3 53 50 plus 6 50 is 1000. So basically break up your screening. Two units where 1000 covers the whole horizontal span and that's what you get. Now you see here that column underneath the right hand column, which is the smaller 13 50. I have chart be and chart see both with three hashtags, right? So the fact that I have another column So from column to column that's one whole column and then this column to the end is the other column. But you notice that there's two charts in his column column or a chart be in charts. See? Right, So that's just how it works. Now we can fiddle with these numbers. You can make these numbers split evenly. You could do 500 and 500 let's save that and render this again. Remember to render you can type in all that or just hit the up arrow and you get to your last command that you ran so hit that Let's go back over here and refresh it. And what do we have? We have a split split and you can add more columns if you'd like. It doesn't have to be that we could do. Ah, 500. Let's do 2 50 on this one and then let's go ahead and copy this lines 22 or 23 we'll go ahead and paste it down here and we now have another column with nothing there. Let's go ahead and copy the chart stuff. Just weaken. Have something to look at. And I paced in their my call that chart D And now let's see what we have. Control s come back down here. Hit the up arrow and run it again. Let's go back and refresh. You See, I added another chart D that spans the entire vertical distance. Pretty cool. And by the way, are TPS Report is now called TPS Report and not entitled. So that's pretty nice too. I'm gonna show you a couple more things now that were here. This is just a layout situation, Um, for now. So now I want to show you how to add another page. So there's a couple things here that I'd like to show you instead of these dashes, which you have to have the right amount of dashes and it has to say column here and then you'll create a column. But you can also do it a different way instead of colonic column. I can I can just do to Hashtags and call it column and delete this. I just want to show you that they're both work for hit Command s on that We run it. This is important because I kind of don't like the dash is because you really have to keep track of how many dashes you have. So there we go. So nothing changed, and that's exactly what I wanted to show you. So instead of the dash is you can do the two hashtags and then put the column in there and then the data width. Um, there's also so this orientation appear at the very top. Where says columns, you can also do it in row layout. So we're dealing with columns that are going left and right, right and left in the rose it would you be dictating the height of each row. And every time you split a row up. It'll split it into columns. So instead our columns of being split into Rose's waken play around that I'll show you where to find different layouts to in just a moment. But I wanted to show you that we can do that. But there's one other thing we can do. We can also do pages. So let's take a quick look at it one more time. See how we have TPS report. We have all these charts. Let's add a whole other pages if it's a whole another section here. So to do that, let's first start with ah page right here and what we're gonna do. Just as you would probably guesses one hashtag and we're gonna call it Page one or we'll call it Ah, start Page will call the start page. I'm gonna hit Command s on that and let's go down to the very bottom and let's go ahead and create another page So you really get a feel for what this is doing. We're gonna dio expert, whatever you wanna call it expert page and then we can do a column. We could say column uhm and we can set the data with and all that by doing the curly braces data with equals 500. And let's just run with this and say test rate, their command s Let's go run it. I got this microphone in my waist. I have to keep looking around it. All right, I'll put is created. Let's go back and hit the refresh button. Boom! All right, so this page still looks the same. But as you see it here I have a start page in an expert page and on the expert page, I have nothing on there except for a test. Now, because there's only one column, it spans the whole thing. What will have to do is add another column. If we wanted to actually see it, let's do let's do it this way. And then we'll do another test to command us. And of course, you're gonna have to play around thes quite a bit because not everything is going to be as intuitive as you think. And you're gonna mess up a little bit. Well, okay, so it did work. I have test on the left hand side and test on the right hand side, and we'll expand more on that in just a few. But mostly what I want to do is on a populate thes now with certain things. So this was the beginning intro level of how to create a flex dashboard. 3. Flexdashboard 02 smaller: left off with the layouts already figured out. Here we have a section with Chart A, B, C and D. We have an expert section that has just one basically section that spans the entire width. Remember, with was set at 1000. Let's go back, and I want to show you how to add multiple charts or sections in this one column. So I'm in. If you look at my my code in this section right here where it says orientation columns. So basically, um, the column orientation means we're gonna focus on column after column after column, as I type columns in. But if I add those hashtags to create regions, it'll add them as Rose under that column. Let me explain here by showing you the code. So see where it says column right here with the two Hashtags. Well, I go from two and then I have three here where Chart A is so it's indented one level up. So says, Take this column that I just created That's the with the 500 create one chart with three hashtags. Uh, what what I can do is Aiken, just copy and paste this and I'll do that twice. Let's call it a two and a three, and I'll show you what I mean. So it goes from two hashtags to three and then three again and three again. So these three chart a two and a three, are all aligned in New Rose under this column. That's what I'm trying to say. OK, so then I get to a new column, which in this this way I used a different format, but it means the same thing. Lines 35 36 together does the same thing as Line 15 here, except the span is different. The span is 250. Let's save that and I'll show you that those graphs were created for those regions. We have no graphs, so very refresh it. We have charted a a two in a three going down. Now we've done that with column to we're gonna call this column to we have Chart B and C in the same column so you can see that pattern still. Look where the column starts. Consider that the two hashtags and now we have three hashtags three hashtags. That's why we have Chart B and C under the same column. You see the pattern now on chart D. We have a new column. Oh, I'm sorry. Where did it start? Day Now, Under here We have one hashtag. So we're actually making a new page. And that's where we get the expert and start. So experts star is because it's got one hashtag expert. And then I created one column with the width of 1000 but I plan on not putting any other rows or columns in here, so I'm just gonna go ahead and delete that out completely. You should probably do the same. Say could follow along. Okay, It's not gonna make any changes aesthetically, but I just wanted to get that out because I'm not planning on putting columns in there. I wanted to span the entire with without having to call him. Okay, Now we have that figured out. Let's say that we wanted to make these charts bigger, and we want to fit him in the same area. One thing we can do is we can make tabs within his column instead of New Rose. Nothing beats an example, So let's go ahead and go back up to where that column starts. Caesar says column data with Well, another parameter you can put in there is but of the kama ado dot tab set. Now, when I hit control s on this and that re render this I think you're gonna like this feature . It's real simple. And it makes your layout a lot cleaner looking refresh. Now UCF chart a region chart A to chart a three. Now, granted, there's nothing in those regions. But look how nice and neat that is organized. And then we still ever chart B, c and D and our expert looks the same as it did. Let's go back. And now let's start filling some of this stuff in. All right, So what we're gonna dio is we're going to create the graphs and plots before we actually put him in our layouts. And normally you want to separate that out from your actual aesthetics and your layout like this. This is how we're laying out our report. Well, let's build the report using a natural our script. So got a file new new file, our script, and we're gonna call this Let's save it right off the bat control s. And we're gonna call this the e t l process for a report. What do you want to call it? He tell process report, and it's under that same directory is your project click save. All right, So we'll use, um g plot library, library, G plot to. And we're gonna, um if you don't have that installed, you would click on packages install, then just typing jewelry plot to and click on install. All right? And then it should install No problem. What that's gonna do, it's gonna allow us to create some basic plots. Now, this is not a lesson on how to create all kinds of fancy plots with the G plot. This is to get you started. So let's create some very basic plots that you can then, um, modified to your needs. So I don't understand. I don't expect you to understand all of the code completely, but I expect you to be able to modify this code to meet your needs. If you had your own CSP file imported, Okay. So speaking of that, too, to bring in some fake data, we're gonna use empty cars. It's a data set that comes with our studio in our so let's say my data and we're gonna assign to my data the empty cars data. So command, enter on that. And we have on the right hand side my data. It's got 32 observations with 11 variables. And here is the data here when I click on it. And we didn't know that library. So let's just go ahead and do that. I did. Command, enter online one now. The library. Judy plot has been loaded. Let me show you how to plot some of this data. So we're gonna use G plot and then inside here, we want to put our data. Our data is my data, and what I want to use is an aesthetic. I want to use an X and y access, so I'm gonna use the A static. So in a es the function, I'm gonna bring in two parameters and the parameters going to x to say X is equal to And look a look at my features list here have mpg cylinders. What do I want along the x axis? I'm gonna put weight wt and on the y axis, I'm gonna put Q sec, which is the quarter mile. How many seconds for 1/4 mile. So W T and Q sick. Let's go back here. X is equal to deputy along the X axis comma my aesthetic for Why is going to be Q sec? Okay, now that's still not gonna do anything. But if I actually do command, enter on here. You'll see my plot area here is just a blank canvas. Let's add a geometry to this We're gonna add when I put the plus sign there, we're gonna add, um gm underscore point and that's it. Nice and simple command. Enter on that And Ws was not found. Oh, because it's w t. Wait, let's try this again. And we have an actual plot over here on the right hand side of the bottom. But we didn't assign it any variable. We didn't save this plot. We simply displayed its Let's say that as well. Call it chart A and will assign this plot to chart a command enter. Okay, now, now, really, if you did this without displaying it first, you wouldn't see it at all. We only see it because it saves the history here. Hit that little brush here and you can delete the history of your plots. Now, if I rerun line five, you won't see it, but it is stored in data you can see in the environment 30 to observe it or ah, chart a list of nine. If I wanted to actually see it, I can just type in, tried a again, command, enter and it'll plot again. But we're not interested in doing that. We're interested in using chart A. I'm gonna save this. Control s over here where Chart A belongs so down here, chart a list. Just type in, chart A and then I can run this. There it is right there. I'm gonna save it. Control s or command us and let's run that are marked down again are marked down render and the name of our file His report dot armed e whatever it is. And now we should see this car appear magically in our area that we set it in Gardez. Try to has nothing in there and so forth and so forth. So you get the idea. Once you get good, you can look up how to do different plots, bar plots, history, grams, things like that. You can start plugging away and putting stuff in there. Let's do one more chart just to give you a little bit of feel. For that, a little bit more feel. Go back to your detail process report. That's great chart be Let's create chart A to start a two. Let's assign that to a plot. It's going to be the same data, my data and this time for X axis will use X equals. Um, I don't know. Maybe will do mpg and wise equal to was take a look at the data one more time. Eso maybe could do a mpg on the X axis, and I don't know what's power on the Y axis. When add a scatter plot the GM point command, enter now to see what it looks like. We can actually type it in here trying to I always do that. So it did plot it, and here we go. It's not a, um, you know, it's it could be meaningful for somebody that wants to know the mpg toe horsepower, right? So whatever that means, we're gonna delete that from here, and we'll put chart A to where it belongs, cause to get you the idea. So try to Let's just plug in. Chart a to Again. Let's follow the steps. Control s save it. Let's re render this hit the up button a couple times and here we go being rendered refresh and chart a two there to see these two different charts. Okay, charts. Not the only thing you can do with this. Let's play with some other stuff real quick just to show you. Let's go and fill in Chart B and we're not gonna call it chart beat when I call it a value box. So let's change the name of that chart. B is not sure it be. It's going to be a value inbox value boxes, just an indicator that gives you a number, but it's a little bit more aesthetically pleasing. All it is is just type in the word value and then box and then open princey. And you could put a number in there so I could put the number in 32 23. Whatever. Hit this button here. Now it doesn't show inside of your RMD file, but hit command estimates. Run that again. I know there's a lot of repeat in here, but I want to really drill this down. Um, so what's render Comeback refresh and see that 23. And it colored it blue and has value box down there. So that's that's the idea is it's just more aesthetically pleasing, so you might have a bunch of different values. You want to show you served 23 customers this hour. You've done 23 extra whatever their it ISS right now, we put a Nikon there to make it a little bit more pretty. There's a few icons you can use, so if you hit the comma, you can add a parameter that's called icon equals. And then f a dash pencil is one of them. You might have to google this toe look up other icons, and you might even be able to do your own modified icons that you create. But that's a little bit beyond the scope of this. So the value box just look at Value Box are icon options. Something like that hit the play button, I'm gonna save it again and let's go and run that. There we go. Refreshing. I'm trying to go quickly through this, so you know you can skip to the part that you want to really get done? So there's your pencil icon chart. See, we're gonna put a gauge a gauge. What's a gauge? Well, you'll see. Let's just let's just put it in there. Uh, Gage is you put a number in there, say 23 then you have a minimum and a maximum men equals zero Max equals 100. Now, if I run this, there's our gauge. I'm not gonna render it yet cause I want to show you some more things beforehand. So that's what engages. But how did it know to turn green? Right. So you have a minute, Max, so you can adjust this any way you want. You can have a minimum start at 20 and it'll just accordingly. 20 to 100 is 23 it knows the ratio. So it's pretty good. Let's start at zero again. But what I want to do is I want to set the colors myself. So let's do comma. They're going to do gauge sector sectors with a capital s, and you could see up here it says success, danger and, uh, warning warning. So success equals and we're gonna put in a set of numbers. We're gonna say success is equal to 90 to 100 comma. Warning is equal to and will say that is equal Teoh 50 to 89 and then finally will do. Danger is equal to zero 2 49 Makes sense. And this is just arbitrary. So when you do that, we see we're in the red because 23 is in the danger zone. Let's do 53 just to see or 53 Run it again and it turned yellow. And of course, finally, if we were at 99 it should be green. See how that works Now, inside of here, where I put 99 up here in the Value box report 23. You can put actual variables in there. So you're variables that are over here. You can add in there or you can actually create him on the fly if you'd want. Now again, this is a very, very introductory not really gonna teach you a whole lot about our but how to use flex dashboard. So I'm assuming, you know, some are, or you can pick it up rather quickly. So my data has 32 observations. Let's Let's add that to the value box. So we want 32 in there, but we want to do it using my data. So I'm gonna say my data, which is available because it's in my environment. I can use my data as a variable, but my data is the data frame, and this thing takes an actual number. So I want to do the dimensions. I want to figure out what's the dimensions. I know the dimensions of 32 by 11 but I want to do it programmatically so dimensions of my data. But that's going to give me two numbers a row in a column. So I'm with the first of those numbers. I want the row. So I subset it with the brackets and I say one. So now if I have this, I have Kate take my data, which is a basically a spreadsheet of data frame. Take the dimensions, which is going to be a 32 by 11. In fact, I can show you down here in the consul, I can say dimension. My data and I hit Enter here and says started to buy 11 to those two numbers. I want the first of those two numbers. In fact, you can do that here just to test it out, save you some time if you're if you want. So there's a number 32. Got it. So if I hit play on that, you get 32 now. The caveat is you have to run your script first over here because my data doesn't exist until you run this. All right, so we've got that figured out and over in the gauge. Let's just keep that at 99 gave you the example of how you can plug in variables in there. Let's do a quick save and take a last look at it. So let's do our markdown. Render quotes, report the arm, defile and run it just to make sure we're all on the same page. We get Chart a chart A to 23 is blank. We've got a value box of 32 engage that shows 99 for Chart D. Let's just throw some narrative in there, so let's go down a chart D and let's just type in because this is not our This is not our code because I don't have an R chunk in There they are. Chunk again Is the back ticks this little our situation here you have. All right, so in the r o, I'm sorry, Chart D We're gonna put just a narrative. Hello? This is my report. By the way, Bt dubs I can change colors and I can say I'm html now. Font uh, color equals red. Hello, red front and close that out. Let's see if this works command us. So I embedded some HTML in there, which will give you a lot of leverage and leeway to customize Let's go back and see if I did that correctly and we have some red text over here in Chart D. Very powerful. You can change the font. You can do a lot of html, but not all. But that's just one more thing. Finally, let's get to the last thing we have. We have a pretty full dashboard here with multiple charts. Now let's go to expert and say what we want to fill that in with. Well, maybe I want the actual data, the underlying data. So let's go back and we're going to do something in expert in the Are we're gonna add a data table. So to do that, I am going to add up here at the very top where it says library, Flex dashboard. Let's add library D T. Which is data table. You could do command center where you can run the whole thing again. It doesn't matter. And if DT is not installed, remember, packages install d t. And then you should have that available. No problem. Okay. DT is gonna give us the ability to add a data table. Data tables are pretty cool. Let's start off with a very simple one. Just called data table. And we're gonna add in our data, which is my data, and that's it. I'll hit a little button here. You can see what it looks like right here. You see how when I move the mouse, it highlights that row. That's pretty awesome. Future. I have a entry. Listeria can show 25. I can show 10 and all of these air customizable and I could do a search was very powerful. And I, as you can see down here, I'm what, Paige, Nate, Page nated. Whatever it's called stagnated. Anyways, you go to different pages. Okay, So one thing that's really important to a lot of people that are not used to other means. Besides, like Excel is the ability to export the data. So let's see if we can figure out how to do that. When we're gonna do that in just a moment, let's render this. Let's first, let's save it, command us and render this one more time just to show you what it looks like. So I want to add just export buttons and then we're finished. We have a full on dashboard and it's customizable to your needs. I will show you exactly one more thing afterwards, too, now that I think of it. So what's that? Buttons to this and this could get a little complicated. Let's go to the Internet. So I'm gonna do a Google search and we're gonna type in D T R for data table and our language. Ever say buttons? And this very 1st 1 here is the one I'm gonna pick. Hopefully, you can find it using Google as well. And what I have here is an example. CEO says copy and print and search all this. And so there's other examples, too. There's a download button so there's all kinds of things you can do. Let's just copy where it says data table cause that's what we're actually using When a copy this whole section going to go back and let's just we know our date is called my data. So control V on That changed the Irish to data set to my data. Right. So now if we run this, we should see at least those buttons we have print and copy. Pretty cool. Let's add C. S V. I know you can add. See SV comma quote. See SV CA quote. Run this again. And now you have the ability to export a CSP, and there are other options. So I I advise you to go explore the data table parameters just to break this down for a 2nd 1 of the parameters is an extinctions. So we having extinctions equal toe buttons and then we have an options list, and the options list is where a lot of things are gonna be at. So the table takes a parameter called options. But inside of options, you can have a list of options. And inside of that list we have this thing called B F B, F R tip and buttons. So this corresponds to the buttons extinction. So they're all working together and we can have a list of buttons basically. And what other buttons air in there? I'm not sure, but you can look those up. Let's render this one last time just to make sure that the buttons show up on the HTML page outputs created. Go back and refresh expert And there are buttons by click on See SV like I just did I can open this up and there it is. It is a CSP file comma separated file it created for us. So that will please a lot of the people that don't wanna work with in this area. Finally, just as a bonus, you don't probably wanna work with empty cars. You want to work with your own data sets. So let's go ahead and do that instead. Okay, So in the e t l process report dot our that we created I said my data is able to empty cars . Let's comment that out. We don't want that. We want to use our own data. Right. Okay, So let's do My data is equal to We're gonna do read. Underscore CSP. Actually, let's keep this very simple. Read dot CS V and underscores using a different library called tidy verse. We'll get into that in other lessons elsewhere. Read Nazi SV and then you open Prentice. See, And you just want to put in the location of your file or or the Earl of the CSB file. Now, if you're on a Windows computer for your path, you don't want to use back spit back slashes like like you don't want to do see Dr Backslash your path. You can do see Dr Backslash backslash user, backslash, backslash whatever it ISS desktop all the way to your actual CSP file. And on a Mac, you would use the forward slashes instead for slash user slash desktop slash my data. Doxy SV. I want to show you an example right now, but I wanted to make that crystal clear. If you're on Windows, it's to back spaces or forward slash, but not one backs back slash. I think you got that idea. Let's just grab. I mean, I do have an Excel file here. Let's let's just I don't even know where I saved it. Let's just grab one from the Internet, so I can show you that. Go to Google. Just say example. See SV file. Find any any example you want. CSB files Dash people Cool. Let's say bios stats dot C S V C. It's right here. Copy this command. See? And then let's go back over to here and we do command V. Now it's going to read in that C S V file from the Internet, and it's gonna start into my data. However, now our Chart A and R chart A two will be different. So let's go ahead and do that anyways. Let's do command. Enter on my data. We have it. So it's 18 observations of five variables. Now our chart and chart A to are not going to make any sense because there's no WT or Q sick. I don't think Let's click, let's check it. My data. Okay, we have name, sex, age high, etcetera. Let's do age versus height for the first chart, and then, yeah, that'll work perfectly. So X equals age, and then the y equals to the height. You can type in my data dollar sign just to get the actual so the actual name of the features. Height dot dot in dot So hiding? Anxious, basically. So let's go ahead and command, enter on that. And now, on the other one, we will do. Let's do, um, age versus weight. So, uh, age for the X and we'll do wait. And since I don't know what the actual variable name is, I'm gonna do the my data thing again. My data be weight. Boom. All right, I'm gonna save that. I'm gonna come back over to the dashboard, which I didn't change anything on this dashboard, right? I'm gonna just click on this run button up top. I'm gonna run all Hopefully it runs. Who got it? I got an error right off the bat. There's a joy. Must have used age somewhere here and chart a Let's go back. I don't think I have. Ah, there's no age. Let's try this. My data. Oh, it's capital A. So age doesn't work. So let's rerun all of this. In fact, you can just click on run and around the whole script. Actually, how little? Then click on, run it around the whole script. Come back over to the dashboard, run all and that's that and let's render it now. I didn't save it. So let's just do a test run and see if it actually matters. We'll know right off the bat, because we're no longer doing Q. Second Wait when it when I hit this free fresh button, Let's see what happens. All right, we got age and height. There we go. And over here we have aged and wait. There's your plot now. These were just static numbers, except for the value box was actually the dimension. The 18 observations. Here's our chart D and our data right here, and I can download it. Print it, copy it like in search for certain things. I don't search for Gwen. There's Gwen right here. That's it. Modify this to your needs. Play with it. There's a lot to learn about our but anybody that's a business analyst or anybody interested in Trento just display things in a dashboard can use this with very little program, an effort whatsoever. So I hope that you can modify this and create your own dashboards.