Data Analyst's Toolbox: Excel, SQL, Power BI

Focused View

Vardges Zardaryan

8:03:24

79 View

1. Course Overview

1. Welcome to the Course.mp4

02:12

2. ----- PART 1. Exploring Data in MS Excel -----

1. MS Excel for Data Analysis.mp4

01:56

2.1 Working data clean.xlsx

2. Introduction to Data Analyst Role.mp4

01:47

3. Cleaning and Preparing Tools

1. Sort and Filter.mp4

07:02

2. Text to Columns.mp4

04:47

3. Remove Duplicates.mp4

04:06

4.1 Data Validation.xlsx

4. Data Validation.mp4

07:00

5. Find, Replace, Go to.mp4

03:46

6. Data Entry Form.mp4

02:55

4. Advanced Forumals and Functions

1. Logical Functions IF, AND, OR.mp4

09:22

2. Math Functions SUM, COUNT, SUBTOTAL.mp4

06:03

3. Text Functions LEFT, RIGHT, CONCATENATE, LEN, LOWER, UPPER, PROPER.mp4

08:26

4. Date Functions YEAR, MONTH, DAY, EOMONTH, DATE.mp4

05:27

5. Conditional Functions SUMIF, COUNTIF, SUMIFS, COUNTIFS.mp4

08:21

6. Statistical Functions AVERAGE, AVERAGEIF, AVERAGEIFS.mp4

06:47

7.1 Financial Analysis.xlsx

7. Financial Functions PMT, PV, FV, RATE, NPER, NPV, IRR.mp4

08:50

5. Pivot Tables and Lookup Functions

1. Introduction to Pivot Table.mp4

07:15

2. Calculated Fields in Pivot Table.mp4

11:57

3. Grouping Data with Pivot Table.mp4

03:14

4. GetPivotData.mp4

04:27

5. VLOOKUP with Exact Match.mp4

07:41

6. INDEX and MATCH functions.mp4

06:54

7. VLOOKUP with Approximate Match.mp4

04:55

8. Format as Table.mp4

02:33

9. Data Model.mp4

04:26

10. Slicer in Pivot Table.mp4

03:12

11. Conditional Formatting.mp4

05:32

6. Part 1 Completed

1. Quiz 1.html

7. ----- PART 2. Statistical Analysis with Excel -----

1. Calculation of Statistical Metrics.mp4

09:41

2.1 Statistical Analysis.xlsx

2. Scatter Plots.mp4

02:01

8. Data Analysis ToolPak

1. Activation of Data Analysis ToolPak.mp4

01:17

2. Descriptive Statistics.mp4

04:12

3. Histogram.mp4

04:36

4. Correlation.mp4

07:55

9. Linear Regression Analysis

1. Linear Regression.mp4

03:21

2. Explanation of the Output of Regression.mp4

06:42

3. Muliple Linear Regression.mp4

08:00

10. AB Testing

1.1 A-B Testing.xlsx

1. Introduction to AB Testing.mp4

01:34

2. Visualization of AB Testing.mp4

06:35

3. Statistical Significance.mp4

07:42

11. Part 2 Completed

1. Quiz 2.html

12. ----- PART 3. Managing Data with MySQL -----

1. What are SQL and MySQL.mp4

01:44

2. Installing MySQL Workbench.mp4

03:36

13. Basic SQL Queries

1.1 data.txt

1. Create Table and Insert Data.mp4

09:16

2. SELECT (DISTINCT) Statement.mp4

07:40

3. WHERE clause.mp4

03:24

4. AND, OR, NOT, IN, and BETWEEN Operators.mp4

07:41

5. LIKE Operator.mp4

04:26

6. INSERT INTO and DELETE FROM Statements.mp4

05:39

7. UPDATE SET Statement.mp4

03:36

8. ORDER BY Statement.mp4

04:02

14. Intermediate Statements and Functions

1. Aggregate Functions.mp4

05:53

2. SQL Subqueries.mp4

02:48

3. GROUP BY Statement.mp4

06:06

4. HAVING Statement.mp4

03:29

5. SQL JOINS.mp4

07:40

6. CASE Statement.mp4

06:32

15. Advanced Tips and Tricks in MySQL

1. SQL Query - Best Practices.mp4

04:08

2. Comments in SQL.mp4

03:08

3. Export and Import Data.mp4

04:37

4. Stored Procedures.mp4

14:40

5. Practical Exercises with Solutions (Part 1).mp4

10:36

