|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/build-microsoft-power-bi-projects/
课程评论：没有评论
课程名称：Power BI 培训营：构建真实世界的 Power BI 项目 课程概述：本课程旨在教导学员如何使用 Microsoft 的 Power BI 平台，结合数据分析和商业智能的基本工具。根据 Gartner 的报告，Microsoft 连续第十三年被评为分析和商业智能平台的领导者。Power BI 使用户能够轻松整合数据，提高报告的可访问性、组织性和可视化效果。它支持超过 70 种连接器，允许企业从多种流行的云端数据源（包括 Azure、DropBox、Google Analytics、OneDrive 和 SalesForce）以及 Excel 表格、CSV 文件和本地存储的数据如 SQL 数据库中加载数据。 该平台的内置连接使用户能够在几秒钟内加载预构建的 Power BI 仪表板，并在几分钟内进行高级数据分析。Power BI 的拖放界面取消了编码或复制粘贴的需求，用户可以轻松开始自己的数据报告。其 Power Pivot 数据建模引擎可以高效压缩数据库，并确保数据加载至内存中，提升速度。即使是 1GB 的数据库，经过压缩后通常也仅为 50-200MB。 Power BI 设计用于处理超过 1 亿条记录的数据表，且能够实现自动增量刷新，确保用户的数据始终保持最新，进一步简化可视化报告的过程。该平台提供多种预制的数据图表，包括条形图、柱形图、折线图、地图、矩阵、饼图、散点图、表格和瀑布图，每种图表都具备自定义选项，以提升展示效果。 此外，用户还可以使用由开发者或内部团队制作并与 Power BI 社区共享的免费自定义图形，从而以最佳方式展示数据。Power BI 社区还提供丰富复杂的图形，诸如子弹图、相关图、决策树、热图和小型图等，用户可以通过 Microsoft 和 AppSource 市场获取这些自定义视觉效果文件。如果希望以独特的方式展示数据，Power BI 也允许用户轻松设计自己的可视化效果，提升个人设计技能。 本课程将为学员提供使用 Power BI 的全面介绍，使其能够在真实项目中应用所学知识。
Gartner has ranked Microsoft a Leader in the Gartner 2020 Magic Quadrant for Analytics and Business Intelligence Platforms for the thirteenth year in a row.Power BI makes it incredibly simple to consolidate your data into a single location for improved accessibility, organisation, and visibility in your reporting efforts. It supports up to 70+ connectors, allowing businesses to load data from a wide range of popular cloud-based sources, including Azure (Azure Data Warehouse), DropBox, Google Analytics, OneDrive, and SalesForce, as well as Excel spreadsheets, CSV files, and data stored on-premises, such as SQL Database.You can load pre-built Power BI dashboards in seconds and execute advanced data analysis in minutes with these built-in connections. You can always further customise aspects to your preference, or have your data professionals start by importing your datasets and creating your own dashboards and reports.Power BI's drag-and-drop interface also eliminates the need to code or copy and paste anything to get started, and Power BI can combine various files (like Excel spreadsheets) and analyse the combined data in a single report.Power BI's Power Pivot data modelling engine (shared with Excel) is a highly performant columnar database that compresses databases and ensures they load fully into memory for the greatest possible speed.It's fairly uncommon for your Power BI Workbook (.PBIX file) to be much less than your original data sets - in fact, 1GB databases are typically compressed down to roughly 50 - 200MB in size.While Excel begins to slow down when dealing with huge models, Power BI is designed to handle tables with more than 100 million records without breaking a sweat. Power BI also uses automatic, incremental refreshes to ensure data is constantly up to date, which is a great benefit that further simplifies visual reporting for end users.In summary, Power BI effectively condenses and loads millions of records into memory, allowing end-users to have a faster and more responsive data analysis experience.Power BI has a multitude of pre-packaged basic data graphics to use in your interactive reports, including bar, column, line, map, matrix, pie charts, scatter, table, and waterfall - each with its own set of customisation options for improved presentation and usefulness.However, to add a personal touch, you may utilise free custom graphics produced by developers (or in-house) and shared with the Power BI community to display your data in the best way possible.There's a remarkable selection of rich and complicated graphics to take use of, including bullet graphs, correlation plots, decision trees, heatmaps, sparklines, and more, with custom visual files accessible from both Microsoft and the community over at the AppSource Marketplace.If you want to show your data in a unique way, Power BI allows you to easily design your own visualisations rather than being limited to the standard options. It's also really beneficial to observe and apply what the larger Power BI community is doing to improve your own design skills.
