Chat with us, powered by LiveChat

Data Analysis in Excel For the Data Analyst

The main purpose of the 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.

CLASS MODULES

MODULE 1: DATA ANALYSIS IN EXCEL

LAB: BUILDING A CLASSIC EXCEL DASHBOARD

MODULE 2: THE EXCEL DATA MODEL

LAB: EXPLORE AN EXCEL DATA MODEL

MODULE 3: IMPORTING DATA FROM FILES T

LAB: IMPORTING DATA FROM A CSV FILE

MODULE 4: IMPORTING DATA FROM DATABASES

LAB: IMPORT DATA FROM MULTIPLE SOURCES

MODULE 5: IMPORTING DATA FROM EXCEL REPORTS

LAB: IMPORTING DATA FROM A REPORT

MODULE 6: CREATING AND FORMATTING MEASURES

LAB: CREATING MEASURES USING ADVANCED DAX FUNCTIONS

MODULE 7: VISUALIZING DATA IN EXCEL

LAB: DATA VISUALIZATION IN EXCEL

MODULE 8: USING EXCEL WITH POWER BI

LAB: CREATING A POWER BI DASHBOARD WITH EXCEL

This course is offered in house and online or both

 

Enter phone number
Enter Course Name

Training Delivered by OpenCastLabs Consulting | info@opencastlabs.co.ke | Plessey House, Uhuru Highway, Nairobi Kenya

Share with your followers...
Email this to someone
email
Share on Facebook
Facebook
Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin
× Chat with us!