Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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

0
votes
1answer
17 views

SSRS and DBA Scope

Just a quick questions regarding DBAs, recently I was asked about the scope of DBA in terms of SSRS and BI, in your experience who handles and maintain/configure your SSRS, is this part of the DBA or ...
0
votes
0answers
11 views

Business Intelligence for developers

I'm a developer with apps backed with SQL databases. I want to give my CEO access through BI self-serving tools such as PowerBI or Tableau. My issue is that the affordable tools all seem to require ...
0
votes
0answers
44 views

Are there any open source OLAP / MDX systems?

Context: I'm familiar with various databases however I need to execute BI queries on a dataset of a few million records. I believe the proper term for what we need is a data warehouse. The output of ...
0
votes
1answer
145 views

Load New Foreign Key in Facts Table, When Update Dimension with SCD Type 2

I'm working on the production of a Data Warehouse with SSIS, and today we create the first dimension with SCD of type 2. The fact table is linked in the DIM_CIPESSOA dimension through the idcipessoa ...
3
votes
2answers
309 views

Always On Availability Groups as a Secondary Read Only Database [closed]

I am working on setting up a secondary copy of our prod DB for Data Warehousing and even something we can possibly use to offload other processes and reporting on. Basically just a read only copy of ...
1
vote
1answer
448 views

'Refreshing' SSRS subscriptions (parameter values not valid due to lack of data in the tables)

In a place where I work we have lots of subscriptions set for SSRS reports. Some reports have as many as 100 subscriptions set up. Our data warehouse is refreshed every night, with all the data ...
1
vote
0answers
56 views

Where to start for DW/BI project?

I work for a small technology MSP. Having just completed my Bachelor's in Information Science, with a focus in data science, my boss has asked me to build a data warehouse (I think he really means a ...
2
votes
3answers
103 views

How to create a normalized database to manage inventory for a small business? [closed]

I am writing a Java application to manage the inventory of a small furniture business. I know little about databases, I have a bit of experience with SQL queries and more experience with Java ...
0
votes
0answers
19 views

Upgrading Oracle BI Server from version 10 to 12

We have a huge suite of reports currently running on Oracle BI Server, on a Windows Server 2008R2 platform. There is a requirement to upgrade the Server and the OBI version, so my thoughts are to do ...
0
votes
0answers
56 views

Web based business intelligence tool using dc.js or olap for web application dashboard

I have a Mysql database. I want to perform multidimensional analyse on this database and build web-based dashboard. I got little confused between using classic OLAP server like mondrian or SSAS or ...
0
votes
2answers
40 views

Is ELT appropriate for life critcal applications such as Medical Systems when converting to a new application? [closed]

My small experience with ELT and reading makes it look like it is mostly for development. Because the data is not cleaned up like in ETL that makes me think the new application will need to adapt its ...
7
votes
2answers
849 views

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 ...
0
votes
1answer
398 views

Complicated SSRS layout - is that possible?

I have been ordered to do a report with a pretty sophisticated table layout. Okay, it's not that sophisticated, but we all know how SSRS is with those things. I am pretty certain that layout cannot be ...
2
votes
1answer
58 views

Which BI solutions cooperate with Postgres database and aren't too expensive? [closed]

I'm looking for solution letting me and my team track changes in Postgres database with daily updates. Data doesn't have to be updated instantly, once a day is enough. We use Excel/Google Sheet ...
1
vote
2answers
2k views

Import data into MySQL using Talend Open Studio

I have been trying to import CSV data about 60Mb, but contains about 400,000 rows, which should not be too much. I used these ways to import the data: 1) MySQL Workbench - it took about 2hours!!! 2) ...
2
votes
1answer
380 views

Data into Star Schema's fact or dimension table?

I'm working on creating a Star Schema for my internship that I want to use for reporting on the company's pre-sales process. The aspects of the pre-sales process that I want to report on, are: Sales ...
1
vote
1answer
205 views

Star Schema - One dimension or split

