了解 Excel、Power BI 和 SQL 方面的确切技术技能，这些技能是找到第一份数据分析师工作所需的
学习内容：
本课程提供成为数据分析师所需的完整准备
了解如何在 excel 中清理和操作
了解如何在 SQL 中编码
主数据可视化
了解如何生成交互式 Power BI 仪表板
了解如何在 Excel 和 Power BI 中使用筛选器和切片器
了解如何使用 Power Query 进行数据转换
了解如何在 Power BI 中构建可视化效果
了解如何在 Power BI 中创建导航按钮
了解如何进行数据准备
了解如何在 Power BI 中创建 DAX 度量值
了解如何在 Excel 中创建图表
了解如何在 excel 中执行数据转换
学习 VLookup 函数
了解 excel 中的 IF、COUNTIF、SUMIF 函数
了解如何为利益相关者创建数据透视图
了解 excel 中的格式设置
了解如何在 Power BI 中合并数据集
了解 SQL 中的联接
了解数据库和表
了解 excel 和 Power BI 中的快捷方式
学习条件格式
了解如何在 Power BI 中连接来自不同源的数据集
了解如何分析数据并将其呈现给业务利益相关者
学习 20 多种不同的 SQL 语句和运算符
了解如何在 SQL 中使用聚合
了解如何设置数据视觉对象的样式
要求：
无需先验知识。您将学习成为数据分析师所需的所有技术技能
积极的态度和学习意愿
互联网连接
工作电脑
描述：
这个独特的数据分析师课程经过精心设计，旨在为您提供在该领域脱颖而出所需的精确技能，而不会让您淹没在不必要的技术术语中。
从基础知识到高级技术，您将获得数据分析、可视化和解释方面的实践经验。该课程分为三个部分，Excel、Power BI 和 SQL。
在每个部分的末尾都会有一个测验，您可以在其中测试您的知识，在课程结束时有实际的编码练习和一个项目。目标是为您提供完整的准备，并将您转变为准备好担任数据分析师工作角色的分析师。
为了带您到达那里，我们将广泛介绍以下主题： 分析数据操作和清理数据在 Excel 中使用 Vlookups、数据透视表、图表和各种函数在 Power BIU 中构建可视化效果通过 Power Query 自动执行数据清理步骤 在 SQL 中编码复杂查询怨恨数据与其他课程不同，本课程仅侧重于就业市场所需的技能， 确保您具备实用知识，以找到理想的数据分析师工作。
无论您是初学者还是希望提高技能的经验丰富的专业人士，本课程都将使您能够自信高效地驾驭数据世界。
加入我们，踏上数据分析领域有益的职业之旅。
本课程适合谁：
没有学位但想成为数据分析师的专业人士
正在面试数据分析师职位的初学者
非常适合寻求职业转变的专业人士
任何想要学习分析师最常用的技术的人
想要学习 Power BI 的专业人士
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 ) | Size: 4.5 GB
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
Description:
This unique Data Analyst course is meticulously designed to provide you with the precise skills needed to excel in the field without drowning you in unnecessary tech jargon. From the fundamentals to advanced techniques, you'll gain hands-on experience in data analysis, visualisation, and interpretation.The course is split into three sections, Excel, Power BI and SQL. At the end of each section there will be a quiz where you can test your knowledge, there are practical coding exercises and a project at the end of the course.The goal is to provide you with complete preparation and turn you into an Analyst ready for a Data Analyst job role. To take you there we'll be covering the following topics extensively: Analysing DataManipulating and cleaning DataUsing Vlookups, Pivot tables, charts and various functions in ExcelBuilding visualisations in Power BIUsing Power Query to automate data cleaning steps Coding complex queries in SQLPresenting DataUnlike other courses, this course focuses solely on the skills demanded by the job market, ensuring you're equipped with the practical knowledge to land your dream job as a Data Analyst. Whether you're a beginner or an experienced professional looking to upskill, this course will empower you to navigate the world of data with confidence and efficiency. Join us and embark on a journey towards a rewarding career in Data Analysis.
Who this course is for:
Professionals who don't have a degree but want to become a Data Analyst
Beginners who are interviewing for Data Analyst jobs
Perfect for professionals seeking a career change
Anyone who wants to learn the most frequently used techniques used by analysts
Professionals who want to learn Power BI
