Business Analysis Masterclass (5 courses in 1)

After completing the course, you will…

• Learn about basic formatting in excel.
• Learn about sorting and filtering functions in excel.
• Learn about UPPER, LOWER, PROPER, LEFT, RIGHT, SEARCH, CONCATENATE functions in excel.
• Learn how to find outliers and missing values in Excel.
• Learn how to find standard deviation and percentiles in data using Excel.
• Learn about IF, IF ERROR, COUNTIF, SUMIF and AVERAGEIF functions in excel.
• Learn about using Color Bars and Color scales in excel.
• Learn applying VLOOKUP and HLOOKUP functions and merge datasets using them in excel.
• Learn how to merge datasets using Index and match.
• Learn making Pivot Tables and Pivot charts in excel.
• Learn making interactive dashboards in excel.
• Learn about What-if analysis in excel.
• Learn how to perform linear regression in excel.
• Learn about creating databases and tables in SQL.
• Learn about Numerical, string functions in SQL.
• Learn about filtering using the LIKE operator in SQL.
• Learn about different DDL and DML commands.
• Learn about Joins and Subqueries in SQL.
• Learn connecting Python and MySQL.
• Learn how Big Query works.
• Learn visualization using Data Studio.
• Learn about the use of big query in data analysis.
• Learn connecting big query to tableau desktop for visualizations.
• Learn creating visualization and dashboards using Tableau.
• Learn how to design histograms, tree maps, Pareto and Multi-axis charts.
• Learn how to sort, group and filter data.
• Learn and master context filters, dimension filters, measure filters and Top N filters.
• Learn about different join types to combine your data into a single rich source data.
• Learn exploring data using Dabl and Sweetviz library.
• Learn the basics as well as advanced visualization techniques.
• Learn how to use groups by functions, pivoting functions.
• Learn about structured problem solving concepts.

Who this course is for:

• Business Analysts

Can I download Business Analysis Masterclass (5 courses in 1) course?

Can I get a certificate after completing the course?

Are there any other coupons available for this course?