Analyzing Data with Excel
ANALYZING AND VISUALIZING DATA WITH EXCEL COURSE OVERVIEW
Analyzing and Visualizing Data With Excel Workshop’s main goal is to teach students how to use BI techniques in Excel data analysis. The course uses Pivot Tables, the Excel Data Model to go beyond the capabilities of tables and charts.
- Extend and explore a traditional Excel dashboard.
- Extend and study an Excel data model.
- Import CSV file that has been formatted.
- Data from a SQL Server database is imported.
- Data from a report can be imported.
- Use advanced functions to create measures.
- Create data visualizations.
- Build a Power BI dashboard.
This course is for students who are familiar with Excel and want to learn more about business intelligence techniques.
ANALYZING AND VISUALIZING DATA WITH EXCEL COURSE OUTLINE
Module 1: Data Analysis in Excel
Firstly: Classic Data Analysis with Excel
Secondly: Excel Pivot Tables
Thirdly: Limitations of Classic Data Analysis
Finally: Building a Classic Excel Dashboard Lab
Module 2: The Excel Data Model
Firstly: Using an Excel Data Model
Finally: Explore an Excel Data Model Lab
Module 3: Importing Data from Files
Firstly: Importing Data into Excel
Secondly: Shaping and Transforming Data
Thirdly: Loading Data
Finally: Importing Data Lab
Module 4: Importing Data from Databases
Firstly: Available Data Sources
Secondly: Previewing, Shaping, and Transforming Data
Thirdly: Loading Data
Fourthly: Table Relationships and Hierarchies
Finally: Importing Data from Multiple Sources Lab
Module 5: Importing Data from Excel Reports
Firstly: Importing Data from Excel Reports
Secondly: Transforming Excel Report Data
Finally: Importing Data from a Report
Module 6: Creating and Formatting Measures
Firstly: Data Analysis Expressions
Thirdly: Advanced DAX Functions
Finally: Creating Measures by Using Advanced DAX Functions Lab
Module 7: Visualizing Data in Excel
Firstly: Using Pivot Charts
Secondly: Using Cube Functions
Lastly: Creating Charts for Cube Functions
See also more Courses and Workshops from HRIB.
Start learning with a wide range of best courses covering different subjects “ Talent Expert “
- Lectures 0
- Quizzes 0
- Students 0
- Assessments Yes