|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/diydashboards/
课程评论：没有评论
**Coursera 课程总结：使用 Excel 打造销售与运营规划 (S&OP) / 综合业务规划 (IBP) 仪表盘和移动应用** 本课程专注于教授学员如何利用 Excel 的标准功能，无需编写任何代码，即可创建功能强大的销售与运营规划 (S&OP) / 综合业务规划 (IBP) 仪表盘和移动应用程序。 **核心内容：** * **Excel 仪表盘构建：** 课程将教授如何使用 Excel 内置工具，如数据透视表 (Pivot Tables)、数据透视图 (Pivot Charts)、图标 (Icons) 和迷你图 (Sparklines)，来构建直观且信息丰富的 S&OP/IBP 仪表盘。所有解决方案均不依赖任何 Visual Basic 或宏。 * **无代码移动应用开发：** 课程的一大亮点是利用 Claris FileMaker（Apple 子公司）发布的免费 iOS 数据库 FileMaker Go。通过导入简单的电子表格，学员可以自动生成可在 iPhone 和 iPad 上原生运行（在线或离线）的业务应用程序。 * **广泛的应用与部署：** 生成的应用程序可以分发给任意数量的用户和 iOS 设备。更高级的用户甚至可以托管在线版本，支持大多数浏览器（包括 Android），并能与 SQL、SAP 等系统集成。Claris Connect 还可以通过简单的流程连接到 API。 **目标学员：** 本课程主要面向普通 Excel 用户，旨在帮助他们掌握无需学习编程即可创建 S&OP/IBP 仪表盘和移动应用的方法。虽然高级功能（如多用户技术、与 SAP、SQL 集成）超出了本课程范围，但 BI 专家、数据分析师、数据科学家、程序员和应用程序开发者也可通过本课程来巩固其在多维度建模和分析方面的核心技能。 **课程优势：** * **零编码门槛：** 彻底摆脱代码编写的困扰，让 Excel 用户也能轻松开发。 * **Excel 原生工具：** 仅使用 Excel 的标准功能，降低学习成本和技术依赖。 * **创新的移动应用解决方案：** 利用 FileMaker Go 轻松将数据转化为可部署的移动业务应用。 * **实用价值高：** 直接应用于 S&OP/IBP 规划，提升业务效率和决策能力。 报名参加本课程，立即开启无需编码的仪表盘和 iPhone 应用创建之旅！
Build an S & OP/IBP dashboards using only ExcelBuild Dashboards & Business Apps without writing a single line of code, all you need is Excel.In a world first we have designed a training course that helps the average Excel user create an Excel dashboard and an iPhone app without having to write a single line of code.When we build the dashboards we only use tools that come standard with Excel - like Pivot Tables, Pivot Charts, Icons and Sparklines (and don't worry there isn't any visual basic or even a single macro in our solution).And here's the best bit … Claris FileMaker (an Apple subsidiary) has released a free database for iOS called "FileMaker Go". It works natively (i.e. online or off-line) on iPhones and iPads.The program you download from the resource section will automatically convert a simple spreadsheet into a sophisticated Business App that works with FileMaker Go. Therefore you will be able to distribute your own apps to as many people and iOS devices as you like.More advanced users can even host an online version which will work with most browsers including Android. The advanced version can integrate with everything from SQL to SAP and Claris has just released Claris Connect, which can connect your app to API's via a simple workflow. These advanced (multi-user) techniques are beyond the scope of this training course however advanced users, BI specialists, data analysts, data scientists, programmers and app developers may still want to take this course to refine core skills in multidimensional modelling and analysis.However, this training course is squarely aimed at the typical Excel user who wants a simple method for building their own Dashboards and Business Apps.Sign up today to start creating your own Dashboards and iPhone apps without learning a single line of code.
