Overview:
One of the trends highlighted in Deloitte’s Human Capital Trend Survey is the continued spotlight on people analytics, particularly with the effects of the pandemic and new trends in people data. Furthermore, the survey found that only 56 % respondents say organizations have made moderate or significant progress in people analytics in the past ten years. The opportunity for organizations to win the war for talent by having advanced people analytics capabilities is thus tremendous.
Before attending this course, audiences must have:
➢ knowledge of the Microsoft Windows operating system and its core functionality.
➢ Advanced working knowledge of Excel spreadsheets including formulas.
➢ Microsoft office (2016 – 2019 – 365)
Course Outline: –
Module 1: – Intro of data Analysis
- Meaning of Data analysis
- Types of Analysis
- Types of Data
- Tools of Analysis
- Art of Design
Module 2: – Microsoft Excel Features
- Advanced Functions in Excel.
- Control your data.
- Types of Charts
- Spark lines, Icons and Conditional Formatting
Module 3: – Analysis using Microsoft office
- How to Create Pivot tables
- Pivot tables Features
- Classic Pivot tables
- Pivot charts
- Filter your data
- using Slicers and Timeline
- How to Create the Dashboard
- How to Refresh your data
Module 4: – Cleaning and Transforming
- How to get data from other Sources.
- Type of Sources (CSV, Web, Folders, etc.)
- How to Clean Your data
- using Query Functions
- How to Merge your data
- How to Append your data
Module 5: – Data Modeling
- The Relations Between data
- Types of Relations
- Using Connections between data
- Using DAX Functions
- How to Create Measures
Module 6: – Power BI
- Intro of Power BI App
- Get data from other Sources by Power BI
- How to Clean and Transform
- How to make Relations Between data
- How To create DAX Functions
- How To create Measures
- Using Features of Power BI
Module 7: – Dashboard
- How to Create Professional Dashboard
- Using Colors in your dashboard
- Using Pics and Icons
- Types of Visualizations
- Formatting your Visualizations
- Create ToolTips
- Power BI Services
- Publish your dashboard
- Link your dashboards
Module 8: – Projects
- Create More than 3 Project ( Excel and Power BI )
- How to use data Library
- How to Create Customize Color in Dashboard
- How to Protect Your data and dashboard
After completing this program, audiences will be able pass the following exams
▪ Exam 70-779: Analyzing and Visualizing Data with Microsoft Excel
▪ Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI
