! I am having an absolute brain fart. This is for my data entry and visualizatio
ID: 337344 • Letter: #
Question
! I am having an absolute brain fart. This is for my data entry and visualization class
What and how do I need to filter in order to identify the top 10 issues with the most complaints. This only part of the data set.
Also I need to complete the following:
Query Creation and Data Model Management (importing the dataset in CSV format, editing the query using Power Query, transforming the data using Power Query, adding hierarchy fields to the Data Model, etc.)
I just need instructions on how to get started with them!
US_Consumer Complaints Dataset 2012_To 2016 (2) (version 1) AutoRecovered Exce File Home Insert Page Layout Formulas Review View Help Power Pivot Tell me what you want to do Larr om Tetcsv BResting Connections DataEl From Table/Range Co-Quenes & Connections ??-T.Reapply ,-: d4?Gro oup .?2. Soler l E Columns-o.?Analysis." Sheet E Ungroup GE Subtotal Edit L ?Advanced Get & Transform Data Forecast 1Compl DateDateTitleDayst Produ Sub pIssueSubi Comp State ZIPcoSubm Comp TimelConsur disputed 10001 Referral Closed w No 10002 Referral Closed w Yes 10004 Referral Closed w Yes 10007 Web Closed wYes 10009 Postal m Closed w Yes 10009 Postal m Closed w Yes 10023 Web Closed w No 10024 Postal m Closed w Yes 10025 Referral Closed wYes 40 Debt coll Other (i.cTaking/tt Attempte Mullool NY 4 Debt coll Other ( Taking/tt Threaten PortfolicNY 5 Debt coll Credit ca Taking/t AttemptE H 0 Debt coll Non-fede Taking/tt Sued wh Forster ENY 3 Debt coll Credit ca Taking/th Attempte Selip & NY 5 Debt coll Credit co Takine/th Attempte Discovei NY 7 Debt coll Credit ca Taking/th Sued w/c Pressler NY 1 Debt coll Credit ca Taking/tt Sued w/c Citibank NY 1 Debt coll Other (i.e Taking/th Attempte Navient NY 0 Debt coll I do notiTaking/t Threaten Linebare NY 0 Debt coll Credit co Takine/th Sued w/cSelip & NY 0 Debt coll Credit ca Taking/th Sued w/c Encore CNY 26 Debt coll Credit ca Taking/tt Attempte Client SENY 24 Debt coll Other (i.e Taking/t Attempte The CMI NY 1 Debt coll Credit ca Taking/th Attempte Portfolic NY 3 Debt coll Credit co Takine/th Attempte JH Portfo NY 4 Debt coll Credit ca Taking/tt Attempte Synchror NY Debt coll Medical Taking/tt Sued whTranswC NY 5 Debt coll Other (i.e Taking/th Attempte Encore CNY 33 Debt coll Credit ca Taking/t Sued w/c Asta Fur NY 7 Debt coll Other (i. Takine/th Attempte JH Portfo NY 0 Debt coll Credit ca Taking/tt Threaten Eltman I NY Debt coll Credit ca Taking/t Threaten Citibank NY 0 Debt coll Federal Taking/tt Sued wh Expert G NY 10028 Web 10028 Web Closed w Yes Closed w Yes 10029 Referral Closed w No 10029 Refera Closed w Yes 10029 Referral Closed w Yes 10029 Referral Closed w Yes 10029 Web Closed w Yes 10031 Referral Closed wYes 10037 Web Closed w No 10039 Referral Closed w No 10128 Web Closed w Yes 10128 Web Closed w Yes 10301 Web Closed wYes 16 739858 3/3/2014 3/4/2014 TRUE 17 739859 3/3/2014 3/6/2014 TRUE US Consumer Complaints Dataset O Type here to searchExplanation / Answer
! I am having an absolute brain fart. This is for my data entry and visualization class
What and how do I need to filter in order to identify the top 10 issues with the most complaints. This only part of the data set.
Also I need to complete the following:
Query Creation and Data Model Management (importing the dataset in CSV format, editing the query using Power Query, transforming the data using Power Query, adding hierarchy fields to the Data Model, etc.)
I just need instructions on how to get started with them!
US_Consumer Complaints Dataset 2012_To 2016 (2) (version 1) AutoRecovered Exce File Home Insert Page Layout Formulas Review View Help Power Pivot Tell me what you want to do Larr om Tetcsv BResting Connections DataEl From Table/Range Co-Quenes & Connections ??-T.Reapply ,-: d4?Gro oup .?2. Soler l E Columns-o.?Analysis." Sheet E Ungroup GE Subtotal Edit L ?Advanced Get & Transform Data Forecast 1Compl DateDateTitleDayst Produ Sub pIssueSubi Comp State ZIPcoSubm Comp TimelConsur disputed 10001 Referral Closed w No 10002 Referral Closed w Yes 10004 Referral Closed w Yes 10007 Web Closed wYes 10009 Postal m Closed w Yes 10009 Postal m Closed w Yes 10023 Web Closed w No 10024 Postal m Closed w Yes 10025 Referral Closed wYes 40 Debt coll Other (i.cTaking/tt Attempte Mullool NY 4 Debt coll Other ( Taking/tt Threaten PortfolicNY 5 Debt coll Credit ca Taking/t AttemptE H 0 Debt coll Non-fede Taking/tt Sued wh Forster ENY 3 Debt coll Credit ca Taking/th Attempte Selip & NY 5 Debt coll Credit co Takine/th Attempte Discovei NY 7 Debt coll Credit ca Taking/th Sued w/c Pressler NY 1 Debt coll Credit ca Taking/tt Sued w/c Citibank NY 1 Debt coll Other (i.e Taking/th Attempte Navient NY 0 Debt coll I do notiTaking/t Threaten Linebare NY 0 Debt coll Credit co Takine/th Sued w/cSelip & NY 0 Debt coll Credit ca Taking/th Sued w/c Encore CNY 26 Debt coll Credit ca Taking/tt Attempte Client SENY 24 Debt coll Other (i.e Taking/t Attempte The CMI NY 1 Debt coll Credit ca Taking/th Attempte Portfolic NY 3 Debt coll Credit co Takine/th Attempte JH Portfo NY 4 Debt coll Credit ca Taking/tt Attempte Synchror NY Debt coll Medical Taking/tt Sued whTranswC NY 5 Debt coll Other (i.e Taking/th Attempte Encore CNY 33 Debt coll Credit ca Taking/t Sued w/c Asta Fur NY 7 Debt coll Other (i. Takine/th Attempte JH Portfo NY 0 Debt coll Credit ca Taking/tt Threaten Eltman I NY Debt coll Credit ca Taking/t Threaten Citibank NY 0 Debt coll Federal Taking/tt Sued wh Expert G NY 10028 Web 10028 Web Closed w Yes Closed w Yes 10029 Referral Closed w No 10029 Refera Closed w Yes 10029 Referral Closed w Yes 10029 Referral Closed w Yes 10029 Web Closed w Yes 10031 Referral Closed wYes 10037 Web Closed w No 10039 Referral Closed w No 10128 Web Closed w Yes 10128 Web Closed w Yes 10301 Web Closed wYes 16 739858 3/3/2014 3/4/2014 TRUE 17 739859 3/3/2014 3/6/2014 TRUE US Consumer Complaints Dataset O Type here to searchRelated Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.