Get samples for Power BI - Power BI (2023)

  • Article
  • 12 minutes to read

APPLIES TO: Get samples for Power BI - Power BI (1)PowerBIDesktop Get samples for Power BI - Power BI (2)PowerBIservice

Are you new to Power BI and you want to try it out, but you don't have any data? Or maybe you'd like to see reports that illustrate some of the capabilities of Power BI. We've got you covered.

Power BI offers different kinds of samples for different purposes, including built-in samples and apps in the Power BI service, .pbix files, Excel datasets, and SQL databases. Here's a collection of different samples:

  • The Power BI report (.pbix file). You can view it in the Data Stories Gallery, open and explore it in Power BI Desktop, or upload it to the Power BI service.
  • The Artificial Intelligence sample Power BI report. In the report, you explore the Power BI artificial intelligence features such as key influencers, root-cause analysis in a decomposition tree, and anomaly detection. Download a copy from the Learn page in the Power BI service navigation pane.
  • A sample template app. You download it from AppSource, also right in the Power BI service. Template apps include dashboards, reports, and datasets. You can modify them, then distribute them to your colleagues.
  • Eight original built-in samples in the Power BI service, with dashboards, reports, and datasets. You install them right in the Power BI service. The built-in samples are also available as Power BI reports (.pbix) and Excel workbooks (.xlsx).
  • Excel workbook versions of the built-in samples, containing the data model. You can explore the data model in the Power Pivot add-in for Excel or use the Excel workbook as a data source for a Power BI report.
  • A Financial data sample workbook, a simple flat table in an Excel file available for download. It contains anonymized data with fictitious products, with sales divided by segments and countries/regions. It makes a useful basic data source for a Power BI report.
  • An Excel workbook version of the AdventureWorks dimensional model, in a tutorial to walk you through creating a Power BI report with the data.
  • If you'd rather work with data in SQL databases, the SQL samples article features links to downloadable AdventureWorks and WorldWideImporters SQL databases in a GitHub repository. The article also has links to other Azure samples.

Our online documentation uses these same samples in tutorials and examples, so you can follow along.

Sales & Returns sample .pbix file

Get samples for Power BI - Power BI (3)

The Sales & Returns sample report

Power BI report designers Miguel Myers and Chris Hamill created the Sales & Returns .pbix file to demonstrate many new features in Power BI, including buttons, drillthrough, conditional formatting, what-if, and customized tooltips.

The scenario for this report is a company that sells Microsoft-themed skateboards. They want to see the state of their sales and returns, and analyze how they should modify their operations.

You can explore it these ways:

  • Download the .pbix file and explore it in depth. Look "behind the curtain" to see how Miguel made it. This link opens the GitHub repo for Power BI Desktop samples. Select Download to download the Sales & Returns sample .pbix file to your computer.
  • Read about the report in the Power BI blog post, .

Eight original samples

Eight original samples are available for you to use. Each sample represents a different industry. You can engage with each in different formats:

  • Install the built-in samples in the Power BI service.
  • Download the Power BI report files (.pbix).
  • Download the Excel workbook files (.xlsx), then upload them to the Power BI service.
  • Explore the Excel files in Excel itself.

The company obviEnce (www.obvience.com) and Microsoft teamed up to create samples for you to use with Power BI. The data is anonymized and represents different industries: finance, HR, sales, and more.

Get samples for Power BI - Power BI (4)

Each of these samples is available in several formats: as a built-in sample, as an Excel workbook, and as a Power BI .pbix file. If you don't know what these things are, or how to get your hands on them -- don't worry. This article explains it all. For each of these samples, we've created a tour. Tours are articles that tell the story behind the sample and walk you through different scenarios. One scenario might be answering questions for your manager, another might be looking for competitive insights, or creating reports and dashboards to share, or explaining a business shift.

Before we get started, here are the legal guidelines for using these samples. After that, we introduce the samples and show how to use them.

Usage guidelines for the sample Excel workbooks

©2015 Microsoft Corporation. All rights reserved. The documents and workbooks are provided "as-is." Information and views expressed in the workbooks, including URL and other Internet Web site references, may change without notice. You bear the risk of using it. Some examples are for illustration only and are fictitious. No real association is intended or inferred. Microsoft makes no warranties, express or implied, with respect to the information provided here.

