Business Intelligence Lab

List of Practical

  1. Import the legacy data from different sources such as (Excel, SqlServer, Oracle etc.) and load in the target system.
  2. Perform the Extraction Transformation and Loading (ETL) process to construct the database in the Sqlserver / Power BI.
  3. Data Visualization from ETL Process
  4. Creating a Data Cubes
  5. Apply the what – if Analysis for data visualization. Design and generate necessary reports based on the data warehouse data.
  6. Implementation of Classification algorithm.
  7. Practical Implementation of Decision Tree
  8. Implementation of k-means clustering
  9. Prediction Using Linear Regression
  10. Data Analysis using Time Series Analysis
  11. Data Modelling and Analytics with Pivot Table in Excel
  12. Data Analysis and Visualization using Advanced Excel

No comments:

Post a Comment