|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analysis-business-intelligence-sql-mysql-power-bi/
课程评论：没有评论
课程名称：数据分析与商业智能：SQL MySQL Power BI 课程概述： 数据分析是一个检查、清理、转化和建模数据的过程，旨在发现有用的信息、形成结论并支持决策。数据分析涵盖多种技术，适用于商业、科学和社会科学等多个领域。在当今商业环境中，数据分析可以使决策更加科学，帮助企业更有效地运营。 商业智能（BI）结合商业分析、数据挖掘、数据可视化、数据工具和基础设施以及最佳实践，帮助组织做出更加数据驱动的决策。现代商业智能的标志是全面了解组织的数据，并利用这些数据推动变革、消除低效、快速适应市场或供应链变化。 SQL是访问和操作数据库的标准语言，代表结构化查询语言（Structured Query Language）。SQL的主要功能包括执行数据库查询、检索数据、插入、更新和删除记录、创建新数据库和表、创建存储过程和视图，还可以设置表、过程和视图的权限。 MySQL是一个由Oracle开发、支持和分发的开源数据库管理系统，具有快速和轻量级的特性，适合与其他应用程序并行运行。PostgreSQL是一个强大且开源的对象关系数据库系统，使用和扩展SQL语言，适合处理复杂数据工作负载。 在数据分析的过程中，Microsoft Excel是一个顶级工具，其中的透视表是非常受欢迎的分析工具。Power BI则是微软的互动数据可视化和分析工具，广泛用于商业智能（BI）领域。Tableau是一个强大且快速的数据可视化工具，能够将原始数据简化为易于理解的格式。 在本课程中，学员将使用MySQL、SQL、Microsoft SQL、PostgreSQL、Excel、Power BI和Tableau进行数据分析和商业智能的实践。
Data analysis is a process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information,informing conclusions, and supporting decision-making. Data analysis has multiple facets and approaches, encompassing diverse techniques under a variety of names, and is used in different business, science, and social science domains.In today's business world, data analysis plays a role in making decisions more scientific and helping businesses operate more effectively.Business intelligence (BI) combines business analytics, data mining, data visualization, data tools and infrastructure, and best practices to help organisations to make more data-driven decisions. In practice, you know you've got modern business intelligence when you have a comprehensive view of your organisation's data and use that data to drive change,eliminate inefficiencies and quickly adapt to market or supply changes.SQL is a standard language for accessing and manipulating databases.What is SQL?SQL stands for Structured Query LanguageSQL lets you access and manipulate databasesSQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987What Can SQL do?SQL can execute queries against a databaseSQL can retrieve data from a databaseSQL can insert records in 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 viewsMicrosoft SQL Server is a relational database management system developed by Microsoft. Transact-SQL (T-SQL) is Microsoft's proprietary extension to the SQL (Structured Query Language) used to interact with relational databasesMySQL is a DBMS, or database management system. It is developed, supported and distributed by Oracle, but since it is open-source it is freely available to anyone under the GPL. MySQL databases are relational, meaning that the data is split up between tables. MySQL is very fast and lightweight so you can run it alongside your other applications on a desktop or laptop. It can also be scaled up to take advantage of all the CPU power and memory available on a dedicated machine.PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads.Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool. Power BI is Microsoft's interactive data visualization and analytics tool for business intelligence (BI).Tableau is a powerful and fastest data visualization tool used in the Business Intelligence Industry. It helps in simplifying raw data in a very easily understandable format. In this course we will be performing data analysis and business intelligence using MySQL, SQL, Microsoft SQL ,PostgreSQL , Excel, Power BI and Tableau.
