Web data import in Power BI - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at an e-commerce company.

📋 Request: Your manager wants you to analyze the latest product prices and ratings from a competitor's website to compare with your own products.

📊 Data: You have access to a web page that lists competitor products with columns: Product Name, Price, and Customer Rating.

🎯 Deliverable: Create a Power BI report that imports the competitor's product data from the web, cleans it, and shows a table and bar chart comparing prices and ratings.

Sample Data

Product Name	Price	Customer Rating
Wireless Mouse	25.99	4.2
Bluetooth Headphones	59.99	4.5
USB-C Charger	19.99	4.0
Gaming Keyboard	89.99	4.7
Webcam HD	49.99	4.3
Portable SSD	129.99	4.6
Smartwatch	199.99	4.4
Noise Cancelling Earbuds	79.99	4.1

1

Step 1: Open Power BI Desktop and start a new report.

No formula needed.

Expected Result

A blank Power BI report is ready for data import.

2

Step 2: Import data from the competitor's web page URL.

Home tab > Get Data > Web > Enter the competitor's product page URL > Connect.

Expected Result

Power BI shows a navigator with tables found on the web page.

3

Step 3: Select the table containing Product Name, Price, and Customer Rating and load it.

Select the correct table in the navigator > Load.

Expected Result

The competitor product data is loaded into Power BI.

4

Step 4: Clean the data in Power Query Editor: ensure Price and Customer Rating columns are numbers.

Transform tab > Change data type of Price to Decimal Number and Customer Rating to Decimal Number.

Expected Result

Price and Customer Rating columns are numeric for analysis.

5

Step 5: Close and apply changes to load cleaned data into the report.

Home tab > Close & Apply.

Expected Result

Cleaned data is available in the report view.

6

Step 6: Create a table visual showing Product Name, Price, and Customer Rating.

Insert a Table visual > Add Product Name, Price, Customer Rating fields.

Expected Result

A table displays all competitor products with their prices and ratings.

7

Step 7: Create a bar chart comparing product prices.

Insert a Bar Chart visual > Axis: Product Name, Values: Price.

Expected Result

A bar chart shows product prices side by side.

8

Step 8: Create a bar chart comparing customer ratings.

Insert a Bar Chart visual > Axis: Product Name, Values: Customer Rating.

Expected Result

A bar chart shows customer ratings for each product.

9

Step 9: Format visuals for clarity: add titles, adjust colors, and ensure labels are readable.

Select visuals > Format pane > Add titles and adjust font sizes and colors for accessibility.

Expected Result

The report is clear, easy to read, and visually appealing.

Final Result

Bar Chart: Product Prices

↓

Bar Chart: Customer Ratings

✓Smartwatch is the most expensive product at $199.99.

✓USB-C Charger is the least expensive at $19.99.

✓Gaming Keyboard has the highest customer rating of 4.7.

✓Prices and ratings vary widely across products, showing opportunities to adjust pricing or improve product features.

Bonus Challenge

Add your own product data and create a combined report comparing your prices and ratings with the competitor's.

Show Hint

Import your product data as a separate table and use relationships or merge queries to combine data for side-by-side comparison visuals.