Business Analytics using Microsoft Power BI and AWS Redshift

A Data-Warehouse is a repository that fetches data from many diverse sources within an organization for Business-Reporting and Business-Analysis. The reports created from intricate queries within a Data-Warehouse are used to improve business process, make optimal judgements, and even announce viable advantages. Since the Organizational Data is increasing exponentially day by day hence in-house Data warehouse is getting obsolete and a new concept of Cloud Based Data Warehouse is emerging. The leading player in this cloud based Data-Warehouse is AWS Redshift. After the data is collated inside the Data-Warehouse, the next step is to retrieve some analytical data and use it to boost business acumen and subsequently increase business revenue and efficiency. The above business analytics can be performed using various tools. The market leader in this regard is Microsoft Power BI. In this paper, we will try to analyze the working of Microsoft Power BI in coordination with AWS Redshift. Prashant Dutta "Business Analytics using Microsoft Power BI and AWS Redshift" Published in International Journal of Trend in Scientific Research and Development (ijtsrd), ISSN: 2456-6470, Volume-3 | Issue-2 , February 2019, URL: https://www.ijtsrd.com/papers/ijtsrd21545.pdf