Data Warehousing

Develop a working knowledge and familiarity with advanced database concepts such as usage, modeling, automation, storage, optimization and administration. To take this course, you must have completed the previous Database courses. You must also be eager to continue your journey with coding. The Professional Certificates create opportunities so that [...]

This course builds on “The Nature of Data and Relational Database Design” to extend the process of capturing and manipulating data through data warehousing and data mining. Once the transactional data is processed through ETL (Extract, Transform, Load), it is then stored in a data warehouse for use in [...]

Building on “Data Warehousing and Business Intelligence,” this course focuses on data visualization and visual analytics. Starting with a thorough coverage of what data visualization is and what type of visualization is good for a given purpose, the course quickly dives into development of practical skills and knowledge about [...]

In this course, you will explore the tools and techniques that can be used to work with Modern Data Warehouses productively and securely within Azure Synapse Analytics. You will learn how Azure Synapse Analytics enables you to build Data Warehouses using modern architecture patterns and how the common schema [...]

"Snowflake - SnowPro Core Certification Preparation" is a comprehensive course meticulously crafted to guide learners through the essentials of Snowflake, preparing them for the SnowPro Core Certification. Spanning three modules, the course begins with the fundamentals of Snowflake, exploring its architecture, data loading, and modeling. The second module delves [...]

This course provides a comprehensive introduction to business intelligence (BI), its key concepts, components, and the benefits and challenges of implementing BI solutions. It also discusses career opportunities and roles available in the BI arena and the skills and qualifications required.

The Data Ecosystem course will give you a foundational understanding of the entire data ecosystem, including data management. Specifically, this course shows how a business intelligence analyst would organize, access, and use data. You will learn about a variety of data sources along with the use and purpose of [...]

The "Data Processing and Manipulation" course provides students with a comprehensive understanding of various data processing and manipulation concepts and tools. Participants will learn how to handle missing values, detect outliers, perform sampling and dimension reduction, apply scaling and discretization techniques, and explore data cube and pivot table operations. [...]