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
Dates
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.
Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.
Need some advice?
Do not hesitate to contact us. We are at your disposal and will be happy to help you.
Why OKškolení?
What are the main advantages of our training centre?
36+ years in business
We have been on the market for more than 36 years and have a wealth of experience in this field.
We are a training center with a rich history and tradition.
Experienced tutors
The basis of any quality education is good and experienced lecturers and this is something that we at OKškolení take particular pride in. Our top lecturers are waiting for you.
Modern classrooms
All classrooms are spacious, air-conditioned, barrier-free and equipped with high-standard computers, with Wi-Fi connection.
Bonus program
Protect your investments into education, loyalty program, advantageous offers, refreshments, grants...
Contact us
Do not hesitate to contact us with any questions you may have.
Do you need to know more about us or would you prefer to contact us using the form?
