|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bi-desktop-masterclass-data-analysis-for-everyone/
课程评论：没有评论
课程名称：Power BI Desktop 大师班 - 面向所有人的数据分析 课程概述： Power BI Desktop 是一个独立的软件包，结合了 Excel 的强大功能（Power Pivot、Power Query 和 Power View）。通过 Power BI，用户能够从不同的数据库、文件和网络服务中查找、获取、转换和分析数据，借助可视化工具自动理解并修复数据质量和格式问题。与 BI 服务结合后，这些数据查询报告和仪表板可以随时分享和查看。这一自助式商业智能系统使普通公司也能享受到数据分析的便利。 课程总结： Power BI Desktop 将数据分析和商业智能的世界带入普通企业。通过连接来自多个来源的数据并进行转换或建模，用户能够以前所未有的方式查看和分享商业洞察。作为一套自助式系统，用户无需 IT 部门的帮助即可完成数据转换或建模。您将学习如何收集数据、转换数据和建模，以便在创建可视化之前解释数据，并与您的组织分享有价值的见解。 课程内容： 在第一部分，您将学习如何下载和安装 Power BI Desktop，并进行一次引导式的操作演示。第二部分将重点介绍如何从多个来源（内部和外部）获取数据，连接不同类型的文件、文件夹和在线数据，设置数据查询并将数据转换为可用格式。在第三部分，您将学习数据建模，建立关系、使用 DAX 创建计算列和度量值、使用计算表以及创建层级。此外，还将介绍一些时间智能功能。在第四部分，您将学习数据可视化，使用不同的图表（如柱状图、散点图、切片器、预测等）进行数据展示。同时，您将接触 Custom Visuals。课程不仅限于数值数据，您还将学习如何结合 Power BI 和 Microsoft Cognitive Services 对文本数据进行情感分析。
Updated May 2017Power BI Desktop is a combination of Excels Power Features (Power Pivot, Power Query and Power View) all in a standalone package. Using Power BI, you can find, get, transform, analyse and Combine data from disparate databases, files, and web services with visual tools that help you understand and fix data quality and formatting issues automatically. Combined with BI Service, these data queries reports and dashboard can be shared and viewed on the go. This self-service business intelligence systems brings data analytics to the ordinary company. COURSE SUMMARY Power BI Desktop brings the world of data analytics and business intelligence to the ordinary business. By connecting to data from multiple sources and transforming or modelling that data, you can view and share insights to your business like never before. Being a self-service system, means you don't need the help of and IT department to transform or model the data. LEARN TO GATHER DATA, TRANSFORM DATA AND MODEL DATA BEFORE YOU CREATE VISUALIZATIONS TO EXPLAIN THE DATA AND SHARE VALUABLE INSIGHTS WITH YOUR ORGANISATION. CONTENTS AND OVERVIEW In section 1 you will learn how to download and install Power BI Desktop and you will also be given a guided tour. In section 2 of this course we will look at getting data from multiple sources, both internal and external. Connecting to different types of files of data, Folders or data and online data. Setting up data queries and transforming the data into a format that can be used. In section 3 of this course we will look at Data modelling, setting up relationships, creating calculated columns and measures using DAX, using calculated tables and creating hierarchy. In addition to this we will also look at some time intelligence functions. In section 4 of this course we will look at Data visualization. We will go through the use of different charts,Column charts, scatter charts, slicer's, forecasting and other visualizations. In addition to the standard visualizations you will also be introduced to Custom Visuals.The use of Power BI is not just for numerical data, so in this course you will also learn how to use Power BI and Microsoft Cognitive Services to carry out a sentiment analysis on Text data.
