Tags
Language
Tags
June 2025
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 1 2 3 4 5
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz

    Data Analysis Projects Using Sql, Power Bi, Tableau & Excel

    Posted By: ELK1nG
    Data Analysis Projects Using Sql, Power Bi, Tableau & Excel

    Data Analysis Projects Using Sql, Power Bi, Tableau & Excel
    Published 6/2023
    MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
    Language: English | Size: 6.24 GB | Duration: 7h 45m

    Hands-on Data Analysis with four essential tools used by Data Analysts

    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.

    Requirements

    MySQL Workbench, Excel and Tableau can be downloaded on a Windows or Mac computer/laptop for free, however Power BI will require a Windows laptop or computer.

    No prior experience required, only curiosity and eagerness to learn - Data Analysis requires a curious mindset and a willingness to explore and experiment with data.

    An understanding of basic mathematical concepts such as arithmetic operations, percentages and averages would be helpful.

    Description

    In this course, you will embark on an exciting journey 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 and subqueries, you'll gain a comprehensive understanding of SQL.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.Tableau Fundamentals: Unleash the full 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.Excel for Data Analysis: Excel remains a fundamental tool for data analysis, and in this course, you'll harness its power. Explore advanced features, such as formulas, pivot tables, data cleaning, and conditional formatting, to efficiently analyze and present data.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 experienced instructors who have 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.

    Overview

    Section 1: Introduction

    Lecture 1 Introduction

    Section 2: SQL

    Lecture 2 Download MySQL Workbench and Classic Models Database - Windows

    Lecture 3 Download MySQL Workbench and Classic Models Database - MacOS

    Lecture 4 What is SQL & a Relational Database

    Lecture 5 Select, From & Where Statement

    Lecture 6 Select Statement Q & A

    Lecture 7 Upper & Lower

    Lecture 8 In & Not In

    Lecture 9 Distinct, Like & Order By

    Lecture 10 Inner Join

    Lecture 11 Left & Right Join

    Lecture 12 Joins Q & A

    Lecture 13 Union & Union All

    Lecture 14 Sum, Round, Group by & Having

    Lecture 15 Count, Max, Min, Avg

    Lecture 16 Aggregate Functions Q & A

    Lecture 17 Subquery

    Lecture 18 Common Table Expression (CTE)

    Lecture 19 Case statement

    Lecture 20 Create a Flag using Case Statement

    Lecture 21 Row Number

    Lecture 22 Lead & Lag

    Lecture 23 Row Number Q & A

    Lecture 24 Date Functions

    Lecture 25 String Functions

    Section 3: Excel with Netflix Dataset

    Lecture 26 Download Excel and Netflix Dataset

    Lecture 27 Common Excel Shortcuts

    Lecture 28 Split Text to Columns - Part 1

    Lecture 29 Split Text to Columns - Part 2

    Lecture 30 Trim & Separate Data

    Lecture 31 Sort & Filter Data

    Lecture 32 Common Calculations - Sum, Avg, Max, Min

    Lecture 33 If Function

    Lecture 34 Sumifs & Countifs

    Lecture 35 Unique, Left, Right

    Lecture 36 Vlookup

    Lecture 37 Pivot Tables

    Lecture 38 Excel - Exercises and Answers

    Lecture 39 Separate Sheets and Find & Replace Blanks

    Lecture 40 Import Netflix Data to MySQL Workbench

    Lecture 41 Set Up Relational Tables for Power BI

    Section 4: Power BI Dashboard - Netflix

    Lecture 42 Download Power BI and Connect to Data

    Lecture 43 Power BI Overview

    Lecture 44 Create Area Chart

    Lecture 45 Create Shows by Rating & Top 10 Categories Charts

    Lecture 46 Create Countries Available Map and import Netflix logo

    Lecture 47 Create Single Title View Page - Part 1

    Lecture 48 Create Single Title View Page - Part 2

    Section 5: Classic Models Data Analysis Exercises

    Lecture 49 Sales Overview by Product

    Lecture 50 Sales Overview by Country

    Lecture 51 Products Purchased Together

    Lecture 52 Customers' Sales Value by Credit Limit

    Lecture 53 Sales Value Change from Previous Order

    Lecture 54 Office Sales by Customer Country

    Lecture 55 Customers Affected by Late Shipping

    Section 6: Power BI Dashboard - Classic Models

    Lecture 56 Create View in My SQL Workbench for Power BI

    Lecture 57 Connect Power BI to Data Source & Prepare Canvas

    Lecture 58 Create Overview Cards

    Lecture 59 Create Overview Line Charts

    Lecture 60 Set up Measures for Sales & Net Profit Buttons

    Lecture 61 Add Actions to Buttons and Create Bar Chart

    Lecture 62 Create Scatter, Column & Donut Charts

    Lecture 63 Add Conditional titles to Charts

    Lecture 64 Create Decomposition Tree

    Lecture 65 Create Sales Overview Table with MoM % and YTD Calculations

    Lecture 66 Add Filters and Page Navigation Buttons

    Section 7: Electric Vehicle Dashboard with Tableau

    Lecture 67 Download Tableau Public and Electric Vehicle Dataset

    Lecture 68 Tableau Overview

    Lecture 69 Create Bar Chart - Vehicle Year

    Lecture 70 Create Map

    Lecture 71 Top 10 Counties Column Chart

    Lecture 72 Make & Model Column Chart and Parameter

    Lecture 73 Create Donut Chart

    Lecture 74 Put Dashboard Together

    Lecture 75 Format and Publish Dashboard

    Beginners: Individuals who have little to no prior experience with data analysis or the mentioned tools but are eager to learn and build a foundation in data analysis.,Aspiring Data Analysts: Individuals who want to pursue a career in data analysis and need to develop a strong understanding of SQL, Power BI, Tableau, and Excel.,Anyone interested in Data Analysis: Individuals with a general interest in data analysis and a desire to learn SQL, Power BI, Excel, and Tableau to explore and analyze data in various contexts.