Questions tagged as 'business-intelligence'

1
answer

Cubes of some clients in Analysis Services

I want to allow my clients to access your data to generate customized reports and use the power of Excel PowerPivot. Today all the clients (business) are in the same database and for the little that I know about cubes I draw the following strate...
asked by 09.10.2014 / 23:19
2
answers

Are there BI / OLAP tools for the MEAN.JS platform?

Can anyone point me to a BI / OLAP framework or at least one Chart Engine, preferably open-source, to properly integrate the MEAN.JS or MEAN.IO with SPA SPA - Single Page Application I know keen.io . It is free in low transactional volu...
asked by 19.10.2014 / 22:16
0
answers

What are the advantages of using a Snowflake, Star model, under a relational model for B.I?

Hello, Nowadays, I see many B.I tools on the market advertising that their tools are plug'n play, connect with relational databases, excels, and "instantly generate B.I systems." This gave me some doubts, as I already had a session in the...
asked by 16.02.2018 / 19:48
0
answers

How to create 15-minute SQL interval? [closed]

I have a timestamp field and need to create a 15-minute interval. How in Sql should I do this? Data = YYYY/MM/DD HH:MM:SS The purpose is to analyze where I need the quantity of products sold every 15 minutes the day before.     
asked by 29.09.2016 / 21:11
0
answers

What is the difference between a data warehouse and a data lake?

Given the concepts of data warehouse and data lake , what notable differences can we cite between them?     
asked by 04.12.2018 / 23:42
2
answers

Generate PivotTable in Excel from MSSQL with 8 million records

I have a table in MSSQL with currently 8 million records. I use Pentaho to analyze this data. I'm trying to use Excel too. If I set it to get the data and put it directly into the PivotTable, it does not restrict the 1 million records, becaus...
asked by 27.01.2017 / 17:41
0
answers

Mobile Report - Reporting Services 2016

This is my first post in the community and I hope to be able to collaborate with my question. I'm working on a BI project where I need to show a quantity of calls on a map, according to the models that exist ready, it's possible to use a colu...
asked by 07.10.2016 / 19:27
1
answer

I can not assign expression return in the SSIS variable

Task to enter Value in Variable by select result MyintentionwiththislogicistopassacalculatedcolumnfromoneexcelfiletoanotherusingastageareawhereIjustwanttomodifyacolumninthedatabasetableandtheninsertitintotheexcelfile.SoIamusingvariablet...
asked by 16.10.2018 / 17:11
0
answers

Business Intelligence - How and where to group school results?

Good people, I am developing a small project of Business Intelligence (BI) / Data Mining (DM) , with link to ambiente educacional (the data comes from a specific university discipline). Home The modelo multidimensional is as...
asked by 16.09.2018 / 23:00
0
answers

Working with Timeshift Shifts

I am structuring a new DataWarehouse that will eventually be consumed on a BI platform. I have already created some dimensions for my database, one of them was Dates , in which I break the date in several formats for future manipulation.  I...
asked by 08.05.2018 / 15:36