Data Analytics With Excel and Power BI
4.2 (28 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
156 students enrolled

Data Analytics With Excel and Power BI

Gain competence with data trend awareness, learn Excel and Power BI as Data analytic tools, gain an understanding of ML
4.2 (28 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
156 students enrolled
Last updated 12/2018
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5 hours on-demand video
  • 17 articles
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Requirements
  • A basic understanding of Probability and statics would be advantageous
  • You should be familiar with working with Excel
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.


Who this course is for:
  • 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
Course content
Expand all 88 lectures 05:40:46
+ Getting Started
6 lectures 14:36
Competencies
01:01
Tools Files and Data Sources
01:42
What is data science?
02:20
How does analytics join big data with data science?
02:38
+ Types of Data, Analytics and Tools
6 lectures 16:06
What is categorical and numerical data
02:28
What is exploratory analysis
02:27
What is descriptive analysis
04:34
What is Inferential analysis
02:35
What is Predictive Analysis
02:30
Casual and Mechanistic Analysis
01:32

take this quiz to test you knowledge

Test your knowledge
7 questions
+ Descriptive Stats In Excel
11 lectures 40:15
Descriptive Statistics In Excel
04:32
Introduction to Histrograms
02:03
Understanding Box Plots
02:41
How to create a boxplot in Excel
04:17
Categorical and Numerical Data in Excel
02:02
How to summarize Categorical Data with Pivot Tables
03:43
Useful Excel Statistics Functions - descriptive statistics
04:28
Useful Excel Statistics Functions - RANK, LARGE and SMALL
03:36
Percentile Functions and Percentrank Functions
06:02
Geometric Mean on Investment Returns
02:57

Take this quiz to test your knowledge

Descriptive Statistics In Excel
3 questions
carry out this activity
Descriptive Statistics In Excel
2 questions
+ Basics of Probability In Excel
9 lectures 32:35
What is Probability
03:58
What is the Law of Complements
02:40
What are Mutually Exclusive and Independent Events
02:02
Calculating Probability on Independent and mutually exclusive events
03:23
What is conditional Probability
01:46
How to Calculated Join Probability using HYPGEOM.DIST
04:08
What is the law of Total Probability
02:41
joint probability pivot table and probability examples
07:17

take this quiz and test your knowledge

Probability quiz
4 questions
complete this activity to gain a better understanding
Probability activity
2 questions
+ Random Variables
8 lectures 34:16
What are random Variables
01:27
What are Binomia and Poissonl Random Variables
01:00
solve problems using both BINOM.DIST and BINOM.DIST.RANGE
06:47
how do you calculate Poisson probability in Excel?
05:05
What is Normal Distribution
00:58
Use NORM.DIST and NORM.INV to solve probability questions
08:14
What is the Central Limit Theorem and how do you use Excel to solve probability
05:38
What are Z scores and how are these calculated or used in Excel?
05:07

test you knowledge

quick quiz
4 questions
carry out the following activity
Random Variables
2 questions
+ Sampling In Excel
6 lectures 15:21
What are Populations and Samples
02:11
How to select a random sample using Excel
01:59
What are Confidence Levels ?
02:07
when you use CONFIDENCE.NORM and CONFIDENCE.T.
03:51
How to estimate a sample size when using an estimated population mean
01:15
example of calculating the population size when using an estimated population me
03:58

test your knowledge

Sampling
5 questions
+ Hypothesis Testing in Excel
6 lectures 24:16
What is a hypothesis test?
04:16
What is a Z-Test
01:49
Z-test in Excel
05:16
T.Test
05:55
Correlation in Excel
02:08
Using Excels Data Analysis ToolPak for Hypotheses testing
04:52

test your knowledge

Hypothesis Testing in Excel
3 questions
carry out the following activity
Hypotheses
2 questions
+ Introduction to Power BI
7 lectures 22:09
What is Power BI and how do I install it
02:24
Tour around desktop
03:31
Connecting to data
01:28
sample connections and transformations
05:16
relationships
02:52
first visulisation
05:19
What about calculations
01:18
carry out this activity
Intro to Power BI
1 question

take this quick quiz

Test your knowledge
4 questions
+ Introduction to Power Query
5 lectures 21:36
Power Query tour
05:32
Connect to excel and transform the data
05:04
Duplicate querys and change query source
05:17
Connecting to a folder
04:28
other Common Transformations
01:15
carry out this activity
Power Query editor
1 question

carry out this quiz to test your knowledge

Test your knowledge
4 questions
+ DAX and Introduction
5 lectures 26:27
What is DAX
05:05
Calculated Columns
07:06
Measures
03:25
X expressions
04:15
Working with related tables
06:36

test your knowledge

Test your knowledge
4 questions
carry out this activity
DAX intro
1 question