Skip to main content




Time to read: 3 minutes

With the October 2020 release From Power BI Desktop, Microsoft has embedded a sample data set directly into the product. While some commonly used training and demo data sets already exist, there are benefits to having a basic beginner Financial data set included.

This data can speed up the learning experience for new users, particularly those who only need to focus on reporting on existing data sets in their organization and don't need to know much about data modeling right away.

Con 700 filas y 16 columnas diversas, no es un conjunto de datos grande. Para los nuevos usuarios o para las persons que buscan crear una demostración rápida para mostrar algunas características, es posible que se ajuste al nicho correcto al crear contents por primera vez con Power BI Desktop.

There are some discrete or categorical attributes:

  • Segment
  • Country
  • Product
  • Discount band
image-5-1104210<>image-5-2696591

There are some fields related to the date:

  • Date
  • Month number
  • Name of the month
  • Year

Curiosamente, los datos van desde 2013-2014. Sé que es un conjunto de datos de muestra, pero estoy visualizando demostraciones de productos donde las impressions iniciales de esta moderna herramienta de BI en 2020 y más allá incluyen datos de muestra que parecen obsoletos. Quizás podría ser un buen ejercicio de capacitación de Power Query actualizar estas fechas en lugar de hacerlo de forma centralizada …

image-6-5354339

Finally, some numeric fields:

  • Sold units
  • Manufacturing price
  • Sale price
  • Gross sales
  • Discounts.
  • Sales
  • COGS
  • Profit
image-7-4872833
image-8-2137486

The inclusion of the financial dataset comes along with some other notable additions for newer users that are hard to miss.

Instead of an empty blank canvas or blank field area, Power BI Desktop now includes helpful directions to get started. These include canvas watermarks, visual tips, and more.

Think about your first experience with Power BI Desktop or talk to new users. Was Power BI intuitive? Would you know that you should get data on tape? These prompts may not be as helpful for experienced users, but they speed up learning and provide a much better appearance for the app than a large blank canvas.

image-2167594
Canvas Watermarks
image-1-8898103
Fields panel
image-9-3122714
Visual suggestions

Selecting the option for Test a sample data set and then choose Load data provides access to the new sample data set.

image-3-3211028

the Financial sample.xlsx file included with Power BI Desktop has a simple finance table. Users can upload as is or choose to transform before uploading.

image-4-9407482

What you think? Will these new features be useful for learning Power BI? Do you plan to use the new sample data?

Payment links

Como asociado de Amazon, gano con las compras que califican.