Data Analyst Technician

$NaN

Need Financial Assistance?

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.

After This Course, You Will Be Able To

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