Power Query Is Everywhere

Power Query Is Everywhere

If you’re a Power BI practitioner, Power Query is the data connectivity and preparation technology that you’re inherently familiar with. It enables users to easily connect to hundreds of data sources and reshape the data to fit their needs, with a no-code, low-code...
Learn the Workings of Power BI

Learn the Workings of Power BI

Power BI is a new age business analytics tool that is created to provide interactive visualizations and business intelligence services using a very simple interface that can be easily understood and operated by the users. The main aim of this tool is to increase...
On Premise Licensing – Power BI vs Tableau

On Premise Licensing – Power BI vs Tableau

Recently, a customer who uses BI systems built by us on the Microsoft platform, wanted to explore the feasibility of using Power BI to spearhead self-service, data driven decision making across their organisation. Currently their reports were created in silos,...
Part 3: Data Storage Recommendations

Part 3: Data Storage Recommendations

Size Of Data Warehouse The storage design (hardware & data modelling) vary based on the size of the data warehouse. Broadly, there are three different sizes of data warehouse: Small-Size Data warehouse: DWH databases ~ 200 GB Medium-Size Data warehouse: DWH...
Part 2: Data Storage Approaches

Part 2: Data Storage Approaches

In a Data Warehousing platform, data is classified into two categories; as follows, Hot Data  (Frequently accessed): data which needs to be live and immediately accessible to the user is Hot data. These data will be stored in the Data Warehouse and distributed to the...
Part 1: What is a Data Warehouse?

Part 1: What is a Data Warehouse?

A data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management’s decision-making process. Great. But what do these terms actually mean? Subject-Oriented: A Data warehouse is built and used to analyse any...