#Ibm dataarchitect team project professional#

In the sixth and final module you will use your skills in Big Data Analytics to create a Spark connection to the data warehouse, and then deploy a machine learning model on SparkML for making sales projections. Finally, you will verify that the data is loaded properly. You will then transform the OLTP data to suit the data warehouse schema, and then load the transformed data into the data warehouse. In Module 5 you will extract data from OLTP, NoSQL, and MongoDB databases into CSV format.

In Module 4 you will create a Cognos data source that points to a data warehouse table, create a bar chart of Quarterly sales of cell phones, create a pie chart of sales of electronic goods by category, andcreate a line chart of total sales per month for the year 2020. You’ll then create the schema and load the data into fact and dimension tables,automate the daily incremental data insertion into the data warehouse, and create Cubes and Rollups to make the reporting easier. In Module 3 you will design the schema for a data warehouse based on the schema of the OLTP and NoSQL databases. In Module 2 you will set up a NoSQL database to store the catalog data for an E-Commerce website, load the E-Commerce catalog data into the NoSQL database, and query the E-Commerce catalog data in the NoSQL database. In Module 1 you will design the OLTP database for an E-Commerce website, populate the OLTP Database with the provided data, and automate the export of the daily incremental data into the data warehouse. You will be presented with a business challenge that requires building a data platform for retailer data analytics.

#Ibm dataarchitect team project professional#

This Capstone provides you with practical hands-on experience to demonstrate all of the Data Engineering skills you have picked up in this Professional Certificate program.Īs part of the capstone project, you will assume the role of an Associate Data Engineer who has recently joined the organization. Create an ETL pipeline and deploy machine learning models.Extract data from OLTP, NoSQL and MongoDB databases, transform it, and load it into the data warehouse.Analyze the data and create a dashboard.Collect and understand data from multiple sources.This is the seven weeks project to finish the IBM Data Engineering Professional Certificate.