Power Query in Power BI

 

DATA TRANFORMATIONS THAT WE NEED TO DO WITH THE DATA, BEFORE IT IS LOADED IN DATA MODEL FOR ANALYSIS AND VISUALIZATION.

AS YOU KNOW, YOU CAN CONNECT TO ALMOST ANY DATA SOURCE AND PULL DATA IN POWER BI, WHETHER SUCH DATA IS STRUCTURED OR UNSTRUCTURED.

IT MAY BE A CSV OR AN EXCEL FILE, SQL OR AZURE DATABASE, ORACLE OR SAP HANA DABASES, ONLINE OR WEB DATA SOURCES.

THE DATA HOWEVER DOESN’T NECESSARILY COME IN A FORMAT THAT IS BEST SUITED FOR CREATING AN OPTIMUM AND EFFICIENT DATA MODEL AND CREATIVE AND MOST MEANINGFUL VISUALIZATION.

WE NEED TO TRANFORM THE DATA BEFORE IT IS ANALYZED. POWER QUERY, WITH ITS RICH GUI AND M (MASH UP) LANGUAGE CAN ALMOST DO ANYTHING AND TRANSFORM DATA.

SO POWER QUERY IS POWER BI’S ‘ETL’ ENGINE.

THIS ONE DAY TRAINING COURSE ON ‘POWER QUERY FOR POWER BI’ IS ABOUT DATA TRANSFORMATION IN POWER BI.

[THERE IS A SEPARATE COURSE ON ‘POWER QUERY AND ADVANCE TRANSFORMATION’ COMING UP VERY SOON]

AT THE END OF THIS COURSE, YOU WILL BE ABLE TO –

• GET FULLY FAMILIAR WITH POWER QUERY GUI.
• KNOW THE BASIC DATA PREPARATION CHALLENGES.
• DIFFERENTIATE AND CREATE FACT VS LOOK UP TABLE.
• MERGE TABLES AND APPEND TABLES.
• PIVOT AND UNPIVOT DATA.
• EXTRACT INFORMATION FROM TEXT MESSAGES.
• CREATE A DATE TABLE.
• UNDERSTAND WHY A DATE OR A CALENDAR TABLE IS REQUIRED IN ANALYSIS.
• COMBINE DATA FROM MULTIPLE SOURCES.
• DUPLICATE VS REFERENCE QUERY TABLES.
• UNDERSTAND DIFFERENT MODES OF CONNECTION. IMPORT VS DIRECT QUERY VS LIVE CONNECTION.
• CONNECT TO SQL DATABASE – WITH DIRECT QUERY CONNECTION MODDE AND QUERY FOLDING.
• CONDITIONAL COLUMN AND CUSTOM COLUMN.
• ALTER THE POWER QUERY WITH M CODE.
• PARAMETER QUERY AND FUNCTION.