• No hay productos en el carrito.

Inicio / Cursos / Data Analysis | SQL,Tableau,Power BI & Excel | Real Projects
Impartido por Graeme GordonPago único de $2,800 MXN · acceso por 12 meses

Data Analysis | SQL,Tableau,Power BI & Excel | Real Projects

4-in-1 bundle: Practical learning of the essential tools used in Data Science with hands on examples and projects

Certificado oficial emitido por la SEPA través del Gobierno del Estado de México
12 meses de acceso En línea · 60 h 14 unidades
Qué aprenderás

Lo que serás capaz de hacer

If you're interested in becoming a data analyst you're in the right place! Please ensure you can install MySQL Workbench 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.

  • 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.

Temario

UNIDAD 1 - Introduction · 2 lecciones

UNIDAD 1 - Introduction

  • IntroductionVideo · 1 min
  • Important Introduction to Udemy and Where to Ask A QuestionVideo · 2 min
UNIDAD 2 - SQL · 44 lecciones

UNIDAD 2 - SQL

  • The Data Analyst RoleVideo · 8 min
  • Downloading MySQL Workbench - Please ReadLectura · 0 min
  • Download MySQL Workbench - WindowsVideo · 9 min
  • Download MySQL Workbench - MacOSVideo · 6 min
  • MySQL Workbench OverviewVideo · 4 min
  • What is SQL & Data Definition Language (DDL)Video · 10 min
  • Insert Data Into a TableVideo · 7 min
  • Create Classic Models SchemaVideo · 1 min
  • What is a Relational Database?Video · 5 min
  • Want to Complete a Relational Database Project?Video · 1 min
  • A note on the SQL sectionLectura · 0 min
  • Select, From & Where StatementVideo · 7 min
  • Select Statement Q & AVideo · 4 min
  • Upper & LowerVideo · 5 min
  • In & Not InVideo · 4 min
  • Show all columns for customers who are from New York, London or Mumbai using INActividad · 0 min
  • Distinct, Like & Order ByVideo · 6 min
  • Examples of Distinct and LikeVideo · 4 min
  • Inner JoinVideo · 6 min
  • Left & Right JoinVideo · 4 min
  • Example and Use Case of JoinsVideo · 5 min
  • Joins Q & AVideo · 7 min
  • Show all customers and their orders, even if they made no orders. Both tables have a cust_code fieldActividad · 0 min
  • Union & Union AllVideo · 6 min
  • Show all Employees and CustomersActividad · 0 min
  • Joins and UnionCuestionario · 0 min
  • Sum, Round, Group by & HavingVideo · 7 min
  • Show the sum of all orders on each dayActividad · 0 min
  • Count, Max, Min, AvgVideo · 6 min
  • Count how many distinct customers there were on each dayActividad · 0 min
  • Aggregate Functions Q & AVideo · 5 min
  • SubqueryVideo · 4 min
  • Common Table Expression (CTE)Video · 3 min
  • Case statementVideo · 5 min
  • Create a Flag using Case StatementVideo · 4 min
  • Examples of Case StatementVideo · 7 min
  • Quiz - Case Statement, Sub Query and CTECuestionario · 0 min
  • Row NumberVideo · 5 min
  • Lead & LagVideo · 4 min
  • Row_Number and Lead/LagCuestionario · 0 min
  • Row Number Q & AVideo · 5 min
  • Date FunctionsVideo · 6 min
  • String FunctionsVideo · 6 min
  • Date and String FunctionsCuestionario · 0 min
UNIDAD 3 - Introduction to Statistics for Data Analysis · 5 lecciones

UNIDAD 3 - Introduction to Statistics for Data Analysis

  • Central Tendency: Understanding Mean, Median, and ModeVideo · 5 min
  • Exploring Range with a Practical ExampleVideo · 4 min
  • Understanding Variance and Standard DeviationVideo · 4 min
  • Understanding Frequency DistributionVideo · 4 min
  • Quantitative and Qualitive VariablesVideo · 5 min
UNIDAD 4 - Excel with Netflix Dataset · 17 lecciones

UNIDAD 4 - Excel with Netflix Dataset

  • Download Excel and Netflix DatasetVideo · 4 min
  • Common Excel ShortcutsVideo · 6 min
  • Split Text to Columns - Part 1Video · 6 min
  • Split Text to Columns - Part 2Video · 4 min
  • Trim & Separate DataVideo · 9 min
  • Sort & Filter DataVideo · 2 min
  • Common Calculations - Sum, Avg, Max, MinVideo · 3 min
  • If FunctionVideo · 7 min
  • Sumifs & CountifsVideo · 4 min
  • Unique, Left, RightVideo · 3 min
  • VlookupVideo · 4 min
  • XlookupVideo · 4 min
  • Pivot TablesVideo · 4 min
  • Excel - Exercises and AnswersVideo · 9 min
  • Separate Sheets and Find & Replace BlanksVideo · 7 min
  • Import Netflix Data to MySQL WorkbenchVideo · 7 min
  • Set Up Relational Tables for Power BIVideo · 5 min
