Data Warehousing certificate program offered through Coursera
Data Warehousing for Business Intelligence Specialization
The data warehousing for business intelligence specialization gives learners a broad understanding of data and business intelligence concepts and trends from experts in the warehouse field. The Specialization also provides significant opportunities to gain hands-on skills in designing, building and implementing both data warehouses and the business intelligence functionality that is crucial in todays business environment.
"With this specialization, learners will gain the necessary skills and knowledge in data warehouse design, data integration processing, data visualization, online analytical processing, dashboards and scorecards and corporate performance management," Karimi said. "They will also receive hands-on experience with leading data warehouse products and business intelligence tools to investigate specific business or social problems."
The certificate program is open to anyone and ends with a capstone project, in which students build their own data warehouse with business intelligence functionality.
Course 1: Database Management Essentials
Database Management Essentials provides the foundation you need for a career in database development, data warehousing, or business intelligence, as well as for the entire Data Warehousing for Business Intelligence specialization. In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy. As you develop these skills, you will use either Oracle or MySQL to execute SQL statements and a database diagramming tool such as the ER Assistant to create ERDs. We've designed this course to ensure a common foundation for specialization learners. Everyone taking the course can jump right in with writing SQL statements in Oracle or MySQL.
Course 2: Data Warehouse Concepts, Design, and Data Integration
In this course, you will create a data warehouse design that satisfies explicit business needs. You will work with sample data sources to gain experience in designing and implementing data integration processes. These are fundamental skills for data warehouse developers and administrators. You will also gain a conceptual background about maturity models, architectures, multidimensional models, and management practices, providing an organizational perspective about data warehouse development. If you are currently a business or information technology professional and want to become a data warehouse designer or administrator, this course will give you the knowledge and skills to do that. By the end of the course, you will have the design experience and organizational context that prepares you to succeed with data warehouse development projects.
Course 3: Relational Database Support for Data Warehouses
In this course, you'll use analytical elements of SQL for answering business intelligence questions. You'll learn features of relational database management systems for managing summary data commonly used in business intelligence reporting. Because of the importance and difficulty of managing implementations of data warehouses, we'll also delve into data governance methodologies and big data impacts.
Course 4: Business Intelligence Concepts, Tools, and Applications
In this course, you will gain the knowledge and skills for using data warehouses for business intelligence purposes and for working as a business intelligence developer. You'll have the opportunity to work with large data sets in a data warehouse environment to create dashboards and Visual Analytics. We will cover the use of MicroStrategy, a leading BI tool, OLAP (online analytical processing) and Visual Insights capabilities for creating dashboards and Visual Analytics.
Course 5: Design and Build a Data Warehouse for Business Intelligence Implementation
The capstone course, Design and Build a Data Warehouse for Business Intelligence Implementation, features a real-world case study that integrates your learning across all courses in the specialization. In response to business requirements presented in a case study, you'll design and build a small data warehouse, create data integration workflows to refresh the warehouse, write SQL statements to support analytical and summary query requirements, and use the MicroStrategy business intelligence platform to create dashboards and visualizations.
Coursera partners with more than 120 top universities and educational institutions to offer hundreds of online courses and Specializations in topics from computer science to social psychology and beyond. Earn certificates from prestigious learning institutions for courses and projects developed in collaboration with top employers that teach the skills you need to succeed. Whether you want to advance your career or pursue a passion, Coursera provides open online education for everyone. For more information, visit www.coursera.org.