Blog - xSai Consulting

Creating Date Dimension in Microsoft Power BI

Background Date/Time dimension is very common and is used in any BI solution. Because any business would like to get business insights and see how their business has done in the past and is going to perform in the future. Whether it’s CFO of a company or Sales/Marketing team they would like to analyze their key...

Business Intelligence & Business Analytics in Simple Terms

I had gone to Park Royal Industrial Area in London with my friend to meet one of his clients who runs an Import/Export Distribution business and his company was specializing in all types of tiles. This company has his office in one of his warehouses. He had three additional warehouses in the same premises.

Improving Customer and User Experience in the Hospitality Industry

Use of cloud based systems in place of POS terminals can ensure better customer and user experience for businesses in the hospitality industry.

A sequel to my article “Task Tracker off-line web application for Mobile using HTML-5, jQuery-UI and KNOCKOUT.js

In this sequel to my earlier article, some additional features are covered.

Frustrated with losing internet connection?

Quickly maximize timely deliverables for real-time schemas. Dramatically maintain clicks-and-mortar solutions without functional solutions. Efficiently unleash cross-media information without cross-media value. Quickly maximize timely deliverables for real-time schemas without solutions.

Using Pivot and UnPivot in Transact-SQL (Part-1):

Background: One of the common scenarios we need to handle in the Data Integration process is to Pivot or UnPivot the input data received from external systems such as ERP or Finance systems. Microsoft SQL-Server provides two very good Transact-SQL commands Pivot and UnPivot to handle such transformations. In this part-1 series of this article

Building Dimension Hierarchies in Microsoft Power BI

Background Fig 1 Power BI Desktop with Date Dimension Whenever we build any Business Intelligence solution then at the heart of it is Design of robust data warehouse. Any data warehouse will consist of cubes or facts and dimensions. Within dimension the dimension hierarchies are very useful to group the dimension members in...

Latest News & Blog