The program focuses on the following objectives:
- Introduction to Data Analysis and reporting field.
- Common Data Problems and how to apply validations.
- What are the 3 steps followed in the Data Analysis field.
- What are the various tools that can be used to collect, analyze and visualize data.
- What are the various datatypes that can be added to our data collection form.
- How to properly validate data entries and reject any wrong or invalid entry.
- What are the differences among Column Chart, Pie Chart, Line Chart, Histogram.
- How to extract data from Google Forms and analyze them on Google Sheets.
- How to benefit and take advantage of the online feature in Google Sheets to synchronize our data among team members and analysts.
- How to use Data Validation to validate every data entered in a cell to be correct and prevent any wrong data analysis.
- How to use conditional formatting.
- How to use data bars and icon sets to easily display analytics.
- How to use advanced functions and charts to represent your data for easier analysis.
- How to effectively use PivotTables and Pivot Charts to easily analyze your data and generate reports.
- How to efficiently use Data Tables to enumerate and list data patterns.
- Take advantage of Advanced Sorting & Filtering to query and analyze data.
- How to use Goal Seek to project data profits for a specific quarter in the company.
- How to use the Consolidate function to summarize and analyze all data expenses.
- How to properly use Scenarios to predict and forecast data.
- How to synchronize data online and allow several collaborators to work on the same data analysis plan.
- How to create live and synchronized dashboards online and convert them as websites.
- What is Infographic? What are the various infographics techniques to show data.
- How to display our data on a map using infographic.
- How to create 3D charts without indicating the exact numbers.
- How to use Animaker: the best website to get infographics and visualization icons.
- How to convert this animation to a video to be posted on social media.