|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/practical-data-analytics-using-excel-vba-power-bi-with-dax/
课程评论：没有评论
课程名称：使用Excel VBA和Power BI及DAX进行实用数据分析 课程概述：本课程将帮助你成为一名具备一定编程知识和商业智能平台（尤其是微软Power BI）技能的数据分析师。课程强调实用性，同时提供必要的理论知识，让你在职场中能够迅速上手。内容涵盖Excel及其编程语言VBA，以及微软提供的免费软件Power BI，用于数据挖掘、流程分析、绩效基准测试和描述性分析，从而提升竞争优势。你将学习如何从网页导入数据到Excel，并使用VBA编写程序，为导入Power BI应用做好数据预处理。此外，课程还将讨论Power BI中的两种语言：M语言和DAX，并阐明其异同。整个课程通过一个案例研究，即1960年至2020年间大多数国家的GDP（国内生产总值）数据进行实操，展示所学概念，使用可视化工具（如切片器）进行国家间的对比分析，特别是BRICS国家（巴西、俄罗斯、印度、中国和南非）。课程共分为9章，以下是每章的简要介绍。 第一章：Excel和VBA基础 该章节介绍编程语言的概念、原理和术语，包括语法和表达式的定义，以及如何培养程序解决能力。还简要介绍了Excel的编程语言Visual Basic for Applications (VBA)，包括声明变量、消息框、输入框、迭代循环及常用语句和好处，同时讲解数据分析的不同类型，并解释如何使开发者选项卡可见。 第二章：数据导入及VBA预处理 该章节展示如何从网页导入数据到Excel，为后续分析和展示做好准备。使用ActiveX命令框的VBA编程用于将数据整理成适合导入Power BI的格式，介绍了变量声明、消息框、数组和迭代循环，并引入了1960年至2020年间266个国家的GDP和人口的案例研究。 第三章：Power BI的何时、何地和为什么 讨论什么是商业智能（BI），其使用场景和原因，BI策略、工具、技术、趋势、软件和系统等内容。介绍微软Power BI的组成部分、概念和仪表板功能，讲解Power BI中的报告、数据和模型视图。 第四章：可视化、导入、表链接和创建字段 涵盖标准Power BI可视化及最佳实践，展示如何将案例研究导入Power BI，通过视频介绍Power BI查询，创建案例研究的新字段，以及链接表格的操作。 第五章：DAX和M语言 讨论Power BI中的两种语言：M语言和DAX。介绍M语言的Power Query用法及其界面，阐明M语言和DAX之间的区别，以及各自的使用场景。 第六章：M语言计算 该章节讲解Power Query和M语言的要点，以及M语言语法。展示一些M语言函数并通过视频演示使用M语言进行案例计算。 第七章：DAX计算 讨论DAX的定义、要点和重要性，涵盖度量值、列、表和行级安全性的DAX计算。通过视频展示DAX函数和语句的实际应用。 第八章：基础统计与可视化 讲解探索性数据分析（EDA）中的统计函数，包括集中趋势和离散程度的度量，及其形状属性（峰度和偏度）。提供Power BI标准可视化的实际例子，并讲解可视化的格式化。 第九章：使用切片器进行比较分析 通过视频展示BRICS国家（巴西、俄罗斯、印度、中国和南非）的GDP增长比较分析， illustrating通过选择1960至2020年之间任意年份的GDP人均箱线图进行对比分析，并使用切片器实现线图、箱线图和散点可视化。 本课程旨在让学生掌握数据分析的实用技能，理解编程与数据可视化的结合，为未来的职业生涯打下坚实基础。
This is the course that will help you walk right into a workplace as a data analyst with some knowledge of programming and working with business intelligence platforms specifically power BI from Microsoft Office. This course has a very practical angle with the theoretical knowledge necessary to become a data analyst hitting the ground running. This course covers some aspects of EXCEL and the programming language VBA which is software packages supplied by Microsoft. Power Business Intelligence (BI) which is free software from Microsoft and helps with data mining, process analysis, performance benchmarking, and descriptive analytics resulting in an increased competitive advantage is taught in this course. also provided for free by Microsoft. You will learn how to populate excel with data from the web and then write a program in VBA to pre-process the data for importing it into a power BI application. The two languages namely M-language and DAX in Power BI are discussed and the differences are pointed out. The case study which includes GDP (Gross Domestic Product) of most countries in the world with data from 1960 to 2020 is used throughout to practically apply all the concepts that are taught. Visuals including the slicer are taught in order to compare different countries with each other. To demonstrate individual as well as comparative analyses the BRICS (Brazil, Russia, India, China and South Africa) are used. The course is divided and presented in 9 chapters. Below a brief description of each chapter.CHAPTER 1: EXCEL AND VBA BASICSThis chapter will cover the concepts, principles, and terminology of programming languages. What is a syntax and an expression as well as how to develop program solving skills are discussed. A quick overview of the programming language of Microsoft Excel called Visual Basic for Applications (VBA) including declaring variables, message and input boxes, iterative loops, popular statements and benefits are also covered. Data analytics and the different types are also taught. How to make the developer tab visible is explained in this chapter.CHAPTER 2: IMPORTING DATA AND USING VBA FOR PRE-PROCESSINGThe importing of data into EXCEL from a webpage, that will then be used throughout the course to analyse and present the data, is demonstrated. The programming language VBA, with an ActiveX command box, is used to prepare the data in the correct format for importing into the Power BI application of Microsoft. The VBA program makes use of variable declaration, a message box, arrays and iterative loops. The case study using GDP (Gross Domestic Product which is a country's total economic output) and population for more than 266 countries from 1960 to 2020 obtained from the world bank is introduced.CHAPTER 3: POWER BI WHERE, WHY AND WHENChapter 3 discusses what is business intelligence (BI), where and why it is used. BI strategies, tools, techniques, trends, software and systems are covered. The software Microsoft power BI parts, concepts and dashboard with its features are discussed. The power BI report, data and model views are covered.CHAPTER 4: VISUALS, IMPORT, LINKING OF TABLES AND CREATING FIELDSStandard Power BI visuals and best practices are covered. How to import the case study into power BI is shown in a video. The power BI query is introduced in a video where new fields for the case study are created using the power query editor and M-language. How to link tables are demonstrated.CHAPTER 5: DAX AND THE M-LANGUAGEThe two languages of Power BI namely the M-language and DAX are discussed. The power query used for the M-language is shown along with its interface. The differences between the M language and DAX are pointed out as well as when to use M, and when do I use DAX.CHAPTER 6: M-LANGUAGE CALCULATIONSThe key points about power query and the M-Language as well as the M-language syntax is discussed in this chapter. Some of the M-language functions are covered. Calculations using the M-language for the case study is demonstrated in a video.CHAPTER 7: DAX CALCULATIONSWhat DAX is, its key points and importance is discussed. DAX calculations for measures, columns, tables and row-level security is covered. DAX functions and statements are demonstrated. DAX calculations using Case study is done through a video.CHAPTER 8: BASIC STATISTICS AND VISUALIZATIONSExploratory data analysis (EDA) statistical functions including measures of central tendencies and dispersion along with shape properties kurtosis and skewness are discussed. Practical examples of the standard visualizations in power BI are given along with the formatting of the visuals.CHAPTER 9: COMPARATIVE ANALYSES USING THE SLICERGDP growth comparative analyses of BRICS countries (Brazil, Russia, India, China, South Africa) is demonstrated through videos. Comparisons for BRICS countries using box plots on GDP per capita is illustrated for any chosen year from 1960 to 2020. The line graphs, boxplots and scatter visualizations are all done using a slicer for choosing different countries or years.
