BUAD 342- Final

discount

- [Quantity sold]*[Sales price per]*[Item Discount]

Smart home devices

- smart Tvs, smart appliances, smart cameras, smart windows blinds

SAS explains that there are three predominant types of analytics in use today.

-Descriptive statistics. -Predictive analytics -Prescriptive analytics

workbook

. Tableau uses a _____ and sheet file structure, much like Microsoft

You want only the measurements of interest in the Measurements section.

. This data set includes Sales data, so most of these will be financial measurements.

Why do we need you to focus on critical thinking more than the specific tool features? If you think about the steps you are performing and focus on

1-interpreting what the data says about a business, and 2-your objectives in creating a series of outputs for your user, you can leverage your learning in this class to more quickly learn how to use other visualization tools.

dashboard

A Tableau ___________ is best described as a collection of views from multiple worksheets that can be viewed simultaneously (at the same time).

A.Dashboard B.Story C.Sheet D.All of the above- ANS E.None of the above

A Tableau workbook contains sheets. A sheet can be a

80 percent and 20 percent

A recent Harvard Business Review article reports that people ____ of their time cleaning and shaping data, and only ______ of their time analyzing it

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.

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

Microsoft Power BI

BI is a collection of online, mobile and desktop services and features that enables you to find and visualize data, share discoveries, and collaborate in intuitive new ways.

Bluetooth trackers

Beeping medicine caps and automated phone calls reminding patients it's time to take the next dose. Smart locks

false

Blocks in a blockchain can be deleted if the information is proven to be false or misleading after they have been added.

Why did we start with database queries first?

Familiarity with databases, queries and SQL are viewed as an added advantage when someone is learning visualization tools. -You will find that some questions are easier to answer using a database query than a visualization tool.

false

General Data Protection Regulation (GDPR) was created to protect consumers' credit card information collected by companies.

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

üCreate three calculated fields -

Gross Sales Net Sales Discounts

.Inner Join

I am using Tableau and pulling in from two data sources. I need to include only records from the two sources that have a data in common and a matching primary key. I should choose a (n)

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

Types of cloud services

IaaS, PaaS, SaaS

story

If you would like to convey information using a controlled sequence of visualizations, which capability within Tableau would you use?

FIRST steps of any data analysis project.

Importing your data and cleaning/formatting data are the most important

Artificial Intelligence (AI)

Just as the cloud enables the Internet of Things, the Internet of Things devices are enabled by advances in

desktop

Power BI _____is designed for authoring (data modeling, merging different data sources, visualization, etc.). Desktop application runs only on Windows.

US Currency

Set default properties, number formats for three computations to

are not supported

Some features (such as count distinct) ______ in Tableau when you are using Microsoft Access data sources, and Microsoft Excel and Text File data sources that have a legacy connection. In some cases, you can correct this by choosing the Extract option -However, when you do, you will need to save the extracted data

drivers

Sometimes you need additional software called ____ to enable a connection to Tableau (and other software):

When you import data,

Tableau initially tags each field as a dimension or a measure. Typically, fields with text (nominal or other text) values are tagged as Dimensions and fields with numeric values are tagged as Measurements. OFTEN THIS IS NOT ACCURATE.

cloud service

The Power BI _____ is designed for sharing and creating dashboards.

side bar.

The Story and Layout panes are available in its

1048576 rows by 16384 columns

The absolute maximum total number of rows and columns on a worksheet:

Infrastructure-as-a-service (IaaS)-

The most basic category of cloud computing services. With IaaS, you rent IT infrastructure—servers and virtual machines (VMs), storage, networks, operating systems—from a cloud provider on a pay-as-you-go basis.

Why should you learn about these technologies?

They are impacting your future workplace, your potential clients, and the very nature of your future careers in significant ways.

false

When Tableau determines that field is a Dimension instead of a Measurement, there is only one way to change its properties.

They can contain formulas and formatting

Which of the following is false about .csv files?

A.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?

Gross Sales & Price per Item

Which of the following would be considered a measurement in Tableau?

A.3D Printing B.Uber C.Netflix D.Amazon Prime E.None of the above (Ans)

Which of these is not an example of a disruptive technology?

joining data

You need to think about how you combine the data, and your choices are

net sales

[Quantity sold]*[Sales price per]*(1-[Item Discount])

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.

Sense Mother

a family of incredibly smart sensors that you can set to monitor whatever you care about

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

A story 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.

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

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.

A sheet can be

a worksheet, a dashboard, or a story

A Tableau story

allows to designate a sequence of visualizations (stored as worksheets or dashboards) that work together to convey information.

Tableau Prep

application features a direct and visual experience for data preparation giving customers a deeper understanding of their data, smart features to automate complex tasks, and integration with the Tableau analytical workflow for faster speed to insight

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.

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.

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.

Changes at "Mickey's House"- Disney Has invested $1 Billion to Boost Customer Experience

by Leveraging Big Data, IoT and Machine Learning

From Microsoft - The main difference between a Free or Pro user is

centered around sharing and collaboration. Only Pro users can publish content to app workspaces, consume apps without Premium capacity, share dashboards and subscribe to dashboards and reports.

With SaaS,

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.

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.

The Tableau workspace

