Análisis de Datos | SQL, Tableau, Power BI y Excel | Proyectos Reales

Resumen

4-in-1 bundle:

Practical learning of the essential tools used in Data Science with hands on examples and projects What you'll learn:

Learn and Understand SQL and it's role in Data Analysis.Develop proficiency in writing complex SQL queries to extract, manipulate, and analyze data.Develop the skills to clean, transform, and prepare data for analysis using Excel.Learn how to effectively use Power BI to create interactive visualizations.Apply the learned concepts and techniques to real-world data analysis projects.Gain expertise in Tableau to create compelling data visualizations and interactive reports.Build a solid foundation for a career in data analysis and be prepared for further learning and professional growth in the field. If you're interested in becoming a data analyst you're in the right place!Please ensure you can install MySQLWorkbench on your computer - I have enabled the installation videos for free preview so you can try.In this course, you will learn how to master the key techniques and concepts required to extract, manipulate, visualize, and analyze data effectively.

Whether you're a beginner or have some experience with data analysis, this course will cater to your needs and help you gain a competitive edge in the rapidly growing field of data analytics.Here's what you can expect to learn:

SQL Fundamentals:

Dive into the world of structured query language (SQL) and learn how to write powerful queries to extract and manipulate data from databases. From basic SELECT statements to advanced JOINs, subqueries and aggregate functions, you'll gain a comprehensive understanding of SQL.

This section is available for Mac and Windows laptops and computers.Tableau Fundamentals:

Unleash the potential of Tableau, a leading data visualization and exploration tool. Learn how to connect to data sources, create stunning visualizations using drag-and-drop techniques, and build interactive dashboards to uncover valuable insights.

This section is available for Mac and Windows laptops and computers.Power BI Essentials:

Explore the capabilities of Power BI, Microsoft's powerful business intelligence tool. Discover how to import, transform, and model data from various sources, create interactive visualizations, and design compelling reports and dashboards.

This section is only available for Windows users. Excel for Data Analysis:

Excel remains a fundamental tool for data analysis, and in this course, you'll harness its power.

Explore common features used by data analysts such as formulas, pivot tables, data cleaning, and conditional formatting to efficiently analyze and present data. This section is available for Mac and Windows laptops and computers.Using ChatGPT as a Data Analyst:

Learn how to use ChatGPT to enhance your productivity as a data analyst.

Discover practical techniques for utilizing ChatGPT to assist in writing SQL queries, generating code snippets, and automating repetitive tasks.Statistics for Data Analysis:

Develop a strong foundation in statistical concepts essential for data analysis. Learn about key measures such as standard deviation, mean, median, and mode.

Understand how to interpret these statistics and apply them to real-world data analysis scenarios.Why Enroll in this Course?Comprehensive Approach:

Gain proficiency in four essential tools used by data analysts, allowing you to tackle a wide range of data analysis tasks.Hands-On Learning:

Through practical exercises and real-world examples, you'll apply your knowledge to solve realistic data analysis challenges.Practical Projects:

Work on exciting projects that simulate real-world scenarios, enabling you to build a portfolio of practical data analysis skills.Expert Instruction:

Learn from an experienced instructor who has extensive industry knowledge and a passion for teaching data analysis.Career Advancement:

Equip yourself with the skills demanded by the job market and unlock lucrative career opportunities as a data analyst or business intelligence professional.

Programa

• Introducción al Análisis de Datos
Panorama del Análisis de Datos y su Importancia
Trayectorias Profesionales en Análisis de Datos
• SQL para Análisis de Datos
Introducción a Bases de Datos y SQL
Conceptos Clave de SQL: SELECT, FROM, WHERE
Agregaciones y Agrupación
Joins y Subconsultas
Práctica de SQL con Conjuntos de Datos Reales
• Excel para Análisis de Datos
Introducción a los Conceptos Básicos de Excel
Limpieza y Preparación de Datos
Tablas Dinámicas y Gráficos
Fórmulas y Funciones Avanzadas
Visualización de Datos con Excel
• Visualización de Datos con Tableau
Introducción a la Interfaz de Tableau
Conexión a Fuentes de Datos
Construcción de Visualizaciones y Paneles de Control
Funciones Avanzadas de Tableau: Cálculos, Parámetros y Filtros
Narración de Datos en Tableau
• Visualización de Datos con Power BI
Introducción a Power BI y su Ecosistema
Modelado de Datos y Conceptos Básicos de DAX
Creación de Informes Interactivos
Análisis Avanzado en Power BI
Compartición y Colaboración en Informes de Power BI
• Proyectos de Análisis de Datos del Mundo Real
Diseño y Planificación de Proyectos de Datos
Proyecto 1: Análisis de Datos de Ventas con SQL
Proyecto 2: Análisis de Datos Financieros en Excel
Proyecto 3: Construcción de un Panel de Control Interactivo en Tableau
Proyecto 4: Visualización de Tendencias del Mercado con Power BI
• Conclusión y Próximos Pasos
Resumen de Conceptos Clave
Construcción de un Portafolio en Análisis de Datos
Oportunidades de Aprendizaje y Certificación Adicionales

---

Impartido por

Graeme Gordon

---

Materias

Data Science