(Video) Download sample datasets and reports for Power BI and Excel

The workbooks do not provide you with any legal rights to any intellectual property in any Microsoft product. You may copy and use this workbook for your internal, reference purposes.

The workbooks and related data are provided by obviEnce. www.obvience.com

ObviEnce is an ISV and an Intellectual Property (IP) Incubator focused on Microsoft Business Intelligence. ObviEnce works closely with Microsoft to develop best practices and thought leadership for jump-starting and deploying Microsoft Business Intelligence solutions.

The workbooks and data are property of obviEnce, LLC, and have been shared solely for the purpose of demonstrating Power BI functionality with industry sample data.

Any uses of the workbooks and/or data must include the above attribution (that is also on the Info worksheet included with each workbook). The workbook and any visualizations must be accompanied by the following copyright notice: obviEnce ©.

By clicking any of the following links to download the Excel workbook files or .pbix files, you are agreeing to the terms above.

Customer Profitability sample Get samples for Power BI - Power BI (5)

Take a tour of the Customer Profitability sample

This industry sample analyzes a CFO's key metrics for the company's executives, products, and customers. You can investigate what factors impact the company's profitability.

Human Resources sample Get samples for Power BI - Power BI (6)

Take a tour of the HR sample

This industry sample focuses on the hiring strategy for a company by analyzing new hires, active employees, and employees who have left. By exploring the data, you can find trends in voluntary separations and biases in the hiring strategy.

IT Spend Analysis sample Get samples for Power BI - Power BI (7)

Take a tour of the IT Spend Analysis sample

In this industry sample, we analyze the planned vs. actual costs of the IT department of a company. This comparison helps us understand how well the company planned for the year and investigate areas with huge deviations from the plan. The company in this example goes through a yearly planning cycle, and then quarterly it produces a new Latest Estimate (LE) to help analyze changes in IT spend over the fiscal year.

Opportunity Analysis sample Get samples for Power BI - Power BI (8)

Take a tour of the Opportunity Analysis sample

This industry sample explores a software company's sales channel. Sales managers monitor their direct and partner sales channels by tracking opportunities and revenue by region, deal size, and channel.

Procurement Analysis sample Get samples for Power BI - Power BI (9)

Take a tour of the Procurement Analysis sample

This industry sample analyzes a CFO's key metrics for the company's executives, products, and customers. You can investigate what factors impact the company's profitability.

Retail Analysis sample Get samples for Power BI - Power BI (10)

Take a tour of the Retail Analysis sample

(Video) Get Python Sample Datasets in Power BI

This industry sample analyzes retail sales data of items sold across multiple stores and districts. The metrics compare this year's performance to last year's in these areas: sales, units, gross margin, and variance, as well as new store analysis.

Sales and Marketing sample Get samples for Power BI - Power BI (11)

Take a tour of the Sales and Marketing sample

This industry sample analyzes a manufacturing company, VanArsdel Ltd. It allows the Chief Marketing Officer to watch the industry and the market share for VanArsdel. By exploring the sample, you can find the company's market share, product volume, sales, and sentiment.

Supplier Quality sample Get samples for Power BI - Power BI (12)

Take a tour of the Supplier Quality sample

This industry sample focuses on one of the typical supply chain challenges — supplier quality analysis. Two primary metrics are at play in this analysis: total number of defects and the total downtime that these defects caused. This sample has two main objectives: understand who the best and worst suppliers are, with respect to quality, and identify which plants do a better job finding and rejecting defects, to minimize downtime.

Install built-in samples

Let's start with the built-in samples. The built-in samples are available in the Power BI service; you don't have to leave Power BI to find them. These samples are each a bundle of one or more dashboards, datasets, and reports that someone creates and that can be used with the Power BI service. These built-in samples are still available, but are being deprecated. They aren't available for Power BI Desktop.

  1. Open the Power BI service (app.powerbi.com) and sign in.

  2. Navigate to your My Workspace, or another workspace where you want to install the sample.

  3. In the bottom-left corner, select Get data.

    Get samples for Power BI - Power BI (13)

  4. On the Get Data page that appears, select Samples.

    Get samples for Power BI - Power BI (14)

  5. Select one of the samples to open a description of that sample, and choose Connect.

    Get samples for Power BI - Power BI (15)

  6. Power BI imports the built-in sample and adds a new dashboard, report, and dataset to your current workspace. Use the samples to take Power BI for a test run.

    Get samples for Power BI - Power BI (16)