We have a Data Warehouse, which has two dimensions, Product and ProductLine. Product has just one entry and there is just one ProductLine with a description that changed from transport to Transport. ...
2
votes
0answers
262 views

BI - Sales Fact Table Header and Detail Dimension

I have a FactSales table that is down to the line item. I also have a sales order detail dimension that contains attributes that don't belong in the fact table. Now, I'm in need of incorporating ...
3
votes
1answer
83 views

How to show when loan was paid off

First time posting but have been a reader for over 10 years. I have a need to show when a loan was paid off regardless of the rolling balance from refinancing/taking out additional loans. In the ...
3
votes
1answer
931 views

Star Schema from Relational Database

I'm a newbie to data warehousing and I've been reading articles and watching videos on the principles but I'm a bit confused as to how I would take the design below and convert it into a star schema. ...
1
vote
1answer
430 views

SSDT - Unresolved Reference to temporary table in linked server

Here's the scenario. I am extracting data from a table in an Oracle database via a linked server as part of an ETL process. I am developing the solution in Visual Studio 2013 with SQL Server Data ...
0
votes
2answers
46 views

What can be used with SQL Server 2014 native tools, for Business Inteligence?

We're trying to achieve better reports using native tools from SQL Server 2014. I'm a DBA, and I don't know so much about c#, c++ and etc. I know also, that we have Analysis services, SQL Server ...
1
vote
1answer
455 views

SSIS push and pull performance

After reading Which one is more efficient: select from linked server or insert into linked server? I wonder if this is true also for SSIS? For example, I have 2 SQL Servers (A and B) and SSIS ...
4
votes
2answers
2k views

For a standby workload of long running analytical queries, is it better to turn on hot_standby_feedback or set max_standby_*_delay settings to -1?

When spinning up a hot standby server specifically for BI/Analytics purposes where long running queries may be common, is it better to turn on hot_standby_feedback or set the max_standby_*_delay ...
1
vote
1answer
279 views

SQL Server + Microsoft Business Intelligence — free version or online learning environment?

I have some experience writing queries and stored procedures in SQL server. I would like to learn how to use the Microsoft Business Intelligence tools (SSIS/SSAS/SSRS). There are loads of books, ...
1
vote
1answer
3k views

Business Intelligence Development Studio installation for Visual studio 2010 problem

I want to install Business Intelligence Development Studio for doing report development in Visual Studio 2010, however in my installation process, I cannot find BIDS in the feature selection. What I ...
0
votes
0answers
40 views

Is it possible to have SSRS generate report while a parameter is being typed?

