|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-data-warehousing-and-analysis-with-microsoft-bi-tools/
课程评论：没有评论
Coursera课程《Microsoft BI & Power BI中的数据仓库与可视化》为您提供了全面的数据处理和可视化技能培训。 **数据仓库部分**，您将学习从数据提取、清洗到加载到SQL数据库仓库的关键技能，这些技能在数据分析领域至关重要。课程将指导您如何利用Microsoft Excel进行数据清洗，然后使用Microsoft SQL Server存储数据。您将掌握SQL Server Integration Services (SSIS)，这是Microsoft商业智能工具套件之一，用于执行ETL（提取、转换、加载）过程，并学习一种能节省大量时间并减少ETL过程中潜在错误的高效方法。此外，您还将学习使用SQL Server Reporting Services (SSRS) 结合SQL查询创建业务报告和进行数据分析。本课程强调实践，通过真实项目和多样化的业务场景，让您在实践中获得知识，巩固记忆。 **Power BI部分**，您将学习将原始数据转化为富有洞察力的图表和图形，以支持决策制定，这是数据科学中的一项关键分析技能。课程首先会介绍数据可视化的概念及其重要性，然后深入讲解Power BI各项服务及其用途。在熟悉这些服务后，您将学习安装和导航Power BI Desktop。接着，您将掌握Power BI Editor的高级功能，用于数据准备和清洗，包括数据集合的追加和合并。随后，您将学习如何利用Power BI强大的功能创建有见地的图表，并根据业务需求进行数据过滤。您还将学习创建度量值和计算列以进行个性化数据分析，并初步了解DAX语言，学习如何根据需求创建新表和列。最后，您将学习如何将项目部署到云端，并与其他用户协同工作，以及如何使用Power BI Pro界面创建、编辑和共享报告。
Data WarehousingLearning how to extract, clean and load data into a SQL database warehouse are highly required skills for data analysis field. You will learn in this course how to use Microsoft Excel to clean your data before loading them into a Microsoft SQL Server database. You will learn how to use SQL Server Integration Services (SSIS) which is one of Microsoft Business Intelligence tools to perform ETL process. You will learn a simple technique that save you a lot of time and help to avoid many possible errors during the ETL process. You will learn also how to use SQL Server Reporting Services (SSRS) to create business reports and data analysis with SQL queries. This course is designed to be more practical by putting your hands on real projects with diverse business scenarios to learn by practice. Learning via practice is the best way to get knowledge stuck in your mind because it is similar to acquire experience through work. Power BIConverting raw data to insightful diagrams and charts to make informative decisions is a crucial analytical skill in data science. You will learn in this course how to create insightful and powerful charts and perform data analysis. First, you will understand data visualization, and why data visualization. After that you will understand Power BI services and the use of each of them. After you became familiar with these services you will learn how to install and navigate in Power BI Desktop. After that, you will learn how to use the advanced functions in Power BI Editor in data preparation and cleaning. You will learn appending and merging datasets to create one dataset. After that you will learn how to turn your datasets into insightful charts using many powerful functions. You will learn how to filter your data according to your business requirements. You will learn how to create measures and calculated columns for your own data analysis. You will have an introduction to DAX language where you can learn how to create new tables and columns according to your needs. After that you will learn how to take your projects in the Cloud where you can work with other users. You will learn how use Power BI Pro interface to create, edit and share reports with others.
