Business Intelligence (BI) solution: SQL Server, Office, and SharePoint

Home > Blogs > Office 365 > Business Intelligence (BI) solution: SQL Server, Office, and SharePoint

Business Intelligence (BI) solution: SQL Server, Office, and SharePoint

Like This Blog 0 Don Jones
Added by June 4, 2013

Do you really need to buy a business intelligence solution in order to get business intelligence?

Maybe not. If you’ve got more or less all of your data in the latest version of SQL Server, and you’re using the latest versions of Office and SharePoint, you’d be surprised what you can cobble together on your own.

Now, I should start by admitting that this isn’t for the faint of heart – you’ll need to decent database, SharePoint, and BI skills on-staff in order to pull together this do-it-yourself kind of system. But for organizations that currently have only very limited or small-scale BI needs, this might be a great stopgap solution until you’re ready to move to a fully-fledged BI system.

Most of what people consider to be a “BI system” consists of things like scorecards and dashboards, and SharePoint – backed up by SQL Server – can certainly deliver those if you’re willing to develop them yourself. Microsoft Excel’s new PowerPivot add-in also provides pretty amazing analytic capabilities, all in a self-service package. Backed by SharePoint, PowerPivot can even publish shared analysis reports. In fact, it’s the combination of Excel, PowerPivot, SQL Server, and SharePoint that are letting many businesses dip their tows into the waters of BI, without having to invest in a full-scale BI system.

Excel has always had its PivotTable feature, but it had some definite limitations in terms of how much data it could deal with at once. PowerPivot blows that limit out of the water by relying on SQL Server to provide some of the back-end power, including the ability to integrate data from multiple data sources. Creating “mashups” of data from many sources is a key benefit of BI systems. The in-memory analysis engine used by PowerPivot removes the need for a pre-built data warehouse that has to be loaded with data in advance; instead, you rely on live data from live sources and crunch the numbers on today’s seriously-powerful, multi-core, gigabytes-of-memory computers. Once you’ve crunched those numbers, save the final data models into SharePoint, where other users can easily access them and even collaborate on them.

There’s a downside: That old Pentium 4 laptop sitting on your CFO’s desk isn’t going to be up to the task. You’ll need a late-model processor with multiple cores, and the more memory you can stuff into the machine, the better – think about 4GB as a reasonable minimum. That’s peanuts compared to the cost of a full BI system, and it’s an inexpensive way to get started on analytics.

Let me conclude by saying that I’m not suggesting that a small business can build their own BI system that’ll be just as rich and powerful as a commercial system. Far from it. But a small business can start getting some of the benefits of business intelligence with a little knowledge, a lot of elbow grease, and the right self-service technologies. Doing so will almost inevitably whet users’ appetites for more, and that’ll put you on the path toward a full-scale BI system that’s right for your organization.

Don Jones
PowerShell and SQL Instructor – Interface Technical Training
Phoenix, AZ

Videos You May Like

Agile Methodology in Project Management

0 171 0

In this video, you will gain an understanding of Agile and Scrum Master Certification terminologies and concepts to help you make better decisions in your Project Management capabilities. Whether you’re a developer looking to obtain an Agile or Scrum Master Certification, or you’re a Project Manager/Product Owner who is attempting to get your product or … Continue reading Agile Methodology in Project Management

Creating Users and Managing Passwords in Microsoft Office 365

0 740 4

In this Office 365 training video, instructor Spike Xavier demonstrates how to create users and manage passwords in Office 365.   For instructor-led Office 365 training classes, see our course schedulle: Spike Xavier SharePoint Instructor – Interface Technical Training Phoenix, AZ 20347: Enabling and Managing Office 365    

Windows 10 Features and Navigation – December 1, 2015

0 128 1

In this recorded Windows 10 webinar from December 1,2015, Windows Instructor Steve Fullmer presents the navigation and some of the new features associated with Windows 10 including Sysinternals Tools for Windows Client, Windows core concepts, exploring Process Explorer as well as some of the features that are not yet ready for prime time but will … Continue reading Windows 10 Features and Navigation – December 1, 2015

Write a Comment

Share your thoughts...

Please fill out the comment form below to post a reply.