Microsoft System Center Reporting实用指南：40个实战技巧

需积分: 10 159 浏览量更新于2024-07-21 收藏 15.4MB PDF 举报

身份认证购VIP最低享 7 折!

30元优惠券

资源详情

资源推荐

iii

Table of Contents

Chapter 8: Creating System Center Advanced Reports 239

Introduction 239

Creating dashboards from basic reports 240

Working with drillthrough reports 252

Working with shared datasets and parameters 258

Analyzing Chargeback reports using System Center 2012 R2 data 265

Chapter 9: Using Power BI to Analyze and Visualize System

Center Data 277

Introduction 277

Conguring Microsoft Excel for System Center data analysis 278

Connecting to System Center data sources with Power Query 283

Creating the data model with PowerPivot 298

Visualizing the analysis with Power View and Power Maps 305

Using Microsoft Cloud services to share and visualize System Center data 309

Appendix: Useful Websites, Chapter Code,

and Community Resources 313

Authors' community blogs 313

Useful community blogs 314

Websites for SQL and reporting 314

Online wikis and curations 315

Index 325

Preface

The System Center product provides you with the best IT systems management and reporting

capabilities. The various components of this product continue to provide great value in all

areas of management and monitoring. Each of the components has one or more data storing

repositories. These data repositories hold valuable strategic information that can assist an

organization in transforming its IT business unit into a strategic enabler.

The database (repository) technology of the System Center product is Microsoft SQL Server.

There is a vast array of information on the Internet on how to query and report on Microsoft SQL

databases. The skill set required for the level of querying and reporting on these databases is

normally aligned to Database Administrators (DBAs) and Business Intelligence (BI) specialists.

The DBAs and BI specialists use various tools to create business-valued reports based on the

data stored in these Microsoft SQL databases.

The challenge DBAs and BI experts face with System Center reporting is a lack of insight

into how the data is structured, and more importantly, a lack of deeper understanding of

the products responsible for the input data. Conversely, in the majority of cases, the System

Center product's Subject Matter Experts (SMEs) do not have the same level of competency as

the DBAs and BI experts in creating and enhancing reports.

The aim of this book is to enhance the competency of System Center SMEs in the areas of

reporting. There are a number of books on querying Microsoft SQL databases and generating

business-value reports. However, those books do not focus on System Center. Also, all

the books on System Center's components dedicate a reporting chapter to that specic

component of the book's focus.

Microsoft System Center Reporting Cookbook, provides a one-stop shop for how to plan, create,

and manage reports for all the components of the System Center product.

This book is written in the Packt Publishing style, which provides you with independent,

task-oriented steps to achieve specic reporting objectives. We recommend that you read

the rst three chapters as primers for subsequent chapters. This book may be read in the

order of your interest, but wherever relevant, we've referred to the dependent recipes in

other chapters.

Preface

What this book covers

Chapter 1, Understanding the Goals of Reporting, discusses the building blocks of your

reporting framework and how to plan for business-valued reports.

Chapter 2, Planning System Center Report Design, covers the internals of System Center

reporting database structures, which you must understand in order to create credible and

powerful reports. This chapter also includes an introductory recipe to SQL queries.

Chapter 3, Unpacking System Center Report Building Tools, discusses the common

report-creating tools available for System Center administrators and Business Intelligence

power users.

Chapter 4, Creating Reports for System Center Conguration Manager, provides tasks for

System Center administrators, who can create System Center Conguration Manager reports

using the Report Builder tool.

Chapter 5, Creating Reports for SCOM and SCVMM, demonstrates how to create System

Center Operations and Data Protection Manager reports, with data available from the

Operations Manager databases.

Chapter 6, Creating Reports for System Center Data Protection Manager, shows you how to

create data-driven reports for System Center Data Protection Manager.

Chapter 7, Creating Reports for System Center Service Manager and Orchestrator, illustrates

how to create service management and automation activity reports using data from System

Center Service Manager and Orchestrator.

Chapter 8, Creating System Center Advanced Reports, shows you recipes that build on and

enhance the reports from previous recipes in this book. These recipes delve into advanced

reporting techniques and combined data source reporting.

Chapter 9, Using Power BI to Analyze and Visualize System Center Data, introduces the Power

Business Intelligence (Power BI) options available for you from Microsoft. These recipes

provide steps for analyzing and visualizing the System Center data using the Microsoft Excel

Power BI add-ons, and introduce the cloud Power BI versions available for you.

Appendix, Useful Websites, Chapter Code, and Community Contributions, lists some of the

sites that provide ready-made solutions and extensive, real-world, and dynamic content on

reporting. Microsoft SQL Server-based reporting, similar to most Microsoft product areas,

has an extended solutions partner community. There is an extensive and active support base

on the Web. This appendix also provides you with the SQL and XML code referred to in the

relevant chapters.

剩余357页未读，继续阅读

ramissue

粉丝: 354
资源: 1487

Microsoft System Center Reporting实用指南：40个实战技巧

Microsoft.System.Center.1511.Endpoint.Protection.Cookbook

openscenegraph.3.cookbook

vulkan cookbook.pdf

boost.asio c++ network programming cookbook.pdf

给我使用python的ocr扣除这张图片的文字，图片的地址是:https://download.ydstatic.com/ead/zhiyun/guanwang_cdn_2019/images/p-ocr/cookbook100K.jpg的文字，把结果发给我就行

www.capache/hive/cookbook

apache maven cookbook 下载

docker cookbook: over 100 practical and in...

vulkan cookbook下载

帮我找一个python比较好的学习教程

python logging库的学习资料

pythoncookbook

用Java写一个图书借阅管理系统

帮我找一个学习Python的博客

有哪些untiy游戏相关的书籍？

biopython教程与手册

Python的参考文献

pandas cookbook中文版

Linux服务搭建参考文献

elasticsearch 5.0 cookbook

最新资源