Module 2 Data Access Applied Assignment Part 2

Be sure to view the course media and complete your readings before you complete any assignments.

Submit only one MS Word document with the various assignments parts included (screenshots included, if applicable). Be sure to attach your R Studio file as well.

To be successful in the assignments consider the following tips:

• Start early
• Meet assignment requirements
• Include comments (explains your code) in your code (remember to use the # sign for comments)
• Check that your code works
• Submit your output showing outcomes and that the code worked
• Submit one Microsoft Word file and not multiple (unless otherwise specified)

You will need the following files for this assignment

If you have trouble with this file you can create your own in R Studio relatively quickly using the approach I include in this

. Be sure to add data to your table and to show that your table has data.

The files that follow are correlated and were derived from the same system. You will notice common identifiers across the files. Click on this

for documentation describing each file and its content.

8. (The data was last collected in 2012, so only ICD-9 codes are represented)

You now have experience writing some code in R. Before data can be analyzed or visualized you need to have access to it. As you already noted, the data will come in a variety of formats including structured formats such as relational databases. Here I would like you to practice reading a SQLite database (healthcare.db) into R Studio and writing some SQL code in R Studio to access content in the database, and also create your own database. This is more advanced than some of the approaches you worked with in Module 1, but important for health informatics practitioners to know.

2.1 Write these lines of code to read this database into R Studio. These lines of code will enable you to create a connection to the referenced database (healthcare.db)

install.packages(“devtools”)

devtools::install_github(“rstats-db/RSQLite”)

library(DBI)

library(RSQLite)

con <- dbConnect(SQLite(), “healthcare.db”)

1. Write a line of R code to show what table (there is only one) is in the database
2. Write R code to access the content of the specific table
3. Write R code to select state ID =1 and state name
4. Write R code to add data to the table (you will add 10 IDs and 10 state names)
5. Write R code to show the columns in the table Copy and paste screenshots with the code and output into an MS Word document. You will be submitting only 1 MS Word document for this assignment. Be sure to include comments in all your coding assignments, even if not specified, it is best practice to do so. Please also include your R Studio file so I can run your code (this will be required for any assignment where you are working in software. You will also submit your Tableau files in future modules). (25 points)

2.2 As future practitioners and leaders in health informatics you will find that you will have access to quite a bit of electronic health data. Before you think about creating nice plots or visualizations or asking someone to do this, it will be important to begin by asking yourself what question you want answered by the data. Review the admissions, ICD-9 procedures, diagnosis, and patient .csv files and think of two interesting questions that you would be able to ask if you combined several of these datasets.

Your response should include the following:

-The interesting questions

-What datasets you would consider combining/merging and why. Merging is possible when you have common identifiers across tables or files. For example, if you have the patient IDs in two files then that data could feasibly be related. (10 points total)

2.3

a. Access Power BI and submit a screenshot of your Power BI workspace

b. Install Tableau if you haven’t yet. Begin exploring Tableau now that it is installed.

(you will need to login with your UC username and password to access the entire video)

Practice importing the four .csv files in the module into Tableau and drag one file into Tableau Preview. Capture a screenshot showing your data in Preview and add it to your MS Word document. How many rows and columns are displayed? Do you see any issues with your data that may need correcting? Explain. (15 points)

Add all your responses and screenshots to one MS Word document and submit only one document for this assignment.