Find Jobs
Hire Freelancers

Consulting on setting up a open source business intelligence server

$15-25 USD / hour

Completed
Posted about 7 years ago

$15-25 USD / hour

We are considering setting up an open source business intelligence server, and have some reports set up. First step is to consider solution, we'd like to receive your recommendation and suggestions. The next steps will be implementation and data model devs. But that is to be another project.
Project ID: 13320709

About the project

2 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I'm a BI/DWH expert from Bulgaria (still in EU) with 7+ years of experience in the field. The main components you need consider when looking for a BI solution are: 1. The data storage: a. RDBMS - Plenty of options here: PostgreSQL, MySQL and many paid ones (SQL Server, Oracle, etc) b. Big Data (HDFS, Cassandra, etc...) - only if the data expected is more than 1TB!!! 2. The ETL tool a. Free - Pentaho Kettle, Talend and many others (popular and not so popular) b. Paid - SSIS, Informatica PowerCenter 3. The BI server - this component is misleading, cause there two sub-components here, which sometimes can't be separated from each other. Tableau, QlikView, MicroStrategy and all major players tend to combine/market them as "a single solution" 3.1. The ROLAP/MOLAP/HOLAP server - This is where the data get persisted/optimized for fast querying a. Free - Mondrian, Jedox, Cubes ... b. Paid (many) - SSAS, Cognos, icCube... 3.2. The visualization part or a.k.a. dashboards - this is both the easiest and the hardest choice: a. Many JavaScript libraries - d3.js, [login to view URL], ... I'm sure there are many of them. b. The "standard reporting" offered by the "BI Server" - Pentaho BI Server, BIRT, Jaspersoft, etc. c. Some other app that offers dashboarding capabilities - Tableau, QlikView, PowerBI and too many others!!! P.S. I'm a Pentaho BI specialist, you can guess my recommendation! Best Regards, Veselin Zh.
$25 USD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of DENMARK
Odense SO, Denmark
5.0
3
Payment method verified
Member since Aug 4, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.