from this blog, we see about "what is power bi ?"and "why should learn power bi ?"and "how to create dashboard in power bi ?"- for theese are all the quastion we are gone to solue in the blog.
what is power BI and why?
It is a BI tool. Reports and dashboards can be easily created using Power BI. Data cleaning and data modeling can be achieved using inbuilt tool - Power Query. It helps in visualising data.
why?:
How to Create Dashboard:
now, open your microsoft store and search power bi desktop and download the app.
after download the power bi, sign in with your work gmail id. before create a dashboard, download this file .
after download this file, enter into power bi check new report.
a new dashboard will be appear and see top. you can see there is "get data" click on that and select more option and select excel workbook.
home>Get data >excel workbook>connect.
after that file page pop-up on screen select the file that i given before.
click the file open option, and it's take to load ,after load navigator bar is pop-up on screen.
select the 3 of them in display option. select order,people and returns and click load option.
see cilpboard, you can see a option transform data. click on that pop-up show up like this
go to people and on the top the pop-up you can use the first row as a header and do this again to "returns " because the header mention as columns. so that use of we can change the first has header to the piople and returns.
then see top, there is a option like close and apply click on them
click the table view option. the excel sheet table shown here.
we should create a new table for date, for example create "date_info"
click new table option and enter this coding
date_info = CALENDAR(FIRSTDATE(Orders[Order Date]),LASTDATE(Orders[Order Date]))this date_info create a calender date taken for order table for order date. now use new column going to create like that for month, month_name, QTR, week,week_name and year.
year = YEAR(date_info[Date])month = MONTH(date_info[Date])month_name = FORMAT(date_info[Date],"mmm")QTR = QUARTER(date_info[Date])week = WEEKDAY(date_info[Date])week_name = FORMAT(date_info[Date],"mmm")after creating this all and all. click on model view . make a connection with other table.
see the common thing of each table. for example people table common to orders table is region, returns table relate to orders table is order id and date_info relate to orders table is date. make connection like this:
after make a connection with these table. go report view page and now start create a dashboard .
go to visulization >click format your report page > canvas settings> custom your page height and width.
then go back to page view, click a text box, drag the box and enter a "sample super store".
after that choose build visual and select the slicer. make them copy of six. In first copy choose value as country,second =region,third=state,fourth=orders_date,fifth=month and last choose has year.
again go back to build visual select a card and make copy of 4. first one insert a customer ID click on them has count. select second card as sales make them into sum. make third card for profit and last card has average of discount.
then select a pie chat insert the value of profit and segment.
create a donut chart and insert the value has category and profit.
then create a linr chart and insert the value has order date and sales
create a clustered bar chart and insert value has category, profit and sub-category.
and then click a double click on the balance "Q&A" will open automatically. the dashboard is ready.
this is Dashboard was created , it's help to present the excel repot to create faster and it's may looks batter than normal report. yeah from this blog how to create a dashborad and how to use power Bi more efficiently.
Comments