Getting Started with Power BI: Prepare data for Analysis and Model Preparation
What is Power BI?
Power BI Desktop is a free tool that enables you connect to, transform, and visualize your data on your local computer. With Power BI Desktop, you may connect to a variety of data sources and integrate them into a data model (a process known as modelling).This data format allows you to create visuals and collections of visuals that you can share as reports with others in your company. The majority of customers who work on business intelligence projects utilize Power BI Desktop to develop reports and subsequently share them with others via the Power BI service.
The following are the most typical uses for Power BI Desktop:
- Connect to information
- To construct a data model, transform and clean the data.
- Create graphics that give visual representations of the data, such as charts or graphs.
- On one or more report pages, create reports that are collections of graphics.
- Use the Power BI service to share reports with others.
Visualization Types In Power BI:
- Area charts
- Bar and Column charts
- Card
- Combo charts
- Decomposition Tree
- Funnel chart
- Maps
- Pie chart, etc
The Power BI home screen
- Ribbon — Shows common tasks connected with reports and visualizations in the task bar below.
- Fields Pane — Shows you the tables, folders, and fields in your data you may use to create visualizations.
- Visualizations Pane — Where you can change visualizations, customize colors or axes, apply filters, drag fields, and more.
- Filter Pane — This is where you can apply filters to your images.
- Report View or Canvas — Visualizations are produced and arranged.
- Report, Data, and Model views — Select the icons in the left column to transition between Report, Data, and Model views.
- Pages tab — This is where you would select or create a report, and it is located at the bottom of the page.
The following association between fields will be established.
Lets get started with Power BI!
Loading dataset in excel format
Review the dataset before loading the dataset.
You can view your data in tabular form by clicking Data icon.
Preparing data for analysis
You can view model view of data by clicking model icon.
Hence we have learned about Power BI tool and how to use Power BI Desktop and created the dataset model as we wanted.