At most one email a week. Unfollow anytime with one click.
Transcript
The full narration of this video. The current sentence is highlighted while the video plays; click any sentence to jump there.
Show transcript
Introduction
This is the final result of part two, Dashboard Distributor Performance. We'll see which distributor has the highest sales, in which city they are located, how much and margin profit each has, and how their rankings change from year to year. Let's start. Hello, this is part two of the Power BI Dashboard series with WaveX sales data. This time, we're creating a Dashboard Distributor Performance to evaluate the performance of each distributor.
Step 1: Duplicate the Sales page into Distributor Performance
We start from the Sales page, which is already complete with a map and country slicer. Right-click the Sales tab, select Duplicate Tab, then double-click the new T bar and name it Distributor Performance. Also change the page title to Distributor Performance.
Step 2: Create the Total Orders measure and KPI
We need the number of orders. Right-click the Sales table, select New Measure, then type Total Order equals Distinction from the order ID column. Note, the column name order ID in this data has a space at the end, so it must be written exactly. Then select the KPI card, remove off-profit per unit, and drag total orders to the value column. Total there are 99 orders.
Step 3: Sales by Distributor
We change the Sales by category chart. Remove the category type from the Y-axis, find the full name in the data panel, then drag it to the Y-axis. Change the title to Sales by Distributor. Jane Lewis leads with sales of about 4.1 million dollars.
Step 4: Sales map by city
We deepen the Sales by Country map to the city level. Remove country from location, then drag the city column. The bubbles on the map now show sales in each distributor's city. The title becomes Sales by City.
Step 5: Donut chart for sales portion by distributor
We change the Donut Sales by Payment Method into sales share per distributor. Clear legend and details, then fill the legend with full name. Jane Lewis contributes almost half of the sales. Change the title to Sales Share by Distributor.
Step 6: Profit Margin per region
The previous top distributor chart compared selling price and cost. We will replace the values with marine profit percentage from the first part. Clear the Y-axis, then drag marine profit percentage. It turns out Sarah Williams has the highest marine, even though her sales are smaller. The title becomes marine profit by distributor. We change our Sales and Forecast chart into a Ribbon Chart.
Step 7: Ribbon chart for distributor ranking per year
Click the Ribbon Chart icon in the visual gallery, then drag full name to the legend. Ribbon Chart displays the distributor ranking each year, with the top band being the largest. The title becomes distributor ranking by year.
Step 8: Number of orders per Jebat
Finally, we turn our sales growth chart into the number of orders per distributor. Replace the X-Axis with full name, and Y-Axis with measure total orders. Jane Lewis handled 35 orders. The title becomes orders by distributor.
Done! Distributor Performance Dashboard
Done. The distributor performance dashboard is now complete. It includes the country filter in the top right to filter all charts. Save the file with Ctrl + S. See you in part three. Want to have a Power BI dashboard like this? Cerdas Inovasi Digital offers Power BI courses, dashboard creation and report automation services, as well as selling Power BI project files from this tutorial series. Contact us via WhatsApp, or visit cerdasinovasidigital.com.
Ask the class material
Type a question or keyword; we find the part of this episode that explains it and jump the video there.
My notes
Notes are saved with the current video time and are only visible to you.
Questions & answers
Stuck on a step? Ask here; the instructor and other learners can answer.
No questions yet.
Your instructor
Cerdas Inovasi Digital Team
Software developers, BIM & 3D engineers, and AI practitioners
52 video classes1,276 episodes
We build software, BIM models, games and AI automations for clients every day, and turn that hands-on work into step-by-step classes: every step is shown on screen and comes with a PDF guide you can keep.
