Step 1: Download Power BI Software
To kick off your journey in creating a Power BI dashboard, it's essential to have the Power BI software installed on your computer. If you haven’t downloaded it yet, you can easily obtain it from the Microsoft official site. After installation, make sure you also acquire the dataset you plan to work with. You can find one on Kaggle (Supermarket sales | Kaggle). Once both are ready, you're set to begin.
Step 2: Open Power BI Software and Extract Data
Launch the Power BI application, and you will be greeted with the default home screen. This screen typically displays past reports along with product details, which we can ignore for now. Click on the Get Data option located in the top right corner to begin the data extraction process. You'll see a list of supported data sources. For our purpose today, we will choose Text/CSV and click “connect.”
A window will pop up displaying the available CSV files. Select the CSV file you want to use. Before we load the data, let's transform it. Click the ‘transform data’ button to access the Power BI query interface for data transformation.
Step 3: Data Editing
Now comes the crucial part of editing data. Navigate to the right to check if the data types are properly assigned. For instance, if the date field is still in text format, select the ABC icon to change it to date type. By default, the date format might be set to UK; make sure to adjust it to the US format when needed. Additionally, we’ll create a new column to extract the hour from the time column. Select “Add Column” from the menu bar, then choose “Extract” to get the first two characters, rename it as “Hour,” and transform it to a whole number.
Step 4: Load Data Correctly
Ensure that all data types are accurate, such as changing the rating column from a decimal to a whole number. Once your edits are done, navigate back to the home icon on the menu bar and click “Close and Apply.” You'll observe that the data is now loading into your workspace. After loading is complete, a new interface will appear, showcasing report and data views for building your report.
Step 5: Build Your Reports
In the report view, you begin creating your reports, while the data view allows for data filtering. First, go back to the report view to explore the available functionalities. On the right side, you'll notice the visualization tab where you can select from various visualization types. Before constructing your report, enhance its aesthetics by switching from the visual tab to the format tab and selecting ‘Wallpaper’ from the dropdown to choose a background image.
Visualise Your Data
Next, it’s time to create your first visual. In the data tab, checkmark the fields you wish to include, such as “Date” and “Total.” Now, you’ll have the total by date, known as revenue. To switch it from a table format, select the line chart to better visualize the data. Adjust the color scheme by heading to “View” on the menu bar and pick a suitable theme, like the city park theme, which enhances the visual appeal.
To better understand data trends, ensure your visual is selected and navigate to the visualisation tab. Click on “Add further analysis to your visual” and enable the “Trend line.” This will stabilize your visual and enrich the insights.
Revenue Distribution By Hour
To analyze revenue distribution hourly, drag the hour field onto the canvas. Since it's a numerical field, switch the visualization type to a table and adjust “Sum” to “Don’t summarize.” For a clearer representation, switch to a clustered column chart, and add an “Average line” to see revenue trends better. Format this visual as previously instructed to enhance its presentation.
Ratings
Our dataset includes ratings for each transaction. To analyze these, select the rating and use the table visual. Uncheck “Sum of Rating” and focus instead on displaying the distinct counts of invoices related to these ratings, showcasing how many transactions correspond to each rating. For clarity, consider transforming this table into a bar chart for easier interpretation.
Payments
Finally, let’s visualize payments by dragging the relevant field onto the canvas. Checkmark “revenue” in your field selection and apply a “clustered bar chart.” While in the general tab under Format Visuals, turn on the “Shadow.” Adjust visual settings as necessary. Also, add the “City” field to the canvas and change it to a “Slicer” for easy filtering by city, providing a straightforward view of performance metrics.
Conclusion
Having followed these steps, you’ll appreciate how simple it is to create a Power BI dashboard and visualize reports without needing coding skills. This guide provides a clear roadmap through the process, making it manageable as long as data extraction, editing, and loading are accurately handled.
Power BI equips users with a variety of tools that not only enhance interactive data reporting but also facilitate quick learning and real-time insights. They foster seamless collaboration between team members, stakeholders, and clients alike.