UNIDAD 5 - Power BI Dashboard: Netflix - Windows Users only · 9 lecciones

UNIDAD 5 - Power BI Dashboard: Netflix - Windows Users only

  • Please Read if You're Starting Course HereLectura · 0 min
  • Are you Having Issues Downloading a Connector to MySQL?Lectura · 0 min
  • Download Power BI and Connect to DataVideo · 7 min
  • Power BI OverviewVideo · 6 min
  • Create Area ChartVideo · 9 min
  • Create Shows by Rating & Top 10 Categories ChartsVideo · 5 min
  • Create Countries Available Map and import Netflix logoVideo · 4 min
  • Create Single Title View Page - Part 1Video · 6 min
  • Create Single Title View Page - Part 2Video · 8 min
UNIDAD 6 - Classic Models Data Analysis Exercises · 10 lecciones

UNIDAD 6 - Classic Models Data Analysis Exercises

  • About this SectionLectura · 0 min
  • Sales Overview by ProductVideo · 18 min
  • Sales Overview by CountryVideo · 6 min
  • Products Purchased TogetherVideo · 12 min
  • Customers' Sales Value by Credit LimitVideo · 14 min
  • Sales Value Change from Previous OrderVideo · 14 min
  • Office Sales by Customer CountryVideo · 15 min
  • Customers Affected by Late ShippingVideo · 4 min
  • Advanced Exercise - Customers who go over Credit Limit Part 1Video · 11 min
  • Advanced Exercise - Customers who go over Credit Limit Part 2Video · 13 min
UNIDAD 7 - AI-Assisted SQL with ChatGPT · 4 lecciones

UNIDAD 7 - AI-Assisted SQL with ChatGPT

  • Introduction to Prompt EngineeringVideo · 7 min
  • Using ChatGPT to extract Sales by Product and CountryVideo · 7 min
  • Attempting Intermediate and Advanced SQL Queries with ChatGPTVideo · 7 min
  • Grouping Data with ChatGPT and SQLVideo · 6 min
UNIDAD 8 - Power BI Dashboard: Classic Models - Windows Users only · 14 lecciones

UNIDAD 8 - Power BI Dashboard: Classic Models - Windows Users only

  • Introduction to Udemy RoleplayLectura · 0 min
  • Dashboard Planning Session with Head of Sales OperationsProyecto · 0 min
  • Create View in My SQL Workbench for Power BIVideo · 10 min
  • Connecting to Power BI Data SourceLectura · 0 min
  • Connect Power BI to Data Source & Prepare CanvasVideo · 7 min
  • Create Overview CardsVideo · 7 min
  • Create Overview Line ChartsVideo · 7 min
  • Set up Measures for Sales & Net Profit ButtonsVideo · 9 min
  • Add Actions to Buttons and Create Bar ChartVideo · 8 min
  • Create Scatter, Column & Donut ChartsVideo · 7 min
  • Add Conditional titles to ChartsVideo · 8 min
  • Create Decomposition TreeVideo · 9 min
  • Create Sales Overview Table with MoM % and YTD CalculationsVideo · 10 min
  • Add Filters and Page Navigation ButtonsVideo · 7 min
UNIDAD 9 - Introduction to Cloud Computing and Snowflake · 12 lecciones

UNIDAD 9 - Introduction to Cloud Computing and Snowflake

  • What is Cloud Computing?Video · 3 min
  • Creating a Snowflake Account and Getting StartedVideo · 2 min
  • Snowflake OverviewVideo · 3 min
  • Loading Data into SnowflakeVideo · 5 min
  • A Note on Recent Snowflake UI UpdatesLectura · 0 min
  • Creating a Database and SchemaVideo · 4 min
  • Creating a Stage and Loading CSV DataVideo · 5 min
  • Loading Parquet and JSON Data into SnowflakeVideo · 11 min
  • Setting Up an Azure Blob Storage AccountVideo · 6 min
  • Bulk Loading Data from Azure Blob Storage to SnowflakeVideo · 7 min
  • Data Manipulation in SnowflakeVideo · 6 min
  • Exploring the Snowflake MarketplaceVideo · 7 min
UNIDAD 10 - AI Assisted Customer Sentiment Analysis Project with Snowflake Cortex · 14 lecciones

UNIDAD 10 - AI Assisted Customer Sentiment Analysis Project with Snowflake Cortex

  • Understand the Dataset and Project ApproachVideo · 3 min
  • Introduction to Snowflake CortexVideo · 3 min
  • Loading Reviews Dataset into SnowflakeVideo · 4 min
  • Creating your First Snowflake NotebookVideo · 5 min
  • Please Read: Snowflake Cortex TranslateLectura · 0 min
  • Using Snowflake Cortex for TranslationVideo · 8 min
  • Summarizing Text with Snowflake CortexVideo · 7 min
  • Snowflake Cortex Sentiment FunctionVideo · 7 min
  • Using AI_AGG to Extract Insights from TextVideo · 9 min
  • Text Classification in Snowflake CortexVideo · 7 min
  • Snowflake AI_SENTIMENT FunctionVideo · 5 min
  • How to Use LATERAL FLATTENVideo · 9 min
  • Generating Code with Snowflake CortexVideo · 6 min
  • Create a Streamlit App Using Cortex AIVideo · 9 min
