Microstrategy and Google Analytics
MicroStrategy, one of the leading platforms for business intelligence and analytics, just released the highly improved and more powerful MicroStrategy 10 Secure Enterprise.
MicroStrategy 10 offers even more options to integrate your data than its predecessor with more than 20 new data sources like Google Analytics, Hadoop and even social media like Facebook or Twitter, with an extraordinary built-in data preparation, "data wrangling" that makes the data transfer much quicker and easier.
In a matter of minutes, you can start building dashboards from almost any data source
MicroStrategy 10 Data Sources
No source was left behind. MicroStrategy 10 easily lets you connect to a variety of data sources including Dropbox, Salesforce, Google Analytics, Facebook and Twitter feeds, Cassandra, Hadoop, and many many more.
The quick import feature allows:
Quickly integrating data into MicroStrategy as part of a proof-of-concept design
Immediately building dashboards, documents, and reports without having to "model" the data source
Importing and reporting on personalized data from various data sources
Combining and analyzing personalized data with your project data
Modifying the data in your data source, then republishing the data to update quickly your dashboards, documents, and reports
Now with MicroStrategy 10 we can combine easily the scope of Google Analytics with the power of Microstrategy engine to visualize the data in innumerable forms.
MicroStrategy goes Social
Now you can gather business information from your Facebook pages to monitor brand awareness or assess the effectiveness of an advertising campaign by importing likes and comments made on your page and posts.
Twitter can also be a valuable resource to explore how your company’s customers are engaging with your products and marketing campaigns, you can import the data from using your Twitter account and the search for tweets.
MicroStrategy Analytics intelligently transforms and aggregates petabytes of big data into targeted gigabytes of in-memory data, ripe for agile data discovery. Preserve enough detail to support a deep investigation and find business insight, while solving the performance challenges of Big Data.
50 + ODBC/JDBC sources
This vast list of ODBC/JDBC sources are not so new MicroStrategy already offered easy integration with the most known and not so known databases.
Business Intelligence tools
Importing data from other BI tools like SAP Business Objects Universe (BO), Oracle Business Intelligence Enterprise Edition (OBIEE), and IBM Cognos Framework Manager is also possible.
You don't even need a database or file to export data, now you can copy/paste any table from Wikipedia, Excel or any place that has a table (WebSite or File), and create dashboards within minutes.
Apart from the already mentioned, you can also import data from OLAP\MDX, Solr, Salesforce.com, Google Drive, Dropbox, by typing a custom query or freeform script, by scraping a web page (Public Data).
And the list goes on with the generic Web Services connector + Partnership with 3rd party providers
Transform and clean your data on the go
Microstrategy 10 reduces the traditional extraction, transformation, and loading (ETL) process. The new wrangling and parsing capabilities let you easily clean, transform and prepare your data on the fly. It comes with an extensive set of row and column-based data transformation functions.
Here you can find a detailed demonstration of the Data Wrangling Feature
More New Features in MicroStrategy 10
Apart from the new great integration with various sources, MicroStrategy has more things to offer:
- New user interface with the new HTML5 data discovery interface, which is compatible with all browsers and does not require third-party software.
- More ways to visualize data. Leverage dozens of inbuilt visualization templates and maps readily available in MicroStrategy 10. Easily extend to include hundreds of new visualizations from the D3 library in minutes.
- Simple and centralized administration through the new Operations Manager.
- Advanced analytics. Create new calculations, generate intelligent trend lines and forecasts, include reference lines, and create data group associations
- MicroStrategy Desktop now also available for Mac.