Tag Archives: MicroStrategy

Interview Question #8 : Many-to-Many Relationships in MicroStrategy

Question

Which of the following issues can result from many-to-many relationships?

A. Exclusion of some attribute elements when drilling

B. Multiple join paths to fact tables

C. Missing values on reports including all attributes from the hierarchy

D. Multiple counting when aggregating data from base fact tables

E. Lost analytical capability

Answer

Both

D. Multiple counting when aggregating data from base fact tables

      and

E. Lost analytical capability

 

Challenges of Many-to-Many Relationships

Because many-to-many relationships require distinct relationship tables, you have to design the logical data model and data warehouse schema in such a way that you can accurately analyze the relationship in regard to any relevant fact data.

If the structure of your logical data model and data warehouse schema does not adequately address the complexities of querying attribute data that contains many-to-many relationships, you can have problems like lost analytical capability and multiple counting.

I will be exploring both of these topics more next week as Tips and Tricks.

MicroStrategy Course Where You Will Learn About This Topic

MicroStrategy Advanced Data Warehousing Course

MicroStrategy Leads in Forrester Wave Agile BI Report, Q2, 2014

Forrester Wave Agile BI Q2 2014

MicroStrategy Analytics Platform received top scores for the features technology professionals need to enable business user business intelligence (BI) self-service, as well as for the effectiveness of its advanced data visualization (ADV) functionality in the recently published Forrester Wave: Agile Business Intelligence Report for Q2, 2014.

According to the report, “Forrester also scored MicroStrategy highly for the business user capabilities to provision applications and data and perform data integration tasks within the BI tool. MicroStrategy received high client feedback scores for its agile, business user self-service and ADV functionality. Clients also gave MicroStrategy a top score for its product vision.”

The report also stated that “in addition to its Agile BI offerings, MicroStrategy’s traditional strengths are its organically grown architecture and a powerful ROLAP engine, which in the long-term can often reduce total cost of ownership by reducing the number of reports and dashboards that need to be produced. With its integrated desktop and cloud-based SaaS offerings, MicroStrategy buyers can start small and scale quickly.”

To get a free download of the complete report, visit MicroStrategy’s Web site at http://www.MicroStrategy.com.

Michael Saylor Keynote – MicroStrategy World Barcelona – July 2014

Click on image to watch keynote video

Click on image to watch keynote video

MicroStrategy Simplifies Product Packaging to Enhance Total Customer Experience

New MicroStrategy Pricing

Converges on Four Products; Offers Free Upgrades to Premium Capabilities for Existing Clients

BARCELONA, Spain, July 8, 2014 – MicroStrategy® Incorporated (Nasdaq: MSTR), a leading worldwide provider of enterprise software platforms, today announced a new packaging structure aimed at delivering the best end-to-end customer and partner experience, making it easier than ever to acquire, deploy, and succeed with MicroStrategy. MicroStrategy also announced that it is extending free upgrades for existing clients to the premium capabilities included in the new product packaging, offering greater value to clients and new users.

The packaging changes will empower new and existing MicroStrategy clients to realize the full potential of their analytical applications using the most comprehensive analytics and mobile platforms in the industry. This information, and more, can be found at: www.microstrategy.com/experience.

“Our new packaging makes it simple for organizations to choose MicroStrategy for the totality of their business analytics and mobile application needs,” said Paul Zolfaghari, President, MicroStrategy Incorporated. “We believe it instantly enhances our value to existing customers and is emblematic of our heightened focus on delivering a positive customer experience. The new packaging allows better preparation and planning for new deployments, providing more value over the broad range of solutions we offer.”

Under the new packaging structure, MicroStrategy’s full feature set, previously split into 21 discrete offerings, has been reduced to four simple packages that empower developers, analysts, power users, and consumers to take advantage of the comprehensive MicroStrategy platform with simplified value-based pricing.

