PBi Exercise1_S2021.pdf - BDAT 1000 In Class Exercise using...

This preview shows page 1 - 2 out of 2 pages.

The preview shows page 1 - 2 out of 2 pages.
BDAT 1000In Class Exercise using Power BIExercise 1Install Power Bi from the Microsoft StoreOpen Power BISelect fromGet dataon the left of the pop up screen (we are suing Power Bi Desktopnot the Power BI service so we will not be using the email sign in option)Loading Data1) Select the first option‘Excel’select‘Connect’and browse to the excel filelocation ‘CrimeData’2)Select the Excel Sheet ‘Data3) Preview the data in the preview pane on the right4)Select ‘Transform datato edit the data, this opens the data in ‘Power QueryEditor’5) From the Ribbon selectFileOptionsandSettingsOptions6) In the Left Panel of Options dialog selectRegional Settings7) From theLocaledrop down selectEnglish (United States)& selectOKtoclose the dialog boxTransform Data8)Go to the ‘View’ Tab9) Select the Column Quality Optionyou will see a bar appear above your dataset that tells you if your data has any errors10) Select Column Profile

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 2 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Winter
Professor
NoProfessor
Tags
Power, Left wing politics, Modifier key, Shift key

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture