Richard J. Bocchinfuso

"Be yourself; everyone else is already taken." – Oscar Wilde

FIT – MGT 5115 – Wk 3 Assignment

You will create a PowerPoint presentation to address the question below. Your PowerPoint presentation should be between 8-12 slides, and developed as if you are presenting to fellow colleagues within the IT industry. 

What are the functions of databases and/ or data warehouses?  Present examples from an office environment or other industry with which you have personal experience (i.e.: health field, accounting, fitness environment, academic institutions), that illustrates these functions (billing, customer searches, etc.)

[google-drive-embed url=”https://docs.google.com/presentation/d/1GNp9xCjperSu7WCIfO_4HB87Ru-Y9A2_ZZZ1BD7H4VM/preview?usp=drivesdk” title=”FIT MGT 5115 Week 3 Presentation” icon=”https://drive-thirdparty.googleusercontent.com/16/type/application/vnd.google-apps.presentation” width=”100%” height=”400″ style=”embed”]

FIT – MGT 5115 – Wk 3 Discussion Post

How does data quality impact business performance? Using your textbook as a resource, describe the functions of database technology, the differences between centralized and distributed database architecture, how data quality impacts performance, and the role of a master reference file in creating accurate and consistent data across the enterprise.

When poor data quality such as missing and/or erroneous data negatively impacts operations, it can cost organizations business, affecting revenues and profits.  Missing and/or erroneous data can affect current revenues and can frustrate customer and place an organizations reputation at risk putting both existing and future business at stake. Data quality issues can decrease efficiency and increase costs, lack of confidence in data integrity causes organizations to spend time and money on data validation and error correction activities.

The goal of a database is to store data in a structured way (maybe).  Two popular database architectures are SQL and NoSQL databases.  SQL or RDBMS (Relational Database Management Systems) are relational with a defined schema. NoSQL databases or document databases are often schemaless and rely on key-value pairs defined at ingest.  As you can imagine ingesting (or inserting) data into a specified schema makes managing data integrity easier than defining the key-value pairs at the time of ingest.

Centralized and distributed database architectures are quite intuitive.  Centralized database architectures centralize the storage and control of data while distributed database architectures allow data to be stored on edge devices such as laptops, tablets, and mobile devices or distributed using master/master, master/slave or parent/child relationships.  Centralized database architectures offer greater control of data quality and security because all data is stored in a single physical location thus adds, updates and deletes can be made in a supervised and orderly fashion.  Centralized database architectures also allow for better security. It is easier to control physical and logical access to a centralized architecture, and the attack surface is limited when contrasted with a distributed system.

Centralized and distributed database architectures each come with tradeoffs which should be considered when selecting an appropriate architecture.  With more and more processing being pushed to the edge (e.g. – mobile and IoT growth) and with ever increasing big data demands decentralized distributed databases like Apache Cassandra and RethinkDB are experiencing massive growth.  Centralized databases like Microsoft SQL Server, MariaDB and others are still very prominent, but even these centralized database players are trying to adapt their architectures to support distributed database architectures to capitalize on the big data revolution.

Master reference files provide a common point of reference and act as a single source truth for a given data entity. Data entities might include customer, product, supplier, employee or asset data. As a single source of truth, master reference files are used to feed data into enterprise systems and maintain data quality and integrity.

References

Buckler, Craig. “SQL vs NoSQL: The Differences — SitePoint.” SitePoint, SitePoint, 18 Sept. 2015, www.sitepoint.com/sql-vs-nosql-differences/. Accessed 14 Sept. 2017.

“Do You Know How Data Quality Impacts Your Business?” BackOffice Assicates, 23 July 23ADAD, resources.boaweb.com/backoffice-blog/do-you-know-how-data-quality-impacts-your-business. Accessed 14 Sept. 2017.

Turban, Efraim, et al. Information technology for management digital strategies for insight, action, and sustainable performance. New Jersey (Estados Unidos), Wiley, 2015.

FIT – MGT 5115 – Wk 2 Discussion Post

Why do managers and workers still struggle to find the information that they need to make decisions or take action despite advances in digital technology? That is, what causes data deficiencies?

Corporate infrastructure and decision support systems have evolved over decades. Over this same period, organizations have endured management changes, shifting priorities and differing perspectives on the role of IT. Data silos, lost or bypassed data, poorly designed interfaces, nonstandardized data formats and chronically in flux requirements further compound the natural system and organizational challenges brought on by progress,

In my opinion, organizations can begin to combat some of the corporate infrastructure and organizational behavior issues by having a clear vision and mission when it comes to information systems. Management changes will happen, but an organization that has a clear vision and mission regarding the value of data and information will stay focused on strategic objectives amidst regime change. Everyone within the organization should be viewed as a stakeholder and a benefactor. There is an education process that needs to take place; all the parties concerned need to have the right reaction to the blue button moment. Data silos, poor user interface design, etc… persist because a wrong choice is made when a blue button moment occurs. The ability to changes the future depends on the decisions we make now.

The wrong blue button moment:
System doesn’t love embedded images so here is a link: https://goo.gl/L1XDLk

Source: Alex Cowan – Getting Started: Agile Meets Design Thinking, University of Virginia

The right blue button moment:
System doesn’t love embedded images so here is a link: https://goo.gl/fFdjnh

Source:  Alex Cowan – Getting Started: Agile Meets Design Thinking, University of Virginia

I believe we are lowering the barrier to entry when it comes to how we transform data into information. For years the industry spent time trying to force data into a common data model for business intelligence (BI), this normalization process usually consisted of one or more ETL (extract, transform, load) jobs. These jobs were typically batched, and the end state was a normalized data set pushed into a relational database management system (RDBMS), the relational SQL database schema was rigid and comprised of tables consisting of columns, rows, and fields. We called these DSS (Decision Support Systems) data warehouses and data marts. Fast forward a few years and many of these information systems which leveraged historical data as the primary predictor of the future are pivoting towards NoSQL databases where key-value pairs have replaced SQL relationships. NoSQL information systems are meant for massive real-time ingest; these systems are being used to build data lakes. The ability to use key-value pairs removed the need for a rigid schema often removing the need for an ETL process. The field of Data Science, NoSQL platforms like Hadoop, applications like Elastic Search for indexing, Kibana for visualization and programming languages like RPythonOctave, etc… make capturing data and performing analytics easier than ever before. With the advent of public cloud and platforms AWS EMRAWS Data PipelineGoogle Cloud DataflowGoogle Cloud Dataproc and many of the issues like data silos, lost or bypassed data, poorly designed interfaces, and nonstandardized data formats are being addressed.  The technology is being adapted to address matters that have persisted for a very long time; these new technologies are streamlining processes, increasing the time to value and solving some of the issues mentioned above.

References

Data Lake vs. Data Warehouse: Is the warehouse going under the lake? (2016, July 22). Retrieved September 06, 2017, from https://www.dezyre.com/article/data-lake-vs-data-warehouse-is-the-warehouse-going-under-the-lake/283

NoSQL vs SQL- 4 Reasons Why NoSQL is better for Big Data applications. (2015, March 19). Retrieved September 06, 2017, from https://www.dezyre.com/article/nosql-vs-sql-4-reasons-why-nosql-is-better-for-big-data-applications/86

Turban, E., Volonino, L., & Wood, G. R. (2015). Information technology for management digital strategies for insight, action, and sustainable performance. New Jersey (Estados Unidos): Wiley.

FIT – MGT 5115 – Wk 1 Assignment

Explain how IT (Information Technology) impacts your career and the positive outlook for IS (Information Systems) management careers.

[google-drive-embed url=”https://docs.google.com/presentation/d/1I-oDP-ci5C4gNkcG4OftGp21OpLNmjxBAAPlmW52eRg/preview?usp=drivesdk” title=”FIT MGT 5115 Week 1 Presentetation” icon=”https://drive-thirdparty.googleusercontent.com/16/type/application/vnd.google-apps.presentation” width=”100%” height=”400″ style=”embed”]

FIT – MGT 5115 – Wk 1 Discussion Post

Select three companies in different industries – such as banking, retail store, supermarket, airlines, or package delivery – that you do business with. What digital technologies does each company use to engage you, keep you informed, or create a unique customer experience? How effective is each use of digital technology to keeping you a loyal customer?

First, let me start by saying I’ve been in tech for the past 25+ years and the disruption and opportunity that public cloud computing has brought to the market has been incredible. While cloud computing may not be as visible as the transistor to the consumer, the impact of cloud computing on those who understand the industry is very significant. When we look the economics of public cloud, open source, etc… and we think about what it takes to incubate a great idea today vs. what it took twenty years ago we are just scratching the surface of the disruptors we will see emerge in this market.

Online Retailer: Amazon
Amazon does so many things well, everything from customer acquisition, to logistics and scale, but much of what Amazon does has nothing to do with retail and everything to do with big data, analytics, artificial intelligence and machine learning. Amazon knows you better than you know yourself, their storefront product placement on Amazon.com, the emails you get suggesting what you might like is not happenstance. Everything that Amazon is doing is rooted in artificial intelligence and machine learning. Amazon relies on data you willingly volunteer, AI and machine learning for everything from supply chain management, warehouse logistics, Amazon storefront user experience to shipping logistics. Amazon creates a unique customer experience by presenting the customer with things they care about, by delivering value, convenience, and quality which is all possible because of Amazon’s efficiency which is driven by technology.

Amazon has done an incredible job managing customer acquisition, scaling and getting to a place where they are a threat to both traditional retailers (e.g. – Walmart) and traditional online Titans (e.g. – Search giant Google). More and more customers are searching for products directly on Amazon as opposed to Google, this shift is driven by big data and the closed ecosystem which Amazon has built. We are beginning to see the likes of Walmart and Google adopt a “The enemy of my enemy is my friend” strategy to take on Amazon (https://www.nytimes.com/2017/08/23/technology/google-walmart-e-commerce-partnership.html). We’ve also seen Walmart begin to turn the screws on their vendors who are using AWS (Amazon Web Services) (https://www.cnbc.com/2017/06/21/wal-mart-is-reportedly-telling-its-tech-vendors-to-leave-amazons-cloud.html), this market is getting very interesting, and Amazon is at the center of the story.

Financial Services: Capital One
Capital One is arguably one of the most technologically forward thinking banking institutions who went all in on public cloud very early (https://medium.com/aws-enterprise-collection/capital-ones-cloud-journey-through-the-stages-of-adoption-bb0895d7772c). Capital One maintains a few brick and mortar locations but they are sparse, and their focus is on building technology for a set of consumers who prefer mobile banking. Because Capital One is focused online and not on brick and mortar locations, they pay high-interest rates with low fees, their economics weel much different than a traditional commercial bank. Capital One’s focus on technology and big data have made them a leading credit card company. Using big data and analytics Capital One develop new products that appeal to the consumer while managing unsecured credit risk. One of the things I love about

I think the credit industry is one of the more interesting banking sectors to watch. For years credit issuers have used something called the FICO (Fair, Isaac and Company) score to determine credit worthiness but this is an antiquated measure of credit worthiness, and this market is ripe for disruption. IMO startups like Tala (https://tala.co/) represent the future of credit worthiness.

Will also see how online banking goliaths like Capital One fare in the payment and transfer marker competing against the likes of PayPal, Square, Venmo, etc… and also how blockchain impacts the financial services industry.

Advanced Media: MLB Advanced Media (MLBAM) and later BAMTech.

http://www.mlbam.com/
MLB Advanced Media focused on building a media streaming, big data and analytics platform for Major League Baseball. The amount of raw data that MLBAM was capturing and storing forced them to consider not only the economics associated with compute, storage, energy, etc… but more importantly could they be and did they want to be the custodian of the Petabytes of data they would collect, was this their core business. The answer to this and other questions made MLBAM an early cloud adopter leveraging AWS to build content repositories (AWS S3), transcoding services (AWS Elastic Transcoder), content distribution services (AWS CloudFront), Streaming data and analytics (AWS Kinesis & Redshift), etc… etc… On top of these public cloud services, MLBAM delivered platforms MLB At Bat (http://m.mlb.com/apps/atbat), MLB.tv (http://mlb.mlb.com/mlb/subscriptions/index.jsp?c_id=mlb) and MLB Statscast (https://www.mlb.com/video/statcast-blashs-diving-catch/c-1788681583?tid=240568594) which is probably most impressive when you watch this AWS re:Invent keynote (https://youtu.be/847HY-JATrs). MLBAM built a platform that they realized that this platform had mass market appeal, so they spun out BAM Tech which is co-owned by MLB Advanced Media, Walt Disney Co., and the NHL. MLBAM’s platform now powers incredibly popular streaming services like HBO Now (https://play.hbonow.com/). MLBAM change took an already statistics driven game to a new level, leveraging big data and analytics in the public cloud.

I could go on and on here, so much incredible innovation and disruption happening in every industry, driven by cloud computing, big data, machine learning and IoT. The technologies are changing the game for every sector and every industry.

No matter what industry you look at, artificial intelligence and machine learning are a rocket ship, and data is the fuel. The more connected we become, the more data we volunteer, the more fuel we provide. It’s up to industry to convert this potential energy into kinetic energy. Those who can do it will reach new heights and those who can’t will likely fizzle out. The market is moving so fast that the need to maintain a legacy business is rapidly becoming an impediment, new business models unencumbered by legacy revenue models are attacking those looking to protect legacy revenue models. The NetFlix vs. Blockbuster story is one where Blockbuster was addicted to late fees. This addition to a legacy business model prevented them from pivoting. Yes, the road ahead would be harder, yes the road ahead may have required closing brick and mortar and moving to a subscription model (no more late fees), yes this may have impacted revenue and profits, etc… Blockbuster couldn’t identify and admit they had an addiction. Blockbusters dependence on late fees (16% of revenues) and their desire to protect revenues would play a significant role in their inability to pivot and ultimately to their death (dramatic but true). Blockbuster couldn’t make the tough decisions, and even though they had numerous first mover advantages and a loyal customer base, they lost.

Bibliography

Bishop, T. (2017, May 06). Jeff Bezos explains Amazon’s artificial intelligence and machine learning strategy. Retrieved August 30, 2017, from https://www.geekwire.com/2017/jeff-bezos-explains-amazons-artificial-intelligence-machine-learning-strategy/

Brown, M. (2015, August 13). MLB Approves New Digital Media Company Spin-Off That Will Create Billions In New Revenues. Retrieved August 30, 2017, from https://www.forbes.com/sites/maurybrown/2015/08/13/mlb-approves-new-digital-media-company-spin-off-that-will-create-billions-in-new-revenues/#5f6833fc315d

Dee, S. (2016, April 14). How Does Capital One Differentiate Itself In The Card Industry? Retrieved August 30, 2017, from https://www.forbes.com/sites/greatspeculations/2015/09/11/how-does-capital-one-differentiate-itself-in-the-card-industry/#2268237f3cda

Meola, A. (2016, April 22). Capital One is expanding its digital technology. Retrieved August 30, 2017, from http://www.businessinsider.com/capital-one-is-expanding-its-digital-technology-2016-4

Orban, S. (2017, April 05). Capital One’s Cloud Journey Through the Stages of Adoption. Retrieved August 30, 2017, from https://medium.com/aws-enterprise-collection/capital-ones-cloud-journey-through-the-stages-of-adoption-bb0895d7772c

Popper, B. (2015, August 04). How baseball’s tech team built the future of television. Retrieved August 30, 2017, from https://www.theverge.com/2015/8/4/9090897/mlb-bam-live-streaming-internet-tv-nhl-hbo-now-espn

Taft, D. K. (2017, August 28). Capital One Taps Open-Source, Cloud, Big Data for Advantage in Banking. Retrieved August 30, 2017, from http://www.eweek.com/cloud/capital-one-taps-open-source-cloud-big-data-for-advantage-in-banking

Thomas, L. (2017, June 21). Wal-Mart is reportedly telling its tech vendors to leave Amazon’s cloud. Retrieved August 30, 2017, from https://www.cnbc.com/2017/06/21/wal-mart-is-reportedly-telling-its-tech-vendors-to-leave-amazons-cloud.html

WAKABAYASHI, D., & CORKERY, M. (2017, August 23). Google and Walmart Partner With Eye on Amazon. Retrieved August 30, 2017, from https://www.nytimes.com/2017/08/23/technology/google-walmart-e-commerce-partnership.html