Data Analysis 2023 - Build Ecommerce Dashboards in Power BI

Plan the layout on paper, then design a PowerPoint ecommerce dashboard using rectangle shapes, solid background colors, no outlines, and a bold label 'e-commerce analysis sales dashboard'.

Develop PowerPoint layouts by adding shapes, aligning text left, applying font size 18 in Arial, bolding text, and creating white rounded-rectangle cards for a clean, sample-driven dashboard design.

Design final PowerPoint layout by creating shapes, inserting icons, and adding labeled text such as total sales versus last year, then export the slide as an image for Power BI.

Develop an ecommerce sales dashboard in Power BI by importing a PowerPoint layout, building total sales, total cost, and profit visuals, and tuning card formatting for clear metrics.

Create a tabular visual to show sales by branch, including total orders, total sales, total cost, and profit, using a distinct-count measure and Power BI table formatting.

Create a profit by product bar chart in Power BI, display the top 20 products, configure the y-axis with product name, add profit as the value, and format data labels.

Change display units from auto to none, set data labels for the bar chart, and create a profit by gender donut chart with legend and color tweaks.

Use smart narrative in Power BI to automatically summarize sales data, highlighting the most profitable product and the branch with the highest sales.

Build top ten products by sales and profit in Power BI, apply top ten filters, and identify least performing products with a min sales measure while formatting stacked bar visuals.

Create and format a Power BI product dashboard that calculates profit and expected profit per product with a calculated column and EP measure, highlighting top branches and products.

Design a PowerPoint layout for an ecommerce dashboard, customize sections and sizes, export the slide as an image, and prepare assets to import into Power BI for dashboard development.

Build a customer dashboard in Power BI using a matrix visual to show each customer's total orders, total sales, and branch from adventureworks database, with header formatting and conditional formatting.

Create customized orders by gender, occupation, and marital status with donut charts in Power BI. Learn formatting details—labels, legends, titles, and colors for clear dashboards.

Count all customers and total orders, and show the top customer by sales in a Power BI ecommerce dashboard. Use a distinct count on customer key and a top-1 filter.

Create a customer dashboard in Power BI that visualizes total orders by month with a stacked column chart, using a calendar table and formatted data labels.

Enable action-based navigation in Power BI by using a page navigation arrow and a page navigator to move between the sales dashboard, summaries page, and customize dashboard.

Add and customize page navigation in Power BI using navigator and back buttons to move between sales dashboard, product dashboard, and customer dashboard with precise styling.

Add slicers to dashboards to filter by year and month in Power BI; format slicers, create a calendar table, sort months, and sync across multiple dashboards.

Create a tooltip page in Power BI to show profit by month when hovering over a product. Tune the area chart and colors; enable slicers for tooltips on the dashboard.

Learn how to create a Power BI service account, use your organization's email, and publish your report to share with colleagues, friends, and your boss.

Link dashboards with navigation, add slicers for year and month, customize tooltips, and display a count on Power BI service, then deploy and share the dashboard with collaborators.