I have Year number and Month Number in my data. How using DAX can I get the month name out of month number? In SSRS its very easy. But how to achieve that using DAX?

I have problems with SSIS process(acctually the same problem occurs for two different processes). So, we are doing some ETL work using SSIS. We have Business Intelligence project that executes with...

What is the difference between fact tables and dimension tables? An example could be very helpful.

I have 2 use cases: Extract, Transform and Load from Oracle / PostgreSQL / Redshift / S3 / CSV to my own Redshift cluster Schedule the job do it runs daily/weekly (INSERT + TABLE or INSERT + NO...

While building a Calendar table with PowerQuery for a PowerPivot model in Excel 2013 I use its Date.QuarterOfYear function to get the number of the quarter. Building the same thing in SSAS Tabula...

We are using ElasticSearch for search capability in our product. This works fine. Now we want to provide self service Business intelligence to our customers. Reporting on the operational database ...

Currently, I'm using the Power BI Designer (newest version). I'm completely new to it. I'm wondering how to get the subtotal of a group of items and then get the report grand total. I only need the...

I don't have much expertise in Power BI. I started work on it and found it very easy and I've created a report. That report is working fine. Now, I've requirements to add Refresh button on the rep...

I'm trying to execute a python scrip from SSIS Execute Process Task. I followed all the tutorials of how to do this an still the script is failing from the start. when i execute the python script o...

I want to use an influxdb within the context of business intelligence: ETL, joining data from other databases, creating live dashboards. Right now, we are using standard BI-Tools such as QLIK or M...

I want to use Power BI Desktop within my MVC application. All I could find about this is coupled with uploading the data [1], [2] into a cloud but that is not an option for me since I am working wi...

I want to generate reports from my SQL Server tables. I have some already made stored procedures that I would like to use to generate reports from. I haven't found a way to do so. Only by rewri...

I've touched a Teradata. I've never touched hadoop, but since yesterday, I am doing some research on that. By description of both, they seem quite interchangable, but in some papers it is written t...

We have been using VS 2017 Shell version for BI development for a few months without problems but today it stopped unexpectedly and restarted on its own. After the restart, we got an error: Coul...

I've have SSIS Package that is exporting 2.5 GB OF DATA containing 10 million records into Sql Server Database which has 10 partitions including PRIMARY FILE GROUP. Before Changing default Max In...

I'm confused by the different products that Talend offer. It seems that Talend Open Studio for Data Integration and Talend Open Studio for Big Data are the same product but just with different com...

I'm developing a report in the Business Intelligence studio and I lost my dataset. The pane was near toolbox, and it is gone. What is the name of the pane I should to reopen?

I was searching for Business Intelligence SSDT tools on Visual Studio 2013. I found SSDT for Visual Studio 2012 here, http://www.microsoft.com/en-in/download/details.aspx?id=36843 Can w...

Hopefully this is easy to explain, but I have a lookup transformation in one of my SSIS packages. I am using it to lookup the id for an emplouyee record in a dimension table. However my problem is ...

I want to understand how surrogate keys are leveraged in real-time DWH environments. I get that they add the benefit of not being dependent on source-generated data to store each dimension key and ...

I have a new laptop with Visual Studio 2015 Enterprise and SQL Server 2016 CTP 3.1 installed on it. I want to develop SSIS & SSRS projects using this setup, but I am having a hard time getting ...

I have no experience at all with QlikView, but I have read great reviews about it. According to Gartner Research Report 2012, QlikView is in the top quadrant together with Microsoft, Oracle, SAP an...

I am using SSIS in Visual Studio 2008. I have many XML files that I need to process and place into an existing DB structure (SQL Server 2005). This is my first attempt at using SSIS and am a little...

Assume having the following DataFrame: rng = pd.date_range('1/1/2011', periods=72, freq='H') np.random.seed(10) n = 10 df = pd.DataFrame( { "datetime": np.random.choice(rng,n), "cat": np.random...

I have searched in the net what's the difference between additive, semi-additive, and non-additive measures in a data warehouse. I have found some results but I have difficulty understanding the di...