Summary
Data is the lifeblood of every business and understanding data through descriptive, predictive, and prescriptive analytics is critical to driving business success in a data driven economy. Creating great visualizations is another key to extracting maximum value out of their data. This 2-day class teaches you all these techniques and more.
• Data Analysis Fundamentals
• How to Visualize Data in Excel
• Using Formulas and Functions to analyze data
• Analyzing data with Pivot Tables
• Presenting Dashboards
• Creating Geospatial Visualizations
• Statistical Analysis
• Getting and Transforming Data
• Modelling Data with Power Pivot
• Presenting Insight with Reports
- • Dates: Feb 25, 2021- Feb 26, 2021
- • Times: 9:00 am - 4:30 pm
- • Location: Virtual
- • Seats: 10
- • Price: $650
Outline
-
Lesson 1: Data Analysis Fundamentals
- Topic A: Introduction to Data Science
- Topic B: Create and Modify Tables
- Topic C: Sort and Filter Data
-
Lesson 2: Visualizing Data with Excel
- Topic A: Visualize Data with Charts
- Topic B: Modify and Format Charts
- Topic C: Apply Best Practices in Chart Design
-
Lesson 3: Analyzing Data with Formulas and Functions
- Topic A: Analyze Data with Formulas and Named Ranges
- Topic B: Analyze Data with Functions
- Topic C: Implement Data Validation, Forms, and Controls
- Topic D: Create Conditional Visualizations with Lookup Functions
-
Lesson 4: Analyzing Data with PivotTables
- Topic A: Create a PivotTable
- Topic B: Analyze PivotTable Data
-
Lesson 5: Presenting Visual Insights with Dashboards in Excel
- Topic A: Visualize Data with PivotCharts
- Topic B: Filter Data Using Slicers and Timelines
- Topic C: Create a Dashboard in Excel
-
Lesson 6: Creating Geospatial Visualizations with Excel
- Topic A: Create Map Charts in Excel
- Topic B: Customize Map Charts in Excel
-
Lesson 7: Performing Statistical Analysis
- Topic A: Visualize Trendlines and Sparklines with Excel
- Topic B: Analyze Data with the Data Analysis ToolPak
-
Lesson 8: Getting and Transforming Data
- Topic A: Connect to Data with Queries
- Topic B: Clean and Combine Data
- Topic C: Shape and Transform Data
-
Lesson 9: Modeling and Analyzing Data with Power Pivot
- Topic A: Install Power Pivot in Excel
- Topic B: Create Data Models with Power Pivot
- Topic C: Create Power Pivots
- Topic D: Perform Advanced Data Analysis and Visualization
-
Lesson 10: Presenting Insights with Reports (Optional)
- Topic A: Plan a Report
- Topic B: Create a Report