“From a customer perspective this is a welcome change,” said Andrew Young, BI Director, at Bob Evans Farms, a MicroStrategy client. “Budgeting and planning new applications will be far easier, especially breaking down platform investments to our business customers. With the simplified offering and pricing structure we can paint a more complete picture and focus on the business value.”

MicroStrategy added that the new packaging allows clients to more affordably deploy the full breadth of MicroStrategy capabilities (including data federation, write-back, closed-loop analysis, and automated report distribution, among others) to more users across the enterprise, giving end users full authoring capabilities as needed and integration with Microsoft® Office® applications. System architects gain efficiencies with the full ability to manage upgrades, migrations, and data loads, as well as free server administration and monitoring features. Within the four product offerings, clients will have all styles of analytics (self-service, dashboards, advanced analytics) across any interface (web, mobile, pdf, email report distribution) at Big Data scale—on an automated platform.

“To maximize the value of a customer relationship requires that companies simplify the pricing to ensure the purchasing process of technology is easy and transparent,” said Mark Smith, CEO and Chief Research Officer at Ventana Research. “The new MicroStrategy packaging and pricing enable the best possible customer experience, while shortening the time to gain full value from technology for organizations.”

The new packaging focuses on user roles within an enterprise:

  • MicroStrategy Server™ benefits all user roles. It includes a fully-featured server infrastructure designed to connect to multiple data sources, supports all major analytic styles from report distribution to information-driven apps to self-service data discovery, and scales to hundreds of thousands of users. It also includes administration and monitoring tools needed by organizations to effectively and efficiently manage their deployments.
  • MicroStrategy Web™ empowers business users to consume, author, and design analytics through an intuitive web-based interface. Business analysts can use MicroStrategy Web to take advantage of the all-inclusive set of self-service analytic capabilities.
  • MicroStrategy Mobile™, the award-winning, industry-leading interface for Apple iOS and Android devices, is an easy, fast, affordable way to mobilize analytics and information-driven applications to an increasingly mobile and 24 x 7 workforce.
  • MicroStrategy Architect™ provides developers with an extensive set of development, deployment and migration tools needed to efficiently manage the application development lifecycle.

The Company also noted that these four offerings complement the free MicroStrategy Analytics Desktop™ it made available last year. MicroStrategy Analytics Desktop is a free self-service business analytics tool designed to enable any individual user to gain deep insight into the user’s data by effortlessly creating powerful, insightful visualizations and dashboards.

MicroStrategy Report Optimization: Computational Distance

Computational Distance

Source: MicroStrategy University, Deploying MicroStrategy High Performance BI, V9.3.1, MicroStrategy, Inc. September, 2013.

Computational Distance

Any BI system consist of a series of processes and tools that take raw data at the very bottom-at the transaction level in a database-and by using various technologies transform that data into the finished answer that the user needs. At every step along the way, some kind of processing is done in the following components-the database, network, BI application, or the browser.

The concept of “computational distance” refers to the length in terms of systems, transformations, and other processes that the data must undergo from its lowest level, all the way to being rendered on a browser as shown in the image above.

The longer the computational distance is for a given report, the longer it will take to execute and render. The preceding image shows a hypothetical example of a report that runs in 40 seconds. Each processing step on that report, such as aggregation, formatting, and rendering, adds to the report’s computational distance, increasing the report overall execution time.

Reducing the Computational Distance of a Report

Computation distance offers a useful framework from a performance optimization perspective because it tells us that to improve the performance of a report or dashboard, you must focus on reducing its overall computational distance. The following image shows different techniques such as caching, cubes, and aggregation that can be used to optimize performance for the 40 second hypothetical report.

In the next blog post, we will next look at two key computational distance reduction techniques offered in the MicroStrategy platform-caching and Intelligent Cubes.

Reducing the Computational Distance

MicroStrategy Report Optimization: Components of Performance

Readers:

Today, I am adding the second post in my MicroStrategy Report Optimization series. This will be a multi-part series (I will leave it open-ended so I can continue to add to it).

Today, we will look at the components that comprise performance.

Best Regards,

Michael

