Home / Course catalog / Data Analytics & Visualisation for Acc... (RBDA003)


Get this course

Data Analytics & Visualisation for Accountants in Business (RBDA003)


Description
Learn to use Power BI to do with data what spies do when observing their surroundings: Get an overview of the data, narrow in on certain aspects of the data that seem abnormal, and then analyse the data. Hence Power BI is a great tool for facilitating the overview, zoom, then filter details-on-demand. It is a lot like a more powerful version of Excel's pivot table and pivot chart functionality.

A mini-case study will be used to help you understand analytical modelling, by performing a correlation analysis to identify two-way relationships, and analyse correlations using a correlation matrix and scatter plots. You will then learn to perform regression analysis in Excel as well as to interpret and evaluate the diagnostic metrics and plots of a regression analysis.
Content
  • 1. Introduction and Goals 1d 13h 30m
  • 2. Empirical Inquiry, Critical Thinking, and Reasoning 117d 13h 30m
  • 3. Analytics Strategy 199d 13h 30m
  • 1. Understanding Data
  • Handout: Understanding Data
  • Structured and Unstructured Data
  • Knowledge Check: Structured and Unstructured Data
  • Data Types
  • Knowledge Check: Data Types
  • Data Quality
  • Data Governance
  • Short Quiz #4
  • Import and Explore Data in Microsoft Excel & Power BI
  • Datasets
  • Assignment #1: Importing and Exploring Data
  • 2. Exploratory Data Analysis (EDA)
  • Handout: Exploratory Data Analysis
  • Descriptive Statistics
  • Knowledge Check: Descriptive Statistics
  • Data Visualization
  • Knowledge Check: Data Visualization
  • Short Quiz #5
  • Data Visualization with Microsoft Excel
  • Data Visualization with Microsoft Power BI
  • Assignment #2: Exploratory Data Analysis
  • Self Reflection Week 1 279d 13h 30m
  • 3. Data Analytics
  • Handout: Data Analytics
  • Data Analytics
  • Correlation
  • Linear Regression
  • Short Quiz #6: Data Analytics
  • Datasets
  • Guide: How to download a csv file from github?
  • Assignment #4: Linear Regression with Microsoft Excel
  • 4. Analytical Modelling/Machine Learning (ML)
  • Linear Regression with Microsoft Excel
  • Logistic Regression with Microsoft Excel
  • Introduction to Machine Learning
  • Simple Text Analytics: Polarity Scores from Customer Reviews
  • Simple Recommender System: Product Recommendation with Collaborative Filtering
  • 5. DATA VISUALIZATION AND STORYTELLING WITH MICROSOFT POWER BI
  • Handout : Data Analytics for Accountants in Business
Completion rules
  • All units must be completed
  • Leads to a certificate with a duration: Forever
Back