Why are Solution Templates Important?

For a business that cares about data-driven decisions the business value of adopting power BI Solution Templates are immense and is a contrast to the traditional approach of building an organization-wide Business Intelligence Solution for your business, from scratch and composed of disparate teams, technologies and builds.

The Solution Template is a full stack BI Solution packaged in a single execution. The Power BI Solution Template for Twitter described herein is one example of how easily a Solution Template can be deployed for a specific environment and specific purpose and Solution Templates for other platforms and purposes can be found here>>.

There is no cost for the Twitter Solution Template!

There is no costs for the QBO Solution Template but there is an Azure Platform As A Service (PAAS) cost for the ETL that your data undergoes before landing in your Power BI dashboard and you can estimate the cost here>>.

For the reasons below, we at FreshBI are bullish on Solution Templates and their derivatives, so much so that we have adopted them as the central method for building and delivering solutions to our partners.

What tools do I need to enable the use of the Power BI Solution Template for QBO ?

• A Quickbooks Online Account

• Power BI Desktop

• Power BI Pro (for sharing the Dashboard with your organization)

• An Azure Account with rights to initiate

  • Azure Functions

  • SQL Server

  • Azure Analysis Services (Optional)

Solution Templates start with an o-auth connection to your data source, then your data can be enriched by various selected services in Azure (like Machine Learning and Analysis Services) and stored in either Azure Blob Storage or Azure SQL Server.

This Solution Template for QBO uses i) o-auth to your QBO, ii) Azure logic apps. ii) Azure Cognitive Services, iv) Machine Learning and v) Azure SQL Server.......with Azure Analysis Services being optional.

The last step in the process below is to download the Power BI Desktop file for this Solution Template which has a link to your Azure SQL Server database containing your twitter data. You can see the connection string to your data in Azure by going to Edit Queries > Data Source Settings in the Power BI Desktop. Be sure that in the Power BI Desktop, you sign into the same account that you used in step 2 below when you signed into Azure.

Solution Mobility

A Solution Template is like having a full stack BI solution in your wallet - it can be deployed against multiple environments and re-deployed anytime you need it.

Fast Solution Deployment

You can burn through the 12 steps below and interacting with your Trial Balance and have visibility of your QBO assets, shared with your team through Power BI, within 30 minutes.

Organization Wide Consistency

Solution Templates create an organizational standard for all your Business Intelligence Solutions.

Single Execution

No disparate actions required to deploy the Solution Template - the whole solution from data to dashboard is executed in one sitting.

Unified Technology Stack

The core technologies for the Solution Template live in Azure, all the way from API's to 'M', to Azure Function and Logic Apps moving data, to storage and finally, visualizing the data in Power BI.

Controlled Azure Deployments

The Solution Template executes a very specific set of instructions to Azure with very specific Azure resources being deployed and this method of deployment can be controlled in one package.

Source Code & Documentation

Source Code and Documentation for all solution templates are available to you in this Github repository. and your organization can us it the way it is or use these assets as a solid base for your documentation and data governance if you select to customize the solution template.

Solution Re-Usability

I like this feature of Solution Templates very much - knowing that there is a fully documented backup of the BI Solution Stack for each business function and that it can be re-used in new/different environments, against various social accounts and companies and even repurposed with a fraction of the effort of building from the ground up.

What Steps are Required to Acquire Such a Solution?

Well, the short answer is, get it here>>

The challenge for most people when they land on this page is that they are faced with some unknowns and consequently and obstacle to obtaining a potentially high ROI Campaign and Brand Management Analytics platform.

The most salient unknowns as far as I can tell are:

1. Effort required to obtain the Solution Template for Twitter

2. Initial Cost and Total Cost of Ownership of obtaining the Solution Template for Twitter

3. The impact that it will have on my Azure environment when I proceed

All of the unknowns above are covered in the 12 steps and video below.

If you're pretty sure you want to try the Solution Template for QBO and you don't wish to review the steps below, then my advice is: you've got nothing to lose if you try it. If you go through the 12 steps and don't find value in the Solution, just cancel the Azure services that it invokes and at least you can say you tried it.......but you'll likely keep it when you experience your twitter data in the thoughtful Power BI dashboard that you receive. 

Step-by-Step Instructions

How do Solution Templates Benefit my Business?

In addition to the business value derived from the features of Solution Templates listed at the start of this post, there are 3 value propositions that I think are important to consider.....

1. TIME: When comparing the time to deploy between engaging a team to build this solution from the ground up vs acquiring this Solution Template, the benefit to your organization is astounding.

2. COST: Try this cost estimator and remember that your investment is 100% elastic and controlled by the running time of you Azure Services and the capacity of the selected Azure Services.

3. ANALYTICS AVAILABLE: The video below does a great job of showing the Analytics available to you and how you can apply this Dashboard to Campaign and Brand Management and to you social media assets.

Our Latest Blogs

About FreshBI

Based in Canada, South Africa and in the United Kingdom, we have helped hundreds of businesses achieve excellence & success through business intelligence.

Power BI runs in our blood, and we are ready to take your business to next level.