- What is data analysis?
Answer: Data analysis is the process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, drawing conclusions, and supporting decision-making.
- What are the two main types of data analysis?
Answer: The two main types of data analysis are descriptive analysis and inferential analysis.
- What is the difference between structured and unstructured data?
Answer: Structured data is organized and formatted in a specific way, while unstructured data lacks a specific format or organization.
- What is a spreadsheet?
Answer: A spreadsheet is a file made up of rows and columns that can be used to organize, analyze, and store data.
- What is a cell in Excel?
Answer: A cell is the intersection of a row and a column in an Excel spreadsheet. It is the basic unit of data storage in Excel.
- What is a formula in Excel?
Answer: A formula in Excel is an expression that performs calculations or operations on data.
- How can you create a chart in Excel?
Answer: To create a chart in Excel, select the data you want to include in the chart, go to the Insert tab, and choose the desired chart type.
- What is a pivot table in Excel?
Answer: A pivot table is a data summarization tool that allows you to rearrange, summarize, and analyze data from a larger dataset.
- What is a primary key in a database?
Answer: A primary key is a unique identifier for each record in a database table.
- What is the SQL SELECT statement used for?
Answer: The SQL SELECT statement is used to retrieve data from a database table.
- What is the difference between the WHERE and HAVING clauses in SQL?
Answer: The WHERE clause is used to filter rows before grouping and aggregating data, while the HAVING clause is used to filter rows after grouping and aggregating data.
- What is normalization in database design?
Answer: Normalization is the process of organizing data in a database to minimize redundancy and dependency.
- What is a foreign key in a database?
Answer: A foreign key is a field in a database table that refers to the primary key of another table, establishing a link between the two tables.
- What is Power BI?
Answer: Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.
- What is a data model in Power BI?
Answer: A data model in Power BI is a collection of tables, relationships, calculations, and measures that define the structure and behavior of a dataset.
- What is a measure in Power BI?
Answer: A measure in Power BI is a calculation performed on the data in a dataset, such as sum, average, or count.
- How can you create a calculated column in Power BI?
Answer: To create a calculated column in Power BI, go to the modeling tab and click on "New Column." Then, you can enter the formula for the calculated column.
- What is the difference between a slicer and a filter in Power BI?
Answer: A slicer allows users to interactively select one or more values to filter data, while a filter applies a condition to the entire dataset.
- What is data visualization?
Answer: Data visualization is the graphical representation of data and information to help users understand patterns, trends, and insights.
- What is a bar chart?
Answer: A bar chart is a chart type that uses rectangular bars to represent data values.