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
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 leccionesUNIDAD 1 - Introduction
UNIDAD 1 - Introduction
- Introduction
- Important Introduction to Udemy and Where to Ask A Question
UNIDAD 2 - SQL · 44 leccionesUNIDAD 2 - SQL
UNIDAD 2 - SQL
- The Data Analyst Role
- Downloading MySQL Workbench - Please Read
- Download MySQL Workbench - Windows
- Download MySQL Workbench - MacOS
- MySQL Workbench Overview
- What is SQL & Data Definition Language (DDL)
- Insert Data Into a Table
- Create Classic Models Schema
- What is a Relational Database?
- Want to Complete a Relational Database Project?
- A note on the SQL section
- Select, From & Where Statement
- Select Statement Q & A
- Upper & Lower
- In & Not In
- Show all columns for customers who are from New York, London or Mumbai using IN
- Distinct, Like & Order By
- Examples of Distinct and Like
- Inner Join
- Left & Right Join
- Example and Use Case of Joins
- Joins Q & A
- Show all customers and their orders, even if they made no orders. Both tables have a cust_code field
- Union & Union All
- Show all Employees and Customers
- Joins and Union
- Sum, Round, Group by & Having
- Show the sum of all orders on each day
- Count, Max, Min, Avg
- Count how many distinct customers there were on each day
- Aggregate Functions Q & A
- Subquery
- Common Table Expression (CTE)
- Case statement
- Create a Flag using Case Statement
- Examples of Case Statement
- Quiz - Case Statement, Sub Query and CTE
- Row Number
- Lead & Lag
- Row_Number and Lead/Lag
- Row Number Q & A
- Date Functions
- String Functions
- Date and String Functions
UNIDAD 3 - Introduction to Statistics for Data Analysis · 5 leccionesUNIDAD 3 - Introduction to Statistics for Data Analysis
UNIDAD 3 - Introduction to Statistics for Data Analysis
- Central Tendency: Understanding Mean, Median, and Mode
- Exploring Range with a Practical Example
- Understanding Variance and Standard Deviation
- Understanding Frequency Distribution
- Quantitative and Qualitive Variables
UNIDAD 4 - Excel with Netflix Dataset · 17 leccionesUNIDAD 4 - Excel with Netflix Dataset
UNIDAD 4 - Excel with Netflix Dataset
- Download Excel and Netflix Dataset
- Common Excel Shortcuts
- Split Text to Columns - Part 1
- Split Text to Columns - Part 2
- Trim & Separate Data
- Sort & Filter Data
- Common Calculations - Sum, Avg, Max, Min
- If Function
- Sumifs & Countifs
- Unique, Left, Right
- Vlookup
- Xlookup
- Pivot Tables
- Excel - Exercises and Answers
- Separate Sheets and Find & Replace Blanks
- Import Netflix Data to MySQL Workbench
- Set Up Relational Tables for Power BI
UNIDAD 5 - Power BI Dashboard: Netflix - Windows Users only · 9 leccionesUNIDAD 5 - Power BI Dashboard: Netflix - Windows Users only
UNIDAD 5 - Power BI Dashboard: Netflix - Windows Users only
- Please Read if You're Starting Course Here
- Are you Having Issues Downloading a Connector to MySQL?
- Download Power BI and Connect to Data
- Power BI Overview
- Create Area Chart
- Create Shows by Rating & Top 10 Categories Charts
- Create Countries Available Map and import Netflix logo
- Create Single Title View Page - Part 1
- Create Single Title View Page - Part 2
UNIDAD 6 - Classic Models Data Analysis Exercises · 10 leccionesUNIDAD 6 - Classic Models Data Analysis Exercises
UNIDAD 6 - Classic Models Data Analysis Exercises
- About this Section
- Sales Overview by Product
- Sales Overview by Country
- Products Purchased Together
- Customers' Sales Value by Credit Limit
- Sales Value Change from Previous Order
- Office Sales by Customer Country
- Customers Affected by Late Shipping
- Advanced Exercise - Customers who go over Credit Limit Part 1
- Advanced Exercise - Customers who go over Credit Limit Part 2
UNIDAD 7 - AI-Assisted SQL with ChatGPT · 4 leccionesUNIDAD 7 - AI-Assisted SQL with ChatGPT
UNIDAD 7 - AI-Assisted SQL with ChatGPT
- Introduction to Prompt Engineering
- Using ChatGPT to extract Sales by Product and Country
- Attempting Intermediate and Advanced SQL Queries with ChatGPT
- Grouping Data with ChatGPT and SQL
UNIDAD 8 - Power BI Dashboard: Classic Models - Windows Users only · 14 leccionesUNIDAD 8 - Power BI Dashboard: Classic Models - Windows Users only
UNIDAD 8 - Power BI Dashboard: Classic Models - Windows Users only
- Introduction to Udemy Roleplay
- Dashboard Planning Session with Head of Sales Operations
- Create View in My SQL Workbench for Power BI
- Connecting to Power BI Data Source
- Connect Power BI to Data Source & Prepare Canvas
- Create Overview Cards
- Create Overview Line Charts
- Set up Measures for Sales & Net Profit Buttons
- Add Actions to Buttons and Create Bar Chart
- Create Scatter, Column & Donut Charts
- Add Conditional titles to Charts
- Create Decomposition Tree
- Create Sales Overview Table with MoM % and YTD Calculations
- Add Filters and Page Navigation Buttons
UNIDAD 9 - Introduction to Cloud Computing and Snowflake · 12 leccionesUNIDAD 9 - Introduction to Cloud Computing and Snowflake
UNIDAD 9 - Introduction to Cloud Computing and Snowflake
- What is Cloud Computing?
- Creating a Snowflake Account and Getting Started
- Snowflake Overview
- Loading Data into Snowflake
- A Note on Recent Snowflake UI Updates
- Creating a Database and Schema
- Creating a Stage and Loading CSV Data
- Loading Parquet and JSON Data into Snowflake
- Setting Up an Azure Blob Storage Account
- Bulk Loading Data from Azure Blob Storage to Snowflake
- Data Manipulation in Snowflake
- Exploring the Snowflake Marketplace
UNIDAD 10 - AI Assisted Customer Sentiment Analysis Project with Snowflake Cortex · 14 leccionesUNIDAD 10 - AI Assisted Customer Sentiment Analysis Project with Snowflake Cortex
UNIDAD 10 - AI Assisted Customer Sentiment Analysis Project with Snowflake Cortex
- Understand the Dataset and Project Approach
- Introduction to Snowflake Cortex
- Loading Reviews Dataset into Snowflake
- Creating your First Snowflake Notebook
- Please Read: Snowflake Cortex Translate
- Using Snowflake Cortex for Translation
- Summarizing Text with Snowflake Cortex
- Snowflake Cortex Sentiment Function
- Using AI_AGG to Extract Insights from Text
- Text Classification in Snowflake Cortex
- Snowflake AI_SENTIMENT Function
- How to Use LATERAL FLATTEN
- Generating Code with Snowflake Cortex
- Create a Streamlit App Using Cortex AI
UNIDAD 11 - Electric Vehicle Dashboard with Tableau · 9 leccionesUNIDAD 11 - Electric Vehicle Dashboard with Tableau
UNIDAD 11 - Electric Vehicle Dashboard with Tableau
- Download Tableau Public and Electric Vehicle Dataset
- Tableau Overview
- Create Bar Chart - Vehicle Year
- Create Map
- Top 10 Counties Column Chart
- Make & Model Column Chart and Parameter
- Create Donut Chart
- Put Dashboard Together
- Format and Publish Dashboard
UNIDAD 12 - Bike Sales Dashboard with Tableau · 10 leccionesUNIDAD 12 - Bike Sales Dashboard with Tableau
UNIDAD 12 - Bike Sales Dashboard with Tableau
- Connect Tableau to our dataset
- Top 10 Products chart
- Stacked Bar Chart showing Profit by Sub Category
- Bubble Chart showing Revenue by Age Group
- Map showing Profit by Country
- Profit and Year on Year % Change Cards, and Year Parameter
- Revenue Card and Line Chart
- Product Category Cost card
- Put Dashboard Together - Part One
- Put Dashboard Together - Part Two
UNIDAD 13 - Appendix - Relational Database Project (Optional) · 7 leccionesUNIDAD 13 - Appendix - Relational Database Project (Optional)
UNIDAD 13 - Appendix - Relational Database Project (Optional)
- Introduction to Relational Databases: Understanding the Basics
- Normalization Explained: First Normal Form (1NF)
- Achieving Second Normal Form (2NF): Part 1
- Achieving Second Normal Form (2NF): Part 2
- Third Normal Form (3NF): Ensuring Data Integrity
- Designing an ER Diagram - Part 1
- Designing an ER Diagram - Part 2
UNIDAD 14 - Congratulations and Thank You! · 3 leccionesUNIDAD 14 - Congratulations and Thank You!
UNIDAD 14 - Congratulations and Thank You!
- Congratulations and Thank You - What you can do now
- Preparing for an Interview
- Bonus Lecture
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
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
14 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
4 cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Un certificado oficial de la SEP
- 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.
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
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.


