SELECT strftime('%Y-%m', OrderDate) Month,
COUNT(OrderID) OrderCount
FROM Orders
GROUP BY strftime('%Y-%m', OrderDate)
ORDER BY MonthAnalysis Report Four - Trend Analysis and Value Creation
Executive Summary
When it comes to platforms for business online, it could be a great tool to help create value through having communities within the platform for more users to be attracted and join. Some organizations depend on platforms that are built behind network effects, multi-homing, disintermediation, clustering, and network bridging. However, it could either positively impact or negatively imapct the platform in the long run. Also in the weeks readings, Digital business models that deal with selling a course, advertising, subscriptions also rely majorly on there data analytics in order to understand their customers. Organizations need to implement these tools and values to grow for the long term and make better strategic business decisions.
Introduction
In the past readings this week, digital platforms create value by the network effects, multi-homing, disintermediation, clustering, and network bridging. These values can either positvely build or negatively bring down the organizations platform. The digital business model reading focuses on how organizations uses these digital business models in order to create a larger revenue and reach a broader audience.
Outside Research
An organization that struggles with their platform to this day is the company Apple through the app store. In June of 2026, Apple publicly announced their agreement between the competitive regulators in Brazil resulting in allowing developers of Brazil their own apps and payment methods outside of the app store. This would be an example of disintermediation and multi homing since the customers now can have the option to bypass apples systems. Apple built a strong ecosystem that was able to present value to their customers but the regulation increase in Brazil created a problem with Apple in the long run.
Data Visualizations 1
ggplot(myquery1,
aes(x = Month, y = OrderCount, group = 1)) +
geom_line() +
labs(
title = "Number of Orders Over Time",
x = "Month",
y = "Number of Orders"
)Data Visualizations 2
SELECT strftime('%Y', OrderDate) Year,
SUM(Freight) TotalFreight
FROM Orders
GROUP BY strftime('%Y', OrderDate)
ORDER BY Yearggplot(myquery2,
aes(x = Year, y = TotalFreight, group = 1)) +
geom_line() +
labs(
title = "Total Freight Over Time",
x = "Year",
y = "Total Freight"
)Recommendations for Industry
When it comes to data analytics and time trends, organizations can better understand and make strategic decision when understanding their customer activity over time. Organizations are able to look at the number of orders and their freight distribution and determine based off the data, if they should increase or decrease. Overall, digital platforms from organizations need to focus on creating value between their customer by having strong network effects and bridging, also while trying to migitate and limit the risk of multu-homing and disintermediation. In conclusion, organizations are able to continue improving their services and products through the user/customers experience which creates a long run value between the customer and organization.
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?){yun2021app, title={App Stores, Aftermarkets, & Antitrust}, author={Yun, John M}, journal={Ariz. St. LJ}, volume={53}, pages={1283}, year={2021}, publisher={HeinOnline} }