Business Intelligence with MicroStrategy Cookbook. (2013)

• Record Type: Book
• Other Names: Moraschi, Davide
• 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. 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.
• Publisher Details: Place of publication not identified : Packt Publishing
• Publication Date: 2013
• Extent: 1 online resource
• Subjects: 006; COMPUTERS -- Enterprise Applications -- Business Intelligence Tools; Business intelligence -- Computer programs; Business intelligence -- Computer programs; Business intelligence / Computer programs; COMPUTERS -- Data Processing; Electronic books
• Languages: English
• ISBNs: 1306070538; 9781306070539; 9781782179764; 1782179763; 1782179755; 9781782179757
• Related ISBNs: 9781782179757
• Notes: Note: Print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.