Курс от Coursera test skillsLearn how to design, build, and evaluate predictive models through this comprehensive course in the Data Analytics Skill Path. You will develop critical competencies including designing conceptual, logical, and dimensional data models; applying normalization and indexing to optimize relational databases; and analyzing query execution plans to identify and resolve performance bottlenecks. You will also gain expertise in data quality and governance by performing reconciliation, enforcing schemas in transformation pipelines, implementing root cause analysis through data lineage, and creating automated dashboards to monitor key data metrics. This course further equips you with advanced technical skills such as building reusable, parameterized scripts for data workflows, applying programmatic logic and regular expressions for complex transformations, and optimizing SQL queries for performance at scale. You will explore data integration through APIs, develop multi-step transformation pipelines, and apply advanced text processing techniques to handle unstructured data. Expanding into analytics, you will learn OLTP vs. OLAP distinctions, design star schemas for reporting, and apply clustering and outlier handling strategies to support analytical models. Finally, you will gain exposure to emerging applications of Generative AI in data engineering to enhance automation, scalability, and innovation. The curriculum blends academic rigor with industry-oriented practice, drawing on expertise from Edureka, Microsoft, Google, Packt, Arizona State University, Maven Analytics, Coursera Instructor Network, and Johns Hopkins University. You will progress from relational database foundations and advanced SQL, to Python scripting and API integration, to complex data modeling and transformation workflows, and ultimately to creating insightful dashboards in Tableau. Perfect for aspiring data engineers, data managers, and analytics professionals, this course provides the end-to-end knowledge and hands-on skills needed to confidently build scalable, efficient, and high-quality data systems that drive business value.
9 модулей · 165 учебных материалов

Преподаватель курса