3. Building Advanced Reports and Documents
by Ning Ma, Himani Rana, Dmitry Anoshin
Mastering Business Intelligence with MicroStrategy
- Mastering Business Intelligence with MicroStrategy
- Mastering Business Intelligence with MicroStrategy
- Credits
- About the Authors
- About the Reviewer
- www.PacktPub.com
- Preface
- 1. Getting Started with MicroStrategy
- Modern BI
- BI project life cycle
- Meet MicroStrategy 10
- Deploying MicroStrategy 10
- BI tips
- Summary
- 2. Setting Up an Analytics Semantic Layer and Public Objects
- 3. Building Advanced Reports and Documents
- 4. Advanced Visualization Techniques
- 5. Customization of MicroStrategy
- 6. Predictive Analysis with MicroStrategy
- Predictive analysis in MicroStrategy 10
- Integrating R with MicroStrategy
- Data mining overview
- Four steps to achieve data mining in MicroStrategy
- Business applications of predictive analysis
- Forecasting quarterly revenues using linear regression and exponential regression with seasonality
- Forecasting quarterly revenues for different regions using tree regression analysis
- Forecasting monthly revenues using time series analysis
- Telco churn analysis using classification
- Telco churn analysis using decision tree
- Telco churn analysis using logistic regression
- Automating the predictive mechanism
- Summary
- 7. Accelerating Your Business with Mobile Analytics
- Before we start
- Mobile Server installation and configuration
- Creating a mobile application
- Determine business goals
- Storyboarding and planning
- Creating an iPad Landscape template
- Dataset creation
- Panel stack and panels for Sales Performance App
- Creating a Home page for Sales Performance App
- Creating a Product page for Sales Performance App
- Creating a Region page for Sales Performance App
- Creating a Trend page for Sales Performance App
- Creating a Customer page for Sales Performance App
- Prompts in mobile applications
- Views in mobile applications
- Linking
- Best practices
- Extending mobile capabilities
- Deployment
- Summary
- 8. Data Discovery with MicroStrategy Desktop
- 9. MicroStrategy System Administration
- 10. Design and Implementation of the Security Model
- 11. Big Data Analytics with MicroStrategy
- 12. MicroStrategy Troubleshooting
In the previous chapter, we learned about the creation of schema designs and different schema and public objects; so, in this chapter, we can dig deeper and understand some advanced techniques for presenting data to end users.
This chapter will cover:
- Creating consolidations
- Building different types of custom group
- Creating transformations
- Working on your first advance report
- Creating and adding data to the document
- Dashboard creation and usage
A report is an object that provides a multi-perspective view of our data. Reports are the starting point for further business investigations and decisions. Advanced reporting allows us to create complex and sophisticated reports using several advanced objects such as advanced metrics, transformations, consolidations, custom groups, freeform SQL, and intelligent cubes.
Before you begin with this chapter, you should be familiar with basic reports and components.
- Real-life scenarios using advanced reporting features include:
- Top N products with highest sales
- Sales of current year versus previous year
- Yearly revenue splits by territory
- Sales based on seasons
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.