Business Intelligence (BI)

Business Intelligence

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

For Business Intelligence 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....