LIVING IN THE I.T. ERA WEEK 13 Flashcards

1
Q

It is the use of software to combine business analytics, data mining, data visualization, data tools and infrastructure, and best practices to help organizations to make more data-driven decisions.

A

Business Intelligence (BI)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

In practice, you know you’ve got modern business intelligence when you have a ___________________________________

A

comprehensive view of your organization’s data and use that data to drive change, eliminate inefficiencies and quickly adapt to market or supply changes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

How Business Intelligence works?

A

Businesses and organizations have questions and goals.

To answer these questions and track performance against these goals,
they gather the necessary data, analyze it and determine which actions to
take to reach their goals.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Why is Business Intelligence important?

A

A few ways that business intelligence can help companies make smarter, data-driven decisions:

*Identify ways to increase profit
* Analyze customer behavior
* Compare data with competitors
* Track performance
*Optimize operations
* Predict success
* Spot market trends
*Discover issues or problems

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Where Is BI Used?

A

Sales, marketing, finance and operations departments use business intelligence.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

They are BI power users, and they use centralized company data paired with powerful analytics tools to understand where opportunities for improvement exist and what strategic recommendations to propose to company leadership.

A

Data scientist and Analyst

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

By blending financial data with operations, marketing and sales data, users can pull insights from which decisions can be acted upon and understand factors that impact profit and loss.

A

Finance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Business intelligence tools help marketers track campaign metrics from a central digital space. BI systems can provide real-time campaign tracking, measure each effort’s performance and plan for future campaigns. This data gives marketing teams more visibility into overall performance and provides contextual visuals for sharing with the company

A

Marketing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

They often use BI dashboards and key performance indicators (KPIs) for quick access to complex information like discount analysis, customer profitability and customer lifetime value. Sales managers monitor revenue targets, sales rep performance along with the status of the sales pipeline using dashboards with reports and data visualizations.

A

Sales

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

To save time and resources, managers can access and analyze data like supply chain metrics to find ways to optimize processes. Business intelligence can also ensure that service level agreements are met and help improve distribution routes.

A

Operations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

American Express has been using the technology to develop new payment service products and market offers to customers. BI also helps the company accurately detect ________ and protect customers whose card data may be compromised

A

fraud

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Using AI-powered image-recognition technology, the company can tell when ___________________. This data, paired with the power of BI, gives the company important insights into who is drinking their beverages, where they are and why they mention the brand online. The information helps serve consumers more targeted advertising, which is four times more likely than a general ad to result in a click.

A

photographs of its drinks post online

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Netflix uses data in multiple ways. One example is how the company formulates and validates original programming ideas based on previously viewed programs. Netflix also uses business intelligence to get people to engage with its content. The service is so good at targeted content promotion that its recommendation system drives over 80% of streamed content.

A

Netflix

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Through its popular loyalty card program and mobile application, Starbucks owns individual purchase data from millions of customers. Using this information and BI tools, the company predicts purchases and sends individual offers of what customers will likely prefer via their app and email. This system draws existing customers into its stores more frequently and increases sales volumes.

A

starbucks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

It lets you analyze your data right from within Excel, while seamlessly connecting to a wide range of external data sources.

A

Power Query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

It is an Excel add-in that provides a seamless experience for data discovery, data transformation, enrichment and sharing for Information Workers, BI professionals and other users.

A

Microsoft - Power Query for Excel

17
Q

you can import or connect to external data, and then shape that data, for example remove a column, change a data type, or merge tables, in ways that meet your needs. Then, you can load your query into Excel to create charts and reports. Periodically, you can refresh the data to make it up to date.

A

Power Query in Excel

18
Q

Four Phases of Power Query in Excel

A

Connect
Transform
Combine
Load

19
Q

Make connections to data in the cloud, on a service, or locally

A

Connect

20
Q

Shape data to meet your needs, while the original source remains unchanged

A

Transform

21
Q

Integrate data from multiple sources to get a unique view into the data

A

Combine

22
Q

Complete your query and load it into a worksheet or Data Model and periodically refresh it.

A

Load

23
Q
A