This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
- HD Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
What you'll learn?
- Get hands-on experience with 4 groups of skills that needs each data analyst - Excel, SQL, Statistics, and Power BI
- Learn MS Excel for cleaning, preparing, calculating and analysing data
- Learn how to write advanced Excel formulas by SUBTOTAL, SUMIFS, COUNTIFS, VLOOKUP, INDEX, MATCH functions
- Learn Excel Pivot Tables so you can quickly get insights from your data
- Learn Statistical Analysis in MS Excel by Data Analysis ToolPak including Descriptive statistics and Linear regression
- Learn how to perform A/B testing and what is P-value
- Start using MySQL – the #1 Database Management System
- Learn how to write complex SQL queries to obtain useful information from the database
- Learn Microsoft Power BI for analysing and visualizing data
- Learn how to connect Power BI to an Excel file and MySQL database and create interactive dashboards for these data sets
- Put all 4 groups of skills together for identifying insights and trends based on real-life data sets
Course Overview
Join over 5,000 students and learn Excel, Statistics, SQL, and Power BI in one course to identify trends and drive business decisions with realâ€world data.
WHY WOULD YOU CHOOSE TO LEARN DATA ANALYSIS TOOLS?
Data analysis is a process of inspecting, cleaning, transforming and modeling data with the goal of discovering useful information, informing conclusion and supporting decision-making. Data Analyst is one of the sexiest jobs in nowadays. Knowing of Excel, MySQL, Power BI and Statistics can get you a promotion and make you a rock star at your company.
WHY TAKE THIS SPECIFIC EXCEL COURSE?
There are many Data Analysis courses out there teaching you the important tools and features you need to master.
But, can you apply what you learnt to your own files? Do you get enough practice to remember all the new information?
This course is concentrated on the most important tools for performing data analysis on the job. In this course you'll play the role of data analyst at a delivery company and you'll be working with real-life data sets. You will learn both technical and business thinking skills, and get important skills to get hired. You don't need to spend months to learn data analysis tools. As you go through the course, you'll be able to apply what you learnt immediately to your job.
Author of this course has over 10 years of working experience in large financial organizations and over 5 years of experience of online and in-person trainings. He has dozens of courses on Excel, SQL, Power BI, Access, and more than 10,000 students in total. Surely he knows what you need.
READ SEVERAL REVIEWS OF STUDENTS:
★★★★★Mary Rose
It was well explained and captured the basic elements of the 4 skills.
★★★★★Vinh Au
This is one of the best course that I've taken. The instructor show just enough example to help you understand the concept within a short period of time. No unnecessary information. If you are a beginner and try to learn data analysis. This is the course to take. Highly recommend.
★★★★★Irina Arakelyan
Very comprehensive course with real work with data and real examples. I found all what I need in one course. I appreciate this instructor and really recommend this course.
WHAT ARE SOME EXCEL TOOLS AND FUNCTIONS YOU WILL LEARN IN THIS COURSE?
You'll learn:
1. MS Excel:
· Unlock the power of MS Excel to utilize its analytical tools — no matter your experience level.
· Execute conditional aggregation commands (SUBTOTAL, SUMIFS, COUNTIFS, etc.) to summarize data.
· Practice applying the Pivot Table tool for data analysis of a sample business case.
· Use the VLOOKUP, INDEX and MATCH functions to manipulate data sets in MS Excel.
2. Statistics:
· Understand the value of descriptive and predictive statistics.
· Learn to describe data using its Mean, Median, Mode, Range, and Variance.
· Create Linear regression model by using Data Analysis ToolPak in MS Excel.
· Perform A/B Testing and calculate Statistical Significance of your test.
3. MySQL:
· Filter data using advanced SQL commands (Select, Where, Group By, Having, Order By, Limit).
· Obtain data by creating relationships between tables using Joins.
· Summarize data sets by employing aggregation commands (“Sum,” “Average,” “Count,” etc.).
· Use CASE statements to structure data and create new attributes.
4. Power BI:
· Get hands-on, practical experience navigating the Power BI software interface.
· Connect your data to Power BI and identify the best ways to visualize and display your results.
· Analyze and visualize your data in Power BI in order to answer basic questions.
· Create advanced interactive dashboards for presentation.
Join today and get immediate, lifetime access to the following:
· In demand course content
· Downloadable Excel project files
· Homework exercises & quizzes
· Free support from the instructor
· Certificate of Completion
See you in there!
Sincerely,
Vardges Zardaryan
P.S.Looking to master the full Microsoft Excel, Statistics, SQL, and Power BI stack? Search for "Vardges Zardaryan" and complete the courses below to become a Data Analysis Rock Star:
1. Data Analysis and Statistics with Excel
2. Power BI Masterclass from Scratch
3. Analytic Techniques: Excel + MySQL + Power BI
Pre-requisites
- MS Excel 2010, 2013, 2016, 2019
- Other softwares used in this course are open sources
- Only the passion for data analysis
Target Audience
- Anyone looking for hands-on data analysis course and real-life projects
- Anyone looking to pursue a career in data analysis or business intelligence
- Business professionals looking to improve their analytical skills and learn more tools for that
- Anyone looking to learn different softwares for effective data analysis
- Data analysts looking to continue their professional development and career advancement
- Students who want a comprehensive, engaging, and highly interactive approach to training
Curriculum 87 Lectures 05:59:38
-
Section 1 : Course Overview
-
Section 2 : ----- PART 1. Exploring Data in MS Excel -----
- Lecture 1 :
- MS Excel for Data Analysis
- Lecture 2 :
- Introduction to the Task
-
Section 3 : Cleaning and Preparing Tools
- Lecture 1 :
- Sort and Filter
- Lecture 2 :
- Text to Columns
- Lecture 3 :
- Remove Duplicates
- Lecture 4 :
- Data Validation
- Lecture 5 :
- Find, Replace, Go to
- Lecture 6 :
- Data Entry Form
-
Section 4 : Advanced Forumals and Functions
- Lecture 1 :
- SUBTOTAL vs SUM
- Lecture 2 :
- Date Functions: YEAR, MONTH, DAY, EOMONTH, DATE
- Lecture 3 :
- Logical Functions: IF, AND
- Lecture 4 :
- Text Fuctions: RIGHT, LEFT, CONCATENATE
- Lecture 5 :
- Math Functions: SUMIF, COUNTIF
- Lecture 6 :
- Logical Functions: OR
- Lecture 7 :
- Text Functions: LEN, LOWER, UPPER, PROPER
- Lecture 8 :
- Math Functions: SUMIFS, COUNTIFS
-
Section 5 : Analysing Data by Pivot Table
- Lecture 1 :
- Calculations in Pivot Table
- Lecture 2 :
- GetPivotData
- Lecture 3 :
- VLOOKUP with Exact Match
- Lecture 4 :
- INDEX and MATCH functions
- Lecture 5 :
- VLOOKUP with Approximate Match
- Lecture 6 :
- Format as Table
- Lecture 7 :
- Data Model
- Lecture 8 :
- Slicer in Pivot Table
- Lecture 9 :
- Conditional Formatting
- Lecture 10 :
- Introduction to Pivot Table
-
Section 6 : ----- PART 2. Statistical Analysis with Excel -----
- Lecture 1 :
- Calculation of Statistical Metrics
- Lecture 2 :
- Scatter Plots
-
Section 7 : Data Analysis ToolPak
- Lecture 1 :
- Activation of Data Analysis ToolPak
- Lecture 2 :
- Descriptive Statistics
- Lecture 3 :
- Histogram
- Lecture 4 :
- Correlation
-
Section 8 : Linear Regression Analysis
- Lecture 1 :
- Linear Regression
- Lecture 2 :
- Explanation of the Output of Regression
- Lecture 3 :
- Muliple Linear Regression
-
Section 9 : A/B Testing
- Lecture 1 :
- Introduction to A/B Testing
- Lecture 2 :
- Visualization of A/B Testing
- Lecture 3 :
- Statistical Significance
-
Section 10 : ----- PART 3. Managing Data with MySQL -----
- Lecture 1 :
- What are SQL and MySQL
- Lecture 2 :
- Installing MySQL Workbench
-
Section 11 : Basic SQL Queries
- Lecture 1 :
- Create Table and Insert Data
- Lecture 2 :
- SELECT (DISTINCT) Statement
- Lecture 3 :
- WHERE Clause
- Lecture 4 :
- AND, OR, NOT, IN and BETWEEN Operators
- Lecture 5 :
- LIKE Operator
- Lecture 6 :
- INSERT INTO Statement
- Lecture 7 :
- UPDATE Statement
- Lecture 8 :
- ORDER BY Statement
-
Section 12 : SQL Functions and Intermediate Statements
- Lecture 1 :
- Aggregate Functions
- Lecture 2 :
- SQL Subqueries
- Lecture 3 :
- GROUP BY Statement
- Lecture 4 :
- HAVING Statement
- Lecture 5 :
- Comments in SQL
- Lecture 6 :
- SQL JOINS
- Lecture 7 :
- CASE Statement
- Lecture 8 :
- Export and Import Data
- Lecture 9 :
- Practice Examples with Solutions
- Lecture 10 :
- SQL Query - Best Practices
-
Section 13 : ----- PART 4. Visualization with Power BI -----
- Lecture 1 :
- Power BI vs MS Excel
- Lecture 2 :
- Installing Power BI Desctop
-
Section 14 : Data Connection and Preparation
- Lecture 1 :
- Connect to XLSX File
- Lecture 2 :
- Connect to SQL Database
- Lecture 3 :
- Basic Transformations
- Lecture 4 :
- Managing Data Relationships
- Lecture 5 :
- Connect to CSV File
-
Section 15 : Charts and Visualization Techniques
- Lecture 1 :
- Stacked Bar Chart
- Lecture 2 :
- 100% Stacked Column Chart
- Lecture 3 :
- Pie and Donut Charts
- Lecture 4 :
- Column Chart with Line
- Lecture 5 :
- Treemap Charts
- Lecture 6 :
- Map and Filled Map Charts
- Lecture 7 :
- Waterfall Chart
- Lecture 8 :
- Gauge Chart
- Lecture 9 :
- Card and KPI
- Lecture 10 :
- Table and Matrix
- Lecture 11 :
- Slicer for Interactive Dashboards
- Lecture 12 :
- Shapes, Textboxes, and Images
- Lecture 13 :
- Visual Relationship
-
Section 16 : Extra Functionalities in Power BI
- Lecture 1 :
- Duplicate Page
- Lecture 2 :
- See and Export Data
- Lecture 3 :
- Enter New Data Manually
- Lecture 4 :
- Update Project Data
- Lecture 5 :
- Wrapping Up of Power BI
- Lecture 6 :
- Power Add-ins in Excel
-
Section 17 : ----- Congratulations -----
- Lecture 1 :
- Conclusion
-
Section 18 : Test Yourself
- Lecture 1 :
- Final Quiz
Our learners work at
Frequently Asked Questions
-
How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time. -
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic. -
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on. -
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want. -
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly. -
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion. -
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions. -
Is there any free trial?
Currently, we do not offer any free trial. -
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?
Instructor
319068 Course Views
3 Courses