Questions tagged [business-intelligence]
The business-intelligence tag has no usage guidance.
14
questions
1
vote
1
answer
105
views
Guideline choosing between reporting solution or application front-end
I am working in the data department of a middle-sized logistics company who is shifting from an 'old-school' on-premise BI data warehouse to a more 'modern' cloud-based data lake approach.
Another ...
- 13
-1
votes
1
answer
554
views
Agile approach in ETL/ELT development
What are the pros and cons of using agile/iterative approach in ETL/ELT (Extract Transform Load or Extract Load Transform) data warehouses/data lakes/lakehouses systems development?
I often find that ...
- 141
1
vote
1
answer
414
views
MS SSIS as good approach for two-way data synchronization
We have SQL Server databases in every retail store, and one database in main office. We want to collect data from all stores and load the main DB (for BI), but we also want to sync data from main DB ...
- 121
1
vote
2
answers
2k
views
Using Entity Framework as substitute for SSIS, SSAS and SSRS
At the moment I have three different sources where my data are. 1. A Dataprovider, 2. inhouse access DB and 3. Salesforce. Now I want to build a datawarehouse (using ms software) where I want to store ...
- 133
0
votes
2
answers
2k
views
What are the advantages of a 3 stage environment for SAP/BI development?
I have recently joined a team in which the developers were able to work completely in live production to produce business intelligence products for customers.
Recently, management, at the advice of ...
- 117
0
votes
1
answer
134
views
How to avoid re-implement business rules in Business Intelligence tools
I have a question about business rules and Business Intelligence tools.
The team working on Business Intelligence report tries to re-implement business rules in their report. Our application does ...
- 1
7
votes
4
answers
19k
views
The best possible way to implement Business Rules in PHP
I'm planning to write an e-commerce app using PHP & MySQL with lots & lots of custom rules. Say for example, I want to have a rule like "Give Customer X, a 10% a discount for Product Y if he ...
0
votes
3
answers
416
views
How to Protect Intellectual property violations from one's own team [duplicate]
I have an android app idea, I want to make the app along with a few batch-mates in my collage.
(1) How do I make sure that these guys will not compromise the intellectual properties involved? In the ...
user52009
5
votes
1
answer
1k
views
What would Business Intelligence (BI) developers look for in code reviews?
Let me preface this with saying I am not a Business Intelligence (BI) developer. I'm a .NET developer, and I have only a vague notion of what BI is, and encompasses.
I've been an evangelist for a ...
- 421
4
votes
1
answer
754
views
Algorithm to denormalize database
I have built a QlikView script generator (QVS), that can be used to generate large script files for data imports from SQL Server to QlikView.
QlikView does not like 'fully' normalised database ...
- 169
3
votes
4
answers
1k
views
Are developers expected to have skills of business analysts? [closed]
Our business analyst has left the team. We are now expected to do the work which was previously done by the business analyst, and the management thinks that a task which is done in three months by a ...
- 1,246
3
votes
2
answers
1k
views
What can I do to help users create self-service reports?
I work using Reporting Services 2008 and I'm constantly creating ad-hoc reports. We'd like to use PowerPivot on Sharepoint but we're stuck on Sharepoint 2007. Using easy reporting software like ...
- 143
5
votes
2
answers
7k
views
What's the best way to learn the MS Business Intelligence stack? [closed]
What's the best/easiest way to get into the MS BI stack on my own (preferably with a [kindle] book)? Specifically, I'd like to learn more about SSIS, SSRS, and SSAS in that order. I've tried looking ...
- 181
0
votes
1
answer
1k
views
Testing BI (Business Intelligence) systems on the MS stack
I'm placing my first steps in the Business Intelligence sector and I'm looking for good ways to test BI systems. I'm going to try to explain what my system consists of so that people unfamiliar with ...
- 1,810