--I've completed this for you as a placeholder. Replace this with your query.
--SQL code in this block
SELECT ProductName, UnitPrice, CategoryName
FROM Products
INNER JOIN Categories
ON Products.CategoryID = Categories.CategoryIDAnalysis Report One - What’s Your Data Strategy
Executive Summary
When it comes to AI and data being a valuable resources for the business, however, it requires more than just collecting data and not efficiently and effectively organizing or protecting the secured information. The readings this week explained that organizations need to find a good balance between data offense which focuses on using data to help improve decision making. And data defense which prioritize security and the data quality. Also this reading disagrees that Ai will be able to create a sustainable competitive advantage because it so readily available to all businesses. How to overcome that would be through combing a strong data strategy while optimizing AI use for the long-term sustainability.
Introduction
During this week’s readings, the main concept was focused around how organizations should operate their data strategy instead of just collecting information and having flaws. In the article, Whats Your Data Strategy, it explains that instead of collecting data, businesses need to implement data offense and data defense which would improve business performance, customer retention in the long run, and decision making. While increasing security and overall quality for the data defense. Also another concept that was found in this week’s reading was single source of truth (SSOT). SSOT helps keep the data accurate across the whole business. However, it explains that generative AI is easily accessible to businesses so therefore it cant have a competitive advantage unless used correctly.
Research and Extensions
Business continue to implement Ai to improve their day to day operations and decision making. However, there has been reports and research that shows there cant be growth if AI is not used to its correct and fullest way. In 2024 there was a study conducted that helped researchers understand how organizations recieve the full value of AI by having a strong data security, high quality, and workers that understand how to operate AI. This also supports the concept from “Whats Your Data Strategy” which went over data offense and defense. Lastly, it reinforces with the article “Why AI will not provide sustainable competitive advantage” by stating that AI alone is not dependeable to create a substain competitive advantage. When organizations combine human innovations with AI they are able to have a more sustainable competitive advantage long term.
Data Visualizations
Include the code and graphs for your two visualizations here (One offensive, defensive). You should describe your data and the visualization, together with an explanation of why the example is relevant for organizations today.
Your queries may be loosly based on Practice queries, but they must extend or adapt the practice in interesting ways (again sticking to the practice concepts) if you want to score highly. Your goal is to show mastery of the week’s material.
Visualization One - Offensive
Important
Don’t forget to do you live edit when you present Visualization one. You must change your WHERE statement in some meaningful way, then rerun your visualization to show the change.
#ggplot visualization in this block. I prettied this up with labels to show what is possible.
ggplot(data = myquery1,
aes(x = CategoryName)) +
geom_bar() +
theme_minimal() + # Cleans up the background grid lines
labs(
title = "Number of Products by Category",
subtitle = "Data taken from Northwind",
x = "Product Category",
y = "Number of Products",
caption = "Source: Northwind Sqlite"
)
Visualization Two - Defensive
--Put your SQL code in this block
SELECT ProductName, UnitsInStock
FROM Products
WHERE UnitsInStock < 10#Put your ggplot visualization in this block
ggplot(data = myquery2,
aes(x = reorder(ProductName, UnitsInStock),
y = UnitsInStock)) +
geom_col() +
coord_flip() +
theme_minimal() +
labs(
title = "Products with Low Inventory",
subtitle = "Products with fewer than 20 units in stock",
x = "Product",
y = "Units in Stock",
caption = "Source: Northwind SQLite"
)
Recommendations for Industry
When looking back at the research and data, organizations need to start prioritizing both data offense and data defense in their data strategy. Companies should implement the data offense strategic whenever it comes to better decision making and how customers interact with the business. It also helps with oppurtunities of innovations with a data team. However, the business must utilize their data defense in order to enhance security on data and have higher quality data through organization governance. Generative AI for business are not a sustainable competitive advantage because it is easily accessible. Companies need to start combining their data management team with AI to create better decision and reduce the business risk which creates a substainable competitive advantage in the long run.
References
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?){bernardo2024data, title={Data governance & quality management—Innovation and breakthroughs across different fields}, author={Bernardo, Bruno Miguel Vital and S{~a}o Mamede, Henrique and Barroso, Joao Manuel Pereira and Dos Santos, V{'}tor Manuel Pereira Duarte}, journal={Journal of Innovation & Knowledge}, volume={9}, number={4}, pages={100598}, year={2024}, publisher={Elsevier} }
(article?){bughin2024drives, title={What drives the corporate payoffs of using generative artificial intelligence?}, author={Bughin, Jacques}, journal={Structural Change and Economic Dynamics}, volume={71}, pages={658–668}, year={2024}, publisher={Elsevier} }