Most voted "business-intelligence" questions
13 questions
Sort by count of
-
5
votes1
answer140
viewsWhat is the difference between a Warehouse date and a Lake date?
Considering the concepts of data Warehouse and of data Lake, what notable differences we can cite between them?
-
4
votes2
answers888
viewsAre there BI/OLAP tools for the MEAN.JS platform?
Someone can indicate me a BI/ OLAP framework or at least a Chart Engine, preferably open-source, that integrates properly the platform MEAN.JS or MEAN IO architecturally SPA - Single Page…
angularjs node.js mongodb express business-intelligenceasked 9 years, 8 months ago Fernando Santucci 161 -
3
votes1
answer187
viewsCubes of some customers in Analysis Services
I intend to allow my customers to access their data to generate customized reports and use the power of Powerpivot Excel. Today all customers (business) are in the same database and for the little I…
-
2
votes0
answers434
viewsHow to Create 15 minute SQL Interval?
I have a field timestamp and I need to create an interval every 15 minutes. How in Sql I should do this ? Data = YYYY/MM/DD HH:MM:SS The purpose is an analysis where I need the amount of products…
-
2
votes0
answers356
viewsWhat are the advantages of using a Snowflake model, Star, 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 bases, excels and "instantly generate B.I systems". This gave me some…
-
1
votes0
answers29
viewsMobile Report - Reporting Services 2016
This is my first post in the community and I hope to be able to collaborate with my question. I am working on a BI project where I need to show a quantitative number of calls on a map, according to…
report sql-server-2012 reporting-services sql-server-2014 business-intelligenceasked 7 years, 8 months ago Rafael Lima 111 -
1
votes2
answers123
viewsGenerate dynamic table 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 as well. If I set it up to take the data and put it right on the dynamic table,…
-
0
votes1
answer588
viewsHow to calculate the sum of a group in MDX
I need to create a Calculation in SQL Server Data Tools. Imagine that in my structure OLAP I have the City and Dealer Dimensions, and a Sales Fact. In the City dimension I have City, State and…
-
0
votes0
answers65
viewsField ordering in Power BI
I have three camps in my Cartão de linha múltipla (This is the translation in Portuguese): Account, balance and % sale. However I need to sort by the order field, which is not in the Campos of the…
-
0
votes0
answers23
viewsSQL - Managed Table vs External Table
I bring a less technical SQL question. I use Hadoop’s Hive tool to manipulate the data with SQL. And I would like to know a real situation where I should apply a Managed table and a External table.…
-
0
votes1
answer31
viewsQLIKVIEW Formula to feed POISSON
I need help finding the value for a formula POISSON I have the table below: With the formula POISSON excel =POISSON(10;11.97;TRUE) I get the value of 35.07% =POISSON( Numero de Peças ; Peças…
-
0
votes0
answers20
viewsWorking with Shifts in Dimension of Hours
I am structuring a new Datawarehouse that will in the future be consumed on a BI platform. Already created some dimensions for my database one of them was the Dates, in which I break the date into…
-
-1
votes1
answer262
viewsI cannot assign return of the expression in the SSIS variable
Task to insert Variable Value by select result My intention with this logic is to pass a column calculated from one excel file to another using an area of Stage where I just want to modify a column…