Actions for Business Intelligence with MicroStrategy Cookbook

Email RIS file
Bookmark
Report an Issue

Business Intelligence with MicroStrategy Cookbook

Author
Moraschi, Davide
Published
[Place of publication not identified] : Packt Publishing, 2013.
Physical Description
1 online resource
Access Online

Availability

I Want It
I Want It

Finding items...

Contents
Cover; Copyright; Credits; Foreword; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Getting Started with MicroStrategy; Introduction; Installing SQL Server 2012 Express LocalDB; Installing SQL Server Native Client 11.0; Installing SQL Server 2012 Command Line Utilities; Setting up the AdventureWorks DW sample database; Installing the .NET Framework 4.0 and the 4.0.2 update; Checking whether IIS is enabled and working; Installing MicroStrategy Suite; Registering the MicroStrategy License; Metadata and data warehouse., Creating ODBC DSN for metadata and data warehouseModifying the logon account for the Intelligence Server; Creating the metadata, and configuring the Intelligence Server; Opening the MicroStrategy Desktop application; Chapter 2: The First Steps in a MicroStrategy Project; Introduction; Creating an empty project; Setting up a data warehouse connection and selecting tables; Modifying a table structure; Using logical tables to create custom views; Generating constants with SELECT statements; Chapter 3: Schema Objects -- Attributes; Introduction; Attribute forms -- ID and DESC., Using functions in an attribute formParent-child relationship I; Parent-child relationship II; Other attribute forms; Selecting which forms are displayed; Building Data Explorer Hierarchies; Creating an attribute only report; Parent-child relationship in a report; Filters on attributes; Chapter 4: Objects -- Facts and Metrics; Introduction; Creating a simple counter fact and metric; Using SQL View to inspect SELECT statements; Understanding the GROUP BY clause; Adding more facts; Filters on metrics; Creating ranking metrics; Grouping at a different level (level metrics)., Embedding filters inside metricsUsing Metric Join Type in reports; Creating a previous month metric (transformation); Chapter 5: Data Display and Manipulation -- Reports; Introduction; Going deeper into data with drill down; Manipulating grids -- Pivot and page-by; Dynamically adding and removing objects in reports; The bottom line -- customizing subtotals; Avoiding missteps -- NULL values in facts; How to sort data in grids; Emphasizing numbers with conditional formatting; Printing and exporting reports; Restricting results with view filters; Chapter 6: Data Analysis and Visualization -- Graphs., and IntroductionDisplaying both grid and graph in the same view; Drag-and-drop objects using drop zones; Beautify your chart; Display multiple metrics with dual axis charts; Conditional formatting with thresholds; Chapter 7: Analysis on the Web -- Documents and Dashboards; Introduction; Setting up MicroStrategy Web; Creating your first ""Hello World"" document; Adding data to a document -- the dataset; Modifying the grouping in a document; Stepping up to dashboards; Using the editable mode to fine-tune the design; Adding interactivity with panels and selectors; Embedding images, HTML, and links.
Summary
Written in a cookbook style, this book will teach you through the use of recipes with examples and illustrations. Each recipe contains step-by-step instructions about everything necessary to execute a particular task. This book is intended for both BI and database developers who want to expand their knowledge of MicroStrategy. It is also useful for advanced data analysts who are evaluating different technologies. You do not need to be an SQL master to read this book, yet knowledge of some concepts like foreign keys and many-to-many relationships is assumed. Some knowledge of basic concepts such.
Subject(s)
Genre(s)
ISBN
1306070538 (ebk)
9781306070539 (ebk)
9781782179764 (e-book)
1782179763 (e-book)
1782179755
9781782179757
Digital File Characteristics
text file
View MARC record | catkey: 37431122