Advanced Data Analytics and Automation in Excel

Course Introduction

The course will take you on to the journey of a data analyst, the skills, tasks, and processes they go through in order to tell a story with data so trusted business decisions can be made. You will learn how the suite of Power BI and Excel BI tools and services are used to tell a compelling story through attractive reports and meaningful dashboards.

At the end of this course, you will learn to:

• Connect to data sources, clean, transform and load data
• Create data visualizations, create and publish reports to the Power BI Service
• Transform less structured data and perform data modelling
• Perform time intelligence on models, create and merge queries

Objectives

The participants will be able to:

• Connect and transform data in Power Query
• Model data use DAX to create measures for Business Performance Measurement
• Analyze and visualize data using pivot tables, charts and slicers by building interactive Excel Dashboards
• Build interactive dashboards in Microsoft Power BI
• Drive better decision making with data visualization in Power BI

Target Audience

• Financial data analysts
• HR data analysts
• Sales Data Analyst
• BI Professionals
• Business executives
• Excel power users
• Reporting managers
• HR Professionals
• Personnel Secretary, Office Secretary
• Business Owner
• Finance Professional

Daily Topics

For More information & Course Contents please contact at

NAYEL Training Centre 

T: +971 4 379 7245 | M: +971 50 249 6876 | Whatsapp : +971 50 249 6876

Email [email protected]