Data analysis is a process of inspecting, cleansing, transforming and modeling data with the goal of discovering useful information, informing conclusions and supporting decision-making. Data analysis has multiple facets and approaches, encompassing diverse techniques under a variety of names, and is used in different business, science, and social science domains. In today’s business world, data analysis plays a role in making decisions more scientific and helping businesses operate more effectively.
Course Objectives
Upon completing this Data Analysis Training Certification course successfully, participants will be able to:
- Learn about data model creation
- Explore, analyse, and visualise data
- Sift data using slicers in multiple pivot tables
- Produce aggregate reports using formula-based techniques
- Collect and transform data from multiple sources
- Understand and combine data in mashups
- Generate flexible data aggregations using pivot tables
- Exemplify data visually using pivot charts
- Evaluate margins and other popular ratios using calculation on the pivot table
Who Should Attend?
This Data Analysis Training course would be suitable for:
- IT Professionals
- Testing professionals
- Programming Developers and System Administrators
- Business Intelligence, Data Warehousing and Analytics Professionals
- Data Engineers
- Data Analysts & Business Intelligence Professionals
- Database Administrators and other DB professionals
- Anyone who works with Excel regularly
- Individuals who want to learn data exploration and analysis
- Anyone looking to pursue a career in data analysis or business intelligence
- Participants looking for a comprehensive, engaging, and highly interactive approach to training
Course OutlineMODULE 1: DATA ANALYSIS WITH EXCEL
- pivot tablespivot charts and slicers