Data Analytics With Excel and Power BI

Description

This course is an introduction level course to business and data analytics.  The aim is to address several competencies, Data awareness, statistical applications in excel, business intelligence software and machine learning awareness.

The first competency is data trend awareness.  What are the different fields? What are the different analysis types and tool? and what are the general buzz terms?  By the end of this section you should have an advanced level of awareness on the types of data, the role of a data scientist and the types of. 

After this we ill look at Statistical application in Excel. By the end of this you should have the ability to carry out an interpenetrate the results from Descriptive Statistics, calculate probability and select samples and variables, Understand the power of hypothesis testing to solve business problems all within Excel

We will then move into power bi, and self-service tool for business intelligence.  You will learn how do to simple transformations on data, how to model data using DAX and how to visualize data

When discussing data and business analytics you can not overlook machine learning. By the end of this course you will have an advanced level of awareness on how this works and where it can be applied.

By the end of this course you should feel comfortable Implementing business intelligence solutions to your organisation using tools such as Excel or Power BI that improve the current reporting system and add greater depth to the information to aid in the business decision making process.

Although this course only has 5 hours or so of video material, the reality is you should expect to take about 20 hours to really complete the course and gain full understanding.  There are many activities to complete and it might be necessary to revisit tutorials to ensure you gained the knowledge that you want.

What You Will Learn!

• You will gain an advanced level of awareness on the types of data, the role of a data scientist and the types of.
• You will learn how to use advanced Excel Statistical functions
• You will learn how to gather, transform, model and visualize data with Power BI
• You will gain an advanced level of awareness on the types of machine learning and how it works
• You will feel confident in implementing Excel and Power BI data solutions to your orginisations

Who Should Attend!

• Those exploring the idea of moving into data analytics for their career
• Those looking for bridging course to add to your current reporting skills
• Business Owners
• Accountants
• Data enthusiastic
• Those looking for a deep awareness of the field

TAKE THIS COURSE