ALA- Data Analysis with Python

Select the true statements about the business uses of Python.

- A Python library is a collection of related programming modules that include pre-compiled bundles of code. - Forty percent of recruiters are actively seeking Python programmers. - Python is used in a variety of business disciplines including data analysis, finance, and accounting.

Because many business executives desire to create a data-driven decision-making culture, which three of the following are competencies organizations invest in to support DDDM?

- Agility in analytics and data analysis - Building a data-driven community - Data proficiency

Select the true statements about how Python is used in finance.

- Analytics in finance provides high-level and granular-level views of an organization's financial data. - Python is used in quantitative and qualitative financial processes in many financial areas including analytics, banking, and cryptocurrency. - Banks use Python to get financial models out of Excel and into an environment that allows for more data analysis and visualization.

Accountants use Python to automate which of the following repetitive tasks?

- Calculate taxes owed - Input of invoices - Input customer information

Web scraping is the automation of the extraction of large volumes of data from websites. Using Python, which of the following web scraping activities can be conducted?

- Collect data from social media sites. - Conduct price comparisons. - Conduct research and development (R&D)

Marketing analytics are used to measure marketing performance and effectiveness and to make decisions on different strategies to increase marketing efficiency and impact. The analysis of marketing performance data can be enhanced using Python. Python is used for the analysis of which marketing related tasks?

- Customer segmentation analysis - Predictive analytics - A/B Testing

Python has a wide array of tools and libraries specifically designed for data analysis. These assist in accomplishing which tasks?

- Data manipulation - Data visualization - Statistical analysis

Which Python web frameworks identified in the text assist in the development of scalable and secure FinTech web applications?

- Django - Flask

The three-step data visualization process is comprised of which of the following?

- Explore data sets for patterns. - Plan your visuals. - Create your visuals.

When compared to Python, which of the following are considered limitations of using Microsoft Excel for data analysis?

- Handling large volumes of data - Syntax errors - Limited scalability

Select the true statements about connectivity in Python.

- Importing and exporting data is streamlined. - Connections to external and internal data sources can be accomplished using Python. - Python libraries such as pandas can interpret and merge data sets from different sources including Excel, CSV, and JASON.

Short for Financial Technology, FinTech refers to the use of technology and innovative solutions to automate and increase efficiency in which industries?

- Insurance - Banking - Payment systems

When compared to Microsoft Excel, which of the following are considered limitations of using Python for data analysis?

- Not as friendly a user interface when compared to Microsoft Excel. - Steep learning curve associated with learning Python for data analysis.

The process of data analytics includes which of the following?

- Predictive analytics - Prescriptive analytics - Descriptive analytics

Select the true statements about the Python programming language.

- Python is completely free to use. - Python syntax is considered by many to be relatively simple. - Many people consider Python to be an ideal first programming language to learn.

Which of the following Python libraries are used in marketing analytics and SEO?

- TensorFlow - ExPan

Select the true statements about the scalability of Python.

- The number of columns or rows used in a data set does not impact the Python user because they are not operating in a data interface environment. - Python can handle data sets of almost any scale. - When working in Python, users can save data in separate files, which allows for simultaneous work and coding.

Python is used in quantitative and qualitative financial processes in which of the following areas?

- analytics - cryptocurrency - banking

Which of the following is Microsoft Excel frequently used for?

- data analytics - data visualization - data entry

Which of the following Python libraries are commonly used to automate accounting tasks?

- pandas - NumPy

The steps in the data project life cycle, according to Harvard University's Data Science Ready project include which three of the following?

- wrangling - sensing - collection

Which of the following Python libraries are commonly used for data processing and data visualization?

-Matplotlib -Seaborn

Which of the following are business uses of the Python programming language?

Accounting Finance Sales and Marketing

The Python programming language was developed in the 1980s by ______.

Guido Van Possum

A/An ______ provides programmers the ability to work with Python and often consists of at least a source code editor, build automation tools, and a debugger.

IDE

In Microsoft Excel, ______ is used to create custom macros and functions that are designed to accomplish organizational specific tasks.

VBA

The process of investigating raw data of various types to uncover trends and correlations, and to answer specifically crafted questions is the role of data ___.

analytics

Search Engine Optimization (SEO) involves the design (and improvement) of websites to increase non-paid visibility on search engines including Google and Bing. There is a Python script called the SEO _____ that is a web crawler designed to collect data from websites.

analyzer

Visual Basic for ______ (VBA) is included in Excel and offers the capability to create custom macros and functions that are designed to accomplish organizational specific tasks.

application

Similar to how mining recovers small amounts of precious metals from large amounts of ore or earth, ______ is the process of extracting information from large data sets.

data mining

In Microsoft Excel, a statement written by a user that is designed for a specific calculation is referred to as a ______.

formula

In Microsoft Excel, a predefined formula that is built into the software for ease of use and deployment is referred to as a ______.

function

API stands for Application Programming ______ and allows for different software programs the ability to connect and work with each other.

interface

In Python, a collection of related programming modules that include precompiled bundles of code that can be used repetitively in different programs and applications are referred to as a Python _____. They often contain configuration data, templates, classes, values, and documentation.

library

The process of collecting, cleansing, transforming, and classifying data is referred to as data processing and ______.

modeling

Microsoft Excel was first introduced in 1982 as a program called ______.

multiplan

Derived from the term "panel data" that is used in econometrics, ______ includes a variety of modules designed to work with data.

pandas

Microsoft Excel is a spreadsheet software application that consists of a grid interface of columns and ______ where data can be entered, structured, and manipulated.

rows

One way to visualize a data ecosystem is to apply it to the data project life cycle. The Data Science Ready project outlines the five steps of the data project life cycle. The final stage in this life cycle is ______.

storage

A subset of data analysis that covers creating visual representations of data is referred to as data ______.

visualization

The graphical and structured representation of data is known as data BLANK.

visualization