Now that you have data, you're on your way. Try out some of our tutorials using the built-in samples or just open the Power BI service and explore.

(Video) Power BI: Dimensional Model Report using Adventure Works sample data. (Tutorial)

Download original sample Power BI files

Each of the built-in samples is also available as Power BI .pbix file. The .pbix files are designed to be used with Power BI Desktop.

  1. Download the files individually using the links below. Selecting these links saves the file automatically to your Downloads folder.

    • Customer Profitability Sample PBIX
    • Human Resources Sample PBIX
    • Procurement Analysis Sample PBIX
    • Retail Analysis Sample PBIX
    • Sales and Marketing Sample PBIX
    • Supplier Quality Analysis Sample PBIX
  2. In Power BI Desktop, select File > Open and navigate to the location where you saved the sample .pbix file.

  3. Select the .pbix file to open it in Power BI Desktop.

Download sample Excel files

Each of the built-in samples is also available as an Excel workbook. The Excel workbooks are designed to be used as a data source in the Power BI service or Power BI Desktop. If you're an advanced Excel user, you can explore or edit the data models in the Power Pivot add-in to Excel.

  1. Download one or all of the sample Excel files from this GitHub repository.

    • Customer Profitability Sample
    • Human Resources Sample
    • IT Spend Analysis Sample
    • Opportunity Tracking Sample
    • Procurement Analysis Sample
    • Retail Analysis Sample
    • Sales and Marketing Sample
    • Supplier Quality Analysis Sample
  2. Save the downloaded file. Where you save the file makes a difference.

    Get samples for Power BI - Power BI (17) Local: If you save your file to a local drive on your computer, you can publish the files to Power BI from Excel. After you've published it, there's no remaining relationship between your local file and the file in the Power BI service.
    Get samples for Power BI - Power BI (18) OneDrive - Business: If you have OneDrive for work or school and you sign into it with the same account you sign into Power BI with, OneDrive for work or school is by far the best place to keep your work in your Excel file in sync with your dataset, reports, and dashboards in Power BI. Because both Power BI and OneDrive are in the cloud, Power BI connects to your file on OneDrive about every hour. If Power BI detects any changes to the files in OneDrive, it automatically updates your datasets, reports, and dashboards in the Power BI service.
    Get samples for Power BI - Power BI (19) SharePoint Team-Sites: Saving your Power BI files to SharePoint – Team Sites is much the same as saving to OneDrive for work or school. The biggest difference is how you connect to the file from Power BI. You can specify a URL or connect to the root folder.

  3. You can use the files as data sources in Power BI Desktop, or Publish to Power BI from Excel to the Power BI service. When you publish, you choose one of these options:

    • Upload your workbook to Power BI: Brings the whole Excel file into Power BI, or
    • Export workbook data to Power BI: Creates a blank Power BI report with all your Excel data in the Fields list.

Explore Excel samples in Excel

(Optional) Want to understand how the data in these Excel workbooks gets converted to Power BI datasets and reports? Opening the Excel samples in Excel and exploring the worksheets provides some of the answers.

  • When you first open a sample workbook in Excel, you may see two warnings. The first warning says the workbook is in Protected View. Select Enable Editing. The second warning may say that the workbook has external data connections. Select Enable Content.

  • There's only one Excel sheet, the Info sheet. It provides information about obviEnce, the company that created the sample, and explains how to see the data in Power Pivot.

  • Where's the actual data? It's in the Power Pivot data model. On the PowerPivot tab, select Manage. In Power Pivot, you can see the data in all the underlying tables, plus all the DAX formulas.

    Tip

    Don't see the Power Pivot tab? Enable the Power Pivot add-in.

