Subsidized course „Jsem v kurzu“

Analyzing Data with Excel

This 2-day instructor led course is intended for anyone responsible for analyzing and reporting data with Microsoft Excel. The course goes beyond the capabilities of tables, Pivot tables, charts and Pivot Charts, the Excel Data Model and DAX language.

Code
DB-EXCEL

Course length
2 days (8:30 – 16:00)

Form
In our classroom or online

Main course tutor

Eliška Červenková

Eliška Červenková

Microsoft instructor

More about tutor

Dates

12/16/2024 – 12/17/2024 Prague Free date 11 800 CZK
without VAT
Add to cart
Buy with the subsidy program "Jsem v kurzu" 11 800 CZK 2 124 CZK
without VAT
Order on Integrated
MoLSA Portal  

This course is intended for

  • This course is intended for anyone responsible for analyzing data with Excel. The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting and analysing data. 

Syllabus

Module 1: Data Analysis in Excel

  • Lesson 1: Classic Data Analysis with Excel
  • Lesson 2: Excel Pivot Tables
  • Lesson 3: Limitations of Classic Data Analysis
  • Lab: Building a Classic Excel Dashboard

Module 2: The Excel Data Model

  • Lesson 1: Using an Excel Data Model
  • Lesson 2: DAX
  • Lab 2: Explore an Excel Data Model

Module 3: Importing Data from Files

  • Lesson 1: Importing Data into Excel
  • Lesson 2: Shaping and Transforming Data
  • Lesson 3: Loading Data
  • Lab 3: Importing Data from a CSV File

Module 4: Importing Data from Databases

  • Lesson 1: Available Data Sources
  • Lesson 2: Previewing, Shaping, and Transforming Data
  • Lesson 3: Table Relationships and Hierarchies
  • Lesson 4: Loading Data
  • Lab 4: Import Data from Multiple Sources

Module 5: Importing Data from Excel Reports 

  • Lesson 1: Importing Data from Excel Reports
  • Lesson 2: Transforming Excel report Data
  • Lab 5: Importing Data from a Report

Module 6: Creating and Formatting Measures

  • Lesson 1: DAX
  • Lesson 2: Measures
  • Lesson 3: Advanced DAX Functions
  • Lab 6: Creating Measures using Advanced DAX Functions

Module 7: Visualizing Data in Excel

  • Lesson 1: Pivot Charts
  • Lesson 2: Cube Functions
  • Lesson 3: Charts for Cube Functions
  • Lab 7: Data Visualization in Excel

Students will be able to

  • Explore and extend a classic Excel dashboard
  • Explore and extend an Excel data model
  • Pre-format and import a .CSV file
  • Import data from a SQL Server database
  • Import data from a report
  • Create measures using advanced DAX functions
  • Create data visualizations in Excel

Course requirements

  • Basic knowledge of the Microsoft Windows operating system
  • Basic knowledge of Microsoft Excel
  • Working knowledge of relational databases

Hardware

Classrooms are equipped with high-performance computers with Internet access and the possibility of wireless connection.

Literature

All participants will receive internal OKsystem materials.

PDF to download

Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.

Similar courses

Take a look at some similar courses from our wide range.

Authorized course Subsidized course „Jsem v kurzu“

Microsoft Power BI Data Analyst PL-300


21 800 CZK Course detail

Need some advice?

Do not hesitate to contact us. We are at your disposal and will be happy to help you.

Mgr. Barbora Záhlavová

Mgr. Barbora Záhlavová

More information about courses


+420 734 525 195
zahlavova@oksystem.cz

Ing. Lumír Vojtěchovský

Ing. Lumír Vojtěchovský

More information about courses


+420 724 332 135
vojtechovsky@oksystem.cz

Why OKškolení?

What are the main advantages of our training centre?

About us

Contact us

Do not hesitate to contact us with any questions you may have.

Simona Dianová

Simona Dianová

Training and test organization


+420 236 072 251
dianova@oksystem.cz

Ing. Dana Černá

Ing. Dana Černá

Certification tests


+420 236 072 318
cernad@oksystem.cz

Do you need to know more about us or would you prefer to contact us using the form?

Contact page

OKškolení is part of OKsystem a.s.