|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/business-intelligence-analyst-power-bi-tableau/
课程评论：没有评论
课程名称：商业智能分析师 - Power BI与Tableau 课程概述：商业智能（BI）帮助组织分析历史和当前数据，从而快速发现可行的见解，以便进行战略决策。商业智能工具通过处理来自多个源的大型数据集，并以易于理解和共享的视觉格式呈现发现，使这一过程成为可能。商业智能系统结合了数据收集、数据存储、知识管理和数据分析，以评估和转化复杂数据为有意义、可操作的信息，从而支持更有效的战略、战术和运营见解及决策。商业智能环境由多种技术、应用、流程、策略、产品和技术架构组成，这些都旨在促进内部和外部商业信息的收集、分析、呈现与传播。 商业智能的工作原理有四个关键步骤，它们将原始数据转化为易于理解的见解，以供组织内部的每个人使用。前三步——数据收集、分析和可视化——为最终决策步骤奠定基础。在使用BI之前，企业需要手动进行大部分分析，而BI工具自动化了许多流程，节省了时间和精力。 步骤1：从多个来源收集和转化数据 商业智能工具通常采用提取、转换和加载（ETL）的方法，从多个来源聚合结构化和非结构化数据。数据经过转换和重建后，存储在一个集中位置，以便应用程序可以轻松将其作为一个综合数据集进行分析和查询。 步骤2：发现趋势和不一致性 数据挖掘或数据发现通常使用自动化技术快速分析数据，以找到提供当前业务状态见解的模式和异常值。BI工具通常具有多种数据建模和分析方法，包括探索性、描述性、统计性和预测性分析，进一步探索数据、预测趋势并提出建议。 步骤3：使用数据可视化呈现发现 商业智能报告使用数据可视化使发现更容易理解和共享。报告方法包括交互式数据仪表板、图表、图形和地图，帮助用户看到当前业务的状况。 步骤4：实时采取见解行动 将当前和历史数据与业务活动相结合，为企业快速从见解转向行动提供了能力。商业智能支持实时调整和长期战略变化，消除低效、适应市场变化、纠正供应问题和解决客户问题。 Power BI是一个软件服务、应用程序和连接器的集合，能够将不相关的数据源转化为一致、视觉上沉浸和交互式的见解。无论数据是Excel电子表格，还是一系列基于云的和本地混合的数据仓库，Power BI都能轻松连接数据源，直观呈现重要信息，并与任何人或所有人共享。Power BI由多个相辅相成的元素组成，基本包括三个部分：Power BI Desktop（Windows桌面应用程序）、Power BI服务（在线SaaS服务）和适用于Windows、iOS和Android设备的Power BI移动应用。 Tableau是一款用于报告和分析大量数据的数据可视化和商业智能工具。它帮助用户创建不同的图表、图形、地图、仪表板和故事，以可视化和分析数据，辅助企业决策。Tableau可以连接多个数据源，使用户能够通过联合和混合不同数据集创建报告。
Business intelligence (BI) helps organizations analyse historical and current data, so they can quickly uncover actionable insights for making strategic decisions. Business intelligence tools make this possible by processing large data sets across multiple sources and presenting findings in visual formats that are easy to understand and share.Business intelligence systems combine data gathering, data storage, and knowledge management with data analysis to evaluate and transform complex data into meaningful, actionable information, which can be used to support more effective strategic, tactical, and operational insights and decision-making. Business intelligence environments consist of a variety of technologies, applications, processes, strategies, products, and technical architectures used to enable the collection, analysis, presentation, and dissemination of internal and external business information.How business intelligence worksThere are four keys steps that business intelligence follows to transform raw data into easy-to-digest insights for everyone in the organization to use. The first three-data collection, analysis, and visualization-set the stage for the final decision-making step. Before using BI, businesses had to do much of their analysis manually, but BI tools automate many of the processes and save companies time and effort.Step 1: Collect and transform data from multiple sourcesBusiness intelligence tools typically use the extract, transform, and load (ETL) method to aggregate structured and unstructured data from multiple sources. This data is then transformed and remodelled before being stored in a central location, so applications can easily analyse and query it as one comprehensive data set.Step 2: Uncover trends and inconsistenciesData mining, or data discovery, typically uses automation to quickly analyse data to find patterns and outliers which provide insight into the current state of business. BI tools often feature several types of data modelling and analytics-including exploratory, descriptive, statistical, and predictive-that further explore data, predict trends, and make recommendations.Step 3: Use data visualization to present findingsBusiness intelligence reporting uses data visualizations to make findings easier to understand and share. Reporting methods include interactive data dashboards, charts, graphs, and maps that help users see what's going on in the business right now.Step 4: Take action on insights in real timeViewing current and historical data in context with business activities gives companies the ability to quickly move from insights to action. Business intelligence enables real time adjustments and long-term strategic changes that eliminate inefficiencies, adapt to market shifts, correct supply problems, and solve customer issues.Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet,or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources,visualize and discover what's important, and share that with anyone or everyone you want.Power BI consists of several elements that all work together, starting with these three basics:A Windows desktop application called Power BI Desktop.An online SaaS (Software as a Service) service called the Power BI service.Power BI mobile apps for Windows, iOS, and Android devices.Tableau is a data visualization and business intelligence tool used for reporting and analysing vast volumes of data.It helps users create different charts, graphs, maps, dashboards, and stories for visualizing and analysing data, to help in making business decisions.It can connect to several data sources. Tableau enables users to create reports by joining and blending different datasets
