[center]
Data Analysis for Beginners (2024)
Published 4/2024
Created by Matthew Walcott
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 118 Lectures ( 4h 31m ) | 4.5 GB[/center]
Learn the exact technical skills in Excel, Power BI and SQL that you need to land your first job as a Data Analyst

What you'll learn:
This course provides the complete preparation you need to become a data analyst
Learn how to clean and manipulate in excel
Learn how to code in SQL
Master data visualisation
Learn how to build interactive Power BI dashboards
Learn how to use filters and slicers in excel and Power BI
Learn how to use Power Query for Data transformations
Learn how to build Visualisations in Power BI
Learn how to create Navigation Buttons in Power BI
Learn how to do data preparation
Learn how to create DAX measures in Power BI
Learn how to create charts in Excel
Learn how to do data transformations in excel
Learn VLookup Function
Learn IF, COUNTIF, SUMIF functions in excel
Learn how to create Pivot Charts for Stakeholders
Learn about formatting in excel
Learn how to merge Datasets in Power BI
Learn Joins in SQL
Learn about Databases and Tables
Learn shortcuts in excel and Power BI
Learn Conditional Formatting
Learn how to connect datasets from different sources in Power BI
Learn how to Analyse and Present Data to business Stakeholders
Learn over 20 different SQL statements and operators
Learn how to use aggregations in SQL
Learn how to style your data visuals

Requirements:
No prior knowledge needed. You will learn all the technical skills you need to become a Data Analyst
A positive attitude and willingness to learn
Internet connection
Working computer