Getting started with PowerBI — Modeling the data
Power BI Desktop is a free tool that enables you to 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 modeling). 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
Power BI has various ways to import data for analysis :
- CSV
- Excel Sheet
- MySQL Database
- API
- Web Scrap URL
- Azure Data sources
- Others
Power BI Home Screen
For this task, I have prepared data using the Microsoft SQL Server Management Studio. For data analysis, I have created six different tables with different fields entered which show the data related to sales details for various products and branches. The table structure is shown in the below image.
Once the data is entered in the tables we use this data to perform data analysis and model data in power bi.
Let’s get started with Power BI!
- Loading dataset in excel format
Review the dataset before loading the dataset
2. You can view your data in tabular form by clicking the Data icon.
3. Open the manage relationship tab from the taskbar which will show output like below:
4. You can view the model view of data by clicking the model icon.
Hence we have learned about the Power BI tool and how to use Power BI Desktop and created the dataset model as we wanted. Next, we will try to create a Dashboard in Power BI.
