How to use power bi?
Question
I think you know the basics of it, if not you can go through our what is Power Bi, a blog for more information. Before we are going into it, you have to check all these things. In power Bi, all the Analysis will go in a common flow.
Especially you can view and communicate with, shared reports and Documents in its applications. You can share your Dashboards with others, and they can see them on their power Bi mobile applications. In particular Distribute your Reports, not to go anywhere, you can design the latest visualizations or Design Dashboards in business Intelligence.
Not to mention, you can spend as much as time with Microsoft Power Bi Service. By watching Reports and Visuals designed by your team members. One of your friends also spends a lot of Time in Power Bi Desktop.
Answer ( 1 )
This Power BI tutorial (Updated 2020) helps you learn the basics as well as advanced level concepts surrounding this tool. It enables you to gain a higher level of expertise in this domain.
So, let’s get acquainted with its working to create robust data models and generate reports. The below-mentioned ones are the topics that are discussed in this Power BI Desktop tutorial.
In This Power BI Desktop Tutorial (Updated 2020), You Will Learn
What is Power BI?
What is Power BI-Desktop
Power BI-Desktop Installation
Importing Datasets into Power BI-Desktop
Basic Views on Power BI-Desktop
Building a Dashboard
Uses of Power BI Desktop
Now, let’s start with knowing what actually is Power BI.
What is Power BI?
Power BI is a cloud-based Business Intelligence Service developed by Microsoft for non-technical business users with tools to aggregate, analyze, share, and visualize data.
What is Power BI Desktop?
Power BI Desktop is a free software application that can be installed on a local computer, and it allows the user to ingest, transform, integrate, and enrich data. Microsoft Power BI Desktop will enable you to ingest, process, combine and improve your data. It will connect all your data sources, simplifies them and share with scalable dashboards, embedded visuals, interactive reports, and others.
It also helps in connecting various data sources and combine them into a data model, build visuals, collect visuals, and share reports with other people in the organization. Most users who work on BI projects choose Power BI Desktop to create reports and to share them with others.
Power BI Course Offer
Want to become a master in Power BI? Then visit here to get Microsoft Power BI Training
Power BI Desktop Installation
Power BI Desktop consists of three basic steps to create a Report, listed as follows:
Importing Dataset to Models
Play around with Visualizations
Creating Reports
The more you use it, the better you’ll get at it. So, let’s get started.
Installing Power BI Desktop: Power BI Desktop can be installed using a simple process as follows:
1
2
3
Go to powerbi.com
Products >> Power BI Desktop >> Downloads page
Click on the Download Button
You can be a free user at first and later can download a paid version if you like. There is a significant difference between the access rights for the free users and paid users, which can be identified in the pricing page. The data usage capacity is the major difference between them.
Visit here: Step by Step Process of Installing Power BI Desktop
Want to good commend over Power BI Components ?
Importing Datasets into Power BI Desktop
The initial thing that you should do to build a dashboard is connecting with your data sources. The steps to import the data sets are as follows:
Choose and Click on the Get Data button
Select the data sources you want to connect. You’ve got CSV, excel azure, etc. You can even scrape the data off web pages if necessary.
Load it into your model.
Click on the Get Data button
Basic Views on Power BI Desktop
When you are adding data for the first time, a blank screen will appear, and you will come across three basic views on the left of the screen.
Report View: To create the dashboard
Data View: To get your data preview and make changes if any. It is also where you can create a new calculated column.
Relationship View: You can see the relationship between objects
Pro-Tip: The field experts always advise users to start with the data view and get a preview of what your data looks like.
Here are a few things to take care of before creating the dashboard:
Rename columns: Let’s assume that we’re building the user’s dashboard. To make it highly interactive, all the data types and naming conventions are going to appear at the surface.
Delete Columns: This contributes to the model size and takes up more system resources while processing. You can delete anything that is not necessary.
Hide Columns: It helps you to hide columns which are used later for calculations, but the user doesn’t need to see them. The columns hidden will appear greyed out and won’t appear in the report view.
You can directly move to the report view once you’re done with all the required transformations of your Power BI Desktop.
What is Power BI Slicer? A Complete Guide
Before moving into dashboard creation, let’s discuss what is a dashboard first
What is a Dashboard?
A dashboard can be defined as a canvas to bring various visualizations or elements representing data sets together. It will provide you with the story overview, and contains all the critical aspects of the report. A report can be a single page or multiple pages long.
Let’s now look into the dashboard creation in Power BI Desktop
Let’s consider that we are creating a Dashboard in Power BI from scratch. For instance, let’s say we are creating a Sales dashboard for different countries. To create this, we need to import customer-related sales data, products, orders, sales, and region details into the Power BI system. Using this data, we can create distinct kinds of visualizations to represent the aspects of the imported data effectively.
A workspace appears as soon as you open a Power BI Desktop. You have tabs like Home, Modeling, View, and Help on the top bar with a range of options in them. There will be two sections on the right, Fields, and Visualizations. The Fields section consists of all the fields of the imported data tables, whereas in the Visualizations, you can select a visual and edit it.
Step 1: Importing data
While creating a Power BI dashboard, the first step is importing data from the source files. Choose the Get Data option and select a data source of your choice. After selecting the data source and choose Connect. You can prepare the data that is imported in the Power Query Editor.
Step 2: Formatting
From the Data tab, you can easily access all the imported items like tables, and view them in the tabular form. On the right side, you’ll find the lists of tables and fields that exist within those tables. You can choose a table or a field for performing actions like format if your data consists of fields like time, date, city, state, currency, percentage value, etc. You can even change the data type or format from the modeling tab.
Step 3: Modeling
Power BI’s Engine creates the associations and relationships between the tables that you load. You can still view and make changes with the help of the Model tab provided in the data model on the left horizontal bar.
The relationship between the two tables is indicated by the links joining two common fields.
Step 4: Creating a KPI for Total Sales
We have imported a few tables for our dashboard, customer details, product details, place details, order details, and sales details. The first visualization that we’ll create is a KPI. Choose KPI from the visualizations section.
Select the fields that you want to include in the Fields section of the Visual. Even you can drag and drop the fields into their respective columns as indicated by the arrow in the following image. You can choose fields, format visuals, and apply filters from the Format icon.
Power BI Architecture – Tutorial With Diagram
Step 5: Creating a chart showing Sales
The next step is creating a Stacked bar chart that will show sales value by the product category. Add this chart from the Visualizations. Then, add fields to the chart and format the data labels, title, axes, legend, data colors, plot area, etc.
Step 6: Creating a chart showing Sales of various countries
Next comes creating column charts, i.e., line and clustered column charts. The following visual shows you the total sales and gross profit for various countries
(Select a Clustered Column Chart and a line from the Visualizations section.
Step 7: Creating a Chart Indicating Sales of various countries
The next step is to create an area chart which will show the total product sales over one year. We’ve created an area chart by choosing the Area chart from Visualizations and including respective fields into it.
Step 8: Creating a multi-row card
Along with visual data representation via charts and graphs, the data can be displayed in the text format using multi-row cards or cards. So, now let’s add multi-row cards from the visualizations section.
We have a multi-row card to the aspects such as product category related information, total units sold, total sales per category, and gross profit.
Step 9: Adding a Slicer for Sub-categories of products
Finally, include a Slicer for product subcategories that you have included in the record. Using Slicers, the user can select particular categories and filter through data. Upon selecting your required items in the slicer, the dashboard will only display the related visuals to the selected field or value.
Step 10: Publish the Dashboard
Power BI Certification Training!
Explore Curriculum
We are done by adding various types of graphics and visuals that we want to have on the dashboard. Since we are nearing the final step. Let’s adjust and resize the dashboard visualizations according to our requirements. You can also select themes for the dashboard, its background page size, etc.
Once the dashboard is set to be ready, you can publish it on your Power BI workspace and save it in the system. Choose to publish the dashboard on the web. Then, Login into your Power BI account and continue with publishing. After this, you will get a link to a web source where you have uploaded the dashboard.
Visit here for – Power BI Interview Questions
What are the Uses of Power BI Desktop
With this, the creation of the Power BI Dashboard has come to an end. Now let’s have a look at the uses of Power BI Desktop. People performing these tasks are considered as data analysts or BI professionals (also known as report creators). However, most people who don’t consider themselves as a report creator or an analyst use Power BI Desktop for creating compelling reports, or for pulling data from distinct sources and building data models that can be shared with their coworkers and organizations.
The common uses of Power BI Desktop are the following:
1. Connect Data
After completion of the Power BI desktop installation, you need to connect the data source and retrieve the data. To connect the data source, you need to open the Power BI app. Then you can notice the following home screen.
Select Get Data > More from the Home ribbon.
Home Ribbon Power BI Desktop
Select a data source from the given category and click on Connect.
Getdata Window PoweBI Desktop
When you select a data source, you’re asked for information, such as the URL and other credentials, i.e. mandatory for Power BI to connect.
Authorization Access Power BI Desktop
2. Transform and Clean Data:
Once your data is connected to the Power BI, you may customize the data as per your requirement. To change and clean your data, Power BI Desktop app is provided with Power BI Query Editor.
Basic Power BI Query Editor Functions:
Changes data type;
Adding or Removing Columns;
Joining data from different sources.
Let’s start the Power BI Query Editor
From the Home ribbon, select Edit Queries.
Query Editor Power BI
Now, you can see the Power BI Query Editor window.
Query Editor Window
Whatever changes( such as transforming data type, or deleting a column) you make, it will be recorded by the query editor. Data is shaped every time by connecting the query to your data source, where your changes have been carried out.
Trasformed Data Power BI Desktop
Once your data model is customized, you can create visuals.
3. Create Visuals
Visual is a pictorial representation of the data in your model.
Basic Visual Power BI Desktop
To create visuals, you need to drag the fields into report canvas.You can also select various visuals from the visualization pane.
Visualization Power BI Desktop
You can also apply the properties of visualization like title, colour, size, filter, font, formats, legends and background, etc
4. Create Reports
Power BI desktop is excelled at visual reports that show various aspects of the final modified data. A report is a composition of visuals that reflect informative insights for better decision making. It can have more than one page, just like an excel file can have multiple worksheets.
Creating Reports Power BI Desktop
5. Sharing Reports
You can now publish your report to the Power BI Service after finishing the creation of reports. A Power BI license is necessary for those who want to access the report in your organization.
From the Home ribbon, select the Publish button.
Publishing Data Power BI Desktop
Now Power BI service is connected with Power BI account with the help of Power BI desktop. Power BI allows you to share the visuals data at any position of Power BI services such as a team workspace, your workspace or some other location.
Conclusion:
Now that you’ve learned everything about the Power BI Desktop, go ahead and create a comprehensive and compelling Dashboard and visualization reports using this technology.
Check out other popular BI Tool Tutorials
Tableau Tutorial.
Qlik Sense Tutorial.
Qlikview Tutorial.
If you interested to learn Power BI and build a career in BI and Data visualization? Then check out our Power BI Training and Certification Course at your near Cities
Power BI Online Course in Bangalore, Power BI Online Course in Chennai, Power BI Online Course in Hyderabad, Power BI Online Course in Houston, Power BI Online Course in London, Power BI Online Course in Singapore, Power BI Online Course in Toronto
These courses are incorporated with Live instructor-led training, Industry Use cases, and hands-on live projects. This training program will make you an expert in Power BI and help you to achieve your dream job.
for more pease visit: https://mindmajix.com/power-bi-training-hyderabad
Attachment