![]() This option imports the tables into Excel and prepares a PivotTable for analyzing the imported tables. Check the ‘Enable selection of multiple tables’ box, and select all the tables. Step 6 − Tables in a database are similar to the tables in Excel. ![]() Step 5 − The Select Table window, displaying all the tables found in the database, appears. Step 4 − Select Events.accdb, Events Access Database file. Step 3 − In the Get External Data group, click on the option From Access. Step 1 − Open a new blank Workbook in Excel. The existing database relationships between those tables is used to create the Data Model in Excel. A Data Model integrates the tables, enabling extensive analysis using PivotTables, Power Pivot, and Power View.Ī Data Model is created automatically when you import two or more tables simultaneously from a database. ![]() You can also make use of the Microsoft Business Intelligence features and capabilities in Excel, PivotTables, Power Pivot, and Power View.ĭata Model is used for building a model where data from various sources can be combined by creating relationships among the data sources. You can build a data model, then create amazing interactive reports using Power View. Excel 2013 has powerful data analysis features.
0 Comments
Leave a Reply. |