TY  - BOOK
AU  - Moraschi,Davide
TI  - Business Intelligence with MicroStrategy Cookbook
SN  - 9781782179764
AV  - HD38.7 -- .M67 2013eb 
U1  - 006 
PY  - 2013///
CY  - Olton
PB  - Packt Publishing Ltd
KW  - Business enterprises -- Decision making
KW  - Business intelligence
KW  - Electronic books
N1  - Intro -- Business Intelligence with MicroStrategy Cookbook -- Table of Contents -- Business Intelligence with MicroStrategy Cookbook -- Credits -- Foreword -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. Getting Started with MicroStrategy -- Introduction -- Installing SQL Server 2012 Express LocalDB -- Getting ready -- How to do it... -- How it works... -- There's more... -- Installing SQL Server Native Client 11.0 -- Getting ready -- How to do it... -- How it works... -- There's more... -- Installing SQL Server 2012 Command Line Utilities -- Getting ready -- How to do it... -- There's more... -- Setting up the AdventureWorks DW sample database -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 1 -- Installing the .NET Framework 4.0 and the 4.0.2 update -- How to do it... -- How it works... -- Checking whether IIS is enabled and working -- Getting ready -- How to do it... -- How it works... -- There's more... -- Installing MicroStrategy Suite -- Getting ready -- How to do it... -- There's more... -- Registering the MicroStrategy License -- Getting ready -- How to do it... -- There's more.... -- Metadata and data warehouse -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating ODBC DSN for metadata and data warehouse -- Getting ready -- How to do it... -- How it works... -- There's more... -- Modifying the logon account for the Intelligence Server -- Getting ready -- How to do it... -- How it works; There's more... -- Creating the metadata and configuring the Intelligence Server -- Getting ready -- How to do it... -- How it works... -- There's more... -- Opening the MicroStrategy Desktop application -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- 2. The First Steps in a MicroStrategy Project -- Introduction -- Creating an empty project -- Getting ready -- How to do it... -- How it works... -- There's more... -- Setting up a data warehouse connection and selecting tables -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 2 -- Exercise 3 -- Modifying a table structure -- Getting ready -- How to do it... -- How it works... -- Using logical tables to create custom views -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 4 -- Generating constants with SELECT statements -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- 3. Schema Objects - Attributes -- Introduction -- Attribute forms - ID and DESC -- Getting ready -- How to do it... -- How it works... -- There's more... -- Using functions in an attribute form -- Getting ready -- How to do it... -- How it works... -- There's more... -- Parent-child relationship I -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 5 -- Parent-child relationship II -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 6 -- Other attribute forms -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 7 -- Selecting which forms are displayed -- Getting ready -- How to do it... -- How it works... -- There's more... -- Building Data Explorer Hierarchies -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 8 -- Exercise 9 -- Exercise 10; Creating an attribute-only report -- Getting ready -- How to do it... -- How it works... -- There's more... -- Parent-child relationship in a report -- Getting ready -- How to do it... -- How it works... -- There's more... -- Filters on attributes -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 11 -- See also -- 4. Objects - Facts and Metrics -- Introduction -- Creating a simple counter fact and metric -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 12 -- Exercise 13 -- Using SQL View to inspect SELECT statements -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 14 -- Understanding the GROUP BY clause -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 15 -- Adding more facts -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 16 -- Exercise 17 -- Exercise 18 -- Filters on metrics -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating ranking metrics -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 19 -- Grouping at a different level (level metrics) -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 20 -- Embedding filters inside metrics -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 21 -- Using Metric Join Type in reports -- Getting ready -- How to do it... -- How it works... -- There's more... -- More Info -- Creating a previous month metric (transformation) -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 22 -- See also -- 5. Data Display and Manipulation - Reports -- Introduction -- Going deeper into data with drill down -- Getting ready -- How to do it... -- How it works... -- There's more; More Info -- Manipulating grids - Pivot and page-by -- Getting ready -- How to do it... -- How it works... -- There's more... -- Dynamically adding and removing objects in reports -- Getting ready -- How to do it... -- How it works... -- There's more... -- More Info -- The bottom line - customizing subtotals -- Getting ready -- How to do it... -- How it works... -- There's more... -- More Info -- Avoiding missteps - NULL values in facts -- Getting ready -- How to do it... -- How it works... -- There's more... -- How to sort data in grids -- Getting ready -- How to do it... -- How it works... -- There's more... -- Sorting NULLs -- Emphasizing numbers with conditional formatting -- Getting ready -- How to do it... -- How it works... -- There's more... -- Printing and exporting reports -- Getting ready -- How to do it... -- How it works... -- There's more... -- Restricting results with view filters -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 23 -- See also -- 6. Data Analysis and Visualization - Graphs -- Introduction -- Displaying both grid and graph in the same view -- Getting ready -- How to do it... -- How it works... -- There's more... -- More Info -- Drag-and-drop objects using drop zones -- Getting ready -- How to do it... -- How it works... -- There's more... -- Beautify your chart -- Getting ready -- How to do it... -- How it works... -- There's more... -- Display multiple metrics with dual axis charts -- Getting ready -- How to do it... -- How it works... -- There's more... -- Conditional formatting with thresholds -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 24 -- See also -- 7. Analysis on the Web - Documents and Dashboards -- Introduction -- Setting up MicroStrategy Web -- Getting ready -- How to do it... -- How it works... -- There's more... -- More Info; Creating your first "Hello World" document -- Getting ready -- How to do it... -- How it works... -- There's more... -- Adding data to a document - the dataset -- Getting ready -- How to do it... -- How it works... -- There's more... -- Modifying the grouping in a document -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 25 -- Stepping up to dashboards -- Getting ready -- How to do it... -- How it works... -- There's more... -- Using the editable mode to fine-tune the design -- Getting ready -- How to do it... -- How it works... -- There's more... -- Adding interactivity with panels and selectors -- Getting ready -- How to do it... -- How it works... -- There's more... -- Embedding images, HTML, and links -- Getting ready -- How to do it... -- How it works... -- There's more... -- Switching to Adobe Flash mode -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- 8. Dynamic Selection with Filters and Prompts -- Introduction -- Restricting rows - compare an attribute to another attribute -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 26 -- Restricting rows - evaluate on moving dates -- Getting ready -- How to do it... -- How it works... -- There's more... -- More Info -- Exercise 27 -- Changing the level of a metric filter -- Getting ready -- How to do it... -- How it works... -- There's more... -- Adding interactivity to filters using prompts -- Getting ready -- How to do it... -- How it works... -- There's more... -- More Info -- Using prompts as object selectors -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- 9. Mobile BI for Developers -- Introduction -- Setting up the Mobile Server -- Getting ready -- How to do it... -- How it works... -- There's more... -- Setting up a mobile connection; Getting ready
N2  - 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 as dimensional modeling (fact tables, dimensions) will also help your comprehension of this book. No previous MicroStrategy knowledge is needed
UR  - https://ebookcentral.proquest.com/lib/buse-ebooks/detail.action?docID=1389367
ER  -