|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/become-a-data-analyst/
课程评论：没有评论
课程名称：成为数据分析师：Excel、SQL 和 Tableau - 3 合 1 套餐 课程概述：如果你有志于成为数据分析师，但对所需的技术技能感到不知所措，那么“成为数据分析师：Excel、SQL 和 Tableau - 3 合 1 套餐”课程专为你设计。该课程结合最新更新，包括Excel中的“Copilot”功能、Power Query、Power Pivot和DAX的教程，并提供SQL实践的趣味案例研究。你将学习Excel、SQL和Tableau这三种数据分析的核心工具，培养将原始数据转化为能够推动更好的业务决策的见解的能力。 在本课程中，你将： - 培养高级Excel技能，以处理和分析数据 - 熟练掌握SQL查询，从数据库中提取数据 - 创造精彩的数据可视化，以有效传达见解 课程的独特之处在于它提供全面的3合1套餐，涵盖成为成功数据分析师所需的所有关键技能。课程以生动易懂的方式讲授，让你能够按照自己的节奏学习，并自信地在工作中应用所学技能。 课程教授者背景：课程由Abhishek（MBA - 德里大学管理学院，B. Tech - 印度理工学院鲁尔基）和Pukhraj（MBA - 印度管理学院阿赫默达巴德，B. Tech - 印度理工学院鲁尔基）教授。他们在全球分析咨询公司担任经理，通过分析帮助企业解决业务问题，并将实践经验融入课程中。他们开设的在线课程累计已有超过120万名学员注册，并获得成千上万的五星好评。 课程内容包括： - 第一部分：数据分析的Excel使用 学习如何进行数据运算、转换、匹配、筛选、排序和聚合，以及使用各种图表可视化数据。 - 第二部分：数据分析的SQL使用 从基本数据操作如创建表、检索表中的数据开始，逐步学习子查询、连接、数据聚合和模式匹配等高级主题。 - 第三部分：使用Tableau进行数据可视化 学习如何开发引人入胜的仪表盘、可视化和见解，掌握数据混合、计算和映射等关键概念。 我们的承诺：我们致力于教学，如果你对课程内容、练习表或任何主题有疑问，可以随时在课程中提问或直接发送信息。 不要让技术技能阻碍你追求数据分析职业的梦想。立即注册，开启成为数据分析师的旅程！
[June 2025 update]Added a section on the "Copilot in Excel" which demonstrates the capabilities and limitations of Copilot - Microsoft's GenAI powered assistant in ExcelAdded a section on "Power Query, Power Pivot and DAX in Excel" for building powerful and automated reports in ExcelAdded a video on the "Analyze Data" option in MS ExcelAdded a new section on how to practice SQL using fun case studies.If you are interested in becoming a data analyst, but feel overwhelmed by the technical skills required, this "Become a Data Analyst: Excel, SQL & Tableau - 3-in-1 Bundle" course is designed for you. You'll learn Excel, SQL, and Tableau - the essential tools for data analysis - and develop the skills to turn raw data into insights that drive better business decisions.In this course, you will:Develop advanced Excel skills to manipulate and analyze dataMaster SQL queries to extract data from databasesCreate stunning data visualizations in Tableau to communicate insightsLearning these skills will allow you to excel as a data analyst, and open up new career opportunities. You'll practice real-world examples and complete hands-on exercises, so you can apply your new skills to real-world situations.This course is different because it offers a comprehensive, 3-in-1 bundle approach that covers all of the key skills required to become a successful data analyst. The course is also taught in an engaging and easy-to-understand format, so you can learn at your own pace and confidently apply your skills in the workplace.What makes us qualified to teach you?The course is taught by Abhishek (MBA - FMS Delhi, B. Tech - IIT Roorkee) and Pukhraj (MBA - IIM Ahmedabad, B. Tech - IIT Roorkee). As managers in the Global Analytics Consulting firm, we have helped businesses solve their business problems using Analytics and we have used our experience to include the practical aspects of business analytics in this course. We have in-hand experience in Business Analysis.We are also the creators of some of the most popular online courses - with over 1,200,000 enrollments and thousands of 5-star reviews like these ones:This is very good, i love the fact the all explanation given can be understood by a layman - JoshuaThank you Author for this wonderful course. You are the best and this course is worth any price. - DaisyWhat is covered in this course?The analysis of data is not the main crux of analytics. It is the interpretation that helps provide insights after the application of analytical techniques that makes analytics such an important discipline. We have used the most popular analytics software tools which are MS Excel, SQL, and Tableau. This will aid the students who have no prior coding background to learn and implement Analytics and Machine Learning concepts to actually solve real-world problems of Data Analysis.Let me give you a brief overview of the coursePart 1 - Excel for data analyticsIn the first section, i.e. Excel for data analytics, we will learn how to use excel for data-related operations such as calculating, transforming, matching, filtering, sorting, and aggregating data.We will also cover how to use different types of charts to visualize the data and discover hidden data patterns.Part 2 - SQL for data analyticsIN the second section, i.e. SQL for data analytics, we will be teaching you everything in SQL that you will need for Data analysis in businesses. We will start with basic data operations like creating a table, retrieving data from a table etc. Later on, we will learn advanced topics like subqueries, Joins, data aggregation, and pattern matching.Part 3 - Data visualization using TableauIn this section, you will learn how to develop stunning dashboards, visualizations and insights that will allow you to explore, analyze and communicate your data effectively. You will master key Tableau concepts such as data blending, calculations, and mapping. By the end of the course, you will be able to create engaging visualizations that will enable you to make data-driven decisions confidently.Our PromiseTeaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet, or anything related to any topic, you can always post a question in the course or send us a direct message.Don't let technical skills hold you back from pursuing a career in data analysis. Enroll now and start your journey towards becoming a data analyst.
