Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

My BI startup: Custom styled standalone Dashboard solutions

This might be a longer post (sorry for that).

I'm working as a junior ERP consultant in an inhouse position. I administrate a SQL based no-name ERP solution with a relative low market share.

I currently have the following skills: B.A. & M.A. in economics, SAP certified application associate in BI (mostly frontend work), Finacial Accounting certified Power User, basic knowledge of SQL Server 2014, Query Design, SSRS, SSAS (basics, never did a rollout), good Access skills (no VBA however), Power Pivot and QlikView (but only basic scripting), Advanced Excel skills (again no VBA), a little bit of RStudio plotting and testing.

What I cannot provide: Any programming skills ;(

What I could provide: Webhosting, VPN access, 1000€ budget for any licenses

What I want to do: I often design reports with tools like FastReport4 based on SQL queries. Sometimes I build access frontends for small SQL DBs. I often build reports to show certain data from our ERP system (like marginal return, top customers etc.).

NOW SOME CUSTOMERS asked me if I could build custom dashboards for them. My idea is that I spend some time with them evaluating if they have good and accessible data (like SQL server or ERP tools that export to csv). Then I will develop their dashboard needs (KPIs, statistics, graphs, drilldowns, grouping items etc.).

In a second step I would like to include a friend of mine's (Designer, specialised on interaction design and app design) knowledge. This means I need a solution that allows easy integration of HTML+CSS styles.


Please keep in mind that my customers are small businesses and cannot buy large servers or expensive licensed software. I would like to sell solutions for <1000€ and I want to build them within a few days (not months).

What would be the easiest/ cheapest solution to offer ? How can I offer cheap and simple dashboards ?

Thanks a lot for your support! Greetings TB

11 Replies
petter
Partner - Champion III
Partner - Champion III

Qlik Sense (in two words) is definitely working well as a local server. The entry point for the Qlik Sense server is about half the price of the entry point of a QlikView server environment.

Seen from a non-BI perspective Qlik Sense could appear a bit expensive. If you start comparing with almost all competitors it is very cheap indeed. Then again comparing BI-solutions just on price actually miss the point in many circumstances.

It is very easy to start with Qlik Sense Desktop - this is running as a stand-alone Windows application but is essentially running the Chromium browser embedded in a .NET application which implements a single user full-fledged in-memory database along with it's analytical engine. The API's are supported except for the server specific ones. It is easy to extend from QS Desktop to QS Server. You can even use any browser against the your QS Desktop to develop. The API's are documented for full on the web at help.qlik.com.

There are many YouTube videos and even Qlik Branch (Open Source community) with a lot of free extensions that can get you started...

oknotsen
Master III
Master III

Hans Lauer wrote:

I would like to know your opinion on why Excel + BI is misused.

have no opinion about that as I do not have any knowledge of this combination.

You must have misread my post. I wrote:

I would not qualify Excel as a BI tool

You probably have mistaken "as" for "+".

May you live in interesting times!