Practical 6

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

Theory:

• PowerBI - Power BI is an analytics tool developed by Microsoft that turns your bits of unstructured data into a visually compelling story. It consists of the Power BI Desktop, the SaaS Power BI Service, and a range of mobile apps (iOS and Android compatible). These tools take big data and help your business or organization ask the right questions and receive actionable insights. Power BI takes information from disparate data sources and turns them into custom visuals designed to help an organization not only read the info but get a clear idea of what to do. The right data visualization can be the difference between having unstructured data that disappears and using that data to make critical (and more importantly, correct) decisions.

• Types of visulaisation:

• 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.

Dataset Description:

Data columns (total 9 columns):
 #   Column                    Non-Null Count  Dtype  
---  ------                    --------------  -----  
 0   Pregnancies               768 non-null    int64  
 1   Glucose                   768 non-null    int64  
 2   BloodPressure             768 non-null    int64  
 3   SkinThickness             768 non-null    int64  
 4   Insulin                   768 non-null    int64  
 5   BMI                       768 non-null    float64
 6   DiabetesPedigreeFunction  768 non-null    float64
 7   Age                       768 non-null    int64  
 8   Outcome                   768 non-null    int64  

(768, 9)