Introduction To Data Analysis Using Excel And Power Bi

by James Cook Institute Claim Listing

This course sets out the foundational skills and knowledge to introduce learners to data analysis using Excel functions and formulae and creation of data visualisation to generate business insights by identifying trends and patterns.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

James Cook Institute Logo

img Duration

16 Hours

Course Details

This course sets out the foundational skills and knowledge to introduce learners to data analysis using Excel functions and formulae and creation of data visualisation to generate business insights by identifying trends and patterns.

 

Course Objectives:

  • Apply Excel functions and formulas to create statistical techniques like mean, median and regression analysis.
  • Identify various trends and patterns from data sets using techniques for statistical analysis.
  • Apply Statistical Functions for Data Analysis
  • Identify Data Requirement with Stakeholder for Further Analysis

 

Target Audience (operational, Supervisory & Managerial):

  • This training is relevant to PMETs who are new to data analysis and is keen to expand their knowledge of Excel to include the use of data analysis functions and dashboards as well as apply data visualization tools for interactive data.

 

Assumed Skills:

  • Workforce Skills Qualifications (“ES WSQ”) Workplace Literacy (“WPL”) level 3.
  • Be able to read and write English at a proficiency level equivalent to ES WSQ WPL level 3.
  • Be able to manipulate numbers at a proficiency level equivalent to ES WSQ Workplace Numeracy (“WPN”) level 3.
  • Learners to have minimum GCE ‘O’ level or ITE certificate education
  • Learner should have at least 1 year’s working experience in any industry.
  • Learners must be able to operate a personal computer, use keyboard and mouse

 

Course Content:

  • Learning Unit 1 –  Understand Data Analysis Process And Using Functions For Statistical Analysis
  • What is Data Analysis
  • Benefits of Data Analytics
  • The Data Analysis Cycle
  • Data Protection Laws and Data Anonymity
  • The 4 Types of Data Analysis
  • The Types of Data
  • What are Statistics?
  • Learning Unit 2 – Importing And Shaping Data Sets For Analysis Of Trends And Patterns
  • Importing Data from Different Data Sources into Excel
  • Using Functions to Prepare Data for Statistical Analysis
  • Creating interactive dashboards to illustrate patterns and trends
  • Learning Unit 3 – Using Functions And Features To Create Statistical Data Visualisation In Excel And Power Bi
  • Introduction to Power BI Desktop
  • Navigating around Power BI
  • Creating statistical visuals
  • Creating conditional formatting to highlight patterns
  • Creating trendlines and slicers
  • Learning Unit 4 – Create Interactive Basic Visualisation And Dashboards For Further Insights
  • Introduction to basic DAX function and formulas
  • Creating KPIs, Scorecards, Gauge visualization
  • Central Branch

    150 Orchard Rd, #06-14, Central

Check out more Power BI courses in Singapore

IMA Logo

Data Analytics and Visualization for Accounting Professionals (Beyond the Basics)

Accounting has always been about analytical thinking. The skillset that accountants have needed to perform math and to keep order has evolved from pencil and paper, to typewriters and calculators, then to spreadsheets and accounting software.

by IMA [Claim Listing ]
Koenig-Solutions Logo

Microsoft Power BI Data Analyst Course

The PL-300T00: Microsoft Power BI Data Analyst certification is a qualification necessary for individuals who analyze and visualize data using Power BI.

by Koenig-Solutions [Claim Listing ]
Simpli Learn Logo

Big Data Hadoop Certification Training Course

The Big Data course is designed to give you an in-depth knowledge of the Big Data framework using Hadoop and Spark. In this hands-on Hadoop course, you will execute real-life, industry-based projects using Integrated Lab.

by Simpli Learn [Claim Listing ]
  • Price
  • Start Date
  • Duration
Institute of Singapore Chartered Accountants (ISCA) Logo

IT078 : Enhancing your Business Analytics Capability with Power BI

This course is intended to equip the participants with skillset to deliver high quality and timely reports and dashboards to support organizational reporting for more effective organizational decision making.

by Institute of Singapore Chartered Accountants (ISCA) [Claim Listing ]
JCube Institute Logo

Power BI

Power BI is quickly becoming the world’s most powerful self-service business intelligence platform, and an absolutely essential tool for Data Professionals and beginners alike.

by JCube Institute [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy