How to Use Power BI

Getting started with Power BI

In this guide, you'll learn how to set up Power BI, create your first report, and enhance your data analysis skills. By the end, you'll be able to generate insightful reports using your data with ease.

Step 1: Sign up and set up

1. Go to Power BI's website.
2. Click on the "Sign up free" button in the top right corner.
3. Follow the prompts to create your Microsoft account or sign in if you already have one.
4. Once signed in, you’ll be directed to the Power BI service. Familiarise yourself with the interface, particularly the left sidebar where you’ll find options like Home, Reports, and Datasets.

Step 2: Your first report

1. On the Power BI homepage, click on "Create" in the top right corner, then select "Report".
2. Choose a data source. You can upload an Excel file, connect to a database, or use online services like Google Analytics.
3. After selecting your data source, click on "Get Data" and follow the prompts to import your data.
4. Once imported, you’ll see your data fields on the right sidebar. Drag and drop these fields onto the report canvas to create visualisations.
5. To add visualisations, click on the "Visualisations" pane on the right and choose the type of chart or graph you want to use (e.g., bar chart, line chart).
6. Click "Save" at the top right to save your report.

Step 3: Get better results

1. Use the "Filters" pane to refine your data visualisations. Drag fields into this pane to filter your reports based on specific criteria.
2. Explore the "AI Insights" feature available in the Visualisations pane to automatically generate insights from your data.
3. Experiment with the "Natural Language Query" feature by clicking on the "Ask a question" box at the top. Type in questions like “What were our sales last quarter?” to receive instant visual insights.

Pro tip

Use the "Themes" option under the "View" tab to quickly change the colour scheme of your report. This saves time on formatting and ensures consistency across your visuals.

Common mistake to avoid

Avoid skipping the data transformation step. Make sure to clean and format your data before creating reports. This prevents errors in your visualisations and ensures more accurate insights.