Practical Example Using Power BI

POWER BI 

Open Power BI 

Interface

  • First interface contains some data source connections and one blank report.
  • After clicking on blank report the actual interface of Power BI will open.
  • In that :
    • Left side:
      • Report view: Create dashboard
      • Table view: Display data tables.
      • Model view: Create relationships.
      • DAX Queries: Write queries here.
    • Top part:
      • Called ribon contains different features related to visuals.
    • Bottom part: 
      • Contain two views first is desktop another is mobile.
      • And other things are pages as like sheets from excel.
    • Right part:
      • It is called pane.
      • Three pane:
        • Data: It shous data reated part.
        • Visualization: It shows different visuals, graphs.
        • Filter: Apply some filters to data.
Practical Example
--- Retail Sales Dashboard using Power BI ---

Sheet1: Sales_Data

Order_ID

Product

Region

Quantity

Price

Date

Customer_ID

101

Laptop

North

2

50000

01-01-2024

C01

102

Mobile

South

3

20000

02-01-2024

C02

103

Tablet

East

1

30000

03-01-2024

C03

 Sheet 2: Customer_Data

Customer_ID

Customer_Name

City

C01

Rahul

Delhi

C02

Priya

Mumbai

C03

Amit

Pune

🔹 Step 1: Data Loading

  • Open Power BI 
  • Get Data → Excel → select File 
  • Add two sheets
  • Click: Load

🔹 Step 2: Data Transformation

        Click: Transform Data
  • Check Data Types: from table view. 
  • Quantity → Whole Number 
  • Price → Decimal Number 
  • Create New Column:
    • Column Name: Total_Amount
    • Formula: Total_amount = Quantity * Price

    • Click: Close & Apply

    🔹Step 3: Relationship

    • Go to Model View
    • Connect: 
      • Sales_Data[Customer_ID] → Customer_Data[Customer_ID]




    Comments

    Post a Comment

    Popular posts from this blog

    Introduction To Data Visualization

    Image
      UNIT I: Introduction To Data Visualization 1.     Definition and Importance of Data Visualization Data Visualization is the process of presenting data in a visual or graphical form such as charts, graphs, maps, and diagrams . It helps to convert large and complex data into a format that is easy to understand and analyze . By using visual elements, data visualization allows users to quickly identify patterns, trends, and relationships in the data. Instead of reading large tables of numbers, people can easily understand information through visual representations. Data visualization is widely used in business, research, education, and data analysis to communicate information clearly and effectively. Importance of Data Visualization Data visualization is important because it helps people understand and analyze data more effectively. Some important points are: 1. Simplifies Complex Data Large datasets can be difficult to understand in raw form. Visual...
    Read more

    Practical Questions

     Practcal Exam Questions of Data Visualization using Power BI 1. Students Data, display subject and marks in Pie chart. Student Name Subject Marks Aditi Math 85 Aditi Science 78 Rahul Math 90 Rahul Science 88 Sneha Math 70 Sneha Science 75 2. Sales Data, Display Category and sales amount in Funnel chart. Product Category Sales Amount Pen Stationery 100 Pencil Stationery 80 Notebook Stationery 200 Chips Snacks 150 Biscuits Snacks 120 Juice Drinks 180 3. Add extra column in Table of Question 2. Column name Total sales, It should contains sum of all amo...
    Read more