Analysis Report Two - Systems Integration and Decision Support

# This setup block will not show when you render the report
library(tidyverse)

── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
✔ dplyr     1.1.4     ✔ readr     2.1.5
✔ forcats   1.0.0     ✔ stringr   1.5.1
✔ ggplot2   3.5.1     ✔ tibble    3.2.1
✔ lubridate 1.9.3     ✔ tidyr     1.3.1
✔ purrr     1.0.2     
── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
✖ dplyr::filter() masks stats::filter()
✖ dplyr::lag()    masks stats::lag()
ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors

library(DBI)
library(RSQLite)

# Connect to the database
mydb <- dbConnect(RSQLite::SQLite(), "../northwind.db")

Executive Summary

This report will highlight how healthcare organizations can use information systems to improve their data defense and offense. Also, transaction processing systems (TPS) is known for collecting operation data through day to day operations. Then the management information systems (MIS) turn the data into reports, while the enterprise resource planning (ERP) system connect across all departments to a central database. Lastly, organizations can prioritize the important data rather than operating AI apart from the organizations strategies. Overall, healhcare executives should use this system to improve their data offense and defense information in order for workers and employees to have faster and better decision making.

Introduction

Organizations rely on data and information that has been collected which is then used to help with any decision making. The transaction processing system (TPS), management information system (MIS), and enterprise resource planning (ERP) are all systems which can improve the organization which it comes to collecting data and using it properly. The assigned readings also reinforced data defense in high quality rather then collecting non useful data. Lastly, keeping a strong data information system where employees have fast and accurate data to keep the operations effective and effienct as much as possible.

Outside Research

When it comes to the outside research examples, electronic health records (EHR) is able to help integrate different areas of the organization. This could be done through all different departs such as administrative, operations, HR. The EHR system integration can help improve communication throughout the healthcare industry by reducing redundancy and providing evidence throughout the performance, and goes over the whole organizations health and performance. However, there are so hardships when it comes to implementing this tool into the healthcare industry. The problem with implementation is that it is very costly, takes a long time, and does not allow much room for the organization to change. As well as, wrong documentation and data that is far from accurate. Overall, the EHR can be implemented to help with the organizations communication, decision making, and oversight. While having some cons of being expensive, wrongful documentation, and resistance from innovation.

Visualization One - Two Table Join

--I've completed this for you as a placeholder. Replace this with your query.
--SQL code in this block

SELECT Customers.CompanyName,Customers.Country,Orders.OrderID,Orders.OrderDate,Shippers.Phone
FROM Customers, Orders, Shippers
WHERE Customers.CustomerID = Orders.CustomerID
AND Orders.ShipVia = Shippers.ShipperID

Important

For your required live edit this week, you must add a table to your two-table join, making it a three-table join LIVE, explaining why you are doing it at each step of the way and demonstrating what insights you can gain from adding another join and using the data it gives you access to in your visualization. Rerun your visualization to show how the new join extends your visualization in some interesting way.

#ggplot visualization in this block. I prettied this up with labels to show what is possible.
ggplot(data = myquery1,
       aes(x = Country)) +
  geom_bar() +
  coord_flip() +
  theme_minimal() +
  labs(
    title = "Orders by Customer Country",
    subtitle = "Data taken from Northwind",
    x = "Country",
    y = "Number of Orders",
    caption = "Source: Northwind SQLite"
  )

Visualization Two - Three Table Join

-- Include another three table join visualization here. This should be completely separate from your two-table join and show different tables, data etc.
--Put your SQL code in this block
SELECT ProductName, CategoryName, CompanyName
FROM Products, Categories, Suppliers
WHERE Products.CategoryID = Categories.CategoryID
AND Products.SupplierID = Suppliers.SupplierID

#Put your ggplot visualization in this block
ggplot(data = myquery2,
       aes(x = CompanyName)) +
  geom_bar() +
  coord_flip() +
  theme_minimal() +
  labs(
    title = "Products by Supplier",
    subtitle = "Three-table join using Products, Categories, and Suppliers",
    x = "Supplier",
    y = "Number of Products",
    caption = "Source: Northwind SQLite"
  )

Recommendations for Industry

When it comes to the recommendations for the Industry, Organizations need to prioritize the systems talked about which were TPS, MIS, and ERP. The systems enable the organization to have better decision making rather than use a generative AI that hold no data strategy. Companies also need to train workers and employees with the AI so the data can be turn into the information system and recieve quicker data for decision making. This overall will help organizations improve business wise by optimizing their performance through human innovation with AI and all the systems in place.

References

(article?){dallemule2017s, title={What’s your data strategy}, author={DalleMule, Leandro and Davenport, Thomas H}, journal={Harvard business review}, volume={95}, number={3}, pages={112–121}, year={2017} }

(article?){silow2012using, title={Using electronic health records to improve quality and efficiency: the experiences of leading hospitals}, author={Silow-Carroll, Sharon and Edwards, Jennifer N and Rodin, Diana}, journal={Issue Brief (Commonw Fund)}, volume={17}, number={1}, pages={40}, year={2012} }