Business Intelligence and Data Visualization Lab Material As the Microsoft Excel 2016 is used in our lab, the instruction for tutorial 3 is based on Microsoft Excel 2016. Lab Work: Download the database Download the file studata2.csv from blackboard Import Data into Excel PowerPivot Do the following: · Open MS Excel. . Click on the PowerPivot menu option. . Click on PowerPivot Manage icon Book1 - Excel × File Home Insert Page Layout Formulas Data Review View ACROBAT Power Pivot Tell me Libo Liu & Share Manage fx Measures KPis - Data Model Calculations Add to Update Data Model All Tables Detect Settings Relationships Go to the Power Pivot window Go to the Power Pivot window to load and prepare data or continue working D E F G H - K L . on data already added to this workbook E& Microsoft Power Pivot for Excel Tell me more PowerPivot is an application that is not 'part of Excel. It works in conjunction with Excel. In many ways it behaves similarly to Excel • Click on From Other Sources option • Select Text File option [] [] [ f) - ( . . | RevierPivot for Tacel - Books lotte Import Wieons Data Feeds
· Select CSV File option once you click 'BROWSE" DIGAS .. . |Power Pivot for Excel - Book1 Home Advanced Fatte Append Paste Replace 2 Data Type : " Format: " 2 1 Sort A to Z H ES M Past From From Data From Other Existing Connections Refresh Pivottable $ - % , % - clear All Sort by Find 120 Cop Database " Service " Sources Get External Data S Clear Sort Filters Column " Clipboard Table Import Wizard Open [ = Desktop > swinburne > BI2019 > 2019 Tutorials > T2 VO Search 12 Organize New folder OneDrive - Swinburne University Nam This PC Desktop Documents & Downloads Music Pictures I Videos (C) Windows (D) UNTITLED (G:) Staff Group Drive (00 DB apps drive (T3 T Drive ·· (D) UNTITLED File name: · Choose the studata2.csv file which you downloaded. · Select 'use first row as column headers' Diagram Show Calculation View Hidden Ares P × X P Date modified Typ No items match your search. 4 . - Power Pivot for Excel - Bookd Hofle Design Advanced Pacto Appand Paste Replace Past From From Data From Other Database . Service . Sources Connections ???ng Rifresh Data Type: - Format: " 9 1 Sort A to Z il Sort Z to A X H create ICPE B Copy Clipboard Forottable 5 - % , 28 28 9a Clear Sort Filters Column Clear all Sort by Get External Daca Data Diagram Flat Files ( *. txt) Flat Files (x) Tab Separated Files ( tab) Comma Separated Files (csv) show calculation Arte View Hidden Table Import Wizard Connect to Flat File Enter the information required to get data from fiat files Friendly connection name: cat StuDota21 File Path: Column Soperator Comme (.) | Use first