|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analysis-business-intelligence-python-pandas-sql/
课程评论：没有评论
课程名称：使用Python和SQL进行数据分析与商业智能 课程概述： 在商业环境中，理解、利用和处理数据已不再是少数高薪分析师的专属技能，而是许多岗位的基本要求。本课程旨在打消对数据分析的恐惧，帮助学员熟悉并掌握一系列旨在让数据分析变得更加简易的工具。在这门高价值的四课程工具包中，我们将详细探讨Excel、Python和Power BI这三种工具。尽管单独使用Excel、Python和Power BI它们各有其优势，但同时学习这三者将使您更深入地理解如何进行复杂的数据分析。 该工具包主要针对中级Excel用户，尤其是那些对Python和Power BI较为陌生的学习者。所有课程包括实践练习，帮助您将所学知识应用于实际。 SQL功能： - 执行数据库查询 - 从数据库中检索数据 - 向数据库中插入记录 - 更新数据库中的记录 - 从数据库中删除记录 - 创建新数据库 - 在数据库中创建新表 - 创建数据库中的存储过程 - 创建数据库视图 - 设置表、过程和视图的权限 Power BI介绍： - Power BI是什么，为什么要使用它？ - 如何将CSV和Excel文件导入Power BI桌面版 - 使用合并查询从其他查询中获取数据 - 创建数据模型中不同表之间的关系 - DAX语言的使用，包括COUTROWS、CALCULATE和SAMEPERIODLASTYEAR函数 - 使用卡片可视化创建汇总信息 - 使用其他可视化工具，如聚合柱状图、地图和趋势图 - 使用切片器过滤报告 - 快速一致地格式化报告主题 - 编辑可视化之间的交互，按可视化、页面和报告级别进行过滤 通过本课程，学员将掌握利用Python和SQL进行数据分析的关键技能，并能够有效使用Power BI进行商业智能分析。
In business, being able to understand, harness, and use data is no longer a skill reserved for a handful of well-paid analysts. It's becoming an essential part of many roles.If that sounds daunting, don't worry. There is a growing set of tools designed to make data analysis accessible to everyone, in this huge-value, four-course Data Analysts Toolbox bundle we look in detail at three of those tools: Excel, Python, and Power BI.In isolation Excel, Python, and Power BI are useful and powerful. Learn all three and you are well on your way to gaining a much deeper understanding of how to perform complex data analysis.This Data Analysts Toolbox bundle is aimed at intermediate Excel users who are new to Python and Power BI. All courses include practice exercises so you can put into practice exactly what you learn.What Can SQL do?SQL can execute queries against a databaseSQL can retrieve data from a databaseSQL can insert records into a databaseSQL can update records in a databaseSQL can delete records from a databaseSQL can create new databasesSQL can create new tables in a databaseSQL can create stored procedures in a databaseSQL can create views in a databaseSQL can set permissions on tables, procedures, and viewsPower BIWhat is Power BI and why you should be using it?To import CSV and Excel files into Power BI Desktop.How to use Merge Queries to fetch data from other queries.How to create relationships between the different tables of the data model.All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions.All about using the card visual to create summary information.How to use other visuals such as clustered column charts, maps, and trend graphs.How to use Slicers to filter your reports.How to use themes to format your reports quickly and consistently.How to edit the interactions between your visualizations and filter at visualization, page, and report level.
