Business Intelligence & Analytics CHOOLS No Comment 01Mar Share Welcome to your Business Intelligence & Analytics What is Business Intelligence (BI)? A process of collecting, storing, and analyzing data to support decision-making A system for managing employee records A programming language A method of encrypting data Which of the following is NOT a component of Business Intelligence? Data Warehousing Reporting and Querying Artificial Intelligence Algorithms Online Analytical Processing (OLAP) The primary goal of Business Intelligence is to: Store large amounts of data Generate insights for better decision-making Increase internet security Reduce the number of employees What type of system is commonly used in BI to store historical data? Transaction Processing System (TPS) Data Warehouse Enterprise Resource Planning (ERP) Content Management System (CMS) Which tool is commonly used for Business Intelligence? Tableau Adobe Photoshop Python Flask Microsoft Word Data mining in BI is used for: Extracting hidden patterns from large datasets Sending emails to customers Compressing images Encrypting data for security OLAP stands for: Online Learning and Processing Online Analytical Processing Offline Logical Analysis Processing Operational Logistics and Processing What is the difference between OLTP and OLAP? OLTP is used for transactional processing, while OLAP is used for analytical processing OLAP is used for transactions, while OLTP is for reporting OLTP is only for cloud systems, while OLAP is on-premises OLAP uses SQL, while OLTP does not Which of the following is NOT a data visualization tool? Power BI Excel SPSS Google Data Studio Key Performance Indicators (KPIs) in BI help to: Evaluate the performance of a business Store large datasets Reduce the use of SQL in databases Encrypt user passwords What is the first step in data preparation? Data Cleaning Data Collection Data Analysis Data Visualization Data Cleaning involves: Removing or correcting incorrect, incomplete, or duplicate data Generating reports for stakeholders Encrypting data for security purposes Backing up data in a cloud storage Which technique is commonly used to handle missing data? Deleting missing values Replacing with mean/median values Predicting missing values using machine learning All of the above Which of the following is NOT a step in data preparation? Data Extraction Data Cleaning Data Analysis Data Transformation What is data normalization? Converting data into a standard format Reducing data security risks Encrypting database records Removing duplicate data from storage Which of the following is a common format for structured data? JSON CSV Excel All of the above What is data transformation? Converting data from one format to another Deleting unnecessary data Encrypting sensitive data Uploading data to the cloud What is data integration? Combining data from multiple sources into a unified view Splitting large datasets into smaller ones Removing duplicate records Creating new database tables What is the purpose of data validation? Ensuring data accuracy and consistency Removing all missing values Converting unstructured data into structured format Encrypting personal data Which of the following methods is used for data reduction? Feature selection Data aggregation Dimensionality reduction All of the above ETL stands for: Extract, Transform, Load Evaluate, Test, Learn Encrypt, Transfer, Log Execute, Transform, Link What is data wrangling? The process of cleaning and organizing raw data The process of compressing large datasets The process of storing data in a warehouse The process of querying a database Which of the following is an ETL tool? Informatica Microsoft Word JavaScript Canva The main goal of dimensionality reduction is to: Reduce the number of variables in a dataset Improve the speed of data transmission Increase data redundancy Encrypt business data Data profiling helps in: Understanding data quality and structure Encrypting stored data Visualizing data in 3D models Converting data into text format Which of the following is NOT a Business Intelligence tool? Power BI Tableau Excel Adobe Photoshop Power BI is developed by: Google Microsoft IBM Oracle What type of software is Tableau? Data visualization tool ERP system Database management system Image editing software Which of the following is an open-source BI tool? QlikView Power BI KNIME Looker What is the main function of a BI dashboard? To display key business metrics visually To store transactional data To encrypt business data To generate random reports Which BI tool is known for its self-service analytics capabilities? Excel Qlik Sense Photoshop Hadoop Looker is a BI tool acquired by: Microsoft Google Amazon Facebook DAX (Data Analysis Expressions) is used in: Power BI Tableau Excel Google Analytics Which BI tool is primarily used for cloud-based data analytics? Tableau Google Data Studio Excel IBM Cognos Apache Superset is an example of: A commercial BI tool An open-source BI tool A programming language A relational database What is an OLAP cube used for? Transactional processing Multidimensional data analysis Encrypting sensitive data Image processing ETL stands for: Extract, Transform, Load Evaluate, Train, Learn Export, Translate, Load Encrypt, Transfer, Log What is the purpose of ETL in BI? To clean and structure raw data for analysis To visualize reports To encrypt business transactions To send automated emails Which of the following is NOT a step in ETL? Extraction Transformation Loading Encryption Which technology is commonly used for real-time data processing? Batch Processing Stream Processing Data Warehousing SQL Queries What is the main difference between OLTP and OLAP? OLTP is used for transactions, OLAP for analysis OLAP is used for transactions, OLTP for analysis OLTP is for cloud systems, OLAP is for on-premises OLAP is faster than OLTP Which query language is most commonly used for BI reporting? Python SQL JavaScript HTML Data pipelines are used to: Automate data flow between systems Manually process data Encrypt database records Delete duplicate records The process of improving the quality of raw data is called: Data Encryption Data Cleaning Data Visualization Data Warehousing Data normalization is used to: Reduce redundancy in databases Visualize data in chartsv Encrypt sensitive information Increase file storage size What is the primary goal of Exploratory Data Analysis (EDA)? To create machine learning models To summarize the main characteristics of a dataset To store data efficiently To encrypt sensitive information Which library is commonly used for EDA in Python? NumPy Matplotlib Pandas All of the above Which of the following techniques is NOT part of EDA? Data Cleaning Data Visualization Model Training Statistical Analysis What is the purpose of a histogram in EDA? To display the relationship between two variables To show the distribution of a single numerical variable To compare multiple datasets To represent categorical data What does a box plot represent in EDA? Mean, median, and standard deviation Quartiles and potential outliers Only the mean of the dataset Correlation between two variables The IQR (Interquartile Range) is calculated as: Q3 - Q1 Q1 - Q3 (Q3 + Q1) / 2 Q3 / Q1 A scatter plot is useful for: Identifying correlations between two numerical variables Displaying categorical data Summarizing statistical measures Checking data types Which metric is used to measure the central tendency of data? Mean Median Mode All of the above What does a correlation coefficient close to +1 indicate? Strong positive correlation Strong negative correlation No correlation Data is normally distributed What type of plot helps in detecting outliers effectively? Line Plot Histogram Box Plot Pie Chart Which of the following is a common technique to handle missing data? Removing missing values Imputing missing values Predicting missing values using machine learning All of the above The process of converting categorical variables into numerical format is called: Normalization Encoding Scaling Outlier Removal Which transformation is useful for normalizing skewed data? Log Transformation Square Root Transformation Box-Cox Transformation All of the above Feature scaling is important in predictive analytics because: It ensures variables are on the same scale It removes outliers It reduces correlation It increases missing values Min-Max Scaling transforms data into which range? (0,1) (-1,1) (0,100) No fixed range Predictive analytics is mainly used to: Describe past trends Forecast future outcomes Store historical data Encrypt personal information Which algorithm is commonly used for regression tasks? Decision Tree K-Means Clustering Logistic Regression Linear Regression In predictive analytics, supervised learning requires: Labeled data Unlabeled data No training data Only numerical data Which machine learning algorithm is best suited for classification problems? K-Means Logistic Regression PCA DBSCAN Overfitting in predictive analytics occurs when: The model performs well on training data but poorly on test data The model generalizes well on new data The model has high bias The model has low variance What is the primary objective of a BI strategy? To store large amounts of data To provide data-driven decision-making capabilities To replace all business processes with automation To eliminate the need for human decision-making A successful BI strategy should align with: IT department goals Organizational business objectives Data storage policies Marketing automation tools The first step in implementing a BI strategy is: Selecting BI tools Defining business goals and objectives Building dashboards Hiring a BI consultant Which of the following is a key component of a BI strategy? Data governance Data encryption Web development frameworks UI/UX design principles What is the role of a Chief Data Officer (CDO) in BI strategy? Writing SQL queries Managing organizational data strategy and governance Designing marketing strategies Developing mobile applications The process of defining key performance indicators (KPIs) in BI strategy helps in: Measuring business performance Storing unstructured data Creating duplicate reports Reducing cloud storage costs A BI strategy should include: Data integration, visualization, and governance Only data storage policies Manual reporting methods Hiring more IT personnel Which of the following is NOT a critical success factor for BI strategy? Stakeholder engagement High-quality data Lack of user training Effective data governance Which of the following is a BI performance indicator? Key Performance Indicator (KPI) Database size Spreadsheet row count CPU processing speed Self-service BI allows: Users to analyze data without IT assistance Only IT teams to analyze data Organizations to eliminate BI tools The removal of governance policies What is data governance? A set of rules to manage data quality and security A method to delete old data A process of increasing data storage A technique to reduce data sources Which of these is NOT a principle of data governance? Data accuracy Data deletion Data consistency Data security Which department is primarily responsible for data governance? Finance IT and Data Management Marketing Sales What is the primary risk of poor BI governance? Increased data accuracy Data breaches and inconsistencies Faster data processing Reduced data insights What is a data steward’s primary responsibility? Managing data accuracy and compliance Deleting historical data Controlling IT hardware Writing financial reports A well-defined data governance framework helps in: Data accuracy, compliance, and security Data removal from databases Increasing storage costs Eliminating BI tools What is master data management (MDM)? Centralizing and standardizing key business data Encrypting all business data Distributing BI access to all users Deleting redundant data What is the purpose of metadata in BI? Provides context and descriptions for data Deletes outdated data Reduces storage costs Encrypts sensitive information Which of these is a BI security best practice? Role-based access control Open access to all employees Storing BI reports in shared drives Allowing all users to edit data sources Data lineage in BI refers to: Tracking data flow and transformations Deleting duplicate records Encrypting all BI reports Analyzing social media trends What is the primary purpose of Business Intelligence (BI) in an organization? Automating financial transactions Enhancing data-driven decision-making Increasing manual data entry Reducing the need for employees Which of the following best describes BI applications? Storing data in spreadsheets Extracting insights from data for strategic decision-making Using BI only for marketing Eliminating IT from business processes Which of the following is NOT a real-world application of BI? Customer behavior analysis Fraud detection Social media management Real-time business monitoring Which BI component is responsible for transforming raw data into meaningful information? ETL process Excel sheets PowerPoint presentations Manual data entry Which industry benefits most from real-time BI for tracking sales performance? Manufacturing Retail Healthcare Education How does BI improve retail decision-making? By predicting customer purchasing patterns By reducing employee salaries By increasing inventory costs By eliminating competitors Which metric is crucial for tracking retail sales performance in BI? Revenue per store Number of employees Warehouse temperature Email open rate BI helps e-commerce companies improve customer experience by: Analyzing customer purchase history Increasing shipping costs Reducing website traffic Removing customer support Which BI technique helps retailers prevent stock shortages? Demand forecasting Social media posting Reducing marketing budgets Manual order tracking Which BI tool is commonly used in retail analytics? Google Analytics Adobe Photoshop Microsoft Word AutoCAD How does BI support fraud detection in banking? By identifying unusual transaction patterns By increasing ATM fees By improving teller efficiency By reducing the need for cybersecurity Which metric is essential for financial BI analytics? Net profit margin Number of social media likes Employee attendance Office temperature What role does BI play in risk management? Identifying financial anomalies Replacing accountants Reducing business intelligence costs Increasing bank loans Which financial sector uses BI for investment portfolio analysis? Asset management firms Grocery stores Construction companies IT service desks How do banks use BI for customer segmentation? By analyzing spending patterns By blocking accounts randomly By deleting customer records By offering the same services to all customers Which of the following is a BI application in healthcare? Predicting patient readmission rates Designing hospital interiors Selling medical equipment Monitoring social media trends How does BI help hospitals improve patient care? By analyzing treatment outcomes By increasing hospital bills By reducing the number of doctors By eliminating medical records Which healthcare metric is tracked using BI? Patient recovery rates Number of hospital beds sold Cost of hospital uniforms Social media followers Which BI function helps hospitals manage resources efficiently? Real-time patient monitoring Social media marketing Television advertising Employee entertainment Which BI tool is commonly used for healthcare analytics? IBM Watson Health Photoshop PowerPoint WhatsApp Time is Up! Previous Financial Modeling February 28, 2025 Next FM Hackathon 1 March 10, 2025 You Might Also Like Hello world CHOOLS No Comment How to Disable Avast Antivirus CHOOLS No Comment AVG Review — Is the Absolutely free Version As effective as the Premium Version? CHOOLS No Comment Understanding the Limitations of Models of Managing CHOOLS No Comment Careers Similar To Teaching CHOOLS No Comment
