PowerBI MasterClass

Today, we are all surrounded with full of data.

Data can be in the form of structured data(eg: Tables, and worksheets), or unstructured data (free text fields or comments from social media). 

In the current modern world of Business Modelling, many organizations have leveraged the importance of having Business Intelligence(BI) to surface the business problems that could be found in their underlying transactional data. 

BI tools have helped a lot of organizations, either in preventing some dreadful losses in the business or in adding growth towards revenue.

BI has now emerged as a Marketing & Strategizing component to help organizations monitor the performance of a promotional event, whether the promotional event has attracted a lot of attention, or the promotional event did not benefit the organization.

Data is everywhere but if we do not transform the data into useful insight, we are not able to make the correct decision on a certain matter.

In this course, we are going to learn more about PowerQuery transformation steps:

• How to transform our columns to extract values or change column formatting
• How to add new columns, eg: Custom columns, conditional columns, index columns etc.

For the report table, we are going to explore more on DAX to help us with some of the common expressions that we used in reporting, eg: MTD/YTD DAX expressions.

Hope you enjoy the course and let's roll!