Source: MicroStrategy University, Deploying MicroStrategy High Performance BI, V9.3.1, MicroStrategy, Inc. September, 2013.

Components of Performance

There are five key layers or components that a typical BI query must go through. They are:

  • Caching Options
  • Data Transfer
  • System Architecture and Configuration
  • Client rendering or Data Presentation
  • Data Warehouse Access

The components above are not listed in any specific order of access during the execution of a query. The image below illustrates the five components.

The Components of High Performance

Caching and Intelligent Cubes

MicroStrategy’s memory technology is engineered to meet the increased demand for higher BI performance, which is driven by the rapid expansion of both data volumes and the number of BI users in organizations across industries. MicroStrategy accelerates performance by pre-calculating computations and placing the results into its memory acceleration engine to dramatically improve real-time query performance.

Data Transfer

Data transfer over one or more networks are a very important component of a BI implementation. A slow or poorly tuned network performance in any of those transfers will translate into poor performance from a report or a dashboard execution perspective.

System Architecture and Configuration

Successful BI applications accelerate user adoption and enhance productivity, resulting in demand for more users, data, and reports. MicroStrategy provides the ability to adapt quickly to constant changes and evolve along with business requirements. MicroStrategy Intelligence Server hs been proven in real-world scenarios to deliver the highest performance at scale with the fewest servers and minimum IT overhead.

Data Presentation

Dashboards provide graphical, executive views into KPIs, enabling quick business insights. MicroStrategy enables higher performing dashboards, averaging 30-45% faster execution and interactivity. Using new compression methods, MicroStrategy dashboards have a smaller footprint than ever before – up to to 55% smaller – resulting in faster delivery using less network bandwidth. Dashboards deliver ever more analysis and data for end-users.

Data Warehouse Access

High performance BI starts with optimizing SQL queries to retrieve results from the database as quickly as possible. BI performance is dependent largely on the time that the queries take to execute in the database. An average reporting request usually takes 40 seconds to complete, out of which 34 seconds, or 85% of the query time, is spent executing in the database.

Therefore, it is critical to optimize report queries to reduce database execution time.

MicroStrategy Report Optimization: Introduction

Readers:

I have received an e-mail from a reader that wanted me to discuss how to optimize MicroStrategy Reports.

I think this is an excellent topic and will today start a new blog topic called MicroStrategy Report Optimization. This will be a multi-part series (I will leave it open-ended so I can continue to add to it).

Before we start the series, it is important to understand report execution flow in MicroStrategy. That is what I will start with today.

Best Regards,

Michael

Source: MicroStrategy University, Deploying MicroStrategy High Performance BI, V9.3.1, MicroStrategy, Inc. September, 2013.

Report Execution Flow

To better understand how some of the components affect the report performance in a MicroStrategy environment, it is important to become familiar with the report execution flow.

The following image depicts the different steps involved in the report execution process.

Report Execution Flow

The following steps and components are involved in the report execution flow.

Report Execution Flow Steps

 

Tips & Tricks #11: The URL path is not visible in the report properties dialog box in MicroStrategy Web

The Issue

Each report and document has a URL path that could be used to directly execute the object when pasted in the browser address bar. The URL path can be found in the properties section when a user right-clicks on the object.

The expected view of that window is as follows:

The view observed by some users without the link feature:

The Cause

The required feature is not enabled in the MicroStrategy Web Admin page.

The Fix

  1. Navigate to the MicroStrategy Web Admin page.
  2. Select ‘Security’ on the left-hand side.
  3. Under ‘URL’, enable the feature – “Session information is included on the URL”.

 

Workaround 

If the session information setting should remain off for security reasons, use the Show Link feature as shown below.

 

Reference

MicroStrategy Knowledgebase Technical Note 39787, Updated July 22, 2013.

MicroStrategy Hires Marcus Starke as Chief Marketing Officer

TYSONS CORNER, Va., April 22, 2014 /PRNewswire/ –

