Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [business-intelligence]

A collective term for the field of developing reporting and analytic systems, often associated with data warehousing.

Business Intelligence (B.I.) is a broad term that covers reporting and analytic systems and the discipline of developing and maintaining them. B.I. can encompass manual processes using desktop tools or integrated server based reporting and analystic systems backed by a data warehouse.

Normally the term is associated with data warehousing but a data warehouse system need not be present in order to implement a business intelligence platform.

96 questions
48
votes
7 answers

How to determine if an Oracle table is locked or not?

We've been using BI software and a repository database that are installed on Oracle Enterprise 11gR2. Some of these batch reports will try to access a database table which may still be locked. How can I find out if an Oracle table is locked or not?…
Selahattin
  • 621
  • 1
  • 6
  • 6
25
votes
3 answers

What are the arguments in favor of using ELT process over ETL?

I realized that my company uses an ELT (extract-load-transform) process instead of using an ETL (extract-transform-load) process. What are the differences in the two approaches and in which situations would one be "better" than the other? It would…
HelloWorld1
  • 797
  • 2
  • 8
  • 16
23
votes
2 answers

What are Measures and Dimensions in Cubes

I'm new to Microsoft SQL Server Business Intelligence and Analysis Service (but I've been programming for years with SQL Server). Can any one describe Measures and Dimensions in Cubes in simple words (If it's possible with images)?
DooDoo
  • 203
  • 1
  • 3
  • 13
18
votes
6 answers

Can you give me one example of Business Intelligence?

I don't really understand what Business Intelligence is all about. If I start from having a corporate DB, what is it that a BI person would do? I found plenty of material on the web, but it usually is a bit too complex. I want a simple example that…
Ryan
  • 281
  • 1
  • 2
  • 3
17
votes
2 answers

Recalculate Time Dimension in BIDS

I'm using BIDS to create a cube in SSAS 2008 r2. I used the wizard to create a time dimension. Part of that configuration is selecting a date range. After creation, I realized that I needed a wider date range than I originally specified. I did find…
JNK
  • 18,064
  • 6
  • 63
  • 98
17
votes
2 answers

Open Source Business Intelligence/DWH solutions

I wonder that this question hasn't already been asked. Google only has very few results for me that don't show a high quality tool What are some Open Source (also free is ok) solutions for Data Warehouses and more specifically Business Intelligence…
DrColossos
  • 7,447
  • 2
  • 33
  • 30
14
votes
2 answers

Will SSRS be extinct soon, and PowerBI the new model?

I read SQL Server 2017 will now include PowerBI Server. They also moved SSRS to a different installer, so it will not come packaged in the original SQL Server installation. Does this mean Microsoft will eventually try to deprecate SSRS? Should our…
user129291
8
votes
4 answers

What advantages does in-memory OLAP have over traditional systems with significant memory?

Do in-memory OLAP engines have advantages over the traditional OLAP engines backed by enough RAM to contain the entire cube(s)? For example, if I use a MOLAP engine (SSAS) and GB / TB of RAM where the entire cube (or even star-schema) is RAM…
kermatt
  • 403
  • 2
  • 8
8
votes
2 answers

Best approach for populating date dimension table

I am looking to populate a date dimension table in a SQL Server 2008 database. The fields in the table are as follows: [DateId] INT IDENTITY(1,1) PRIMARY KEY [DateTime] DATETIME [Date] …
JohnLinux
  • 255
  • 1
  • 4
  • 9
8
votes
2 answers

How should I configure these disks on a SQL Server for a BI configuration?

Assuming constant memory (32gb) and CPU (4), 2 x disk arrays, I have the following disks 2 x 150 (10k) 6 x 150 (15k) They are all local disks. My requirements My DB is 350gb and set to default 10% growth My OS & SQL Server are Server 2k8R2 (C:…
Preet Sangha
  • 907
  • 4
  • 11
  • 22
8
votes
4 answers

How do you roll up header-level values on a fact table with line-item granularity?

From what I've read, the recommended granularity for a fact table based on an order header / line item structure is at the line item level. In the process, any additive values that apply only to the order header are repeated for each line item:…
8kb
  • 2,639
  • 2
  • 32
  • 36
6
votes
1 answer

How to report on sparse areas of sparse fact table

A source system tracks student attendance for a school district by reporting absence events. Attendance on any particular day can be determined by examining three datasets: school calendar, student enrollment, and absence. On any given school day,…
Gary Clarke
  • 161
  • 3
6
votes
3 answers

Find material for improvement in Microsoft BI

Which websites, books etc. can you recommend me to improve my basic knowledge in Microsoft Business Intelligence 2008, SSAS, SSIS and SSRS? Please remember that I'm a newbie in technical BI tool. If possible, it would be great to retrieve any…
HelloWorld1
  • 797
  • 2
  • 8
  • 16
6
votes
1 answer

How do I display subtotals in cube browser in SSAS 2012 (Sql Server Data Tools)?

Apparently this feature was available in previous versions but has now been removed. What are some alternatives?
Sarah
  • 61
  • 2
5
votes
1 answer

Fact table design - Level or contribution measures

I am trying to come up with a dimensional model for the following: The source data comes from game machines as meter messages. Basically, the game machine accepts payments and sends a snapshot of the current values of several measures. The message…
Ali_Abadani
  • 153
  • 3
1
2 3 4 5 6 7