Applied Data Analysis by CloudSwyft Global Systems, Inc via Futurelearn: Fee, Duration, How to Apply

Quick Facts

particular	details
Collaborators Microsoft Corporation	Medium of instructions English	Mode of learning Self study	Mode of Delivery Video and Text Based	Learning efforts 3-5 Hours Per Week

Course overview

The Applied Data Analysis online course is designed to equip learners with the fundamental skills of an effective data analyst. The course covers a wide range of topics to provide learners with a complete overview of data analysis. In the Applied Data Analysis certification by FutureLearn participants will learn how to import data from various sources, create data mashups, and prepare data for analysis.

Moving forward, learners will delve into the world of Power BI for advanced data analysis and visualisation. They will gain insights into connecting to multiple data sources, enhancing data models, exploring data, creating stunning visualisations, and sharing reports and dashboards across the web and mobile devices.

A significant part of the Applied Data Analysis certification course focuses on unpacking statistics for data analysis in Excel. Learners will understand the core principles of statistics, basic probability, random variables, confidence intervals, and hypothesis testing, which are essential skills for any data analyst.

Course and certificate fees

Fees information

₹ 900

The Applied Data Analysis certification fee comes at a monthly subscription price of Rs. 900.

Applied Data Analysis fee structure

Course Name	Fee
Applied Data Analysis	Rs. 900 p.m.

certificate availability

Yes

certificate providing authority

Futurelearn

Who it is for

Data analyst Data scientist Artificial intelligence engineer Big data engineer

The Applied Data Analysis certification syllabus is designed for individuals who are interested in pursuing a career in data analysis or those who want to enhance their data analysis skills in their current professions. It caters to a diverse range of career options and professions, including but not limited to:

Eligibility criteria

Certification Qualifying Details

Completion of Applied Data Analysis training is enough for certification.

What you will learn

Knowledge of excel Data analysis Knowledge of data visualization Decision making skills

During Applied Data Analysis classes, participants will:

Master data analysis in Excel, including importing data from various sources and performing data mashups.
Understand business calculations and expressions for effective data analysis in Excel.
Gain proficiency in using Power BI for advanced data analysis and visualisation.
Connect to multiple data sources, enhance data models, and create stunning visualisations in Power BI.
Share reports and dashboards with colleagues across web and mobile platforms.

The syllabus

Advanced Data Analysis and Visualization Using Microsoft Excel

Course Introduction

About the Course
Data Analysis in Excel
CloudSwyft Hands-On Labs
Data Models and DAX in Excel
CloudSwyft Hands-On Labs
Wrapping up the Week

Importing Data into the Excel Data Model

Importing Data: CSV Files
CloudSwyft Hands-On Labs
Importing Data: Databases and Multiple Files
Importing Data: Excel Reports
CloudSwyft Hands-On Lab
Wrapping Up the Week

Data Analysis and Visualisation with Excel and Power BI

The DAX Language
CloudSwyft Hands-On Labs
Visualising Data in Excel
CloudSwyft Hands-On Labs
Power BI
Wrapping Up the Course

Statistics and Data Analysis in Excel

Descriptive Statistics

About the Course
Defining Data
Histogram and Skewness
Descriptive Statistics with Analysis ToolPak
What is a Boxplot?
Categorical Data, PivotTables, and PivotCharts
Summarizing Heirarchal Data
80-20 Rule and Pareto Charts
Week 1 Test

Basic Probability

Introduction to Probability
Law of Complements
Mutually Exclusive Events and Finding Prob (A or B)
Conditional Probability
Law of Total Probability and Bayes Rule
Basic Probability Review
Week 2 Test

Random Variables

Random Variable Definitions
Mean, Variance, and Standard Deviation of a Random Variable
Mean, Variance, and Standard Deviation for Sum of Random Variables
Binomial Random Variable
Poisson Random Variable
Normal Random Variable
Central Limit Theorem
Z Scores
Week 3 Test

Sampling and Confidence Intervals

Populations and Samples
Point Estimation of a Population Mean and Proportion
The Standard Normal
Confidence Interval Estimation
Sample Size Determination
The Finite Correction Factor
Additional Reading
Week 4 Quiz

Hypothesis Testing

Defining Hypotheses
Type I and Type II Error
One Sample Z-Test
One Sample T-Test
Single Sample Test for Population Proportion
Testing Equality of Variances
Testing the Difference Between Two Population Means
Chi-Squared Test for Independence
Additional Reading
Week 5 Quiz
Wrapping Up the Course

Microsoft Power BI: Advanced Data Analysis and Visualisation

Course Introduction

About this Course
Power BI Desktop Transformations
Further Transformation
CloudSwyft Hands-On Labs: Data Transformation
Wrapping Up Data Transformation

Data Modelling & Dax in Power BI

Data Modelling
Dax in Power BI

Power BI Desktop Visualisations

Connecting and Collaborating With Excel
Work With Power BI visuals
Data-driven story with Power BI reports

Power BI Service

Work With Key Performance Indicators
Mobile App
Final Assessments & Wrapping Up the Course

Successful Data Analysis for Modern Industries

Welcome to the Course

About this Course
Data Economics and Ecosystems
Data Analysis for Business
Data Analysis for Education
Wrapping Up the Week

Data Analysis for Social Good and Careers in Data Analysis

Data Analysis in Healthcare
Data Analysis for Social Good
Careers in Data Analysis
Final Assessments & Wrapping Up the Course

Admission details

Follow the steps below to join the online course.

Step 1- Click on the link below: https://www.futurelearn.com/experttracks/applied-data-analysis

Step 2- Register to the Futurelearn platform

Step 3- Subscribe to the FutureLearn service and start learning

How it helps

Applied Data Analysis certification benefits include:

Acquiring fundamental data analysis skills.
Mastering Excel for data analysis and visualisation.
Gaining proficiency in using Power BI for advanced analysis and visualisation.
Understanding core statistical principles and hypothesis testing.
Enhancing career prospects in the field of data analysis.
Receiving industry-specific digital certificates.

FAQs

What is the ExpertTrack offered by CloudSwyft?

The ExpertTrack is a comprehensive data analysis course covering Excel, Power BI, and statistics, designed to equip learners with essential data analyst skills.