6. Practical Exercises with Solutions (Part 2).mp4

14:48

16. Part 3 Completed

1. Quiz 3.html

17. ----- PART 4. Visualization with Power BI -----

1. Power BI vs MS Excel.mp4

02:47

2. Installing Power BI Desctop.mp4

03:01

18. Data Connection and Preparation

1.1 Full Data Excel.xlsx

1. Connect to XLSX File.mp4

05:07

2.1 Orders Data.csv

2. Connect to CSV File.mp4

02:10

3. Connect to SQL Database.mp4

05:32

4. Basic Transformations.mp4

04:15

5. Working with Dates.mp4

03:07

6. Splitting Columns.mp4

04:21

7. Conditional Columns.mp4

06:21

8. Calculated Columns.mp4

02:54

9. Calculation of Statistics.mp4

01:58

10. Apply Transformations.mp4

03:51

11. Managing Data Relationships.mp4

06:18

19. Charts and Visualization Techniques

1. Stacked Bar Chart.mp4

06:35

2. 100% Stacked Column Chart.mp4

04:04

3. Pie and Donut Charts.mp4

02:58

4. Column Chart with Line.mp4

03:35

5. Treemap Charts.mp4

02:32

6. Map and Filled Map Charts.mp4

04:28

7. Waterfall Chart.mp4

01:39

8. Gauge Chart.mp4

03:22

9. Card and KPI.mp4

05:51

10. Table and Matrix.mp4

05:23

11. Slicer for Interactive Dashboards.mp4

06:49

12. Shapes, Textboxes, and Images.mp4

03:17

13. Visual Relationship.mp4

04:57

20. Extra Functionalities in Power BI

1. Duplicate Page.mp4

03:18

2. See and Export Data.mp4

01:20

3. Enter New Data Manually.mp4

06:23

4. Update Project Data.mp4

06:00

5. Wrapping Up of Power BI.mp4

03:29

6. Power Add-ins in Excel.mp4

03:28

21. Part 4 Completed

1. Quiz 4.html

22. ----- Congratulations -----

1. Conclusion.mp4

01:04

2. Next Steps.mp4

01:12

Description

Gain hands-on experience with Excel, Statistics, MySQL and Power BI to drive powerful analysis and communicate insights

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, AVERAGEIFS, VLOOKUP, INDEX, MATCH and other 50+ functions
Learn 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 datasets
Put all 4 groups of skills together for identifying insights and trends based on real-life data sets

Who is this for?

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

What You Need to Know?

MS Excel 2010, 2013, 2016, 2019

Other softwares used in this course are open sources

Only the passion for data analysis

More details

Description
Join to over 5,000 students and learn Excel, Statistics, SQL, and Power BI in one course to analyze data, identify trends, design visualizations, and drive business decisions with realâ€world data sets. Gain a competitive advantage in the job market.

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 COURSE?
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 20,000 students in total. Surely he knows what you need.

HERE WHY THIS COURSE IS ONE OF THE BEST COURSES ON UDEMY:
â˜…â˜…â˜…â˜…â˜… 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 TOOLS AND TECHNIQUES 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.

So, what are you waiting for? Join today and get immediate, lifetime access to the following:
Â· 8+ hours on-demand video
Â· Downloadable project files
Â· Practical exercises & quizzes
Â· 1-on-1 expert support
Â· Course Q&A forum
Â· 30-day money-back guarantee
Â· Digital Certificate of Completion
See you in there!

Sincerely,
Vardges Zardaryan

P.S. Looking to master the full Microsoft Excel, Power BI + SQL stack? Search for "Vardges Zardaryan" and complete the courses below to become a Data Analysis Rock Star:
1. Mastering Data Analysis in Excel
2. Mastering Data Analysis with Power BI
3. Data Analystâ€™s Toolbox: Excel, SQL, Power BI
4. The Complete Introduction to SQL for Data Analytics
Who this course is for:
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

User Reviews

Rating

average 0

Total votes0

Focused display

Hi. My name is Vardges. I'm an Analyst with over 10 years of experience in data analysis, banking risk management, and reporting. During my whole career I have been using MS Excel and other data analytics tools, and now these are not only the tools for solving my daily tasks but also hobby for me. If you want to become an advanced analyst follow my courses. I have Master's Degree in Mathematics and many certificates from world-class universities and organizations such as Microsoft, IBM, Duke University, Corporate Finance Institute, International Financial Corporation, and I will share my experience and knowledge with you during my courses.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.