Easy quiz on Business Intelligence-Data mining-4 June 23, 2020 by adminvgitcs Table of Contents ToggleQuiz on Business Intelligence (BI)-Data mining (DM) part 4 Connect with us on following platformsOther related quizzesOther related practicals Quiz on Business Intelligence (BI)-Data mining (DM) part 4 Try this Business Intelligence quiz and Data mining quiz Below content is referred from Business Intelligence: Data Mining and Optimization for Decision Making (WSE) by Carlo Vercellis Connect with us on following platforms Facebook Twitter Youtube Instagram Reddit Pinterest Telegram Slideshare Linkedin Github Other related quizzes BUSINESS INTELLIGENCE, DECISION SUPPORT SYSTEM QUIZZES Try quiz on Business Intelligence-Data mining-1 Easy Business Intelligence-Data mining quiz-2 Easy quiz on Business Intelligence-Data mining-3 MATHEMATICAL MODELS FOR DECISION MAKING, DATA MINING, DATA PREPARATION Easy quiz on Business Intelligence-Data mining-4 Easy Data Mining-Business Intelligence quiz-5 More quizzes are coming soon…. Other related practicals 0How to install SQL Server 2012 Full version 0Installation steps for Power BI 1Import the legacy data from different sources such as ( Excel , SqlServer, Oracle etc.) and load in the target system. ( You can download sample database such as Adventureworks, Northwind, foodmart etc.) 2 APerform the Extraction Transformation and Loading (ETL) process to construct the database in the Power BI 2 BPerform the Extraction Transformation and Loading (ETL) process to construct the database in the Sqlserver. 3 B Create the cube with suitable dimension and fact tables based on OLAP 4 B Execute the MDX queries to extract the data from the datawarehouse. 5 AImport the datawarehouse data in Microsoft Excel and create the Pivot table and Pivot Chart 5 BImport the cube in Microsoft Excel and create the Pivot table and Pivot Chart to perform data analysis 6Apply the what – if Analysis for data visualization. Design and generate necessary reports based on the data warehouse data. 7Perform the data classification using classification algorithm. 8Perform the data clustering using clustering algorithm 9Perform the Linear regression on the given data warehouse data. 10Perform the logistic regression on the given data warehouse data 11Practical Implementation of Decision Tree using R Tool 12Data Modelling and Analytics with Pivot Table in Excel 13Data Analysis and Visualization using Excel We are aiming to explain all concepts of Business Intelligence and Data mining in easiest term as possible. ITVoyagers Author