Upload the Excel files to the Power BI service

  1. Open the Power BI service (app.powerbi.com) and sign in.

    (Video) Power BI - Get Sample Data file - للمبتدئين كيفية تنزيل ملف عملي للتدريب مجانا

  2. Navigate to your My Workspace or to another workspace, or create a workspace just for the sample.

  3. In the bottom-left corner of the navigation pane, select Get data.

    Get samples for Power BI - Power BI (20)

  4. On the Get Data page that appears, select Files > Get.

    Get samples for Power BI - Power BI (21)

  5. Select the location where you downloaded and saved the sample.

    Get samples for Power BI - Power BI (22)

  6. Select the file. Depending on where you saved the file, select Connect or Open.

  7. Choose whether to import the data or to bring the workbook into Power BI and see it exactly as it is in Excel online.

    Get samples for Power BI - Power BI (23)

  8. If you select Import, Power BI imports the sample workbook and adds it as a new blank report and dataset, in this case each named Procurement Analysis Sample.

  9. Open the report, and explore creating visuals in Power BI.

Next steps

Basic concepts for designers in the Power BI service

Tutorial: Connect to the Power BI samples

Data sources for Power BI

More questions? Try the Power BI Community

FAQs

Where to get sample data for Power BI? ›

Open the Power BI service (app.powerbi.com) and sign in. Navigate to your My Workspace, or another workspace where you want to install the sample. In the bottom-left corner, select Get data. On the Get Data page that appears, select Samples.

Can Power BI learn in 2 days? ›

If you want to know how long it takes to learn Power BI, here's a quick answer for you: It takes 1-2 months to learn Power BI. This includes concepts like Data Analysis Expressions (DAX). This timeline is considered if you spend around 8 hours a day, 5 days a week.

How many days will take to expert in Power BI? ›

It can take anywhere from 1 to 6+ months to learn Power BI and get certified.

Does Power BI have sample data? ›

Power BI has several samples that you can either download in the Power BI service or open in Power BI Desktop. In a built-in sample, the report is bundled with a dashboard and dataset, and built into the Power BI service. The . pbix file that you can view in Power BI Desktop contains a report and dataset.

Where can I find sample datasets? ›

10 Great Places to Find Free Datasets for Your Next Project
  • Google Dataset Search.
  • Kaggle.
  • Data.Gov.
  • Datahub.io.
  • UCI Machine Learning Repository.
  • Earth Data.
  • CERN Open Data Portal.
  • Global Health Observatory Data Repository.
Oct 4, 2022

Where can I get free datasets for analysis? ›

Free Public Data Sets for Advanced Users
  • Data.world.
  • Kaggle.
  • FiveThirtyEight.
  • Buzzfeed.
  • Data.gov.
  • Reddit.

What is considered sample data? ›

A sample refers to a smaller, manageable version of a larger group. It is a subset containing the characteristics of a larger population. Samples are used in statistical testing when population sizes are too large for the test to include all possible members or observations.

What is the difference between sample and data set? ›

A population data set contains all members of a specified group (the entire list of possible data values). [Utilizes the count n in formulas.] Example: The population may be "ALL people living in the US." A sample data set contains a part, or a subset, of a population.

What is one good source of free data? ›

Pew Internet

If you're looking for sociological data, Pew Research is a great source. There are some interesting articles that you can find by browsing around, too. You do need to sign up to view and download datasets but it's free.

How do you create a sample dataset? ›

To gain practical experience, it is important to practice it with sample datasets.
  1. Method 1 : Enter Data Manually.
  2. Method 2 : Sequence of numbers, letters, months and random numbers.
  3. Method 3 : Create numeric grouping variable.
  4. Method 4 : Random Numbers with mean 0 and std. dev 1.
  5. Method 5 : Create binary variable (0/1)

What is the easiest data analysis method? ›

Content analysis is possibly the most common and straightforward QDA method. At the simplest level, content analysis is used to evaluate patterns within a piece of content (for example, words, phrases or images) or across multiple pieces of content or sources of communication.

Can I learn data analysis on my own? ›

Yes, it's possible to learn the fundamentals of data analytics on your own. To do it, though, you will need to set aside time to study data analytics on your own, using the resources available to you.

Can I use Google sheets for data analysis? ›

Get summaries and charts of your data with the click of a button in Sheets. It's kind of like having an expert in data analysis sitting next to you. In a spreadsheet, select a range of cells, columns, or rows. Otherwise, you'll get insights based on where your cursor is.

