Getting Started with PowerBI

Theory:

PowerBI is a powerful business intelligence tool developed by Microsoft that helps users create interactive visualization using business intelligence. Best part is users could create appealing reports and actionable dashboards by themselves without taking external help.

PowerBI and its Counterparts.

Which different types of visualization it provides:

Area Charts, Bar Charts
Clustered Column Charts
Doughnut charts
Line Charts
Scatter charts
Candle Stick
Map
Pie Chart
KPI
Other Charts can be imported from Market place

Visualization in PowerBi can be dynamic based on the feature selected. It has dynamic flow for all the diagrams or charts that are created in a Dashboard. It has ability to change the values and display based on page, reports etc.

PowerBi has various ways to import data for analysis. It has sources like:

CSV
Excel Sheet
MySQL Database
API
Web Scrap URL
Azure Data sources
Others

PowerBi is robust tool comparing it with its counterparts like Tableau, Quicksight etc. PowerBI give you the power to maintain dashboards with other Microsoft's other application like Word, Powerpoint Presentation, Excel etc. This is the best feature which also allows access to Azure cloud. PowerBi also has Mobile app which makes it easier to share the report created.

ETL Process in PowerBI:

Extract-Transform-Load process is the main base to start with PowerBI. It has power query that allows users to process and transform the data according to the requirements.

Step 1: Set the source of the data or import the data.