Business Intelligence with MicroStrategy Cookbook

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...

Full description

Bibliographic Details
Main Author: Moraschi, Davide
Format: eBook
Language:English
Published: Packt Publishing 2013
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
LEADER 04723nmm a2200433 u 4500
001 EB001912609
003 EBX01000000000000001075511
005 00000000000000.0
007 cr|||||||||||||||||||||
008 210123 ||| eng
020 |a 1306070538 
020 |a 9781782179764 
020 |a 9781306070539 
020 |a 1782179755 
020 |a 1782179763 
050 4 |a QA76.76.A65 
100 1 |a Moraschi, Davide 
245 0 0 |a Business Intelligence with MicroStrategy Cookbook 
260 |b Packt Publishing  |c 2013 
300 |a 1 online resource 
505 0 |a 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 
505 0 |a 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 
505 0 |a 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. 
505 0 |a 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) 
505 0 |a 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 
653 |a COMPUTERS / Data Processing / bisacsh 
653 |a Business intelligence / Computer programs 
653 |a COMPUTERS / Enterprise Applications / Business Intelligence Tools / bisacsh 
041 0 7 |a eng  |2 ISO 639-2 
989 |b OREILLY  |a O'Reilly 
776 |z 9781782179764 
776 |z 1782179763 
776 |z 9781306070539 
776 |z 9781782179757 
776 |z 1306070538 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781782179757/?ar  |x Verlag  |3 Volltext 
082 0 |a 006 
082 0 |a 330 
520 |a 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