BUAD 342 FINAL
Where are your files in Windows?
Go File Explorer and Find My Documents. You should see My Tableau Repository folder. Unless you change your defaults, files are likely stored in Documents>My Tableau Repository>Workbooks and Documents>My Tableau Repository>Datasources
Inner Join
I am using Tableau and pulling in two data sources that are related via a PK & FK. I need to include only records from the two sources that have data in common. I should choose a (n) ________ A.Left Join B.Right Join C.Inner Join D.Union E.Outer Join
A.IaaS
I have decided not to buy my own servers, virtual machines, networks, etc. but to rent them on a pay-as-you-go basis. My best option is A.IaaS B.PaaS C.SaaS D.Create and host my own private cloud E.None of the above
Watson
IB's _____beat two of the most successful human contestants at jeopardy
Story
If you would like to convey information using a controlled sequence of visualizations, which capability within Tableau would you use? A.Sheet B.Dashboard C.Story D.Union E.Extraction
important FIRST steps of any data analysis project.
Importing your data and cleaning/formatting data are -people spend 80% of time cleaning data and 20% analyzing it
Predictive analytics
These models use past data and predictive algorithms to help you determine the probability of what will happen next.
OFTEN THIS IS NOT ACCURATE.
Typically, fields with text (nominal or other text) values are tagged as Dimensions and fields with numeric values are tagged as Measurements.
false
When Tableau determines that field is a Dimension instead of a Measurement, there is only one way to change its properties.
chatbots
are essentially the "apps" of voice and messaging platforms, defining how people converse with your digital business services and data."
Dimensions
are fields that are qualitative and usually cannot be aggregated to produce a meaningful sum. Dimension fields are usually used for row or column headings. Examples include sales region, employee, location, or category.
College football team use internet of things
are now monitoring hits through helmet technology. It allows coaches to measure head impacts for each player
Deep learning
(deep neural networking) is a subfield of machine learning that is concerned with emulating the learning approach that human beings use to gain certain types of knowledge. _____trains a computer to perform human-like tasks, such as recognizing speech, identifying images or making predictions. Instead of organizing data to run through predefined equations, deep learning sets up basic parameters about the data and trains the computer to learn on its own by recognizing patterns using many layers of processing
bot
(short for "robot") is a program that operates as an agent for a user or another program or simulates a human activity. On the Internet, the most ubiquitous bots are the programs, also called spiders or crawlers, that access Web sites and gather their content for search engine indexes.
Robotic process automation (RPA)
) is the use of software with artificial intelligence (AI) and machine learning capabilities to handle high-volume, repeatable tasks that previously required humans to perform. These tasks can include queries, calculations and maintenance of records and transactions
proof of work.
*The process of solving the mathematical problem that validates a new block in a block chain is called
Tableau Prep
, a brand new data preparation product designed to empower people to quickly and confidently combine, shape, and clean their data, further reducing the time from data to insight. The application features a direct and visual experience for data preparation giving customers a deeper understanding of their data, smart features to automate complex tasks
seven common reasons organizations are turning to cloud computing services:
-cost -speed -global scale -productivity -performance -reliability -security
Deep learning
-self driving car It is a machine trying to adapt to an unlimited number of outcomes. When you drive, there is not a limited number of outcomes. Deep learning will allow it to think for itself. They will make a decision based on past data that they have collected.
blockchain
1. is a disrupted ledger meaning that other people can see it and there can be no changes made to the ledger without the changes being unanimously approved. (cannot delete block in a chain) 2. All changes to a block chain must be approved by a consensus 51% of users. 3. You cannot delete a block in the chain, but rather you must create a new block that undoes the previous one if you wish to make changes.
All of the above
A Tableau workbook contains sheets. A sheet can be a A.Dashboard B.Story C.Sheet D.All of the above E.None of the above
sheet
A _____ can be a worksheet, a dashboard, or a story.
true
According to the video from ESET, a botnet is a network of computers infected with malware that can be controlled by a hacker known as a bot master.
chat bot.
Amazon returns, or a lot of websites that have a chat feature
Internet of Things
An organization has decided to use devices on shopping carts and shopping baskets to track a consumer's path through a store and improve store layout and place premium products in high traffic areas. This is an example of A.Augmented Reality B.BYOD C.Machine Learning D.Internet of Things E.None of these
false
General Data Protection Regulation (GDPR) was created to protect consumers' credit card information collected by companies.
worksheet
A Tableau ____contains a single view along with shelves, cards, legends, and the Data and Analytics panes in its side bar.
story
A Tableau _____ allows to designate a sequence of visualizations (stored as worksheets or dashboards) that work together to convey information. A _____ is a good way to "control" the order in which a user looks at worksheets. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case.
dashboard
A Tableau _____ is a collection of views from multiple worksheets. The Dashboard and Layout panes are available in its side bar.
Dashboard
A Tableau ___________ is best described as a collection of views from multiple worksheets that can be viewed simultaneously (at the same time). A.Story B.Dashboard C.Workbook D.View E.All of the above
false
Blocks in a blockchain can be deleted if the information is proven to be false or misleading after they have been added.
Procure to Pay Process
Buying "Things" Event •Identify a Need •Negotiate Purchase Order •Receive and Inspect Goods •Store/Maintain Goods •Pay Vendor •Return Goods
DELTA Model
Data - unique, accessible and clean to your company Enterprise wide - focus where data and analytics available to a firm (key data system and analytics resources available to whole firm) Leaders - at all levels that promote data analytics driven culture Targets - for key business areas that can benefit from this approach Analysts - to execute strategy
Artificial Intelligence (AI)
Just as the cloud enables the Internet of Things, the Internet of Things devices are enabled by advances in_____
Microsoft Tay
Microsoft released bot in Twitter designed to be 18-24 year old female bot as people twitered to her she would learn from it. -more communication with people was suppose to make her smarter -didn't work
Order to Cash Process
Selling "Things" Event •Market Goods or Service •Negotiate terms of Sales Orders •Select and Inspect Goods •Prepare goods/services for Delivery •Deliver Goods/Services •Receive Payment for Goods/Services •Negotiate Terms/Accept Returns
drivers
Sometimes you need additional software called ___ to enable a connection to Tableau (and other software):
side bar.
The Story and Layout panes are available in its _____
workspace
The Tableau _____-consists of menus, a toolbar, the Data pane, cards and shelves, and one or more sheets.
Infrastructure-as-a-service (IaaS)-
The most basic category of cloud computing services. With ______, you rent IT infrastructure—servers and virtual machines (VMs), storage, networks, operating systems—from a cloud provider on a pay-as-you-go basis. -get physical items from a third party
mining
The process of adding a new block to the chain is called
Deep Learning
Which of the following technological advances attempts to teach machines to learn on their own by enabling them with layers of processing power? A.Robot Process Automation B.Internet of Things C.Deep Learning D.Artificial Intelligence E.Machine Learning
Both B and D
Which of the following would be considered a measurement in Tableau? A.Employee Name B.Gross Sales C.Zip Code D.Price per Item E.Both B and D
None of the above
Which of these is not an example of a disruptive technology? A.3D Printing B.Uber C.Netflix D.Amazon Prime E.None of the above
Software-as-a-service (SaaS)
You all have an office 365 account that UT gave you. You don't own excel, powerpoint, etc. UT provides it to you because you are students. You didn't pay for it, but rather UT covers the subscription so that you don't have to.
clean data
You will get so called ____with instructions for how to merge and/or join separate files.)
Cloud Computing
a general term for the delivery of hosted services over the internet. Such as: •Create new apps and services •Store, back up, and recover data •Host websites and blogs •Stream audio and video •Deliver software on demand •Analyze data for patterns and make predictions
internet of things video
a lot of things are connected to internet (phones, computer, videogame, smart tv, refrigerator -estimated that by 2020 there will be 50 billion objects connected to internet -internet monitors our very move -IPV6= creates more potential address than the amount of atoms in surface of earth (alter reality as we know it)
machine learning
a subset of AI that includes abstruse statistical techniques that enables machines to improve at tasks with experience. The category includes deep learning
Machine learning
a subset of artificial intelligence (AI) that trains machines how to learn. Machine learning allows software applications to become more accurate in predicting outcomes without being explicitly programmed. The basic premise of machine learning is to build algorithms that can receive input data and use statistical analysis to predict an output value within an acceptable range.
deep blue
an IBM computer called ______defeated the reigning world chess champion, Garry Kasparov. -machine learning
artificial intelligence (AI)
any technique that enables computers to mimic human intelligence , using logic, if then rules, decision trees, and machine learning (including deep learning ) -is when we are trying to teach a machine something that it shouldn't be able to do. Or something that humans can do. Chat bot, self-driving car, etc.
Twitter bots
are computer programs that tweet on their own. While people access Twitter through its Web site or other app/client, bots use a code-to-code to the Twitter mainline, via Twitter's application programming interface (API), parsing the information in real time and posting on their own.
Bots
are consumer-facing software agents designed to execute an action or task, such as learning what's on tap or shopping for and buying a mattress. They use voice activation and natural language processing technologies in the form of Siri, Cortana, Alexa and Google Assistant. Artificial intelligence platforms such as Alexa Skills and Google Actions support bot technology. Bots inhabit new and evolving device form factors such as Amazon Echo, Google Home and Roku while also being available through popular communication applications such as Facebook Messenger and Skype. Bots enable consumers to execute transactions, such as ordering coffee from their kitchen when they are almost out, using just their voice — without touching a single screen or device.
Public clouds
are owned and operated by a third-party cloud service provider, which deliver their computing resources like servers and storage over the Internet. Microsoft Azure is an example of a public cloud. With a public cloud, all hardware, software, and other supporting infrastructure is owned and managed by the cloud provider. You access these services and manage your account using a web browser. ex: dropbox, onedrive
Measures
are those fields that can be measured, aggregated (used for mathematical operations). Measures are usually used for plotting or giving values to the sizes of markers. Examples include sales revenue or times
AlphaGo
beat the best Go player
Blockchain
can only be updated by consensus between participants in the system, and when new data is entered, it can never be erased. The blockchain contains a true and verifiable record of each and every transaction ever made in the system.
Hybrid clouds
combine public and private clouds, bound together by technology that allows data and applications to be shared between them. By allowing data and applications to move between private and public clouds, hybrid cloud gives businesses greater flexibility and more deployment options.
A workbook
contains sheets.
created bots that were suppose to talk to each other, eventually they got so intelligent that they created their own language and Facebook ended up turning them off
Descriptive Analytics
dash boards, score cards and alerts -tell what happened in the past but not why it happened or what might change
Blockchain
enables Cryptocurrency currencies like bitcoin to function
Procure to Pay
includes the activities involved in acquiring, paying for, and maintaining the goods and services needed by an organization. The overall objective of the procure to ____is to provide needed resources for the organization's order to cash and conversion processes at an optimal time (at the point when they are needed in an effort to reduce process cycle times, waste and costs)
Order to Cash
includes the sequence of activities that collectively serve to attract and retain customers, help customers select goods and services, deliver the goods and services requested, and collect payments for the goods and services. Essentially, the ______business process is the mirror image of the procure to pay business process. Whenever one entity acquires and pays for goods and services, another entity is selling the goods or services and receiving payment.
Disney "Internet of things "
invest 1billion to boast customer experience by leveraging big data lot and machine learning - create magic bands (RFID reader/tag) walk by reader and register your there (act as ticket into park, id)
cryptocurrency
is a digital medium of exchange that uses encryption to secure the processes involved in generating units and conducting transactions. -are a subset of digital currencies and, as such, have no physical representation. They may be used for online or in-person transactions with any vendors who accept them. In-person transactions using - are typically conducted through mobile payment from a digital wallet.
bitcoin
is a form of Cryptocurrency not blockchain
Visualization
is a general term that describes any effort to help people understand the significance of data by placing it in a visual context.
Data visualization
is a general term that describes any effort to help people understand the significance of data by placing it in a visual context. Patterns, trends and correlations that might go undetected in text-based data can be exposed and recognized easier with data visualization software
Internet of things (IoT)
is a giant network of connected "things" (which also includes people). The relationship will be between people-people, people-things, and things-things. The analyst firm Gartner predicts that by 2020 there will be over 26 billion connected devices. That's a lot of connections (some even estimate this number to be much higher, over 100 billion).
Software-as-a-service (SaaS)
is a method for delivering software applications over the Internet, on demand and typically on a subscription basis. With _____, cloud providers host and manage the software application and underlying infrastructure, and handle any maintenance, like software upgrades and security patching. Users connect to the application over the Internet, usually with a web browser on their phone, tablet, or PC.
Blockchain
is a public electronic ledger - similar to a relational database - that can be openly shared among disparate users and that creates an unchangeable record of their transactions, each one time-stamped and linked to the previous one. Each digital record or transaction in the thread is called a block (hence the name), and it allows either an open or controlled set of users to participate in the electronic ledger. Each block is linked to a specific participant.
machine learning
is an application of artificial intelligence (AI) that provides systems the ability to automatically learn and improve from experience without being explicitly programmed. ______ focuses on the development of computer programs that can access data and use it learn for themselves.
Virtual reality
is an artificial environment that is created with software and presented to the user in such a way that the user suspends belief and accepts it as a real environment. On a computer, virtual reality is primarily experienced through two of the five senses: sight and sound. -think you are in a different place
Analytics
is an encompassing and multidimensional field that uses mathematics, statistics, data mining, visualizations, predictive modeling and machine learning techniques to find meaningful patterns and knowledge in recorded data.
Union
is another method for combining two or more tables by appending rows of data from one table to another. Ideally, the tables that you union have the same number of fields, and those fields have matching names and data types.
Right join
is asking for all the rows from the table displayed or listed on the right and, if there's a match in the table on the left , match it up. When a value in the right table doesn't have a corresponding match in the left table, you see a null value in the data grid.
Full outer join
is asking for every row from the table on the left and every row from the table on the right. If they have matching values, the computer matches them up. If they don't have matching values, the computer will still display each row, but show nulls where they don't match.
disruptive technology
is one that displaces an established technology and shakes up the industry or a ground-breaking product that creates a completely new industry. Ex: Amazon Uber, Lift ,
Internet of things (IoT)
is the concept of basically connecting any device with an on and off switch to the Internet (and/or to each other). This includes everything from cellphones, coffee makers, washing machines, headphones, lamps, wearable devices and almost anything else you can think of. This also applies to components of machines, for example a jet engine of an airplane or the drill of an oil rig. -requires the cloud to work , and the cloud will continue to evolve to better serve IoT
Cloud Computing
is the delivery of computing services—including servers, storage, databases, networking, software, analytics, and intelligence—over the Internet ("the cloud") to offer faster innovation, flexible resources, and economies of scale. You typically pay only for cloud services you use, helping you lower your operating costs, run your infrastructure more efficiently, and scale as your business needs change.
Augmented reality
is the integration of digital information with the user's environment in real time. Unlike virtual reality, which creates a totally artificial environment, augmented reality uses the existing environment and overlays new information on top of it. -ex google glass
data mining
is the process of sorting through large data sets to identify patterns and establish relationships to solve problems through data analysis. Data mining tools allow enterprises to predict future trends.
Left join
join is asking for all the rows from the table displayed or listed on the left and, if there's a match in the table on the right match it up. When a value in the left table doesn't have a corresponding match in the right table, you see a null value in the output.
Inner join
join matches up records between two tables based on designated values. The result set that you get contains the rows from the table on the left that match the table on the right. If there are rows in either table that don't match, they aren't returned in the result set.
Predictive Analytics
more useful. Use past data to model future outcomes perhaps indicating how customers will respond to a marketing promotion or how sales will be affective by certain market condition
A private cloud
refers to cloud computing resources used exclusively by a single business or organization. A ______ cloud can be physically located on the company's on-site datacenter. Some companies also pay third-party service providers to host their private cloud. is one in which the services and infrastructure are maintained on a private network. -more expensive
Platform-as-a-service (PaaS)
refers to cloud computing services that supply an on-demand environment for developing, testing, delivering, and managing software applications. ______is designed to make it easier for developers to quickly create web or mobile apps, without worrying about setting up or managing the underlying infrastructure of servers, storage, network, and databases needed for development -gives developers a safe place to test out their apps without worrying about messing things up
big data and analytics
refers to the vast volume and types of information that companies can now collect and process using increasingly high tech system. -when combine big data with effective analytics =key competitive advantage
Blockchains
rely on cryptography, which is includes techniques for secure communication. It is created using mathematics, such as number theory, and the application of formulas and algorithms, that are used to design a method of storing and transmitting data in a particular form so that only those for whom it is intended can read and process it.
Artificial Intelligence
simulation of human intelligence processes by machines (training machines to perform human tasks).
example of internet of things
smart home devices (smart tv, smart camera, windows, blinds) - amazon dash wand with Alexa to order groceries -google nest -HapiFork: make you eat slower and lose weight (lets you know when you're eating too fast) -Smart vending machine: including one that is using facial recognition -Kilobree: a toothbrush that helps improve brushing but also sends data to your phone -- --reminds you to brush, or rats out your children when they don't
deep learning
the subset of machine learning composed of algorithms that permits software to train itself to perform tasks, like speech and image recognition by exposing multilayered neural networks to vast amounts of data
analytics
the use of math and statistics to derive meanings from data in order to help us make better and informed decisions
Prescriptive Analytics
uses optimization or a b testing to advise managers and workers on how best to do their jobs -they might tell a tv salesman the right discount to offer or a web designer which add will aliased more quicks or a truck driver where to stop for gas
machine learning
which is teaching a computer to make decision based on a set number of outcomes. I am trying to teach a computer what to do based on a finite number of outcomes. The first one that we ever tried to create was a computer called Deep Blue who could play and win chess. There are only a finite number of outcomes in chess, so we teach the machine everything that could happen
blockchain video
•Once you have a block in a blockchain, it is connected to the block before and the block after. •So, if I sell my diamond, that sale is connected to the transaction where I bought it and the person I sold it to. •Once I add a block, I cannot delete that block. •We can change them by making a new block. •In order for there to be a new block in the chain, there has to be CONSENSUS. 51% of people.
Descriptive statistics
•These are the models that will help you understand what happened and why. There are still plenty of descriptive analytics in use today - everything from how many clicks a page receives to how many units are produced vs. how many are sold. -what historically we have used? Looks back
Prescriptive analytics.
•answers the question of what to do by providing information on optimal decisions based on the predicted future scenarios. The key to _____ is being able to use big data, contextual data and lots of computing power to produce answers in real time. -where we want to be?
