Microsoft promotes BI Development with Microsoft Visual Studio 2010

WEBINAR:
On-Demand

Application Security Testing: An Integral Part of DevOps


Microsoft's BI message was on display at the Microsoft Tech Ed North America 2010 and BI Conference 2010 events this week in New Orleans. Ted Kummert, senior vice president of the Business Platform Division at Microsoft keynoted the second day of the event and showed how Microsoft has exposed rich, self-service BI capabilities to line of business workers. But there is one audience that hasn't been getting a lot of attention in Microsoft's BI conversation, and that is developers. Until now. Donald Farmer is principal program manager for SQL Server at Microsoft. He says Microsoft has worked to align its BI stack with Microsoft Visual Studio, turning the IDE into, he said, "the development environment for BI." "Our BI environment is our developer environment. What that means is there is a consistent set of tools across all the pieces," Farmer said. "You get versioning. You get a true build environment, which is very unusual for a BI environment."

If the strategy sounds familiar, it's because it is. Microsoft's efforts to up-level BI into an extensible platform for development mirrors similar efforts with other application stacks-turned-platforms, including Office and SharePoint. The use of common tooling opens a lot of possibilities for robust, purpose-built application development. Farmer described a decision support scenario, where Visual Studio is used to embed predictive analytics into an Outlook-based CRM customer data entry application. Developers, he said, are able to use familiar SQL Server-like commands and well-known data structures. A major driver of effective BI, said Farmer, is the ability to embed functionality into applications. BI processes that require workers to jump to another interface are disruptive to users, and can pose issues for developers and BI designers forced to work with distinct environments.

"At the operational end, this has to be embedded in the applications they are already using. It has to be embedded in the call center application," he said. "That's one of the reasons embeddability is so important. It's one of the reasons having a developer story is so important." That developer story may emerge as a significant competitive advantage for Redmond. Andrew Brust, Chief, New Technology for consultancy twentysix New York, a Microsoft Regional Director, and a member of Microsoft's BI Partner Advisory Council, gave a talk Tuesday afternoon at Tech Ed. He noted that the large ecosystem of partners and solution providers give the Microsoft BI stack an important competitive advantage over competitors.

Itamar Ankorion, director of marketing and business development at Attunity, said organizations have grown increasingly concerned about the impact of intense BI activity on production data stores, particularly as user-friendly tools like PowerPivot expand the scope of BI usage. Ankorion expects that trend to grow. "For developers in general, what we are going to see is developers building applications in PowerPivot," he said. "Just as you have people developing Excel applications, you will see this with PowerPivot." Microsoft is working to make sure that is exactly what happens, by putting Microsoft Visual Studio at the center of the BI universe. Said Farmer: "It was actually a revelation to us how much the BI community really wanted the Microsoft Visual Studio environment.".

Microsoft significantly updated its business intelligence (BI) stack with the releases of SharePoint 2010, Office 2010 and SQL Server 2008 R2.

View Article



Comments

  • There are no comments yet. Be the first to comment!

  • You must have javascript enabled in order to post comments.

Leave a Comment
  • Your email address will not be published. All fields are required.

Top White Papers and Webcasts

  • IDC estimates that more than 70% of organizations have a cloud-first application deployment strategy to align with digital transformation initiatives. As such, many organizations are transitioning to Microsoft Office 365 and utilizing public clouds such as Microsoft Azure. However, IT leaders are discovering that default data protection schemes are not as robust as they desire. As a result, many are turning to Veeam® to provide the necessary data management and protection policies demanded by the …

  • IT planners have far more options as to where to run their workloads than ever before. On-premises data centers, co-location facilities and managed services providers are now joined by hybrid multi-clouds – a combination of Software-, Infrastructure- and Platform-as-a-Service (SaaS, IaaS, and PaaS) execution venues. All have unique operational, performance and economic characteristics that need to be considered when deploying workloads. Submit the form to watch this webinar replay featuring 451 …

Most Popular Programming Stories

More for Developers

RSS Feeds

Thanks for your registration, follow us on our social networks to keep up-to-date