UNIDAD 11 - Electric Vehicle Dashboard with Tableau · 9 lecciones

UNIDAD 11 - Electric Vehicle Dashboard with Tableau

  • Download Tableau Public and Electric Vehicle DatasetVideo · 4 min
  • Tableau OverviewVideo · 5 min
  • Create Bar Chart - Vehicle YearVideo · 5 min
  • Create MapVideo · 4 min
  • Top 10 Counties Column ChartVideo · 3 min
  • Make & Model Column Chart and ParameterVideo · 6 min
  • Create Donut ChartVideo · 5 min
  • Put Dashboard TogetherVideo · 10 min
  • Format and Publish DashboardVideo · 11 min
UNIDAD 12 - Bike Sales Dashboard with Tableau · 10 lecciones

UNIDAD 12 - Bike Sales Dashboard with Tableau

  • Connect Tableau to our datasetVideo · 2 min
  • Top 10 Products chartVideo · 5 min
  • Stacked Bar Chart showing Profit by Sub CategoryVideo · 4 min
  • Bubble Chart showing Revenue by Age GroupVideo · 4 min
  • Map showing Profit by CountryVideo · 3 min
  • Profit and Year on Year % Change Cards, and Year ParameterVideo · 12 min
  • Revenue Card and Line ChartVideo · 4 min
  • Product Category Cost cardVideo · 3 min
  • Put Dashboard Together - Part OneVideo · 13 min
  • Put Dashboard Together - Part TwoVideo · 13 min
UNIDAD 13 - Appendix - Relational Database Project (Optional) · 7 lecciones

UNIDAD 13 - Appendix - Relational Database Project (Optional)

  • Introduction to Relational Databases: Understanding the BasicsVideo · 5 min
  • Normalization Explained: First Normal Form (1NF)Video · 8 min
  • Achieving Second Normal Form (2NF): Part 1Video · 14 min
  • Achieving Second Normal Form (2NF): Part 2Video · 13 min
  • Third Normal Form (3NF): Ensuring Data IntegrityVideo · 6 min
  • Designing an ER Diagram - Part 1Video · 9 min
  • Designing an ER Diagram - Part 2Video · 8 min
UNIDAD 14 - Congratulations and Thank You! · 3 lecciones

UNIDAD 14 - Congratulations and Thank You!

  • Congratulations and Thank You - What you can do nowVideo · 2 min
  • Preparing for an InterviewVideo · 4 min
  • Bonus LectureLectura · 0 min
Certificado oficial

Tu certificado lo emite la SEP, no solo una plataforma

Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.

Tu certificado con INEC

  • Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
  • Documento oficial con folio verificable en línea
  • Lo otorga la Universidad Tecnológica Fidel Velázquez

Otras plataformas en línea

  • Constancia privada emitida por la misma plataforma
  • Solo acredita horas cursadas o asistencia
  • Sin respaldo de una autoridad educativa
Cómo funciona

Tu itinerario, de la inscripción al certificado

  1. 1

    Inscripción con pago único

    Pagas $2,800 MXN una sola vez y entras de inmediato al curso.

  2. 2

    Estudias a tu ritmo

    14 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.

  3. 3

    Cuestionarios por unidad

    4 cuestionarios para comprobar lo aprendido.

  4. 4

    Certificado

    Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.

Lo que obtienes

Un certificado oficial de la SEP

Muestra del certificado: Data Analysis | SQL,Tableau,Power BI & Excel | Real Projects

Muestra · verificable por folio y QR

  • Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
  • Contenido impartido por Graeme Gordon.
  • Folio y QR verificables para compartirlo con quien te contrate.
Medios que necesitas
Equipo de cómputo Conexión estable a internet
Pago único

Empieza hoy, a tu ritmo

Un solo pago y acceso inmediato al curso completo durante 12 meses.

  • 14 unidades · 160 lecciones · 60 h
  • 12 meses de acceso
  • 4 cuestionarios de evaluación
  • Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Pago único
$2,800MXN
Acceso por 12 meses
Inscribirme Hablar con un asesor
Preguntas frecuentes

Sobre tu inscripción

¿Cómo es el pago?

Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.

¿Cuánto tiempo tengo acceso?

12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.

¿Quién imparte el contenido?

El curso es impartido por Graeme Gordon; INEC gestiona tu inscripción, evaluación y certificado.

¿Qué pasa cuando vence mi acceso?

Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.

Certificado emitido por la SEP a través del Gobierno del Estado de México · Data Analysis | SQL,Tableau,Power BI & Excel | Real Projects

Inscribirme
  INEC es una Marca de SalesPartners Ciudad de México S de RL de CV. Template Design © Learnify LMS. All rights reserved. Terminos y Condiciones Aviso de Privacidad Politica de Devolución
Hide picture