Business Intelligence & Data Analysis Masterclass -5 courses

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

[Free Udemy Course] Business Intelligence & Data Analysis Masterclass -5 courses


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.




Please note that many coupons are limited-time coupons. Please let us know if you find any expired coupon.