Further to my blog post about SQL server appliances Microsoft and HP also offer the very exciting Business Decision Appliance. This contains a preconfigured environment with:
- Microsoft Windows Server 2008 R2 Enterprise Edition
- Microsoft SQL Server 2008 R2 Enterprise Edition with PowerPivot integration for SharePoint
- Microsoft SharePoint 2010 Enterprise Edition Prerequisites for SharePoint and PowerPivot
- Appliance Administration Console
- Appliance-specific SharePoint Home Page
- Up to 80 Concurrent Users
The aim of this appliance is to provide a safe and scalable environment for business users to quickly put a PowerPivot environment in place. This is isolated from existing systems and can be implemented by a business department with very limited IT involvement. Its isolated nature is important as many organisations don’t run SharePoint 2010 throughout their enterprise. PowerPivot authors also need Excel 2010 but once reports are built and deployed they can be shared throughout the business through SharePoint using any web browser. Anyone who has already tried to set up an integrated SharePoint and PowerPivot environment will know that the installation is not simple. This appliance takes that pain away with a one click installation from first start up that can have you up and running in under an hour.
The key point is that business users love PowerPivot and its ability to quickly use their data to answer any question. They can respond dynamically, collaborate and share insights throughout the organisation. Importantly PowerPivot allows the creation of reports that look great and are very fast. All this is done from within the familiar Excel interface and requiring little training to get started. Any team of business analysts would likely have a massive boost in productivity from the installation of the BDA in their department. IT can then monitor those reports that are heavily used and decide whether they need making more robust through transition to enterprise software such as Analysis Services. PowerPivot use is at its easiest in an environment where there is a clean data warehouse but where the business aren’t happy with the speed or responsiveness to change of their current front end. In an environment with more disparate and dirty data the end users need to be more SQL and data modelling skilled, but the payback can be even greater.
I see massive opportunity in this appliance for any team of data analysts to be able to deliver massive value to their business right now.
Introduction to Data Wrangler in Microsoft Fabric
What is Data Wrangler? A key selling point of Microsoft Fabric is the Data Science
Jul
Autogen Power BI Model in Tabular Editor
In the realm of business intelligence, Power BI has emerged as a powerful tool for
Jul
Microsoft Healthcare Accelerator for Fabric
Microsoft released the Healthcare Data Solutions in Microsoft Fabric in Q1 2024. It was introduced
Jul
Unlock the Power of Colour: Make Your Power BI Reports Pop
Colour is a powerful visual tool that can enhance the appeal and readability of your
Jul
Python vs. PySpark: Navigating Data Analytics in Databricks – Part 2
Part 2: Exploring Advanced Functionalities in Databricks Welcome back to our Databricks journey! In this
May
GPT-4 with Vision vs Custom Vision in Anomaly Detection
Businesses today are generating data at an unprecedented rate. Automated processing of data is essential
May
Exploring DALL·E Capabilities
What is DALL·E? DALL·E is text-to-image generation system developed by OpenAI using deep learning methodologies.
May
Using Copilot Studio to Develop a HR Policy Bot
The next addition to Microsoft’s generative AI and large language model tools is Microsoft Copilot
Apr