Data Tools
What is Tableau?
data visualization and analytics platform that allows users to create reports and share them across desktop and mobile platforms, within a browser, or embedded in an application
Name 5 roles in the data space
Data Engineer, Data Architect, Data Analyst, PowerBI Developers, Data Scientist, Database Engineer, etc.
What does ETL stand for?
extract, transform, load
What groups does reporting & visualization fall under? (EDM, Insights/BI, or Advanced Analytics)
Insights/BI
What is Hadoop?
one of the most widely used software frameworks in big data. It is a collection of programs which allow storage, retrieval and analysis of very large data sets using distributed hardware (allowing the data to be spread across many smaller storage devices rather than one very large one)
What role collects and sifts through data to extract insights that answer business questions with actionable solutions?
Data Analyst
What is data visualization?
the representation of information in the form of a chart, diagram, picture, etc.
What are 3 components/tools of advanced analytics?
data analysis, predictive analysis, machine learning, artificial intelligence, analytics & cloud tools, etc.
What is Cassandra?
A popular open-source database management system managed by The Apache Software Foundation that has been designed to handle large volumes of data across distributed servers
What role uses data-driven insights to clearly communicate initiatives throughout entire organizations, often acting as the intermediary between a company’s business and tech teams?
Business Analyst
What is data correlation?
data with two or more variables that may demonstrate a positive or negative correlation to each other (e.g., salaries by level of education)
What does EDM stand for and what is it?
enterprise data management, ability of an organization to precisely define, easily integrate and effectively retrieve data for internal and external communication
What is Microsoft's BI tool?
PowerBI
What does a Machine Learning Engineer do?
Processes data provided by a company’s Data Analyst using machine learning algorithms developed by the Data Scientist to glean insights that will ultimately drive business decisions
What is data governance?
establishes rules for effective data management
What are 3 groups of data?
Enterprise data management (EDM), enterprise insights/business intelligence (BI), and advanced analytics
What are 2 types of data?
quantitative and qualitative
What is the difference between a Data Scientist and a Data Architect?
Data Scientists apply principles of computer-science, mathematics, and statistics to build models while Data Architects translate business requirements into tech requirements and build the framework for data scientists to use
What are two types of quantitative data?
discrete and continuous
What are 3 components of enterprise data management?
Data architecture, ETL processes, data warehouses, data lakes, databases, etc.