$ 29.90$ 89.9067% Off

Enrollment will begin soon

$ 29.90$ 89.9067% Off

Enrollment will begin soon

Home CoursesBusiness & Management

Advanced Data Analysis with Excel Bootcamp

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

Learn Advanced Data Analysis Bootcamp with Excel

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.

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

Course Content

7 sections•46 lectures• total length

1. Introduction

1 lectures

Advanced Excel Bootcamp Data Analytics and Business Intelligence

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

10 lectures

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 Video)

9 lectures

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 Video)

8 lectures

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 (8Video)

8 lectures

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 Video)

9 lectures

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 lectures

Thank You!

Instructor

Danish Nawaz

Expert Instructor

5Rating

100Reviews

500Students

10Courses

Enrollment will begin soon