A full data warehouse infrastructure with ETL pipelines running inside docker on Apache Airflow for data orchestration, AWS Redshift for cloud data warehouse and Metabase to serve the needs of data visualizations such as analytical dashboards.
The CEDS Collaborative Exchange is a repository of code developed by the community that interacts with the CEDS Integration Data Store and the CEDS Elements repositories. All resources provided in this community are considered free and open source.
Modeled for longitudinal storage and reporting of P-20W data, the Common Education Data Standards (CEDS) Data Warehouse implements star schema data warehouse normalization techniques for improved query performance.
This course introduces the concept of data warehousing and data integration architecture and explains the role they play in overall business intelligence and analytics strategy of an organization. The course covers predominate architecture design strategies as well as hybrid designs that combine best practices from multiple areas. A key component of instruction is an emphasis on following industry best practices such as adhering to the requirements of an integrated data platform, selecting an appropriate design strategy and the tools to support it, selecting metrics for monitoring performance and data quality, and planning for future enhancements. The course provides hands-on experience in combining structural and design elements with best practices for data governance and coding standards to build a high-level plan for implementing a data warehouse and data integration system for organizations.
Business Intelligence and Data warehousing system to assist Forever collectibles (sports merchandise sales company) move their business from B system (wholesale retail) to C system (wholesale and E-commerce retail).