Data Analyst Technician

Washtenaw Community College

Online - On DemandType
12 Continuing Education UnitsEducation Credits
25 AvailableTotal Seats

Course Details

Master skills that are essential in data analysis, business intelligence, management and engineering. Work with Microsoft Excel to collect and manage data. Using actual mobility data, this course will cover concepts from Excel and the Excel course certification exam. Additional topics show the relationship of XML with Microsoft Excel, including importing, mapping schema and exporting content. Finally, visualization of the data is taught using Power BI, where you will learn how to query data, transform dates and text, and create and publish reports.

What You'll Learn
Demonstrate a thorough understanding of Microsoft Excel Describe and apply data collection and management techniques Create formulas to analyze and present complex information Define the relationship between XML and Microsoft Excel Use Power BI to query data, transform dates and text, and create and publish reports

Skills you'll acquire

Critical ThinkingReading ComprehensionQuality Control AnalysisActive ListeningSocial Perceptiveness
View all skills

Knowledge Outcomes and Experience

  • Business Intelligence Analysts
  • Computer & Information Research Scientists
  • Intelligence Analysts
  • Data Warehousing Specialists

Course Content

Need Help Choosing? Compare courses side by side to help you choose the right one for your learning journey!
Similar Available CoursesExplore other similar courses that align with your interests and career goals.
Similar Available CoursesExplore other similar courses that align with your interests and career goals.