Applied Data Analysis
Learn applied data analysis from scratch including descriptive statistics and using the powerful tools in Excel and Power BI.
Duration
Approx 14 weeks3-5 hrs per week
Learn the fundamental skills of an effective data analyst
Exploring data in meaningful ways is vital for any organisation. Instead of guesswork, businesses can use data to make informed decisions – overcoming challenges and moving forward with useful insights.
This ExpertTrack provides a beginner’s guide to descriptive statistics, using Power BI, data visualisations, and query reports on Excel.
You’ll get a complete overview of data analysis, and how you can apply these essential practices to your workplace.
Master data analysis in Excel
With new tools enabling the analysis of more data, Excel is now one of the most widely used solutions for analysing and visualising data.
You’ll delve into data analysis in Excel and learn how to import data from different sources, create mashups between data sources, and prepare data for analysis.
After preparing the data, you’ll find out how business calculations can be expressed.
Discover how to use Power BI for advanced data analysis
As you start your data analysis and visualisation journey with Power BI, you’ll gain an overview of Power BI and how you can use it to connect to multiple data sources, create and enhance the data model, explore the data, create stunning visualisations, upload reports, and create dashboards.
What’s more, you’ll learn how you can share all of these with your co-workers and business users, across both web and mobile devices.
Unpack statistics for data analysis in Excel
To maximise your potential as a data analyst, you’ll learn how to use the powerful Excel tools to explore the core principles of statistics and basic probability.
With this knowledge, you’ll understand random variables, sampling, confidence intervals, and hypothesis testing.
Learn how to apply your data analyst skills in any workplace
Data analysis takes place in the context of industry pressures, considerations of environment and data ecosystems, and what’s happening in the real world.
You’ll unpack the larger context that any organisation or industry must contend with while doing the work of a data analyst . This knowledge will help your build the confidence to ensure you can apply your skills to the workplace.
Learn from the experts at CloudSwyft to boost your career
As a leading Learning-as-a-Service platform provider, CloudSwyft are specialists in helping their learners develop future-ready skills.
This ExpertTrack gives you the opportunity to develop critical data analysis skills to help you stand out in the field.
Key skills you will learn
- Excel
- Data Analysis
- Data Visualization
- Statistics
- Power BI
- Decision Making
Experience required
This ExpertTrack is designed for learners who are new to Power BI and data analysis but have knowledge of Excel.
You may want to advance your career, perform tasks more efficiently, test out whether a career in data analysis is for you, or simply improve your skills.
Getting started
You don’t need any prior experience but it would be helpful if you know the basic functionalities of Power BI, be able to create formulas and how cells are referenced in Excel, and use visualizations to present findings.
ExpertTrack course overview
Course 1
Microsoft Excel: Advanced Data Analysis and Visualisation
Develop your data science skills as you learn how to import, manipulate, analyse, and visualise data in Excel.
3 weeks
5 hours per week
Week 1
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
Week 2
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
Week 3
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
Course 2
Statistics and Data Analysis in Excel
Learn the essential concepts of statistics and basic probability using Excel to discover the powerful tools at your disposal.
4 tests
5 weeks
3 hours per week
Week 1
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
Week 2
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
Week 3
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
Week 4
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
Week 5
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
Course 3
Microsoft Power BI: Advanced Data Analysis and Visualisation
Master the fundamentals of Power BI and learn how to gather, transform, and visualise data with ease.
1 test
4 weeks
5 hours per week
Week 1
Course Introduction
- About this Course
- Power BI Desktop Transformations
- Further Transformation
- CloudSwyft Hands-On Labs: Data Transformation
- Wrapping Up Data Transformation
Week 2
Data Modelling & Dax in Power BI
- Data Modelling
- Dax in Power BI
Week 3
Power BI Desktop Visualisations
- Connecting and Collaborating With Excel
- Work With Power BI visuals
- Data-driven story with Power BI reports
Week 4
Power BI Service
- Work With Key Performance Indicators
- Mobile App
- Final Assessments & Wrapping Up the Course
Course 4
Successful Data Analysis for Modern Industries
Learn the data analysis skills you need to succeed in different and advancing industries, both today and tomorrow.
2 tests
2 weeks
5 hours per week
Week 1
Welcome to the Course
- About this Course
- Data Economics and Ecosystems
- Data Analysis for Business
- Data Analysis for Education
- Wrapping Up the Week
Week 2
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
Prove you're job ready
Highlight the new, job-relevant skills you’ve gained and supplement existing qualifications with a hard-earned, industry-specific digital certificate – plus one for every course within your ExpertTrack.
- Learn the latest in your chosen industry or subject.
- Complete each course and pass assessments.
- Receive certificates validated by the educating organisation.
- Impress employers with learning outcomes you can add to your CV.
- Make your career dreams a reality.
Download a PDF
How ExpertTracks work
Join an ExpertTrack to master new skills in your chosen specialist area. Work through a series of topic-focused courses at your own pace, and pass the final assessment to earn a digital certificate award which proves your expertise.
Decide if the ExpertTrack is right for you with free access to the full suite of courses and assessments for a week.
Pay a monthly subscription fee of $39 for as long as it takes you to complete the ExpertTrack. You can learn at your own pace and cancel at any time.
Receive a certificate for every completed course and pass the final assessment to earn a digital certificate.
Use your specialist training to progress further in your career or build expertise in areas you’re passionate about.
World-class learning with CloudSwyft Global Systems, Inc.
CloudSwyft has partnered with the top global technology companies to deliver cutting edge digital skills learning across the modern workplace.
World-class learning with Microsoft
Welcome to the world of Microsoft technology – choose a path and make your mark.
Learning on FutureLearn
Your learning, your rules
- Courses are split into weeks, activities, and steps to help you keep track of your learning
- Learn through a mix of bite-sized videos, long- and short-form articles, audio, and practical activities
- Stay motivated by using the Progress page to keep track of your step completion and assessment scores
Join a global classroom
- Experience the power of social learning, and get inspired by an international network of learners
- Share ideas with your peers and course educators on every step of the course
- Join the conversation by reading, @ing, liking, bookmarking, and replying to comments from others
Map your progress
- As you work through the course, use notifications and the Progress page to guide your learning
- Whenever you’re ready, mark each step as complete, you’re in control
- Complete 90% of course steps and all of the assessments to earn your certificate
Want to know more about learning on FutureLearn? Using FutureLearn
What are our learners saying?
Add a new skill or forge a new path
"I recommend Futurelearn to anyone looking to learn and upskill...If you are in the job market, you might want to add a new skill or forge a new path."
They bring the classroom right to you
"FutureLearn courses are always interesting and informative. They bring the classroom right to you and send you on a journey to explore new ideas and offer interesting topics."
Start learning today - free 7-day trial
After your free trial you can:
- Pay $39 per month to keep learning online
- Have complete control over your subscription; you can cancel any time
- Work at your own pace and set your own deadlines at every stage
- Only pay while you’re learning; the subscription will cancel automatically when you finish
- Complete online assessments to test your knowledge and prove your skills
- Earn digital course certificates and a final award that you can share online, with potential employers, and your professional network
- Keep access to the content of courses you complete even after your subscription ends
FAQ
ExpertTracks are a series of online courses designed to help you master new skills in specialist areas. You pay a monthly subscription fee which includes access to all courses within the ExpertTrack, as well as assessments and the final digital certificate.
Each ExpertTrack comes with a 7-day free trial period. You may cancel your subscription at any time and your subscription will automatically cancel when you finish the courses and assessments in your chosen ExpertTrack.
Yes. All of our ExpertTracks come with a 7-day free trial. You may claim one free trial period per ExpertTrack.
You have seven days before you will be charged your first monthly subscription fee. When you join an ExpertTrack you automatically receive a 7-day free trial period. You can cancel at any time during the trial period and no payment will be taken from your account.
Please see our full refund policy here.
No, all of our ExpertTracks consist of fully online courses. This means you can take an ExpertTrack from anywhere in the world.
No. ExpertTracks are designed for you to master new skills in a specialist area. You will earn a digital certificate that proves your learning, but it does not carry accreditation.
If you’re looking for certified or accredited courses, many of our microcredentials offer university credit or professional certification.
Have more questions about ExpertTracks? Read the ExpertTracks FAQs, or contact us.