Are you interested in pursuing a career in data analytics? In this course, instructor Robin Hunt brings you into the mind of an analyst. She defines and explains foundational concepts, such as how to think about data, how to work with others in different roles to get the data you need, and the tools you need to work with data, such as Excel and Microsoft Access. She introduces you to SQL queries, PowerBI, and more. Robin goes into syntax and explains how to interpret the data you see, find the data you need, and clean the data for effective data work. She explains data governance and how to ask the right questions of different departments to gather the data you need. Robin shows how to work with data, including how to import data, work with flat files such as CSVs, and create datasets for others. Robin goes into what cleaning and modeling mean, as well as how to use Power Query in Excel. She has also added challenge/solution sets in each chapter to help you evaluate your skills.
Learn More- Seek Your Pathways
- Explore Academics
- Anthropology
- Communication
- Economics
- Journalism
- Landscape Architecture
- Legal Studies
- Managerial Economics
- Political Science
- Public Policy
- Environmental & Natural Resource Economics
- Social Thought & Political Economy (STPEC)
- Sociology
- Sustainable Community Development
- SBS Exploratory Track
- Minors, Certificates, and More
- SBS 4+1 Accelerated Masters Programs
- Explore Careers
- What are Career Communities?
- Advertising / Public Relations / Marketing
- Business / Entrepreneurship / Management / Consulting
- Health / Research / Education / Culture
- Environment / Natural Resources / Sustainability
- Finance / Investment / Real Estate / Insurance
- Government / Public Policy / International Relations
- Law / Legal Services / Criminology / Forensics
- Media / Journalism / Entertainment
- Non-Profit / Social Justice / Activism
- Technology / Data / Analytics
- Our Diverse Communities
- What Are Diverse Communities?
- SBS RISE: Remedying Inequity through Student Engagement
- Black, Indigenous & Students of Color
- First Generation Students
- International Students
- LGBTQIA+ Students
- Student Athletes
- Students with Disabilities
- Students with Financial Need
- Transfer Students
- Veterans
- Women in the Workforce
- Post-Grad Planning
- Who We Serve
- How do I?
- Complete Academic/Degree Tasks
- Apply for Scholarships and Awards
- Declare an SBS Major
- Meet with an Academic Advisor
- Meet with an Academic Dean
- Suggest New Courses
- Petition for Late Add
- Petition for Pass/Fail
- Withdraw from a Class/Petition for Late Withdrawal
- Petition for Course Credit Overload
- Release Academic Information (FERPA)
- Withdraw from the University
- Explore Majors, Experiential, and Professional Pathways
- Apply for Funding for Internships, Study Abroad, Research, and other High-impact Opportunities
- Assess My Skills and Interests
- Explore Majors
- Find an Undergraduate Research Opportunity
- Get Involved on Campus
- Learn about Different Career Paths
- Study Abroad
- Take Courses through the Five Colleges
- Domestic Exchange
- Get Career Ready
- Apply for Scholarships to Support Research or Internships
- Develop My Job Search Skills & Strategy
- Look for Internships and Jobs
- Meet with a Career Advisor
- Negotiate an Offer
- Network and Connect with Mentors
- Prepare a Resume and Cover Letter
- Prepare for/Navigate a Career Fair
- Prepare for an Interview
- Register an Internship for Credit
- Write a Personal Statement for Graduate School
- Complete Academic/Degree Tasks