會(huì)員

Business Intelligence with MicroStrategy Cookbook

更新時(shí)間：2021-07-23 15:32:36

開(kāi)會(huì)員，本書免費(fèi)讀 >

Writteninacookbookstyle,thisbookwillteachyouthroughtheuseofrecipeswithexamplesandillustrations.Eachrecipecontainsstep-by-stepinstructionsabouteverythingnecessarytoexecuteaparticulartask.ThisbookisintendedforbothBIanddatabasedeveloperswhowanttoexpandtheirknowledgeofMicroStrategy.Itisalsousefulforadvanceddataanalystswhoareevaluatingdifferenttechnologies.YoudonotneedtobeanSQLmastertoreadthisbook,yetknowledgeofsomeconceptslikeforeignkeysandmany-to-manyrelationshipsisassumed.Someknowledgeofbasicconceptssuchasdimensionalmodeling(facttables,dimensions)willalsohelpyourcomprehensionofthisbook.NopreviousMicroStrategyknowledgeisneeded.

目錄(177章)

倒序

封面
版權(quán)信息
Credits
Foreword
About the Author
About the Reviewers
www.PacktPub.com
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 warehouse
Modifying 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 form
Parent-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 metrics
Using 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
Introduction
Displaying 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
Switching to Adobe Flash mode
Chapter 8. Dynamic Selection with Filters and Prompts
Introduction
Restricting rows – compare an attribute to another attribute
Restricting rows – evaluate on moving dates
Changing the level of a metric filter
Adding interactivity to filters using prompts
Using prompts as object selectors
Chapter 9. Mobile BI for Developers
Introduction
Setting up the Mobile Server
Setting up a mobile connection
Installing and configuring the mobile client
Adapting content to the iPad screen
Using mobile views in documents
Adding panels to mobile documents
Creating panel selectors
Adding details with pop-up windows
Linking from one document to another
Chapter 10. Mobile BI for Users
Introduction
Answering prompts in reports or documents
Sorting drilling and paging
Adding notes and sharing
When things go wrong
Chapter 11. Consolidations Custom Groups and Transformations
Introduction
Creating virtual attributes with consolidations
Aggregating results with custom groups
Creating bands on metrics (custom groups banding)
Month-to-date and year-to-date transformations
Chapter 12. In-Memory Cubes and Visual Insight
Introduction
Creating a cube from an existing report
Building a new cube
Scheduling data refresh
Creating reports and documents based on a cube
Exploring data with Visual Insight
Using the network visualization
Chapter 13. MicroStrategy Express
Introduction
Creating an Express account
Importing Excel data
Using filters
Importing cross-tabbed data
Connecting to a RDBMS
Refreshing dashboard data
Sharing a dashboard by e-mail
Appendix A. Solution to Exercises
Exercise 1
Exercise 2
Exercise 3
Exercise 4
Exercise 5
Exercise 6
Exercise 7
Exercise 8
Exercise 9
Exercise 10
Exercise 11
Exercise 12
Exercise 13
Exercise 14
Exercise 15
Exercise 16
Exercise 17
Exercise 18
Exercise 19
Exercise 20
Exercise 21
Exercise 22
Exercise 23
Exercise 24
Exercise 25
Exercise 26
Exercise 27
Exercise 28
Exercise 29
Exercise 30
Exercise 31
Exercise 32
Exercise 33
Exercise 34
Exercise 35
Appendix B. Where to Look for Information
Online resources
Blogs
Books
Appendix C. Cloudera Hadoop
Introduction
Connecting to a Hadoop database
Appendix D. HP Vertica
Introduction
Connecting to a Vertica database
Index 更新時(shí)間：2021-07-23 15:32:36

官术网_书友最值得收藏!

Business Intelligence with MicroStrategy Cookbook