Project 1 : Configuration and Logging
Industry : General
Problem Statement : How to integrate data from multiple sources into the SQL Server
Topics : In this SQL Server Integration Services (SSIS) project you will extensively work on multiple data from heterogeneous source into SQL Server. As part of the project you will learn to clean and standardize data and automate the administrative work. Some of the tasks that you will be performing are adding logs to SSIS package, configuration and saving it to an XML file. Upon completion of the project you will have hands-on experience in handling constraints, error row configuration and event handlers.
- Integrate data from heterogeneous sources
- Working with Connection Manager
- Deploying data modeling
Project 2 – SSAS Cube Using BI Data Tools 2012
Industry : Sales
Problem Statement : How to create the SSAS Cubes for faster reporting
Topics – In this project you will be work on large volume of data and use it for creating reports and dashboards for sales performance in order to derive valuable insights. You will deploy the sales database in sql server and build SSAS Cubes. Upon completion of the project you will be well-versed to work in a real world business scenario to analyze various parameters and instances in order to derive business insights.
- Create multidimensional cubes
- Deploying MDX query language
- Working with in-memory analytics.
Project 3 – Building Dashboard
Data – Sales
Topics – In this project you will be working on SQL Server Reporting Services (SSRS) and deploying it for building dashboards in a business environment. The Business Intelligence Report that you create will be used to calculate sales based on the years and currencies that you choose. Some of the tasks that you will be performing as part of this project are – design and create Gauge and Map Charts, Spark lines and Data Bar and perform drill-through Reports, and ad hoc Reporting.