Name: Analyzing Data with Excel BI tools

Duration: 24Hrs (Generally done in 3 days)

Objectives: This course is designed for all excel users, how use excel as a report developer tools or MIS Reporters often in large quantity, You will also learn how to build dashboards of interactive data displays by using Excel Business Intelligence tools. The main purpose of Analysing Data with Excel course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.
Prerequisites: Basic know how of computers and Microsoft Office.

Training Delivery medium: Classroom, Live Virtual Instructor Led

Course Outline:

• Explore Microsoft Access 2013
• Data Analysis in Excel
• The Excel Data Model
• Importing Data from Files
• Importing Data from Databases
• Importing Data from Excel Reports
• Creating and Formatting Measures
• Visualizing Data in Excel
• Using Excel with Power BI