PRACTICAL 6

 Practical 6

AIM:

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

THEORY:

Power BI 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.

Power BI and its Counterparts:

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 Power BI 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. 

Power BI 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

Power BI is robust tool comparing it with its counterparts like Tableau, Quicksight etc. Power BI 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. Power BI also has Mobile app which makes it easier to share the report created.

ETL Process in Power BI:

Extract-Transform-Load process is the main base to start with Power BI. 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.

Step 2: Transform and Prepare Data for Analysis.

Step 3: Transform window and process for Load and below is the snapshot of loaded dataset.

Dataset used for Visualization in PowerBI:

This data set is created only for the learning purpose of the customer segmentation concepts , also known as market basket analysis . I will demonstrate this by using unsupervised ML technique (KMeans Clustering Algorithm) in the simplest form.

Stacked Bar graph

Stacked Column graph

Line chart

Area Chart

Pie Chart

    Ribbon chart