BI数据分析服务

（CH） 在此阶段，客户已经了解了自身需求，并且已有所需报告功能和关键绩效指标的草稿待办事项。或者，我们可以退一步，开展一次评估研讨会。如有必要，我们将实施所有部分，包括基于 Azure 的 ETL、数据仓库 (DWH) 以及 Power BI 报表和仪表板。目标是实现完全自动化且安全的 ETL，并将数据导入并更新到 Azure DWH。在 Azure DWH 中，数据经过预处理，以便快速准确地进行解读。然后，用户可以通过 Power BI 分析从 Azure DWH 获取的数据，或查看已构建的报表和仪表板。用户还可以构建自己的报表和仪表板。技术方面，我们专注于使用 Microsoft Azure 托管 ETL（数据工厂）和 DWH。这使客户能够受益于可扩展性和安全性，并减少管理工作。用户可以根据公司范围内的限制和准则，使用安全连接从任何地方访问数据。使用 Microsoft Azure，我们还可以扩展 Azure 机器学习的功能，访问数据湖等。

（EN） At this stage the client knows what he/she wants and a draft backlog of needed reporting functionalites and KPIs exists. Alternatively we can take a step back and do an assessment workshop. We implement all parts if necessary including Azure based ETL, Data Warehouse (DWH) as well as Power BI Reports and Dashboards. The target is to have fully automated and secured ETLs, importing and update the data into the Azure DWH. in the Azure DWH the data gets pre-processed to allow fast and correct interpreations. The users then analyse the data via Power BI taken from the Azure DWH or vie already build repost and dashboards. The users will also be enabled to build their own reports and dashboards. Technologywise we focus on Microsoft Azure to host the ETL (Data Factory) and the DWH. This allows the client to benefit from scalability and security as well as it come with less administration. Users can access Data from anywhere using secure connections based on company wide restrictions and guidelines. Using Microsoft Azure we can also extend the functionality towards Azure Machine Learning, access Data Lakes etc