The most open business and technology blog

This is the place where we share experience, innovation and thoughts with the community

Bit Software

Recent Posts

Administrative privileges in MicroStrategy

Author: Bit Software

I've met a lot of people that have been confused about Administrative privileges in MicroStrategy and how they relate to their licensing costs. The confusion possibly is related to an old bundle MicroStrategy used to sell called "Administrator" which included the products Object Manager, Enterprise Manager and Command Manager. While those tools are critical to administer a system, they aren't related to actual Administrative privileges like killing jobs, creating schedules, clearing caches or reloading projects. The truth is that administrative privileges don't require any license beyond a Desktop license and in fact are very granular. You can grant any user access to manage anything in MicroStrategy from full on administrative functions to simple things like clearing the cache.

[read more...]

How a BI solution can help the healthcare industry

Author: Bit Software

The healthcare industry in most countries is dealing with low revenues as well as a great lack of organization. Even in the healthcare public sector, they try to increase revenues as it allows them to buy better equipment, increase capacity and thus, obtain more income from the state.
Even If, in most of the cases it is hard to make managers, from hospitals and laboratories, understand that a Business Intelligence solution would help them lower their costs, increase revenues and help organize their structure, it is noticeable they are changing their minds and try to accept the idea that a BI solution would not be a waste of money, but a great help on their daily operations.
How many times do they underuse a ward due to a bad schedule? It is not rare to see a doctor coming into an operating theatre with a patient and find out that operating theater is already taken. It is also not rare that a patient in recovery needs to be moved from one room to another because of schedule overlapping.
A Business Intelligence solution would easily help managers:

[read more...]

Google Map Widget

Author: Bit Software

