Tableau Prep
2 Lab 2: Data Preparation Exercise This exercise is to help you practice the following objectives • Prepare data for analysis and reporting • Extract, clean, and transform data Examine the attached data files. The first file contains data on movies and TV shows scrapped from IMDB website. This dataset has issues around inconsistent variable names for example in the year columns, null values, non-alpha numeric variables etc. The second dataset is a live data set on average salaries of managers in different domains. The data input for this dataset is free text and therefore has issues with consistency and outliers. Apply what you have learned to load the data correctly to tableau prep and generate and execute a cleaning workflow. Once completed, take a screenshot of the workflow, and do a two-page lab report of the cleaning steps and rationale behind it. Submission Submit the lab report in PDF format. This report should include required parts with screenshots, labels, and descriptions. All screens must be clear, original, and show the complete screen. Grading The lab is assessed based on: • Completion of required tasks. • Satisfaction of submission requirements. • The quality of lab report, including completeness and explanation of screenshots. Rubric: Score Summary Rating Description 10 Outstanding work; beyond expectation. Correctly developed all workflows and loaded data required. Satisfied all submission requirements. Excellent report with clear original screenshots and explanation. 8-9 Good work; meet expectations. Correctly loaded data required with minor issues. Satisfied most submission requirements. Good report with clear original screenshots; explanation may need improvement. 6-7 Adequate work; need improvement. Loaded data but with major issues or different from the tutorial. Satisfied most submission requirements. Too simple report without labels or explanations. screenshots, or unclear/unqualified screenshots.<6 lack of effort. unfinished steps in the workflow. did not follow submission requirements. poor report with unclear, partial or edited screenshots. no explanations at all. 2 other resources -power bi 1. getting started with power query a) https://docs.microsoft.com/en-us/power-query/power-query-what-is-power-query b) using the query editor: https://docs.microsoft.com/en-us/power-bi/desktop-query-overview c) common query tasks in power bi desktop: https://docs.microsoft.com/en-us/power- bi/desktop-common-query-tasks d) https://docs.microsoft.com/en-us/learn/modules/get-data-power-bi/ 2. getting data from various sources: https://docs.microsoft.com/en-us/power-bi/desktop-data-sources a) csv: https://docs.microsoft.com/en-us/power-bi/desktop-connect-csv b) excel: https://docs.microsoft.com/en-us/power-bi/desktop-connect-excel c) web page: o https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-web o https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-data o https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-web-by-example live connection? tutorial getting data from aw data mart https://www.biinsight.com/connect-live-power-bi-to-ssas-multidimensional/ 3. data cleaning and transformation a) data cleaning: https://www.digitalvidya.com/blog/data-cleaning-features-in-power-bi/ b) shape and combine data: https://docs.microsoft.com/en-us/power-bi/desktop-shape-and- combine-data c) calculated column: https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create- calculated-columns d) data types: https://docs.microsoft.com/en-us/power-bi/desktop-data-types e) string functions: https://www.tutorialgateway.org/power-bi-dax-string-functions/ f) https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/ 4. some more extensive exercises a) https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-analyzing-sales-data-from-excel- and-an-odata-feed b) https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-importing-and-analyzing-data- from-a-web-page c) wiseowltutorials: https://www.youtube.com/watch?v=ckeaf78qlfm&list=plnis- awhqzcnsmnbeupqrkuiqgplnb2hh&index=6 – complete four parts 3.1 to 3.4 (see all tutorials in the playlist). for part 3.2 and 3.4, once completed, take a screenshot of the relationship view (clearly showing all tables and relationships), and a screenshot of data view for each table (clearly showing data values). include this part in the lab report. get data from sql server … power query - overview and learning 2 • https://support.office.com/en-us/article/power-query-overview-and-learning-ed614c81- 4b00-4291-bd3a-55d80767f81d • https://support.office.com/en-us/article/power-query-101-008b3f46-5b14-4f8b-9a07- d3da689091b5 power query with m language in excel https://support.office.com/en-us/article/introduction-to-microsoft-power-query-for-excel-6e92e2f4- 2079-4e1f-bad5-89f6269cd605 form responses 1 timestamphow old are you?what industry do you work in?job titleif your job title needs additional context, please clarify here:what is your annual salary? (you'll indicate the currency in a later question. if you are part-time or hourly, please enter an annualized equivalent -- what you would earn if you worked the job 40 hours a week, 52 weeks a year.)how much additional monetary compensation do you get, if any (for example, bonuses or overtime in an average year)? please only include monetary compensation here, not the value of benefits.please indicate the currencyif "other," please indicate the currency here: if your income needs additional context, please provide it here:what country do you work in?if you're in the u.s., what state do you work in?what city do you work in?how many years of professional work experience do you have overall?how many years of professional work experience do you have in your field?what is your highest level of education completed?what is your gender?what is your race? (choose all that apply.) 4/27/2021 11:02:0925-34education (higher education)research and instruction librarian55,0000usdunited statesmassachusettsboston5-7 years5-7 yearsmaster's degreewomanwhite 4/27/2021 11:02:2125-34computing or techchange & internal communications manager54,6004000gbpunited kingdomcambridge8 - 10 years5-7 yearscollege degreenon-binarywhite 4/27/2021 11:02:3825-34accounting, banking & financemarketing specialist34,000usdustennesseechattanooga2 - 4 years2 - 4 yearscollege degreewomanwhite 4/27/2021 11:02:4025-34nonprofitsprogram manager62,0003000usdusawisconsinmilwaukee8 - 10 years5-7 yearscollege degreewomanwhite 4/27/2021 11:02:4125-34accounting, banking & financeaccounting manager60,0007000usdussouth carolinagreenville8 - 10 years5-7 yearscollege degreewomanwhite 4/27/2021 11:02:4525-34education (higher education)scholarly publishing librarian62,000usdusanew hampshirehanover8 - 10 years2 - 4 yearsmaster's degreemanwhite 4/27/2021 11:02:5025-34publishingpublishing assistant33,0002000usdusasouth carolinacolumbia2 - 4 years2 - 4 yearscollege degreewomanwhite 4/27/2021 11:02:5925-34education (primary/secondary)librarianhigh school, ft50,000usdunited statesarizonayuma5-7 years5-7 yearsmaster's degreemanwhite 4/27/2021 11:03:0145-54computing or techsystems analystdata developer/etl developer112,00010000usdusmissourist. louis21 - 30 years21 - 30 yearscollege degreewomanwhite 4/27/2021 11:03:0135-44accounting, banking & financesenior accountant45,0000usdi work for a charter schoolunited statesfloridapalm coast21 - 30 years21 - 30 yearscollege degreewomanhispanic, latino, or spanish origin, white 4/27/2021 11:03:0225-34nonprofitsoffice manager47,5000usdunited statesboston, ma5-7 years5-7 yearscollege degreewomanwhite 4/27/2021 11:03:0735-44education (higher education)deputy title ix coordinator/ assistant director office of equity and diversity62,0000usdusapennsylvaniascranton11 - 20 years5-7 yearsphdwomanhispanic, latino, or spanish origin, white 4/27/2021 11:03:0935-44accounting, banking & financemanager of information services100,0000usdunited statesmichigandetroit11 - 20 years11 - 20 yearscollege degreemanasian or asian american, white 4/27/2021 11:03:0925-34lawlegal aid staff attorneynon-profit law firm52,0000usdunited statesminnesotasaint paul2 - 4 years2 - 4 yearswomanwhite 4/27/2021 11:03:1018-24health carepatient care coordinator32,000cadcanadaremote1 year or less1 year or lesscollege degreewomanwhite 4/27/2021 11:03:1135-44utilities & telecommunicationsquality and compliance specialist24,000500gbpunited kingdom lincoln11 - 20 years5-7 yearscollege degreemanwhite 4/27/2021 11:03:1335-44business or consultingexecutive assistant85,0005000usdusaillinoischicago8 - 10 years8 - 10 yearssome collegewomanwhite 4/27/2021 11:03:1845-54art & designgraphic designer59,000usdusacaliforniapomona21 - 30 years21 - 30 yearscollege degreewomanwhite 4/27/2021 11:03:2035-44business or consultingsenior manager98,0001000usdusageorgiaatlanta11 - 20 years2 - 4 yearsmaster's degreewomanwhite 4/27/2021 11:03:2335-44education (higher education)assistant director of academic advising54,000usdunited statesfloridaboca raton11 - 20 years11 - 20 yearsmaster's degreewomanwhite 4/27/2021 11:03:2325-34health caredata programmer analyst74,0000usdusapennsylvaniaphiladelphia5-7 years5-7 yearsmaster's degreewomanwhite 4/27/2021 11:03:2435-44nonprofitsprogram coordinator & assistant editor 50,000usdunited statesatlanta5-7 years2 - 4 yearsphdwomanwhite 4/27/2021 11:03:2735-44nonprofitsevent planner63,000cadcanadatoronto11 - 20 years8 - 10 yearsmaster's degreewomanwhite 4/27/2021 11:03:2835-44government and public administrationresearcher96,0001000usdunited statesohiodayton8 - 10 years2 - 4 yearsphdwomanasian or asian american 4/27/2021 11:03:3125-34public libraryteen librarian 44,5000usdusfloridabradenton5-7 years2 - 4 yearswomanwhite 4/27/2021 11:03:3435-44education (higher education)communications specialist60,0000usdusamichiganann arbor11 - 20 years1 year or lessmaster's degreewomanwhite 4/27/2021 11:03:3725-34nonprofitsprogram directori manage staff members who each manage 8-15 other people. 62,000usdusdistrict of columbiawashington dc5-7 years2 - 4 yearscollege degreemanwhite 4/27/2021 11:03:4035-44lawbookkeeper/billing manager48,0004000usdusamarylandsilver spring11 - 20 years2 - 4 yearscollege degreewomananother option not listed here or prefer not to answer 4/27/2021 11:03:4135-44government and public administrationeconomist140,000usdusadistrict of columbiawashington11 - 20 years11 - 20 yearsmaster's degreewomanwhite 4/27/2021 11:03:4225-34engineering or manufacturingresearch engineer80,000usdunited statestexassan antonio5-7 years5-7 yearscollege degreewomanwhite 4/27/2021 11:03:4325-34nonprofitsvolunteer and giving coordinator39,000usdunited statesminnesotaminneapolis2 - 4 years2 - 4 yearscollege degreewomanwhite 4/27/2021 11:03:4335-44media & digitaleditor125,0000usdusadistrict of columbiawashington, dc11 - 20 years8 - 10 yearsmaster's degreewomanwhite 4/27/2021 11:03:4525-34accounting, banking & financefinancial advisor230,000usdcommission basedusamissourist. louis11 - 20 years11 - 20 yearscollege degreewomanwhite 4/27/2021 11:03:4535-44accounting, banking & financeaccounting manager110,00015000usdusvirginiarichmond21 - 30 years11 - 20 yearscollege degreewomanwhite 4/27/2021 11:03:5325-34nonprofitsadministrative and hr manager50,000usdunited statesdistrict of columbiawashington5-7 years2 - 4 yearscollege degreewomanwhite 4/27/2021 11:03:5435-44education (higher education)senior irb analyststate university, higher ed research adminstration68,0000usdusanorth carolinaresearch triangle5-7 years2 - 4 yearsmaster's degreewomanwhite 4/27/2021 11:03:5518-24media & digitalreporter41,000100usdunited statesmichigankalamazoo2 - 4 years2 - 4 yearscollege degreewomanwhite 4/27/2021 11:03:5625-34accounting, banking & financesenior administrator 76,00010000usdunited statesnew yorkmanhattan5-7 years2 - 4 yearscollege degreewomanwhite 4/27/2021 11:03:5735-44government and public administrationstaff services manager iimid-level manager, team of 1378,0000usdusacaliforniasacramento8 - 10 years5-7 yearsmaster's degreewomanwhite 4/27/2021 11:03:5825-34accounting, banking & financereceptionist37,0000usdusatexasdallas2 - 4 years2 - 4 yearscollege degreewomanwhite 4/27/2021 11:04:0145-54engineering or manufacturinglead engineersupervisor level with no direct reports100,00050000usdusageorgiawaynesboro21 - 30 years21 - 30 yearscollege degreewomanwhite 4/27/2021 11:04:0135-44marketing, advertising & prsenior copywriter35,0006000gbpukliverpool11 - 20 years11 - 20 yearscollege degreewomanwhite 4/27/2021 11:04:0125-34government and public administrationmanager of data integrity and prospect research65,0000usdusavirginiarichmond5-7 years5-7 yearscollege degreemanwhite 4/27/2021 11:04:0325-34computing or techprincipal software engineer187,5005000usdunited statespennsylvaniapittsburgh8 - 10 years5-7 yearscollege degreewomanwhite 4/27/2021 11:04:0325-34computing or techintelligence analyst110,00020000usdaround 20,000 a year in stockusavirginiaarlington, va8 - 10 years8 - 10 yearsmaster's degreemanwhite 4/27/2021 11:04:0425-34nonprofitsproject manager66,6251500usdusmassachusettsboston8 - 10 years8 - 10 yearscollege degreewomanhispanic, latino, or spanish origin, white 4/27/2021 11:04:0635-44computing or techmobile developer144,6002500usdusamassachusettsboston5-7 years5-7 yearsphdwomanwhite 4/27/2021 11:04:0935-44computing or techproduct design director200,85040000usdusanorth carolinachapel hill11 - 20 years11 - 20 yearscollege degreewomanwhite 4/27/2021 11:04:0925-34engineering or manufacturingengineering specialist120,0001500cadcanadavancouver11 - 20 years8 - 10 yearscollege degreewomanwhite 4/27/2021 11:04:1025-34retailmanager, total rewards97,50010000cadcanadatoronto8 - 10 years8 - 10 yearscollege degreewomanwhite 4/27/2021 11:04:1035-44education (higher education)research and development engineer 3process engineer in a university cleanroom96,000usdunited statescaliforniaberkeley5-7 years5-7 yearsphdwomanwhite 4/27/2021 11:04:1125-34education (primary/secondary)science teacher (public high school)53,0001000usdunited statesminnesotaapple valley5-7 years1 year or lessmaster's degreewomanwhite 4/27/2021 11:04:1525-34marketing, advertising & prsenior manager, programmatic95,00010000usdunited statesillinoischicago8 - 10 years8 - 10 yearscollege degreewomanwhite 4/27/2021 11:04:1935-44computing or techmanaged services sales coordinatorprimarily proposal writing72,0003000usdunited statesmichigantroy11 - 20 years5-7 yearsmaster's degreewomanwhite 4/27/2021 11:04:2135-44media & digitaleditor52,0000cadcanadatoronto11 - 20 years11 - 20 yearscollege degreewomanasian or asian american 4/27/2021 11:04:2235-44engineering or manufacturingwater resources engineer106,0000usdunited statesmassachusettsboston21 - 30 years11 - 20 yearsmaster's degreewomanwhite 4/27/2021 11:04:2425-34government and public administrationprogram officer115,000usdunited statesdistrict of columbiadc5-7 years5-7 yearsphdwomanhispanic, latino, or spanish origin 4/27/2021 11:04:2625-34business or consultingaccount supervisorprogram manager for government contractor100,5003000usdusdistrict of columbiawashington11 - 20 years5-7 yearscollege degreewomanwhite 4/27/2021 11:04:2725-34lawlegal secretary33,2000usdusnew jerseylinden8 - 10 years2 - 4 yearssome collegewomanwhite 4/27/2021 11:04:2735-44government and public administrationpolicy leadmiddle manager policy role in public sector. 52,0000gbpunited kingdombristol11 - 20 years11 - 20 yearsmaster's degreewomanwhite 4/27/2021 11:04:2725-34education (higher education)coordinator52,000usdunited statesillinoischampaign8 - 10 years8 - 10 yearscollege degreewomanwhite 4/27/2021 11:04:2925-34government and public administrationsenior advisor79,000cadcanadanova scotia8 - 10 years5-7 yearsmaster's degreewomanwhite 4/27/2021 11:04:2965 or overproperty or constructionsafety director104,00025000usdextra money comes from overtimeusageorgiaatlanta41 years or more21 - 30 yearscollege degreemanwhite 4/27/2021 11:04:3125-34education (primary/secondary)secondary school educator75,000cadcanadaottawa5-7 years2 - 4 yearscollege degreewomanasian or asian american 4/27/2021 11:04:3118-24biotechnologydownstream process development research associate i52,000usdunited statestexasbryan2 - 4 years2 - 4 yearscollege degreewomanwhite 4/27/2021 11:04:3225-34education (higher education)research programmersoftware engineering without the job title70,0000usdtechnically 37.5 hours, but ends up being pretty similarusarhode islandprovidence5-7 years2 - 4 yearsmaster's degreenon-binarywhite 4/27/2021 11:04:3425-34nonprofitsmanager, natural climate solutions developmentthis is not a non-profit development/fundraising role.84,0008400usdunited statesdistrict of columbiadistrict of columbia5-7 years5-7 yearsmaster's degreewomanwhite 4/27/2021 11:04:3435-44health carear manager53,0000usdunited statesillinoisbloomington21 - 30 years11 - 20 yearsmaster's degreewomanwhite 4/27/2021 11:04:3625-34computing or techtechnical specialist34,0002000usdunited statesminnesotaminneapolis5-7 years5-7 yearscollege degreewomanwhite 4/27/2021 11:04:3725-34nonprofitsprogramming coordinator38,000usduscoloradodenver5-7 years2 - 4 yearsmaster's degreewomanwhite 4/27/2021 11:04:3825-34government and public administrationcity research scientist iipublic health research and data analysis87,0000usdunited statesnew yorknew york city5-7 years2 - 4 yearsmaster's degreemanwhite 4/27/2021 11:04:3935-44aerospace contractingproject engineer cost/schedule analyst122,0003600usdunited statescolorado springs11 - 20 years11 - 20 yearsmaster's degreewomanwhite 4/27/2021 11:04:3925-34insurancepricing analyst45,0002000gbpuksouthampton5-7 years2 - 4 yearsmaster's degreewomanwhite 4/27/2021 11:04:4025-34engineering or manufacturingmarketing coordinator45,000usdunited statessouth carolinacolumbia5-7 years5-7 yearssome collegewomanwhite 4/27/2021 11:04:4135-44computing or techtech writer88,000usdusamarylandprefer not to answer11 - 20 years8 - 10 yearscollege degreewomananother option not listed here or prefer not to answer 4/27/2021 11:04:4335-44nonprofitssupervisory archivistat a historical society71,0000usdusnew yorknyc (remotely)11 - 20 years8 - 10 yearsmaster's degreewomanwhite 4/27/2021 11:04:4345-54education (higher education)program manager71,000usdusaillinoischampaign11 - 20 years11 - 20 yearsphdwomanwhite 4/27/2021 11:04:4535-44education (primary/secondary)high school teacher at an independent school75,0000usdunited statesgeorgiaatlanta11 - 20 years11 - 20 yearsmaster's degreewomanwhite 4/27/2021 11:04:4835-44education (higher education)manager of market research and datamy group is responsible for data gathering, analysis and reporting to state and federal stakeholders as well as strategic initiatives and grant applications. we also manage the organization's crm system.80,0000usdusanorth carolinaraleigh21 - 30 years11 - 20 yearsmaster's degreewomanwhite 4/27/2021 11:04:4835-44computing or techsenior business analyst125,000usdusnew yorknew york11 - 20 years8 - 10 yearsmaster's degreewomanwhite 4/27/2021 11:04:5035-44education (higher education)special collections catalogertenure-track faculty65,000usdunited statespennsylvania-----11 - 20 years11 - 20 yearsmaster's degreewomanwhite 4/27/2021 11:04:5145-54education (primary/secondary)teacher 36,000gbpscotland edinburgh21 - 30 years21 - 30 yearscollege degreewomanwhite 4/27/2021 11:04:5425-34nonprofitsgraphic designer / webmaster55,000usdu.s.minnesotast. paul2 - 4 years2 - 4 yearscollege degreewomanwhite 4/27/2021 11:04:5425-34art & designsenior ux designer90,0001000usdusapennsylvaniaphiladelphia11 - 20 years8 - 10 yearscollege degreewomanwhite 4/27/2021 11:04:5835-44engineering or manufacturingsenior engineer 105,00013000usdunited states pennsylvaniaphiladelphia (suburbs)8 - 10 years5-7 yearscollege degreewomanwhite 4/27/2021 11:05:0135-44nonprofitsoffice administrator60,0000cadcanadakitchener, ontario11 - 20 years11 - 20 yearshigh schoolmanwhite 4/27/2021 11:05:0135-44education (higher education)digital archivist65,0000usdunited statespennsylvaniaphiladelphia11 - 20 years8 - 10 yearsmaster's degreewomanwhite 4/27/2021 11:05:0125-34business or consultingassociate program managerassociate program manager of a utility sponsored energy efficiency program85,0008500usdbonuses are variable based on company's performance and the amount referenced is the full amount i'm possible to receiveusaillinoischicago5-7 years2 - 4 yearsmaster's degreewomanwhite 4/27/2021 11:05:0125-34salescsr39,520usdunited states oregonportland 8 - 10 years2 - 4 yearssome collegewomanwhite 4/27/2021 11:05:0445-54computing or techdirector of engineering115,000cadcanadaottawa21 - 30 years21 - 30 yearsmaster's degreemanwhite 4/27/2021 11:05:0525-34energyfuel efficiency program analyst76,0000usdunited states district of columbiawashington8 - 10 years5-7 yearscollege degreewomanwhite 4/27/2021 11:05:0555-64business or consultingsenior vice president of marketing180,00060000usdusamassachusettsboston31 - 40 years11 - 20 yearsmaster's degreewomanwhite 4/27/2021 11:05:0625-34accounting, banking & financeaccounting manager90,0000usdustennesseenashville5-7 years5-7 yearsmaster's degreewomanwhite 4/27/2021 11:05:0725-34government and public administrationtechnical assistantdata entry and processing for local government19,3000gbpunited kingdomnewcastle, uk5-7 years5-7 yearssome collegemanwhite 4/27/2021 11:05:0755-64business or consultingsenior administrative assistant and project specialist65,0005000usduswashingtonseattle31 - 40 years11 - 20 yearsmaster's degreewomanwhite 4/27/2021 11:05:0745-54computing or techsenior web application developer98,1660usdunited statesindianaindianapolis21 - 30 years21 - 30 yearscollege degreemanwhite 4/27/2021 11:05:0725-34education (primary/secondary)director of development63,500usdunited statestennesseenashville5-7 years1 year or lessmaster's degreewomanwhite 4/27/2021 11:05:0755-64environmental regulationquality assurance lead58usdusamarylandbaltimore21 - 30 years8 - 10 yearsmaster's degreewomanwhite 4/27/2021 11:05:0825-34nonprofitsprogram & administrative assistant47,7002000usdusadistrict of columbiawashington5-7 years2 - 4 yearscollege degreewomanwhite 4/27/2021 11:05:0855-64computing or techchief engineer87,0008000usdusaohiosolon31 - 40 years31 - 40 yearssome collegemanwhite 4/27/2021 11:05:1135-44media & digitalproduction co-ordinatorecomm studio48,000cadcanadamontreal8 - 10 years8 - 10 yearscollege degreewomanwhite 4/27/2021 11:05:1325-34education lack="" of="" effort.="" unfinished="" steps="" in="" the="" workflow.="" did="" not="" follow="" submission="" requirements.="" poor="" report="" with="" unclear,="" partial="" or="" edited="" screenshots.="" no="" explanations="" at="" all.="" 2="" other="" resources="" -power="" bi="" 1.="" getting="" started="" with="" power="" query="" a)="" https://docs.microsoft.com/en-us/power-query/power-query-what-is-power-query="" b)="" using="" the="" query="" editor:="" https://docs.microsoft.com/en-us/power-bi/desktop-query-overview="" c)="" common="" query="" tasks="" in="" power="" bi="" desktop:="" https://docs.microsoft.com/en-us/power-="" bi/desktop-common-query-tasks="" d)="" https://docs.microsoft.com/en-us/learn/modules/get-data-power-bi/="" 2.="" getting="" data="" from="" various="" sources:="" https://docs.microsoft.com/en-us/power-bi/desktop-data-sources="" a)="" csv:="" https://docs.microsoft.com/en-us/power-bi/desktop-connect-csv="" b)="" excel:="" https://docs.microsoft.com/en-us/power-bi/desktop-connect-excel="" c)="" web="" page:="" o="" https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-web="" o="" https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-data="" o="" https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-web-by-example="" live="" connection?="" tutorial="" getting="" data="" from="" aw="" data="" mart="" https://www.biinsight.com/connect-live-power-bi-to-ssas-multidimensional/="" 3.="" data="" cleaning="" and="" transformation="" a)="" data="" cleaning:="" https://www.digitalvidya.com/blog/data-cleaning-features-in-power-bi/="" b)="" shape="" and="" combine="" data:="" https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-="" combine-data="" c)="" calculated="" column:="" https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-="" calculated-columns="" d)="" data="" types:="" https://docs.microsoft.com/en-us/power-bi/desktop-data-types="" e)="" string="" functions:="" https://www.tutorialgateway.org/power-bi-dax-string-functions/="" f)="" https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/="" 4.="" some="" more="" extensive="" exercises="" a)="" https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-analyzing-sales-data-from-excel-="" and-an-odata-feed="" b)="" https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-importing-and-analyzing-data-="" from-a-web-page="" c)="" wiseowltutorials:="" https://www.youtube.com/watch?v="cKEAf78qLFM&list=PLNIs-" awhqzcnsmnbeupqrkuiqgplnb2hh&index="6" –="" complete="" four="" parts="" 3.1="" to="" 3.4="" (see="" all="" tutorials="" in="" the="" playlist).="" for="" part="" 3.2="" and="" 3.4,="" once="" completed,="" take="" a="" screenshot="" of="" the="" relationship="" view="" (clearly="" showing="" all="" tables="" and="" relationships),="" and="" a="" screenshot="" of="" data="" view="" for="" each="" table="" (clearly="" showing="" data="" values).="" include="" this="" part="" in="" the="" lab="" report.="" get="" data="" from="" sql="" server="" …="" power="" query="" -="" overview="" and="" learning="" 2="" •="" https://support.office.com/en-us/article/power-query-overview-and-learning-ed614c81-="" 4b00-4291-bd3a-55d80767f81d="" •="" https://support.office.com/en-us/article/power-query-101-008b3f46-5b14-4f8b-9a07-="" d3da689091b5="" power="" query="" with="" m="" language="" in="" excel="" https://support.office.com/en-us/article/introduction-to-microsoft-power-query-for-excel-6e92e2f4-="" 2079-4e1f-bad5-89f6269cd605="" form="" responses="" 1="" timestamp="" how="" old="" are="" you?="" what="" industry="" do="" you="" work="" in?="" job="" title="" if="" your="" job="" title="" needs="" additional="" context,="" please="" clarify="" here:="" what="" is="" your="" annual="" salary?="" (you'll="" indicate="" the="" currency="" in="" a="" later="" question.="" if="" you="" are="" part-time="" or="" hourly,="" please="" enter="" an="" annualized="" equivalent="" --="" what="" you="" would="" earn="" if="" you="" worked="" the="" job="" 40="" hours="" a="" week,="" 52="" weeks="" a="" year.)="" how="" much="" additional="" monetary="" compensation="" do="" you="" get,="" if="" any="" (for="" example,="" bonuses="" or="" overtime="" in="" an="" average="" year)?="" please="" only="" include="" monetary="" compensation="" here,="" not="" the="" value="" of="" benefits.="" please="" indicate="" the="" currency="" if="" "other,"="" please="" indicate="" the="" currency="" here:="" if="" your="" income="" needs="" additional="" context,="" please="" provide="" it="" here:="" what="" country="" do="" you="" work="" in?="" if="" you're="" in="" the="" u.s.,="" what="" state="" do="" you="" work="" in?="" what="" city="" do="" you="" work="" in?="" how="" many="" years="" of="" professional="" work="" experience="" do="" you="" have="" overall?="" how="" many="" years="" of="" professional="" work="" experience="" do="" you="" have="" in="" your="" field?="" what="" is="" your="" highest="" level="" of="" education="" completed?="" what="" is="" your="" gender?="" what="" is="" your="" race?="" (choose="" all="" that="" apply.)="" 4/27/2021="" 11:02:09="" 25-34="" education="" (higher="" education)="" research="" and="" instruction="" librarian="" 55,000="" 0="" usd="" united="" states="" massachusetts="" boston="" 5-7="" years="" 5-7="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:02:21="" 25-34="" computing="" or="" tech="" change="" &="" internal="" communications="" manager="" 54,600="" 4000="" gbp="" united="" kingdom="" cambridge="" 8="" -="" 10="" years="" 5-7="" years="" college="" degree="" non-binary="" white="" 4/27/2021="" 11:02:38="" 25-34="" accounting,="" banking="" &="" finance="" marketing="" specialist="" 34,000="" usd="" us="" tennessee="" chattanooga="" 2="" -="" 4="" years="" 2="" -="" 4="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:02:40="" 25-34="" nonprofits="" program="" manager="" 62,000="" 3000="" usd="" usa="" wisconsin="" milwaukee="" 8="" -="" 10="" years="" 5-7="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:02:41="" 25-34="" accounting,="" banking="" &="" finance="" accounting="" manager="" 60,000="" 7000="" usd="" us="" south="" carolina="" greenville="" 8="" -="" 10="" years="" 5-7="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:02:45="" 25-34="" education="" (higher="" education)="" scholarly="" publishing="" librarian="" 62,000="" usd="" usa="" new="" hampshire="" hanover="" 8="" -="" 10="" years="" 2="" -="" 4="" years="" master's="" degree="" man="" white="" 4/27/2021="" 11:02:50="" 25-34="" publishing="" publishing="" assistant="" 33,000="" 2000="" usd="" usa="" south="" carolina="" columbia="" 2="" -="" 4="" years="" 2="" -="" 4="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:02:59="" 25-34="" education="" (primary/secondary)="" librarian="" high="" school,="" ft="" 50,000="" usd="" united="" states="" arizona="" yuma="" 5-7="" years="" 5-7="" years="" master's="" degree="" man="" white="" 4/27/2021="" 11:03:01="" 45-54="" computing="" or="" tech="" systems="" analyst="" data="" developer/etl="" developer="" 112,000="" 10000="" usd="" us="" missouri="" st.="" louis="" 21="" -="" 30="" years="" 21="" -="" 30="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:03:01="" 35-44="" accounting,="" banking="" &="" finance="" senior="" accountant="" 45,000="" 0="" usd="" i="" work="" for="" a="" charter="" school="" united="" states="" florida="" palm="" coast="" 21="" -="" 30="" years="" 21="" -="" 30="" years="" college="" degree="" woman="" hispanic,="" latino,="" or="" spanish="" origin,="" white="" 4/27/2021="" 11:03:02="" 25-34="" nonprofits="" office="" manager="" 47,500="" 0="" usd="" united="" states="" boston,="" ma="" 5-7="" years="" 5-7="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:03:07="" 35-44="" education="" (higher="" education)="" deputy="" title="" ix="" coordinator/="" assistant="" director="" office="" of="" equity="" and="" diversity="" 62,000="" 0="" usd="" usa="" pennsylvania="" scranton="" 11="" -="" 20="" years="" 5-7="" years="" phd="" woman="" hispanic,="" latino,="" or="" spanish="" origin,="" white="" 4/27/2021="" 11:03:09="" 35-44="" accounting,="" banking="" &="" finance="" manager="" of="" information="" services="" 100,000="" 0="" usd="" united="" states="" michigan="" detroit="" 11="" -="" 20="" years="" 11="" -="" 20="" years="" college="" degree="" man="" asian="" or="" asian="" american,="" white="" 4/27/2021="" 11:03:09="" 25-34="" law="" legal="" aid="" staff="" attorney="" non-profit="" law="" firm="" 52,000="" 0="" usd="" united="" states="" minnesota="" saint="" paul="" 2="" -="" 4="" years="" 2="" -="" 4="" years="" woman="" white="" 4/27/2021="" 11:03:10="" 18-24="" health="" care="" patient="" care="" coordinator="" 32,000="" cad="" canada="" remote="" 1="" year="" or="" less="" 1="" year="" or="" less="" college="" degree="" woman="" white="" 4/27/2021="" 11:03:11="" 35-44="" utilities="" &="" telecommunications="" quality="" and="" compliance="" specialist="" 24,000="" 500="" gbp="" united="" kingdom="" lincoln="" 11="" -="" 20="" years="" 5-7="" years="" college="" degree="" man="" white="" 4/27/2021="" 11:03:13="" 35-44="" business="" or="" consulting="" executive="" assistant="" 85,000="" 5000="" usd="" usa="" illinois="" chicago="" 8="" -="" 10="" years="" 8="" -="" 10="" years="" some="" college="" woman="" white="" 4/27/2021="" 11:03:18="" 45-54="" art="" &="" design="" graphic="" designer="" 59,000="" usd="" usa="" california="" pomona="" 21="" -="" 30="" years="" 21="" -="" 30="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:03:20="" 35-44="" business="" or="" consulting="" senior="" manager="" 98,000="" 1000="" usd="" usa="" georgia="" atlanta="" 11="" -="" 20="" years="" 2="" -="" 4="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:03:23="" 35-44="" education="" (higher="" education)="" assistant="" director="" of="" academic="" advising="" 54,000="" usd="" united="" states="" florida="" boca="" raton="" 11="" -="" 20="" years="" 11="" -="" 20="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:03:23="" 25-34="" health="" care="" data="" programmer="" analyst="" 74,000="" 0="" usd="" usa="" pennsylvania="" philadelphia="" 5-7="" years="" 5-7="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:03:24="" 35-44="" nonprofits="" program="" coordinator="" &="" assistant="" editor="" 50,000="" usd="" united="" states="" atlanta="" 5-7="" years="" 2="" -="" 4="" years="" phd="" woman="" white="" 4/27/2021="" 11:03:27="" 35-44="" nonprofits="" event="" planner="" 63,000="" cad="" canada="" toronto="" 11="" -="" 20="" years="" 8="" -="" 10="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:03:28="" 35-44="" government="" and="" public="" administration="" researcher="" 96,000="" 1000="" usd="" united="" states="" ohio="" dayton="" 8="" -="" 10="" years="" 2="" -="" 4="" years="" phd="" woman="" asian="" or="" asian="" american="" 4/27/2021="" 11:03:31="" 25-34="" public="" library="" teen="" librarian="" 44,500="" 0="" usd="" us="" florida="" bradenton="" 5-7="" years="" 2="" -="" 4="" years="" woman="" white="" 4/27/2021="" 11:03:34="" 35-44="" education="" (higher="" education)="" communications="" specialist="" 60,000="" 0="" usd="" usa="" michigan="" ann="" arbor="" 11="" -="" 20="" years="" 1="" year="" or="" less="" master's="" degree="" woman="" white="" 4/27/2021="" 11:03:37="" 25-34="" nonprofits="" program="" director="" i="" manage="" staff="" members="" who="" each="" manage="" 8-15="" other="" people.="" 62,000="" usd="" us="" district="" of="" columbia="" washington="" dc="" 5-7="" years="" 2="" -="" 4="" years="" college="" degree="" man="" white="" 4/27/2021="" 11:03:40="" 35-44="" law="" bookkeeper/billing="" manager="" 48,000="" 4000="" usd="" usa="" maryland="" silver="" spring="" 11="" -="" 20="" years="" 2="" -="" 4="" years="" college="" degree="" woman="" another="" option="" not="" listed="" here="" or="" prefer="" not="" to="" answer="" 4/27/2021="" 11:03:41="" 35-44="" government="" and="" public="" administration="" economist="" 140,000="" usd="" usa="" district="" of="" columbia="" washington="" 11="" -="" 20="" years="" 11="" -="" 20="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:03:42="" 25-34="" engineering="" or="" manufacturing="" research="" engineer="" 80,000="" usd="" united="" states="" texas="" san="" antonio="" 5-7="" years="" 5-7="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:03:43="" 25-34="" nonprofits="" volunteer="" and="" giving="" coordinator="" 39,000="" usd="" united="" states="" minnesota="" minneapolis="" 2="" -="" 4="" years="" 2="" -="" 4="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:03:43="" 35-44="" media="" &="" digital="" editor="" 125,000="" 0="" usd="" usa="" district="" of="" columbia="" washington,="" dc="" 11="" -="" 20="" years="" 8="" -="" 10="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:03:45="" 25-34="" accounting,="" banking="" &="" finance="" financial="" advisor="" 230,000="" usd="" commission="" based="" usa="" missouri="" st.="" louis="" 11="" -="" 20="" years="" 11="" -="" 20="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:03:45="" 35-44="" accounting,="" banking="" &="" finance="" accounting="" manager="" 110,000="" 15000="" usd="" us="" virginia="" richmond="" 21="" -="" 30="" years="" 11="" -="" 20="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:03:53="" 25-34="" nonprofits="" administrative="" and="" hr="" manager="" 50,000="" usd="" united="" states="" district="" of="" columbia="" washington="" 5-7="" years="" 2="" -="" 4="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:03:54="" 35-44="" education="" (higher="" education)="" senior="" irb="" analyst="" state="" university,="" higher="" ed="" research="" adminstration="" 68,000="" 0="" usd="" usa="" north="" carolina="" research="" triangle="" 5-7="" years="" 2="" -="" 4="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:03:55="" 18-24="" media="" &="" digital="" reporter="" 41,000="" 100="" usd="" united="" states="" michigan="" kalamazoo="" 2="" -="" 4="" years="" 2="" -="" 4="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:03:56="" 25-34="" accounting,="" banking="" &="" finance="" senior="" administrator="" 76,000="" 10000="" usd="" united="" states="" new="" york="" manhattan="" 5-7="" years="" 2="" -="" 4="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:03:57="" 35-44="" government="" and="" public="" administration="" staff="" services="" manager="" ii="" mid-level="" manager,="" team="" of="" 13="" 78,000="" 0="" usd="" usa="" california="" sacramento="" 8="" -="" 10="" years="" 5-7="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:03:58="" 25-34="" accounting,="" banking="" &="" finance="" receptionist="" 37,000="" 0="" usd="" usa="" texas="" dallas="" 2="" -="" 4="" years="" 2="" -="" 4="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:04:01="" 45-54="" engineering="" or="" manufacturing="" lead="" engineer="" supervisor="" level="" with="" no="" direct="" reports="" 100,000="" 50000="" usd="" usa="" georgia="" waynesboro="" 21="" -="" 30="" years="" 21="" -="" 30="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:04:01="" 35-44="" marketing,="" advertising="" &="" pr="" senior="" copywriter="" 35,000="" 6000="" gbp="" uk="" liverpool="" 11="" -="" 20="" years="" 11="" -="" 20="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:04:01="" 25-34="" government="" and="" public="" administration="" manager="" of="" data="" integrity="" and="" prospect="" research="" 65,000="" 0="" usd="" usa="" virginia="" richmond="" 5-7="" years="" 5-7="" years="" college="" degree="" man="" white="" 4/27/2021="" 11:04:03="" 25-34="" computing="" or="" tech="" principal="" software="" engineer="" 187,500="" 5000="" usd="" united="" states="" pennsylvania="" pittsburgh="" 8="" -="" 10="" years="" 5-7="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:04:03="" 25-34="" computing="" or="" tech="" intelligence="" analyst="" 110,000="" 20000="" usd="" around="" 20,000="" a="" year="" in="" stock="" usa="" virginia="" arlington,="" va="" 8="" -="" 10="" years="" 8="" -="" 10="" years="" master's="" degree="" man="" white="" 4/27/2021="" 11:04:04="" 25-34="" nonprofits="" project="" manager="" 66,625="" 1500="" usd="" us="" massachusetts="" boston="" 8="" -="" 10="" years="" 8="" -="" 10="" years="" college="" degree="" woman="" hispanic,="" latino,="" or="" spanish="" origin,="" white="" 4/27/2021="" 11:04:06="" 35-44="" computing="" or="" tech="" mobile="" developer="" 144,600="" 2500="" usd="" usa="" massachusetts="" boston="" 5-7="" years="" 5-7="" years="" phd="" woman="" white="" 4/27/2021="" 11:04:09="" 35-44="" computing="" or="" tech="" product="" design="" director="" 200,850="" 40000="" usd="" usa="" north="" carolina="" chapel="" hill="" 11="" -="" 20="" years="" 11="" -="" 20="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:04:09="" 25-34="" engineering="" or="" manufacturing="" engineering="" specialist="" 120,000="" 1500="" cad="" canada="" vancouver="" 11="" -="" 20="" years="" 8="" -="" 10="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:04:10="" 25-34="" retail="" manager,="" total="" rewards="" 97,500="" 10000="" cad="" canada="" toronto="" 8="" -="" 10="" years="" 8="" -="" 10="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:04:10="" 35-44="" education="" (higher="" education)="" research="" and="" development="" engineer="" 3="" process="" engineer="" in="" a="" university="" cleanroom="" 96,000="" usd="" united="" states="" california="" berkeley="" 5-7="" years="" 5-7="" years="" phd="" woman="" white="" 4/27/2021="" 11:04:11="" 25-34="" education="" (primary/secondary)="" science="" teacher="" (public="" high="" school)="" 53,000="" 1000="" usd="" united="" states="" minnesota="" apple="" valley="" 5-7="" years="" 1="" year="" or="" less="" master's="" degree="" woman="" white="" 4/27/2021="" 11:04:15="" 25-34="" marketing,="" advertising="" &="" pr="" senior="" manager,="" programmatic="" 95,000="" 10000="" usd="" united="" states="" illinois="" chicago="" 8="" -="" 10="" years="" 8="" -="" 10="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:04:19="" 35-44="" computing="" or="" tech="" managed="" services="" sales="" coordinator="" primarily="" proposal="" writing="" 72,000="" 3000="" usd="" united="" states="" michigan="" troy="" 11="" -="" 20="" years="" 5-7="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:04:21="" 35-44="" media="" &="" digital="" editor="" 52,000="" 0="" cad="" canada="" toronto="" 11="" -="" 20="" years="" 11="" -="" 20="" years="" college="" degree="" woman="" asian="" or="" asian="" american="" 4/27/2021="" 11:04:22="" 35-44="" engineering="" or="" manufacturing="" water="" resources="" engineer="" 106,000="" 0="" usd="" united="" states="" massachusetts="" boston="" 21="" -="" 30="" years="" 11="" -="" 20="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:04:24="" 25-34="" government="" and="" public="" administration="" program="" officer="" 115,000="" usd="" united="" states="" district="" of="" columbia="" dc="" 5-7="" years="" 5-7="" years="" phd="" woman="" hispanic,="" latino,="" or="" spanish="" origin="" 4/27/2021="" 11:04:26="" 25-34="" business="" or="" consulting="" account="" supervisor="" program="" manager="" for="" government="" contractor="" 100,500="" 3000="" usd="" us="" district="" of="" columbia="" washington="" 11="" -="" 20="" years="" 5-7="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:04:27="" 25-34="" law="" legal="" secretary="" 33,200="" 0="" usd="" us="" new="" jersey="" linden="" 8="" -="" 10="" years="" 2="" -="" 4="" years="" some="" college="" woman="" white="" 4/27/2021="" 11:04:27="" 35-44="" government="" and="" public="" administration="" policy="" lead="" middle="" manager="" policy="" role="" in="" public="" sector.="" 52,000="" 0="" gbp="" united="" kingdom="" bristol="" 11="" -="" 20="" years="" 11="" -="" 20="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:04:27="" 25-34="" education="" (higher="" education)="" coordinator="" 52,000="" usd="" united="" states="" illinois="" champaign="" 8="" -="" 10="" years="" 8="" -="" 10="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:04:29="" 25-34="" government="" and="" public="" administration="" senior="" advisor="" 79,000="" cad="" canada="" nova="" scotia="" 8="" -="" 10="" years="" 5-7="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:04:29="" 65="" or="" over="" property="" or="" construction="" safety="" director="" 104,000="" 25000="" usd="" extra="" money="" comes="" from="" overtime="" usa="" georgia="" atlanta="" 41="" years="" or="" more="" 21="" -="" 30="" years="" college="" degree="" man="" white="" 4/27/2021="" 11:04:31="" 25-34="" education="" (primary/secondary)="" secondary="" school="" educator="" 75,000="" cad="" canada="" ottawa="" 5-7="" years="" 2="" -="" 4="" years="" college="" degree="" woman="" asian="" or="" asian="" american="" 4/27/2021="" 11:04:31="" 18-24="" biotechnology="" downstream="" process="" development="" research="" associate="" i="" 52,000="" usd="" united="" states="" texas="" bryan="" 2="" -="" 4="" years="" 2="" -="" 4="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:04:32="" 25-34="" education="" (higher="" education)="" research="" programmer="" software="" engineering="" without="" the="" job="" title="" 70,000="" 0="" usd="" technically="" 37.5="" hours,="" but="" ends="" up="" being="" pretty="" similar="" usa="" rhode="" island="" providence="" 5-7="" years="" 2="" -="" 4="" years="" master's="" degree="" non-binary="" white="" 4/27/2021="" 11:04:34="" 25-34="" nonprofits="" manager,="" natural="" climate="" solutions="" development="" this="" is="" not="" a="" non-profit="" development/fundraising="" role.="" 84,000="" 8400="" usd="" united="" states="" district="" of="" columbia="" district="" of="" columbia="" 5-7="" years="" 5-7="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:04:34="" 35-44="" health="" care="" ar="" manager="" 53,000="" 0="" usd="" united="" states="" illinois="" bloomington="" 21="" -="" 30="" years="" 11="" -="" 20="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:04:36="" 25-34="" computing="" or="" tech="" technical="" specialist="" 34,000="" 2000="" usd="" united="" states="" minnesota="" minneapolis="" 5-7="" years="" 5-7="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:04:37="" 25-34="" nonprofits="" programming="" coordinator="" 38,000="" usd="" us="" colorado="" denver="" 5-7="" years="" 2="" -="" 4="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:04:38="" 25-34="" government="" and="" public="" administration="" city="" research="" scientist="" ii="" public="" health="" research="" and="" data="" analysis="" 87,000="" 0="" usd="" united="" states="" new="" york="" new="" york="" city="" 5-7="" years="" 2="" -="" 4="" years="" master's="" degree="" man="" white="" 4/27/2021="" 11:04:39="" 35-44="" aerospace="" contracting="" project="" engineer="" cost/schedule="" analyst="" 122,000="" 3600="" usd="" united="" states="" colorado="" springs="" 11="" -="" 20="" years="" 11="" -="" 20="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:04:39="" 25-34="" insurance="" pricing="" analyst="" 45,000="" 2000="" gbp="" uk="" southampton="" 5-7="" years="" 2="" -="" 4="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:04:40="" 25-34="" engineering="" or="" manufacturing="" marketing="" coordinator="" 45,000="" usd="" united="" states="" south="" carolina="" columbia="" 5-7="" years="" 5-7="" years="" some="" college="" woman="" white="" 4/27/2021="" 11:04:41="" 35-44="" computing="" or="" tech="" tech="" writer="" 88,000="" usd="" usa="" maryland="" prefer="" not="" to="" answer="" 11="" -="" 20="" years="" 8="" -="" 10="" years="" college="" degree="" woman="" another="" option="" not="" listed="" here="" or="" prefer="" not="" to="" answer="" 4/27/2021="" 11:04:43="" 35-44="" nonprofits="" supervisory="" archivist="" at="" a="" historical="" society="" 71,000="" 0="" usd="" us="" new="" york="" nyc="" (remotely)="" 11="" -="" 20="" years="" 8="" -="" 10="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:04:43="" 45-54="" education="" (higher="" education)="" program="" manager="" 71,000="" usd="" usa="" illinois="" champaign="" 11="" -="" 20="" years="" 11="" -="" 20="" years="" phd="" woman="" white="" 4/27/2021="" 11:04:45="" 35-44="" education="" (primary/secondary)="" high="" school="" teacher="" at="" an="" independent="" school="" 75,000="" 0="" usd="" united="" states="" georgia="" atlanta="" 11="" -="" 20="" years="" 11="" -="" 20="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:04:48="" 35-44="" education="" (higher="" education)="" manager="" of="" market="" research="" and="" data="" my="" group="" is="" responsible="" for="" data="" gathering,="" analysis="" and="" reporting="" to="" state="" and="" federal="" stakeholders="" as="" well="" as="" strategic="" initiatives="" and="" grant="" applications.="" we="" also="" manage="" the="" organization's="" crm="" system.="" 80,000="" 0="" usd="" usa="" north="" carolina="" raleigh="" 21="" -="" 30="" years="" 11="" -="" 20="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:04:48="" 35-44="" computing="" or="" tech="" senior="" business="" analyst="" 125,000="" usd="" us="" new="" york="" new="" york="" 11="" -="" 20="" years="" 8="" -="" 10="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:04:50="" 35-44="" education="" (higher="" education)="" special="" collections="" cataloger="" tenure-track="" faculty="" 65,000="" usd="" united="" states="" pennsylvania="" -----="" 11="" -="" 20="" years="" 11="" -="" 20="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:04:51="" 45-54="" education="" (primary/secondary)="" teacher="" 36,000="" gbp="" scotland="" edinburgh="" 21="" -="" 30="" years="" 21="" -="" 30="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:04:54="" 25-34="" nonprofits="" graphic="" designer="" webmaster="" 55,000="" usd="" u.s.="" minnesota="" st.="" paul="" 2="" -="" 4="" years="" 2="" -="" 4="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:04:54="" 25-34="" art="" &="" design="" senior="" ux="" designer="" 90,000="" 1000="" usd="" usa="" pennsylvania="" philadelphia="" 11="" -="" 20="" years="" 8="" -="" 10="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:04:58="" 35-44="" engineering="" or="" manufacturing="" senior="" engineer="" 105,000="" 13000="" usd="" united="" states="" pennsylvania="" philadelphia="" (suburbs)="" 8="" -="" 10="" years="" 5-7="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:05:01="" 35-44="" nonprofits="" office="" administrator="" 60,000="" 0="" cad="" canada="" kitchener,="" ontario="" 11="" -="" 20="" years="" 11="" -="" 20="" years="" high="" school="" man="" white="" 4/27/2021="" 11:05:01="" 35-44="" education="" (higher="" education)="" digital="" archivist="" 65,000="" 0="" usd="" united="" states="" pennsylvania="" philadelphia="" 11="" -="" 20="" years="" 8="" -="" 10="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:05:01="" 25-34="" business="" or="" consulting="" associate="" program="" manager="" associate="" program="" manager="" of="" a="" utility="" sponsored="" energy="" efficiency="" program="" 85,000="" 8500="" usd="" bonuses="" are="" variable="" based="" on="" company's="" performance="" and="" the="" amount="" referenced="" is="" the="" full="" amount="" i'm="" possible="" to="" receive="" usa="" illinois="" chicago="" 5-7="" years="" 2="" -="" 4="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:05:01="" 25-34="" sales="" csr="" 39,520="" usd="" united="" states="" oregon="" portland="" 8="" -="" 10="" years="" 2="" -="" 4="" years="" some="" college="" woman="" white="" 4/27/2021="" 11:05:04="" 45-54="" computing="" or="" tech="" director="" of="" engineering="" 115,000="" cad="" canada="" ottawa="" 21="" -="" 30="" years="" 21="" -="" 30="" years="" master's="" degree="" man="" white="" 4/27/2021="" 11:05:05="" 25-34="" energy="" fuel="" efficiency="" program="" analyst="" 76,000="" 0="" usd="" united="" states="" district="" of="" columbia="" washington="" 8="" -="" 10="" years="" 5-7="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:05:05="" 55-64="" business="" or="" consulting="" senior="" vice="" president="" of="" marketing="" 180,000="" 60000="" usd="" usa="" massachusetts="" boston="" 31="" -="" 40="" years="" 11="" -="" 20="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:05:06="" 25-34="" accounting,="" banking="" &="" finance="" accounting="" manager="" 90,000="" 0="" usd="" us="" tennessee="" nashville="" 5-7="" years="" 5-7="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:05:07="" 25-34="" government="" and="" public="" administration="" technical="" assistant="" data="" entry="" and="" processing="" for="" local="" government="" 19,300="" 0="" gbp="" united="" kingdom="" newcastle,="" uk="" 5-7="" years="" 5-7="" years="" some="" college="" man="" white="" 4/27/2021="" 11:05:07="" 55-64="" business="" or="" consulting="" senior="" administrative="" assistant="" and="" project="" specialist="" 65,000="" 5000="" usd="" us="" washington="" seattle="" 31="" -="" 40="" years="" 11="" -="" 20="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:05:07="" 45-54="" computing="" or="" tech="" senior="" web="" application="" developer="" 98,166="" 0="" usd="" united="" states="" indiana="" indianapolis="" 21="" -="" 30="" years="" 21="" -="" 30="" years="" college="" degree="" man="" white="" 4/27/2021="" 11:05:07="" 25-34="" education="" (primary/secondary)="" director="" of="" development="" 63,500="" usd="" united="" states="" tennessee="" nashville="" 5-7="" years="" 1="" year="" or="" less="" master's="" degree="" woman="" white="" 4/27/2021="" 11:05:07="" 55-64="" environmental="" regulation="" quality="" assurance="" lead="" 58="" usd="" usa="" maryland="" baltimore="" 21="" -="" 30="" years="" 8="" -="" 10="" years="" master's="" degree="" woman="" white="" 4/27/2021="" 11:05:08="" 25-34="" nonprofits="" program="" &="" administrative="" assistant="" 47,700="" 2000="" usd="" usa="" district="" of="" columbia="" washington="" 5-7="" years="" 2="" -="" 4="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:05:08="" 55-64="" computing="" or="" tech="" chief="" engineer="" 87,000="" 8000="" usd="" usa="" ohio="" solon="" 31="" -="" 40="" years="" 31="" -="" 40="" years="" some="" college="" man="" white="" 4/27/2021="" 11:05:11="" 35-44="" media="" &="" digital="" production="" co-ordinator="" ecomm="" studio="" 48,000="" cad="" canada="" montreal="" 8="" -="" 10="" years="" 8="" -="" 10="" years="" college="" degree="" woman="" white="" 4/27/2021="" 11:05:13="" 25-34="">