What are the 4 types of samples? ›

There are four main types of probability sample.
  • Simple random sampling. In a simple random sample, every member of the population has an equal chance of being selected. ...
  • Systematic sampling. ...
  • Stratified sampling. ...
  • Cluster sampling.
Sep 19, 2019

What is the best way to sample data? ›

The most straightforward way to sample data is with simple random sampling. Essentially, the subset is built of observations that were chosen from a larger set purely by chance; Each observation has the same chance of being selected from the larger set. Simple random sampling is extremely simple and easy to implement.

What are the 5 types of samples? ›

There are five types of sampling: Random, Systematic, Convenience, Cluster, and Stratified.

How many days required to learn Tableau? ›

In just one or two days, or even in a matter of hours, you can get acquainted with tableau and start using it efficiently and properly. However, the best answer that can be given to the above question is: Learning tableau is a simple and straightforward affair.

How long will it take to learn Dax? ›

How Long Does It Take to Learn DAX? It takes approximately 4-6 weeks to learn DAX. The learning duration can vary depending on the users' previous experience in Microsoft Excel and business intelligence tools. Complete mastery of DAX at the advanced level may take several months to years, depending on the learner.

Can I get a job just knowing Tableau? ›

A person with knowledge of Tableau can get many roles like data analyst, business analyst, and Tableau consultant. Further in Business Intelligence, one can get roles like Business Intelligence Analyst, Business Intelligence Developer, and Business Intelligence Manager all of which are highly paying roles.

Is Powerbi easy to learn? ›

Although Power BI is considered relatively easy to learn, there are still challenges involved with mastering this tool. One of the most difficult aspects of Power BI to learn is DAX, which is short for Data Analysis Expressions.

Is Powerbi better than Tableau? ›

Power BI tends to drag slowly while handling bulk data. Tableau can handle large volumes of data quickly. It is faster and provides extensive features for visualizing the data. Tableau doesn't limit the number of data points in visualization or enforce row or size limitations, giving you a 360-degree view of your data.

How can I learn DAX easily? ›

The best way to learn DAX is to create some basic formulas, use them with actual data, and see the results for yourself. The examples and tasks here use the Contoso Sales Sample for Power BI Desktop file. This sample file is the same one used in the Tutorial: Create your own measures in Power BI Desktop article.

How do you practice DAX? ›

4 recommended practices for new DAX users
  1. Worry about the important functions first. DAX has many possible functions, and it can be hard to know where to start. ...
  2. Skip memorizing and focus on understanding concepts. ...
  3. Keep your functions as readable as possible. ...
  4. Sort your measures by category.

Is DAX similar to Excel? ›

DAX formulas are very similar to Excel formulas. To create one, you type an equal sign, followed by a function name or expression, and any required values or arguments.

Videos

1. Best Practices and Easter Eggs in the New Power BI Sample Reports for Dynamics 365
(SkyPoint Cloud)
2. Power BI: How to Combine Multiple Excel Files from a Folder
(Avi Singh - PowerBIPro)
3. Awesome Power BI sample reports for inspiration
(BI Elite)
4. Mastering Microsoft Power BI - Create Power BI Report in 5 mins
(Tutorials Point)
5. Power BI Tutorial for Beginners 17 - Creating A Sample Report In Power BI
(ProgrammingKnowledge)
6. How to Use Microsoft Power BI | Create Your First Dashboard Now (Practice Files included)
(Leila Gharani)
Top Articles
Latest Posts
Article information

Author: Corie Satterfield

Last Updated: 02/15/2023

Views: 5593

Rating: 4.1 / 5 (42 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Corie Satterfield

Birthday: 1992-08-19

Address: 850 Benjamin Bridge, Dickinsonchester, CO 68572-0542

Phone: +26813599986666

Job: Sales Manager

Hobby: Table tennis, Soapmaking, Flower arranging, amateur radio, Rock climbing, scrapbook, Horseback riding

Introduction: My name is Corie Satterfield, I am a fancy, perfect, spotless, quaint, fantastic, funny, lucky person who loves writing and wants to share my knowledge and understanding with you.