Practical-6

Aim: Introduction to PowerBI and Get started with PowerBI, Prepare data for analysis and Model data in Power BI.

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.