based on the case utilize predictive simulation modeling to identify key areas for improvement base on the content of the case It uses data provided by US governmental agencies you can download it and you can go through the project using excel or SQL or maybe my favorite are programming this project was inspired by my own real world work as italics professional so it's totally legit and if you are interested in changing careers this particular project might actually be a really great showcase in your project portfolio to demonstrate to potential hiring managers the skills that you've developed by going through the project now this project has everything you can think of it has data acquisition it has data understanding it has data cleaning it has exploratory data analysis and then it has analytics on top of that you can do as much or as little of this as you would like and I would suggest that if you're going to make it a part of your project portfolio do it to the Max and by the way don't click it just yet but if you're interested I do have a video and we'll be up here of my top five tips on how to make a data analytics project portfolio really pop the hiring managers so let's go ahead and get started On this project So what is it so this project at base is taking data from the state of Texas in the United States and then marrying it up with data from the US federal government in particular the US Census Bureau has with all good analytics projects you need to have some sort of question then you want to analyze that will guide what do you need what sort of cleaning you will do what sort of exploratory data analysis you will do and eventually whatever sort of analytical insights you might derive out of your work so in this particular case what you're going to be looking at is data from the state of Texas regarding licensed professionals so in the United states there are certain types of professions that require you to be licensed in the state in which you operate so for example if you are a Barber if you cut people's hair you need to be licensed to do that so the state of Texas provides you with lists of all the people that are licensed as professionals in the state whether they're barbers massage practitioners as the all kinds of different professions so that data is freely available you can download it so the question under analysis is this what sort of demographic factors within the counties of the state of Texas are highly associated with certain professions so for example let's take institutions if you're not familiar institution is somebody who gives people facials they take care of your skin they have to be licensed in the state of Texas to do this work so one hypothesis you might have is well that seems to be like a kind of a luxury service so maybe what we would see in the data is that esthetician license density is highest in those counties in the state of Texas with the highest amounts of disposable income that's the kind of thing that you can be working on in this particular project so first up let's go see where you can get this data so here we are in a website from the state of Texas in the United States and by the way the links for all this stuff will be down below in the description of this video so this is the Texas Department of licensing and regulation right TDLR here and what you can see here is a bunch of data files just a wealth of all kinds of data that you can download and use for this particular data cleaning project now here's what makes it so awesome even though all of these CCVS because that's what you'll typically download the CSV file from this website are from the same state Regulatory agency in the United states the data files are typically in different formats they're not always in the same format so if you want to do a more exhaustive analysis so for example maybe you want to look at multiple professions simultaneously to see if there are clusters of certain types of professions that tend to congregate or tend to be quite dense I should say OK quite dense in a particular county for with particular types of characteristics inside the state of Texas then this is a great project for you because the files are all in different formats which is very very common by the way in the real world so you can see here we have barbers which are typically in the United States professionals that specialize in cutting men's hair and then we have cosmetologists which in the United states are folks that specialize in cutting hair whether female or male and you can see we have electricians and motor motor fuel metering and quality so all kinds of goodness all kinds of different types of professions and different kinds of data are here from the state of Texas so let me show you what some of this data looks like I downloaded a file here from the website that we just saw and this is the All cosmetologists do file and what you can see here is you know your license type your license number and you kn