# Flexi is a Video Recording of Live Online+Official Courseware+Hands-On-Labs+Qubits Test

+
=

### Analyzing Data with Excel

###### Includes 280+ Tests Questions (Qubits42)
Module 1
• Data Analysis in Excel
• Contents:
• Module Overview 1-1
• Lesson 1: Classic Data Analysis with Excel 1-2
• Lesson 2: Excel PivotTables 1-7
• Lesson 3: Limitations of Classic Data Analysis 1-10
• Lab: Building a Classic Excel Dashboard 1-12
• Module Review and Takeaways
• The Excel Data Model
• Contents:
• Module Overview 2-1
• Lesson 1: Using an Excel Data Model 2-2
• Lesson 2: DAX 2-7
• Lab: Explore an Excel Data Model 2-15
• Module Review and Takeaways
• Importing Data from Files
• Contents:
• Module Overview 3-1
• Lesson 1: Importing Data into Excel 3-2
• Lesson 2: Shaping and Transforming Data 3-7
• Lab: Importing Data 3-17
• Module Review and Takeaways
• Importing Data from Databases
• Contents:
• Module Overview 4-1
• Lesson 1: Available Data Sources 4-2
• Lesson 2: Previewing, Shaping, and Transforming Data 4-5
• Lesson 4: Table Relationships and Hierarchies 4-14
• Lab: Importing Data from Multiple Sources 4-18
• Module Review and Takeaways
• Importing Data from Excel Reports
• Contents:
• Module Overview 5-1
• Lesson 1: Importing Data from Excel Reports 5-2
• Lesson 2: Transforming Excel Report Data 5-9
• Lab: Importing Data from a Report 5-17
• Module Review and Takeaways
• Creating and Formatting Measures
• Contents:
• Module Overview 6-1
• Lesson 1: Data Analysis Expressions 6-2
• Lesson 2: Measures 6-6
• Lesson 3: Advanced DAX Functions 6-11
• Lab: Creating Measures by Using Advanced DAX Functions 6-17
• Module Review and Takeaways
• Visualizing Data in Excel
• Contents:
• Module Overview 7-1
• Lesson 1: Using PivotCharts 7-2
• Lesson 2: Using Cube Functions 7-12
• Lesson 3: Creating Charts for Cube Functions 7-20
• Lab: Data Visualizations in Excel 7-30
• Module Review and Takeaways
• Using Excel with Power BI
• Contents:
• Module Overview 8-1
• Lesson 1: Power BI 8-2
• Lesson 2: Using Excel As a Data Source in Power BI 8-7
• Lesson 3: Power BI Mobile App 8-12
• Lab: Creating a Power BI Dashboard with Excel 8-15

We do not have a fresh Live Online Recording for the course. It can take 4-5 days to edit a recording. If your need is urgent, request for an un-edited version.

Flexi Video

USD 99

Official Courseware

USD 49

Hands-On-Labs

USD 59

Total

USD 99

100% Secure Transaction

## Q1. How long do you have access to Flexi after purchase?

A. 3 months from date of delivery.

## Q2. Can the content be shared or is it only available for one user?

A. It is only for the self-use of the purchaser.

## Q4. What is the pass rate of students that used Flexi as their method of preparation?

A. We do not track the pass rate of Flexi students. We, however suspect that it will be lower than for Live Online.

## Q5. If we buy Flexi today, and there are any updates in the course, do we get the updated recordings as well or do we need to repurchase Flexi?

A. If the latest update comes within 3 months after the sale we can give the updated version.