Agile BI using SharePoint 2010

No replies
Offline
Joined: 27/02/2012
Puntos: 3

Hey folks!

Here's a case about Agile BI through SharePoint Server 2010.
I'm looking for extending/developing part of SP BI capabilities in order to permit the business end-user control and manipulate the data they wanna see, mainly focusing 2 essential pillars: self-service capabilities and visualization.

SharePoint currently offers various BI solutions, it's true: MSRS, PPS, Excel Services (+ PowerPivot), even Visio diagrams, but none of them, IMO, can fulfil the data self-service requirements, with an easy colourful drag/drop visualization, ideal for SMEs that are still developing their internal processes and so, developing extensive data models would be cumbersome.

As an example, we can look for Tableau, for example, that permits the creation of "cubes" on the fly, direct access to the data (I guess they can have some stuff in memory as well, but performance is not the question here) and a very easy interface. Here's a nice video that exemplifies the idea: http://www.youtube.com/watch?v=cYA1M4rPH_4
So, the question: do you know if SharePoint 2010 has some out-of-the-box solution, or is there any example of feature, service or some customized developed solution with such characteristics mentioned above? If not, if you have any idea/suggestion on developing such solution (extending PPS, fancy webapp using Excel Services, ...)

Regards from Portugal :-)
Jorge Mateus

Google
 
     

Similar entries

  • Within SAS solutions focused on improving performance and response time analytic environments highlights the effort with the proposed SAS In-Database. This proposal is accompanied by other high-performance solutions such as Grid Computing and SAS In-memory, which also improve performance, help manage the workload and improve the scalability of analytic environments.

     

  • Data Models and Scoring Applications Available for Government, Retail, Healthcare, Financial Services, Law Enforcement, Insurance, and CRM Deployments

    Information Builders, an independent leader in business intelligence (BI) solutions, today announced a partnership with Fractal Analytics, a leading provider of advanced analytics, to develop predictive analytics solutions on Information Builders' WebFOCUS RStat BI and data-mining platform. Fractal's predictive analytics solutions will be deployed through the WebFOCUS RStat application to help clients have an end-to-end solution from development to deployment.

    The Information Builders-Fractal partnership is currently working with the Charlotte-Mecklenburg Police Department (CMPD) to develop crime-forecasting applications. Using historical data of crime patterns, Fractal is developing predictive models that will tell the CMPD when and where they should deploy resources to fight crime. Information Builders will implement these models through WebFOCUS so the police department can drill down through data and reallocate officers to targeted areas to reduce criminal activity. While CMPD has always used data to understand trends, this is the first time the department will use a specific set of data from multiple sources to forecast future trends. When implemented, the WebFOCUS RStat application will enable CMPD supervisors to forecast crime and develop strategies to prevent it using statistical models based on historical crimes, calls for service, the nature of crime, population density, weather, special events, and more...

  • Pervasive Business Intelligence could be translated as Omnipresent Business Intelligence, at least at the enterprise level. This is to make the BI system to reach all levels of the organization, at the right time, and the information needed for each. You can even include integration with other systems operating normally, and also provide interaction capabilities, not just access to information.

    TDWI have done a study on the extent of introduction of the BI tools in business. Used as a basis a survey of over 700 people involved in BI projects and in-depth interviews with over 20 vendors and professional world of BI.

    The results of this study is the report Pervasive Business Intelligence, Techniques and Technologies to Deploy BI on an Enterprise Scale, which way to summarize what I find most relevant:

    Poll Results  

    Adoption of BI tools and level of use

    • Adoption based on roles

    Others who lead the adoption of both ratios (allocation of licenses) and use of BI tools are the business analysts, followed by managers and executives.

  • IBM today announced new consulting services and software that take the power of predictive analytics to new levels of impact for the highest-priority issues of C-suite decision makers. The new analytic offerings address the emerging opportunities of big data to manage financial operations, decrease fraud and nurture next-generation customer relationships.

  • Salesforce.com, the enterprise cloud computing (http://www.salesforce.com/cloudcomputing/) company, today unveiled the social enterprise, leveraging social, mobile and open cloud technologies to revolutionize companies’ relationships with their customers. Salesforce.com announced new innovations Chatter Now, Chatter Customer Groups, Chatter Approvals, Chatter Service and Data.com, which will accelerate social app adoption in the enterprise. Bringing mobile apps to the social enterprise, touch.salesforce.com will leverage HTML5 to deliver an optimized experience on touch devices for all Salesforce and native Force.com apps. And finally, Heroku for Java, Chatter Connect and Database.com will deliver the most open, flexible and social enterprise platform in the industry. Salesforce.com is helping companies transform themselves into social enterprises, all powered by salesforce.com’s trusted cloud platform.