DAT102 - Analyzing and Visualizing Data using Excel

About this course

 

In the first course of our Data Analysis Series (DAT101: Introduction to Data Analysis using Excel), we set a good foundation for data analysis by exploring essential tools such as pivot tables and other important excel functions. In this second course in the series, we will deep dive into more complexed functions of excel to ensure that participants are equipped with better data analysis skills.

 

Excel is one of the most widely used solutions for analyzing and visualizing data. It now includes tools that enable the analysis of more data, with improved visualizations and more sophisticated business logic.

 

We will revise some of the tools learned in DAT101 such as pivot tables, pivot charts, and slicers; learn how to import data from different sources; create mashups between data sources, and prepare data for analysis. After preparing the data, find out how business calculations can be expressed using the DAX calculation engine. We will also explore an Excel Data Model; practice financial formulas such as NPV and IRR; and calculate payment schedules and periods using Excel tools.

Course Objectives: On completion, you will be able to:

  • Build pivot tables, pivot charts, and slicers.
  • Explore an Excel Data Model using Power Pivot.
  • Create a DAX expression for calculated columns and measures.
  • Import multiple tables from a SQL database.
  • Create a mash-up between data from text-files and data from SQL database.
  • Explore ways to create visualizations in Excel including the CUBE functions and Microsoft Power BI.
  • Use financial formulas such as NPV and IRR.

Fee: Le4,000,000 per person.

5% Discount for Women. Additional 5% Discount for Groups of 10+; and 10% Discount for Entrepreneurs. All discounts can be claimed.

Registration:

Participants will be required to register through our website www.fbs.edu.sl/dat102 for the course and are expected to attend all classes to be eligible to receive a Certificate.

Dates: 19th June – 20th July 2019.

Session:  Wednesdays, Thursdays, and Fridays (6:00 pm to 8:00 pm)

Fee:  Le4,000,000 per person. 5% Discount for Women. Additional 5% Discount for Groups of 10+; and 10% Discount for Entrepreneurs. All discounts can be claimed.

Venue:  Africell American Corner, 25 Bathurst Street, Freetown