Inteligencia de Negocios Con Power BI y Sql Server 2019

This course is designed for users with basic Excel knowledge who want to level up their data skills. It progresses to cover advanced topics relevant to professionals like programmers, Business Intelligence developers, database administrators, and IT managers.

The course delves into Data Warehousing, utilizing Microsoft SQL Server Data Tools and its Integration Services to build and populate a data warehouse through ETL processes. You'll learn how to create cubes, metrics, and KPIs using Analysis Services to effectively analyze business performance.

A significant portion of the course focuses on Power BI, enabling you to create compelling and insightful dashboards for data visualization.

Key topics covered include:

• Data Warehousing Fundamentals: Understand the principles and benefits of data warehousing.
• ETL Processes: Learn to extract, transform, and load data into your data warehouse.
• Analysis Services (SSAS): Master cube creation, metric development, and KPI definition.
• Power BI Dashboard Creation: Design and build interactive dashboards for data analysis.
• Data Modeling with Star Schema: Learn to model data for optimal data warehousing performance.
• Adding Geographic Dimensions: Enhance your star schema with geographic data for deeper insights.

Course Details:

• Total Hours: 14.5
• Ongoing Updates: The course is continuously updated with new content, including advanced SSAS measures and Power BI cube consumption techniques (updated 10/02/2019).
• Last Updated: 11/08/2019 - New classes added on Data Modeling and Geographic Dimensions.

Enroll now and continue your journey to becoming a data expert! Many more hours of valuable content are planned.