One of the eagerly anticipated features added to 9.2 was the addition of an out of the box Google Map Widget. Well, not technically out of the box, but at least a provided plugin with easy to follow instructions for setting it up. While the steps seem straight forward, I often see a lot of questions surrounding it. There`s also a surprise waiting for you if you're currently enjoying the plugin in 9.2 and haven't yet upgraded to 9.2.1.

[read more...]

What are the features that determine the success of a BI tool?

Author: Bit Software

When is a BI tool successful? When the presentations are glamourous, when the presented data is according to what the users are expecting or when they are right? Those are just few of the questions I heard releated to the same subject: what are the features that determine the succes of a BI tools.

According to experts, the effective measure of the value of BI is to quantify how much it contributes to the objective of the company of obtaining sustaining profitability. Is the BI tool helping the company compete on analytics, increasing market share and sales revenue? Are the managers making better decisions in order to reduce inventory investment or operating expenses? If the answers are yes, then your BI is contributing to the fundamental goal of the company, measured in terms of Net Profit, ROI and cash flow. But, according to Gartner, this is not easy though, because almost 80% of Business Intelligence implementations fail. And the main reasons are poor data quality and difficult to use BI interface. So the isuue is how to let management understand that in first phase of the BI traject data quality is poor, how to manage that fact and how to improve that quality. These two apects are key items in making a BI traject successful and need to be addressed properly. And must realize that every human being will preferably stick to what he is used too.

In conclusion, for being successful, the BI tool must be simple, elegant and scalable.

[read more...]

A new Web mode included by MicroStrategy 9.0.2

Author: Bit Software

MicroStrategy 9.0.2 included a new Web mode called Express to Documents. In the same release, MicroStrategy removed the antiquated View mode from Web, which was a static view of your Document. Considering the push for interactivity, this was an inevitable evolution of the product. In reality, if you don't build any interactive components, then Interactive and View mode were effectively the same thing.

[read more...]

Automatically Answer Prompts

Author: Bit Software

MicroStrategy offers a lot of built in manipulations that can be performed directly within the URL. This can provide a lot of benefits for seamlessly linking to MicroStrategy reports from either within MicroStrategy itself or from an external system.
The URL API may sound complicated, but its actually really simple and doesn't require any actual programming or extra licenses. This makes it the ideal tool to perform some neat tricks and even some basic "free" customizations.
Before you can start modifying the URL for a report or document, you must first obtain it. DO NOT ever take the URL out of your address bar. This usually contains extra information that's specific to your current session, or it's missing crucial information that is already stored in your session.
Once you've got the base URL, you can start adding/modifying it. The most common task to perform is to automatically answer Prompts. This is useful when linking to reports or documents from an existing report or document and you want to automatically answer some or all of the prompts based on previous knowledge, either because you know what the user clicked on or you know what the user previously answered.
There are 5 built in methods for answering prompts:

[read more...]

A Smarter Cloud - MicroStrategy Cloud

Author: Bit Software

MicroStrategy Cloud (MSC) is the first cloud service purpose-built for the world's largest data volumes, high concurrency and high performance. MicroStrategy Cloud scales dynamically in response to demand, from tens of users to tens of thousands. MSC is also configured, optimized and maintained by MicroStrategy, so organizations no longer have to worry about provisioning hardware, tuning the architecture, or upgrading software.

MicroStrategy Cloud customers can connect directly to their on-premises or cloud-based data sources via MicroStrategy’s multisource capabilities. In addition, customers can opt to build and host their own database on the MicroStrategy Cloud through integrated database and ETL (extract, transform, and load) options.

Compared to traditional on-premises BI approaches, MicroStrategy Cloud is quicker to deploy and more flexible, delivers world-class performance, and offers significant financial advantages. MicroStrategy Cloud eliminates inefficient and risky processes related to planning, architecting, sourcing, contracting, budgeting, hiring, training, installing, testing, deploying, and more. And it is designed to deliver the highest available levels of security and operational control.

[read more...]

Open source vs. closed source BI

Author: Bit Software

Recently, I took part in a very interesting discussion on Linkedin about open source vs. closed source BI tools. It wasn't a general discussion on closed vs. open source. It was a discussion about Frankenstein BI (as closed source followers called the open source BI tools) and Big Businesses BI (term used by open source advocates to define closed source BI).

[read more...]

MicroStrategy Gateway - converts the Facebook social graph data into a relational data

Author: Bit Software

MicroStrategy Gateway for Facebook, one of the most recent enterprise product launched by MicroStrategy, is a new cloud-based service that interconnects enterprise IT environments and enterprise applications with the Facebook social graph. MicroStrategy Gateway converts the Facebook social graph data structure into a relational data structure, making it instantly suitable for enterprise applications like CRM, marketing, service, sales, loyalty, and mobile applications. By enabling bidirectional data flow, MicroStrategy Gateway lets you add social intelligence from Facebook to enterprise applications, and enterprise applications can interact back with the social network.
MicroStrategy Gateway enables companies to inject social intelligence into their enterprise applications transforming them into "friendly" applications that simplify and enhance the consumer experience. MicroStrategy Gateway is continuously updated to ensure compliance with Facebook's privacy policy and will use only the data permitted, users being in full control of how their Facebook information is accessed.
With MicroStrategy Gateway, a wide range of developers and technologies are now building social intelligence, personalization, and social interactivity into their applications. Even custom-built Facebook applications can use MicroStrategy Gateway as a simpler and more efficient access mechanism, particularly when the queries require a real-time response.

You can sign up for a Webcast on August 24th for more information about MicroStrategy Gateway for Facebook.

[read more...]

BI Best Practices Benchmark Report, Part 5: Performance Metrics

Author: Bit Software

One of the main goals of Business Intelligence is to organize and distribute metrics on the performance of the business. But one of the trickiest things to measure is the performance of the BI platform itself. A few statistics about BI performance are relatively easy to obtain and quantify, such as usage data drawn from the logs of specific tools or portals. One trend that jumped out from Gleanster survey is that almost all companies seem to be more focused on metrics tied to business outcomes and not at usage metrics, which are easy to measure but not as valuable to the business.

Below is a list of „performance metrics”, according to the participants responses (in descending order of importance):

1. Time-to-decision / time-to-response for information requests. The majority see BI as a business accelerator, a tool for driving faster, better informed decision making. But this may be a somewhat subjective measure for high-level strategic decisions.

2. Information comprehensiveness, accuracy and consistency. Audit for desired quality measures, analyzing extracts from the data warehouse to identify missing or incomplete data. By scoring for information quality, set goals for improving it and make specific plans to correct the inaccuracies.

3. Volume / quality of actionable insights. Track the number of decisions that can be traced to data or patterns exposed by BI tools. Work toward continuous improvement of both quality and quantity.

4. Financials (revenue, operating margins, etc.) Look for evidence that the BI strategy is making the company more valuable. If the evidence is not there, reconsider both the data and the models used by the BI platform. Finally, track if decision makers are, in fact, using the BI, cause a system that is not being used will never achieve its intended results.

5. Number of active users. How many users have accounts on the BI platform, compared with the penetration you would ideally like to see across the organization? How frequently do they access the system? Those are the questions raised by survey participants.

6. System usage (number of queries, dashboard views). Almost three out of four Top Performers cited number of users and technical measures of system usage as important metrics, a higher percentage of those in the Everyone Else category focused on these things over speed of decision making or quality of insights. According to survey participants, is important to find the answers to the following questions: How many times per day are BI tools employed, overall and by targeted classes of business users? Is that number rising? What parts of the BI platform are getting the most use?

7. Employee performance / productivity. Employees ought to be more productive when they do not have to waste time compiling reports or searching for information that is now readily available through the BI platform.

8. Employee satisfaction. By making measures of individual and departmental performance clearly understood and readily available through dashboards and reports, the organization provides employees with more control and eliminates uncertainly.

[read more...]

Archive


more...