I have only been using SSRS for a few weeks now and from what I have seen, I know that we create a dataset, define parameters (I do it by using a paramaterized stored procedure and linking that to a ...
0
votes
1answer
58 views

Change SSIS package location (REPOST from SO) [closed]

My SSIS Package are located in shared drive with a long path name. To make the packages easier and not to remember long path name, I use "Map my network drive" option and use X: drive as an alias to ...
2
votes
3answers
53 views

Data Warehouse attribute that describes its timeframe?

I am writing a document about a Data Warehouse system, and would like to know if is there a single word (noun) that describes the DW attribute of how many time it contains? I mean, if a DW contains ...
-1
votes
1answer
2k views

Adding a Quarter column every three months in a report in SSRS

This is driving me a bit bonkers. It seems like it should be easy but SSRS has me stumped. I want to create a report of our customers displaying the monthly sales totals and display the Quarter ...
4
votes
2answers
260 views

BI and DBA dev , where to start [closed]

I've read a lot about business intelligence development and database development, too. I have tried to work my way around a couple of courses on SQL Server 2008 however I feel kind of lost and I have ...
3
votes
1answer
60 views

Are there best practices or standardized syntax for writing transformation logic?

This may not be the appropriate forum, but its the closest I could find. I write a lot of source to target mappings for work. These documents just describe the operations/logic/transformations/etc. ...
1
vote
1answer
579 views

How to load .dat files to oracle database

I have .DAT files extracted from telecom switch. I want to upload this file to an Oracle server using IBM data-stage ETL tool. Unfortunately these files are not readable format. This is a picture ...
1
vote
1answer
964 views

MDX Max, Average and StDev functions not giving correct results

I have a scenario where I have Date dimension and Time dimension along with some other dimensions. The time dimension contains only Hours since there was no need to save data at minute or second level....
2
votes
2answers
2k views

Have a separate database for data warehousing?

I have built a typical web application using PHP and MySQL for enterprise usage. The MySQL database is 3NF as much as possible. However, as time goes by, the requests for the data appear to be more ...
4
votes
1answer
705 views

What known strategies, if any, can I use to validate a Slowly Changing Dimension?

I have a customer dimension in our data warehouse (SSAS 2014 Multidimensional). It is set up as a Type II SCD, with just Start and End Date fields to track changes. (null end date = current). As our ...
0
votes
1answer
1k views

RapidMiner Not Connecting To SQL Server Database Connection

I recently installed RapidMiner and tried connecting the application to my MS SQL database connection via the Manage Database Connections feature. I have followed video tutorials on integrating SQL ...
4
votes
2answers
340 views

Is it good or bad practice to have a fact table relate to the same dimension table multiple times?

I'm new to DW/BI, and this seems like a pretty basic question, but I can't seem to find a good answer. I have a fact table that would have more than one date associated with it, so I was thinking ...
1
vote
1answer
2k views

SQL Server 2012 Business Intelligence licensing

I have Microsoft SQL Server 2012 Entreprise Edition license, What are the tools needed to work on SSIS/SSAS/SSRS? Since BIDS was replaced with SSDT on the 2012 version, does it mean I will need to ...
2
votes
2answers
3k views

2 SSRS Instances, one in native mode and one in sharepoint integrated mode with PowerPivot and PowerView on same server

Wanted to know if I can have two SSRS instances on the same server, one in native mode and one in SharePoint integrated mode. I have one SSRS instance in native mode on a SQL server default instance ...
3
votes
0answers
2k views

How to insert values into Bridge Table in star schema?

I am modelling my database with respect to star schema with bridge tables. My master Table looks like below. I need to convert this format to star schema. MasterTable StudentNumber | Subject1 | ...
-1
votes
1answer
47 views

Use Oracle 10g BI enterprise edition with Oracle 11g database

Can i use Oracle 10g BI enterprise edition with Oracle 11g database. please tell. Thanks.
2
votes
1answer
68 views

Modeling Conversion Events in a Data Warehouse

How should I model conversion events? For instance, if a sales opportunity goes from "stage: prospecting" to "stage: validating", should that be treated as a changing dimension, or a conversion event ...
1
vote
2answers
945 views

Business Logic in Data Warehouse

my question is: Should business logic be stored in the data warehouse data store? Or should it only exist in the reporting applications? To give a more concrete example: In the CRM operational ...
0
votes
2answers
5k views

How to choose suitable naming convention for Dimensional Table Column in a Data Mart?

I have done a lot of reading on naming columns for use in a data mart / data warehouse, as well as for general programming usage. For example, if I had a business branch in a normal application I ...
8
votes
1answer
15k views

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] ...
0
votes
1answer
364 views

How do I choose primary keys for star schema BI data warehouse?

I am extracting sales turnover data from a Microsoft Dynamics Database into another SQL database that will be used by the BI tool of choice. This data is coming from G/L (general ledger) entry items. ...
4
votes
1answer
542 views

Search, filter and group across all columns in a tall and wide dataset quickly [closed]

We have certain datasets which may span 80 to 300 fields, across 300,000 to 35 million rows. For each dataset, we want to produce a web based analysis tool (a web grid) which would allow our users ...
1
vote
2answers
844 views

Using a data warehouse staging database as a source of operational data

Should you use the staging database within a data warehouse as a source of operational data? ie, is it good practice for other operational (non BI) systems to source their data from this database? ...
0
votes
0answers
68 views

Merge data using Integration Service

Please Consider this scenario: I have a table in my database. I want move this data in my OLAP database using SSIS.I can move all record from my table to OLAP database.The problem is I don't know how ...