$ 29.90$ 89.9067% Off

Enrollment will begin soon

$ 29.90$ 89.9067% Off

Enrollment will begin soon

Home CoursesData Analysis

Advanced Data Analysis Bootcamp with Excel

Name: Advanced Data Analysis Bootcamp with Excel
Price: 29.9 USD
Availability: InStock
Rating: 4.2 (45 reviews)

This advanced bootcamp focuses on high-level data analysis techniques using Microsoft Excel. Develop expertise in handling complex datasets and building powerful analytical models.

984 Enrolled

English

4.2 (45)

Offered By: iqrasity

7 Modules

Gain insight into a topic and learn the fundamentals.

Beginner

No prior experience required

Self-paced

Flexible deadline. Learn at your own pace.

What you'll learn

Advanced formulas and data modeling techniques.

Power Query and data transformation tools.

Advanced Pivot Tables and Pivot Charts.

Dashboard creation and automation.

Scenario analysis and forecasting methods.

Course Content

7 sections•46 resources• total length

1. Introduction

1 resources

Advanced Excel Bootcamp Data Analytics and Business Intelligence

2. Power Query for Extract Transform And Load (ETL) Operations (10 Videos)

10 resources

Introducing Power Query

Applying Basic Transformations

Editing Transformations

Numerical Transformations

Text Transformations

Date Transformations Building A Calendar Table

Conditional Transformations

Merging Datasets

Appending Datasets

3. The Excel Data Model (9 Videos)

9 resources

Introducing Excel's Data Model

Putting the Data Model to Work

Relationships

Relationships In The Excel Data Model

Power Pivot Tables

Calendar Tables

Exercise Imposter Syndrome

Power Pivot Pitfalls

Multiple Data Tables

4. Analyzing The Data Model With DAX (8 Videos)

8 resources

Calculated Columns With DAX

The IF Function in DAX

The SWITCH Function

The RELATED Function

Introducing Measures

Using DAX Functions in Measures

The CALCULATE Function

The ALL Function

5. Advanced DAX (8 Videos)

8 resources

Introducing Time Intelligence Functions

The ISBLANK Function

The DATEADD Function

The DATESINPERIOD Function

Variables In DAX

The X Functions

The RANKX Function

The TOPN Function

6. Data Visualization Techniques (9 Videos)

9 resources

Pivot Table Formatting Tips

Conditional Formating Data Bars Color Scales And Icon Sets

Custom Conditional Formats

Introducing Pivot Charts

Column Charts

Line Charts Area Charts And Timelines

Combo Charts

Changing Measures With Slicers

Using Pivot Tables As Formulas

7. Where To Go From Here (1 Video)

1 resources

Thank You!

Skills you'll gain

Advanced data analysis and modeling.Data automation and transformation.Dashboard design and visualization.Forecasting and trend analysis.Decision-making using complex datasets.

Pre-requisite

Intermediate knowledge of Microsoft Excel.
Basic understanding of data analysis concepts.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

0 assignments

Taught in English

Why iqrasity

Certified, accredited, and experienced instructors

Comprehensive question bank covering all domains

Course content based on the latest exam syllabus

Proven track record of learner success across industries

Long-term access to all learning materials and updates

Rigorous assessments to ensure complete mastery

Issuance of shareable, digitally verifiable certificate

Highly affordable and self-paced

Digital Certificate

Career Paths You Can Pursue

Senior Data Analyst

Business Intelligence Analyst

Financial Analyst

Data Consultant

Analytics Specialist

MIS Manager

Operations Analyst

Instructor

iqrasity

Subject Expert

5Rating

963Reviews

9.9MStudents

63Courses

Iqrasity is a leading digital learning network dedicated to designing and delivering industry-relevant, future-focused education. When a course is developed in-house, Iqrasity serves as the instructor, bringing together subject-matter experts, instructional designers, and industry practitioners to create high-quality, practical learning experiences. Each course is carefully structured to meet global standards, ensuring learners gain up-to-date knowledge, hands-on skills, and career-ready competencies aligned with real-world demands.