High Impact Data Visualization with Power View, Power Map, and Power BI
High Impact Data Visualization with Power View, Power Map, and Power BI helps you take business intelligence delivery to a new level that is interactive, engaging, even fun, all while driving commercial success through sound decision-making. Learn to harness the power of Microsoft’s flagship, self-s...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress
2014.
|
| Edición: | 1st ed. 2014. |
| Colección: | Expert's voice in business intelligence.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629650406719 |
Tabla de Contenidos:
- Contents at a Glance; Introduction; Chapter 1: Self-Service Business Intelligence; The Microsoft Self-Service Business Intelligence Solution; The Excel BI Toolkit; Power BI; The Excel BI Toolkit and Power BI; Power Query; PowerPivot; Power View; Power Map; Power BI; Preparing the Self-Service BI Environment; PowerPivot; Power View; Power Query; Power Map; Power BI; Adding a Power BI Site; The Windows Power BI App; Corporate BI or Self-Service BI ?; The Excel Data Model; How This Book Is Designed to Be Read; Discovering Data; Creating a Data Model; Taking Data and Preparing It for Output
- Taking Existing Excel BI and Sharing ItDelivering Geodata; Delivering Excel BI to Mobile Devices; To Learn the Product Suite Following a Real-World Path; The Self-Service Business Intelligence Universe; Conclusion; Chapter 2: Power View and Tables; The Power View Experience; Adding a Power View Sheet to an Excel Workbook; The Power View Interface; The Power View Ribbon; The Field List; Using the Field List; Renaming or Deleting a Power View Report; Tables in Power View; Adding a Table; Deleting a Table; Changing the Table Size and Position; Changing Column Order; Removing Columns from a Table
- Types of DataData and Aggregations; Enhancing Tables; The Design Ribbon; Row Totals; Formatting Columns of Numbers; Default Formatting; Changing Column Widths; Font Sizes in Tables; Copying a Table; Sorting by Column; Table Granularity; Matrix Tables; Row Matrix; Column Matrix; Sorting Data in Matrix Tables; Drilling Through with Matrix Tables; Drilling Down; Drilling Up; Reapplying Matrix Visualization; Drilling Through with Column Hierarchies; Card Visualizations; Card Visualization Styles; Sorting Data in Card-View Tables; Switching Between Table Types; Key Performance Indicators (KPIs)
- ConclusionChapter 3: Filtering Data in Power View; Filters; Hiding and Displaying the Filters Area; View Filters; Adding Filters; The (All) Filter; Clearing Filters; Deleting Filters; Expanding and Collapsing Filters; Subsetting Large Filter Lists; Searching for Specific Elements in a Filter; Clearing a Filter Subset; Filtering with Wildcards; Clearing a Filter Element Search; Filtering Different Data Types; Numeric Data; Range Filter Mode; List Filter Mode; Quickly Excluding Outliers; Date and Time Data; Other Data Types; Multiple Filters; Advanced Filters; Applying an Advanced Filter
- Clearing an Advanced FilterAdvanced Wildcard Filters; Numeric Filters; Date and Time Filters; Complex Filters; Advanced Text Filter Options; Advanced Numeric Filter Options; Advanced Date Filter Options; Visualization-Level Filters; Filter Hierarchy; Filtering Tips; Don't Filter Too Soon; Drill-Down and Filters; Annotate, Annotate, Annotate; Conclusion; Chapter 4: Charts in Power View; A First Chart; Creating a First Chart; Deleting a Chart; Basic Chart Modification; Basic Chart Types; Column Charts; Line Charts; Pie Charts; Essential Chart Adjustments; Resizing Charts; Repositioning Charts
- Sorting Chart Elements
