Curso de Microsoft Power BI desde cero | IMPORTAR DATOS DESDE ARCHIVO EXCEL(video 5)
New Section
In this section, the speaker introduces the process of importing an Excel file into Microsoft Power BI.
Importing Excel File
- The process of importing an Excel file involves selecting "Get Data" from the initial ribbon of options.
- Upon selecting the Excel file, a window opens allowing users to choose specific sheets or ranges within the Excel document for import.
- Distinction between importing as a table (represented by a grid icon) and as tabs (represented by tab icons) is explained, highlighting differences in data structure.
- Recommendations are provided to guide users on choosing between tables and entire sheets based on data organization within Excel.
- Users are shown how to preview imported data before finalizing selections, ensuring accuracy and completeness.
New Section
This part delves into previewing and selecting specific data elements for import in Power BI from an Excel file.
Previewing Data Elements
- Users can enlarge previews to inspect columns such as complete date, years, sales date, sales target days, and sales target values.
- Selection process for specific tables or ranges within the Excel document is demonstrated through checkboxes that turn green upon selection.
New Section
The focus shifts to loading selected data elements into Power BI and navigating through imported datasets.
Loading Data Elements
- After confirming selections, users initiate the loading process for chosen tables or sheets from the Excel file into Power BI.