consists of menus, a toolbar, the Data pane, cards and shelves, and one or more sheets.

Tableau worksheet

contains a single view along with shelves, cards, legends, and the Data and Analytics panes in its side bar

A workbook

contains sheets

PaaS 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.

Power BI mobile

enables you to view your reports and dashboards.

Tableau Prep

has customized visual experiences to make common yet complex tasks - such as joins, unions, pivots and aggregations - simple. -These intuitive experiences help customers get desired results faster and with greater confidence.

Predictive analytics

has surged in popularity. The desire to predict customer behavior has been a main driver. Increased computing power with the ability to run hundreds or thousands of models quickly - and widespread adoption of predictive techniques like support vector machines, neural networks and random forests - are bringing predictive analysis to the forefront of many organizations. These models use past data and predictive algorithms to help you determine the probability of what will happen next.

Descriptive statistics.

have been around the longest. Remember the Swedes in 1749? Tabulating population counts was an early foray into descriptive analysis - the summary of collected data points. 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.

Tableau dashboard

is a collection of views from multiple worksheets. - ___ and layout panes are available in its side bar.

Visualization

is a general term that describes any effort to help people understand the significance of data by placing it in a visual context

Software-as-a-service (SaaS)

is a method for delivering software applications over the Internet, on demand and typically on a subscription basis.

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.

left 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.

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.

A 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.

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

as you update worksheets used in dashboards and stories,

it also updates them in the dashboard and story views.

Gartner Research--

major cloud providers, there are three top contenders, and then everyone else.

Inner 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.

a union.

merging/appending data via

The cloud service is

multi-platform - use Microsoft Edge, Internet Explorer, Chrome, Safari, Firefox or mobile apps (iOS, Android and Windows 10).

Employees table includes

one record per Employee.

Types of cloud deployments:

public, private, hybrid

private cloud

refers to cloud computing resources used exclusively by a single business or organization. A private 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. A private cloud is one in which the services and infrastructure are maintained on a private network.

Platform-as-a-service (PaaS)

refers to cloud computing services that supply an on-demand environment for developing, testing, delivering, and managing software applications.

artificial intelligence

simulation of human intelligence processes by machines (training machines to perform human tasks).

Sales table

table includes one record per Sale

deep learning

the subset machine learning composed of algorithms that permit software to train itself to perform tasks, like speech and image recognition, by exposing multilayered neutral networks to vast amounts of data

Technology trends/issues transforming the way we conduct business (and as a result,

the way we manage and leverage information)

You will get so called clean data

with instructions for how to merge and/or join separate files -realizing that you typically must perform data clean up before starting your analyses is very important

Unions are used when

you have the same data set - data values of the same fields - broken into separate files and you want to recombine them.)

To decide about the joins you need, let's review the nature of the data and the relationships:

üEach (one) employee is linked to zero, one, or many sales. ü üEach (one) customer is linked to zero, one, or many sales. ü üEach (one) product is linked to zero, one or many salelines. üEach (one) product is linked to one or many suppliers. üEach (one) shipper is linked to zero, one or many sales. ü üEach (one) sale is linked to one employee. üEach (one) sale is linked to one customer. üEach (one) sale is linked to one or many shippers. üEach (one) sale is linked to one or many salelines. üEach (one) saleline is linked to one or many product. üEach (one) saleline is linked to one order.

Which fields do you use for the joins?

•Access will ask you for the field to join on SOMETIMES - Why does it ask you?

What are the technology trends/issues transforming the way we conduct business (and as a result, the way we manage information)?

•Analytics and Big Data •Migration to Cloud Computing •The Internet of Things •AI/Machine Learning/Rise of Business Bots/RPA/Augmented Reality and Virtual Reality •Blockchain •Cryptocurrencies •Social Media/BYOD/BYOD MESSAGING (e.g. Slack, Facebook messenger, GroupMe, Whatsapp) •Compliance with Information Management Regulations and Standards (e.g., PCI-DSS, EMV technology, GDPR) •Cyber Security

Only link to a subset of the tables -

•Sales •Salelines •Customers •Employees •Shippers •Products

We are including 6 tables:

•Sales •Salelines •Customers •Employees •Shippers •Products

Why not use Excel only???

•Worksheet and workbook specifications and limits •Open Excel workbooks are limited by available memory and system resources •Spreadsheets such as Excel are not interactive by nature. They are static. •By its very design, a spreadsheet is a table view of data. Data visualizations are not based on the concept of a table view. Trends, relationships, and patterns are easier to communicate and interpret with data visualization.

Create (concatenated/combined) Calculated Fields for employee and customer names. An example of how you do that:

•[First Name]+" "+[Last Name] or [First Name]+", "+[Last Name]

gross sales

•[Quantity sold]*[Sales price per]

üMove the following from Measure to Dimensions (why??):

•empReportsTo •2 instances of Sales Invoice ID •Cust Income Bracket

Prescriptive analytics.

•is the newest kid on the block. Knowing what will happen and knowing what to do are two different things. Prescriptive analytics answers the question of what to do by providing information on optimal decisions based on the predicted future scenarios. The key to prescriptive analytics is being able to use big data, contextual data and lots of computing power to produce answers in real time.