Welcome to Our Intermediate Data Analytics Course!
You are here reading this because you have been nurturing a desire to become a Data Analyst, but you hadn’t known how to get there. Well, this course was designed for you.
Course Overview
This Intermediate Data Analytics Course expands on fundamental concepts with more complex data analysis techniques.
Why This Course?
In today’s data-driven world, the ability to analyse and derive meaningful insights from data is a game-changer for businesses. Our Data Analytics Training, designed by leading industry experts at The Corporate Trainer, equips professionals with the cutting-edge skills needed to transform data into strategic decisions.
What You’ll Learn
• Complex Data Analysis Techniques: Build on your foundational knowledge with more advanced data analysis methods.
• Practical Application: Gain hands-on experience with real-world data sets and scenarios.
What’s Included
• Downloadable Sample Files: Access files to practice with during and after the training.
• Best Practices: From beginner to advanced level, distilled into easy-to-understand patterns that you can instantly apply to your business/work.
• Completion Certificate: Receive a certificate upon completing the course.
Why Wait?
Sign up now to become an invaluable asset to your organization. Equip yourself with the skills to excel in the dynamic field of Data Analytics and take your career to the next level.
Course Features
- Lectures 70
- Quizzes 0
- Duration 52 weeks
- Skill level Intermediate
- Language English
- Students 1073
- Certificate Yes
- Assessments Yes
Curriculum
- 1 Section
- 70 Lessons
- 52 Weeks
- Mastering Pivot Tables70
- 1.1Introduction
- 1.2Course Materials.
- 1.3Understanding Data Types
- 1.4Determining the Proper Date Entry
- 1.5Different Types of Datasets
- 1.6Categories of Databases
- 1.7Structures of Databases
- 1.8Normalising Databases – How to remove Duplicates
- 1.9Performing The VLOOKUP Formula to De-Normalise Databases
- 1.10Performing The VLOOKUP Approximate
- 1.11Performing The HLOOKUP
- 1.12The MATCH function
- 1.13The INDEX and MATCH function
- 1.14The XMATCH function
- 1.15The XLOOKUP function
- 1.16The IF function
- 1.17The AND function
- 1.18The OR function
- 1.19The Nested IF-AND-OR function
- 1.20Number Formating
- 1.21Deleting Named Ranges and Table Properties
- 1.22The Pivot Table Layout
- 1.23Getting Data ready for Analysis
- 1.24My First Report
- 1.25Two Dimensional Report
- 1.26Multi Dimensional Report
- 1.27Creating reports that involve COUNT, AVERAGE, MAX and MIN
- 1.28Formating your Report
- 1.29Turning your pivot table into a final report
- 1.30Applying Filters to your Report
- 1.31Performing Magic with the Filters
- 1.32Introduction to Slicers
- 1.33Formatting your Slicers
- 1.34Creating Reports From Recommended Pivot Tables
- 1.35Quick Analysis Tool Completed
- 1.36Positioning and Naming your Pivot Reports
- 1.37Creating your report next to your Data Source
- 1.38Relocating your pivot table report
- 1.39Changing your report’s Data source
- 1.40Managing changes in the Data Source
- 1.41Changing the Data Source
- 1.42Adding new Fields to the Data Source
- 1.43Eliminating Errors in my Dataset
- 1.44Dealing with Blank rows in the Dataset
- 1.45Introduction to Grouping
- 1.46Grouping Dates
- 1.47Grouping Dates into Weeks
- 1.48Grouping Numbers
- 1.49Grouping Text Fields
- 1.50Sorting the Pivot Table Report
- 1.51Controlling how the Pivot table summaries your values
- 1.52The Pivot table’s Special tabs
- 1.53The Compact Layout
- 1.54The Outline Layout
- 1.55The Tabular Layout
- 1.56Introducing the Dynamic Excel Table
- 1.57Filtering the Raw Data with Pivot table values
- 1.58Other filtering options
- 1.59Filtering with the Timeline
- 1.60Creating Top N reports
- 1.61Introduction to Calculated Fields
- 1.62How to Modify or Delete a Calculated Field
- 1.63Creating a report with Values in the Rows area
- 1.64Adding Calculated Columns in the Raw Data
- 1.65Introduction to Calculated Items
- 1.66Changing the calculation in a value field
- 1.67Working with Grand Totals for Columns and Rows
- 1.68Working with Sub-Totals
- 1.69Adding Gridlines to your report
- 1.70Show Value as Percentage of the Grand Total
