POWER BI AND POWER QUERY

POWER BI is a data analysis tool [ Software] which can help us to analyze the data in the lightening speed. Power Query is a formatting tool which can format thousands of lines of data within seconds.

As the complexities of the businesses are increasing day by day, so is the number of data from various inputs, which are required to make the correct business decisions. In such a VOCA world, we can’t rely on any one or two inputs .

So, for such a scenario , we are in requirement of such a tool which can help us to get the data from various sources and analyze it in real time.

NOTE: You don't need any prior knowledge  of POWER BI or POWER QUERY.

IN THIS PAGE, YOU'LL FIND THE DIFFERENT ARTICLES WHICH WILL HELP YOU LEARN THE USE OF POWER BI AND POWER QUERY FROM THE SCRATCH.

CHOOSE THE TOPIC OF YOUR CHOICE

INTRODUCTION TO POWER BI

INTRODUCTION POWER BI is a data analysis tool [ Software] which can help us to analyze the data in the ...

LEARN DATA SOURCES IN POWER BI

Table of Contents INTRODUCTION TYPES OF DATA SOURCES IN POWER BI LIST OF DATA SOURCES IN POWER BI: STANDARD PROCEDURE ...

HOW TO IMPORT DATA FROM DATABASE IN POWER BI ?

Table of Contents INTRODUCTION PROCEDURE TO IMPORT DATA FROM OTHER DATABASE IN POWER BI [MICROSOFT ACCESS] CREATING THE CONNECTION TO ...

HOW TO IMPORT DATA FROM CSV FILE INTO POWER BI

INTRODUCTION POWER BI is a data analysis tool [ Software] which can help us to analyze the data in the ...

HOW TO IMPORT DATA FROM WEB INTO POWER BI

INTRODUCTION POWER BI is a data analysis tool [ Software] which can help us to analyze the data in the ...

HOW TO IMPORT DATA FROM EXCEL INTO POWER BI

INTRODUCTION POWER BI is a data analysis tool [ Software] which can help us to analyze the data in the ...

WHAT IS POWER QUERY? HOW TO USE POWER QUERY?

WHAT IS POWER QUERY? HOW TO USE POWER QUERY? INTRODUCTION If you have been using the MICROSOFT EXCEL software for ...

HOW TO CONVERT COLUMNS TO ROWS IN POWER QUERY

Table of Contents INTRODUCTION GETTING THE EXAMPLE READY INTRODUCTION If you have been using the MICROSOFT EXCEL software for some ...

HOW TO CONCATENATE COLUMNS IN POWER QUERY FOR POWER BI

Table of Contents INTRODUCTION WHAT IS CONCATENATION HOW TO CONCATENATE COLUMNS IN POWER QUERY DATA FOR THE EXAMPLE PREREQUISITES FOR ...

HOW TO CONCATENATE CUSTOM TEXT TO COLUMNS IN POWER QUERY

INTRODUCTION If you have been using the MICROSOFT EXCEL software for some time, you must have heard or read about ...

HOW TO CHANGE UPPERCASE OR LOWERCASE IN POWER QUERY

Table of Contents INTRODUCTION WHAT DIFFERENT KINDS OF CASES AVAILABLE TO CHANGE IN POWER QUERY? HOW TO CHANGE THE TEXT ...

HOW TO REVERSE ROWS IN POWER QUERY

INTRODUCTION If you have been using the MICROSOFT EXCEL software for some time, you must have heard or read about ...

HOW TO SPLIT COLUMN IN POWER QUERY

INTRODUCTION If you have been using the MICROSOFT EXCEL software for some time, you must have heard or read about ...