Skip to Content
  1. All Products
  2. All Products
  3. Excel Level 3
Default
Excel Level 3

Excel Level 3

https://www.lines-academy.com/web/image/product.template/42/image_1920?unique=97b26ba

This program offers an advanced opportunity to understand the automation of data analysis using Excel's powerful tools such as Power Query, Power Pivot, and DAX. The program aims to empower participants to analyze data effectively, improve performance, and design interactive dashboards that facilitate data-driven decision-making. 

975.00 SR 975.0 SAR 975.00 SR Tax Included

975.00 SR Tax Included

Not Available For Sale

  • Availability

This combination does not exist.

Contact Us
Availability: Unavailable

Terms and Conditions
money-back guarantee if not satisfied

Share

Money-Back Guarantee if not satisfied

If you don’t benefit from our program, your investment is safe. We offer a full refund to ensure your confidence in our service.

Certified By the TVTC

Our program is recognized and accredited by the technical and Vocational Training Corporation, ensuring high-quality learning and professional standards.

 Flexible Payment Options, Including Installments

Choose the payment plan that suits you best. We provide a variety of payment methods, including installment options, to make it easier for you.

Live Online Learning Experience

Enjoy the convenience of learning from anywhere with our interactive, live virtual zoom sessions led by expert instructors.

Targeted Groups

Employees who need to design interactive dashboards to improve performance

​

Individuals responsible for preparing reports and analyzing data

 

Analysts and Excel users who want to automate data analysis



Those interested in using advanced tools for data analysis and visualization

At the end of this program, the participants will be able to:

1.  Understand the concept of automating data analysis using Excel.
2.  Implement data analysis stages using Power Query and Power Pivot.
3.  Extract and clean data from multiple sources.
4. Create advanced data models and establish relationships between data sources.

5. Use DAX for data analysis and write advanced formulas.


6. Design interactive dashboards using pivot tables and charts.


7. Share reports and collaborate effectively with other teams.


Modules:

​Explore Each Module and Uncover New Knowledge.

Course Prerequisites:

  • Basic knowledge of Excel.
  • Familiarity with tables, references, and simple formulas.
  • Basic understanding of data concepts and relationships.
  • The concept of automating data analysis.
  • Stages of data analysis and how to implement them using Excel.
  • Navigating the Power Query interface.
  • Cleaning and shaping data.
  • Handling multiple data sources (CSV, Databases, TXT).
  • Preparing data using Power Query.
  • Saving data for use in presenting analysis results.
  • Creating a data model.
  • Establishing relationships between different data sources.
  • Optimizing performance for faster and more efficient analysis.
  • Introduction to writing DAX formulas.
  • Adding a calendar table to enhance analysis.
  • Improving analysis with Key Performance Indicators (KPIs).
  • Creating pivot tables using DAX measures.
  • Designing interactive pivot charts.
  • Adding tools for filtering and interaction.
  • Building professional dashboards for data analysis.
  • Effective ways to share reports with teams.