Creating Excel Power Pivot And Power View Dashboards Год выпуска: 2014 Производитель: Lynda Сайт производителя: lynda.com Автор: Ron Davis Продолжительность: 1:12 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: All it takes to point your business in the right direction are some strategic insights from your data. In this course, author Ron Davis uses the Power Pivot and Power View plugins to build robust dashboards for analyzing key metrics in Excel—all in just over an hour. First, learn some dashboard design guidelines—such as understanding your audience and identifying necessary metrics—before getting started. Then Ron walks you through importing data, setting up calculated fields and columns, creating key performance indicators (KPIs), and building the PivotTables and PivotCharts for the dashboards. Last, find out how to add charts and eye-catching visuals with Power View, in order to make your dashboards easily understood. Использование Power Pivot в Экселе.
Содержание
Introduction Welcome Demonstration of the dashboard we will be building Building an environment Using the exercise files 1. Sourcing and Enhancing the Data Model Dashboard design guidelines Importing data Relating data Creating calculated fields and columns Creating key performance indicators (KPIs) 2. Creating the Excel Power Pivot Dashboard Add a linked table to the data model Create the PivotTables Create the PivotCharts Create the PivotTables and charts for the customer KPI sheet 3. Completing Your Dashboard Adding Power View visualizations Formatting with color Reviewing the completed dashboard Conclusion Next steps
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum