- 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
- Home
- CloudSwyft Global Systems, Inc
- Courses
- Applied Data Analysis
Applied Data Analysis
Master data analysis with Excel, Power BI, and statistics to make informed decisions while enrolled in the Applied Data Analysis online course.
Intermediate
Online
14 Weeks
₹ 900
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.
The highlights
- Approx. 14 Weeks To Complete
- Certification accredited by Microsoft
- 100% online
- Intermediate Level Course
Program offerings
- Certification
- Live video
- Quiz
- Activity
Course and certificate fees
Fees information
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
certificate providing authority
Eligibility criteria
Certification Qualifying Details
Completion of Applied Data Analysis training is enough for certification.
What you will learn
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.
Who it is for
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:
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
The syllabus
Advanced Data Analysis and Visualization Using Microsoft Excel
Course Introduction
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
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
The ExpertTrack is a comprehensive data analysis course covering Excel, Power BI, and statistics, designed to equip learners with essential data analyst skills.
No prior experience is necessary, but some familiarity with Excel functionalities and data visualisation will be helpful.
Yes, the course is fully online, allowing learners to participate from any location globally.
The course duration is 14 weeks long based on individual learning pace, as it is self-paced and allows learners to progress at their convenience.
Learners will receive industry-specific digital certificates, validating their expertise in data analysis.
Articles
Popular Articles
Latest Articles
Similar Courses
Data Processing and Analysis with Excel
RIT via Edx
Excel Power Tools for Data Analysis
Macquarie University, Sydney via Coursera
Data Analysis with R
Facebook via Udacity
Observation Theory Estimating the Unknown
Delft University of Technology via Edx
Stochastic Processes Data Analysis and Computer Si...
Kyoto University via Edx
Image Processing and Analysis for Life Scientists
Swiss Federal Institute of Technology Lausanne via Edx
Courses of your interest
Salesforce Administrator and App Builder
SkillUp Online via Simplilearn
Introduction to Medical Software
Yale University, New Haven via Coursera
Google Cloud Architect Program
Google Cloud via SkillUp Online
Google Cloud Architect Program
Google via SkillUp Online
Information Security Design and Development
Coventry University, Coventry via Futurelearn
Ethics Laws and Implementing an AI Solution on Mic...
CloudSwyft Global Systems, Inc via Futurelearn
Network Security and Defence
Coventry University, Coventry via Futurelearn
Cyber Security Foundations Start Building Your Car...
EC-Council via Futurelearn
Advanced and Applied Artificial Intelligence on Mi...
CloudSwyft Global Systems, Inc via Futurelearn
More Courses by CloudSwyft Global Systems, Inc
Microsoft Business Applications Dynamics 365 and P...
CloudSwyft Global Syst... via Futurelearn
Data Science on Microsoft Azure using R Programmin...
CloudSwyft Global Syst... via Futurelearn
Data Science on Microsoft Azure Using Python Progr...
CloudSwyft Global Syst... via Futurelearn