Marcus-StarkeMicroStrategy ® Incorporated, a leading worldwide provider of enterprise software platforms, recently announced that Marcus Starke has been hired as the company’s new Chief Marketing Officer.  Starke comes to MicroStrategy with more than 25 years of marketing and general business experience, including senior leadership roles with some of the world’s best-known software and media companies. Prior to joining MicroStrategy, Starke served as SAP’s Senior Vice President of Worldwide Marketing & Communications Regions, where he oversaw all marketing strategy and execution and was a member of SAP’s global leadership team. Immediately preceding his five-year tenure at SAP, Starke was President and CEO (EMEA) of Wunderman, a division of the WPP Group.

“We are extremely pleased to have a recognized marketing innovator like Marcus join us at a very exciting time for the company,” said Michael Saylor, CEO, MicroStrategy Incorporated. “Marcus brings global marketing expertise, not only from his time with SAP but also from leading marketing communications agencies.  Marcus is a thought-leader who’s passionate about innovation, and his track record as a disruptive force in strategy, marketing and communications couldn’t be better suited to our plans to transform the market with our offerings.  His hire represents the latest in a series of concrete steps that MicroStrategy has taken to enhance the customer experience and capture market share in the global market place.””Telling the story of such an important global technology and innovation leader — boasting thousands of successful customers, including hundreds of major global brands — is a terrific opportunity,” said Starke. “This is a pivotal time for MicroStrategy as it leads the market with the world’s number #1 mobile BI platform, the leading cloud BI solution and what I believe is the most comprehensive analytics platform. There’s also a powerful opportunity ahead in its new mobile identity and loyalty platforms. I am very excited about the opportunity to help customers significantly accelerate business innovation, simplify their businesses, and dramatically enhance the experience of their customers through the amazing technologies MicroStrategy has developed.”

Earlier in his career, Starke served as the Chief Executive Officer and Chairman of Publicis Frankfurt.  He also managed his own consulting and marketing agency. A strong advocate of “social business,” in navigating the social media/social community landscape, Starke pens a widely-read blog and is a passionate proponent of customer engagement through world-class marketing and communications.

About MicroStrategy Incorporated Founded in 1989, MicroStrategy is a leading worldwide provider of enterprise software platforms.  The Company’s mission is to provide the most flexible, powerful, scalable and user-friendly platforms for analytics, mobile, identity and loyalty, offered either on premises or in the cloud.

The MicroStrategy Analytics Platform™ enables leading organizations to analyze vast amounts of data and distribute actionable business insight throughout the enterprise.  Our analytics platform delivers reports and dashboards, and enables users to conduct ad hoc analysis and share their insights anywhere, anytime.  MicroStrategy Mobile™ lets organizations rapidly build information-rich applications that combine multimedia, transactions, analytics, and custom workflows.  The MicroStrategy Identity Platform™ (branded as MicroStrategy Usher™) provides organizations the ability to develop a secure mobile app for identity and credentials. The MicroStrategy Loyalty Platform™ (branded as MicroStrategy Alert) is a next-generation, mobile customer loyalty and engagement solution.  To learn more about MicroStrategy, visit www.microstrategy.com and follow them on Facebook ( http://www.facebook.com/microstrategy ) and Twitter ( http://www.twitter.com/microstrategy ).

MicroStrategy, MicroStrategy Analytics Platform, MicroStrategy Mobile, MicroStrategy Identity Platform, MicroStrategy Loyalty Platform, and MicroStrategy Usher are either trademarks or registered trademarks of MicroStrategy Incorporated in the United States and certain other countries.  Other product and company names mentioned herein may be the trademarks of their respective owners.

Bryan’s BI Blog: MicroStrategy vs Tableau

Readers:

Bryan BrandowBryan Brandow, has posted his second new post on his new blog, Bryan’s BI Blog and it is a doozy. Bryan does an in-depth comparison of MicroStrategy vs. Tableau.

Here is a link to the MicroStrategy vs. Tableau post.

Best Regards,

Michael

 

Follow

Get every new post delivered to your Inbox.

Join 84 other followers