Business Analysis Masterclass (5 courses in 1) [FREE]

Free Certification Course Title: Business Analysis Masterclass (5 courses in 1)

All the skills you need for Business Analyst career track. Tableau, Python, Excel, SQL, BigQuery. All-in-one Mega course

Business Analysis Masterclass (5 courses in 1)

What you’ll learn:

  • 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.

Requirements:

  • No prior knowledge required.
  • Determination and Desire to Learn new things.
  • A willingness to learn and practice.
  • A positive attitude to success.
  • Some background in computer science.

Who this course is for:

  • Business Analysts
  • Job-seekers
  • Anyone who wants to explore data science.
  • Students and professionals who want to improve the training capabilities
  • Just Passion for Learning
  • Business Professionals

This course includes:

  • 24 hours on-demand video
  • 2 articles
  • 79 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of completion