All the skills you need for Business Analyst career track. Tableau, Python, Excel, SQL, BigQuery. All-in-one Mega course
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
How to Enroll Business Intelligence & Data Analysis Masterclass -5 courses course?
How many members can access this course with a coupon?
Business Intelligence & Data Analysis Masterclass -5 courses Course coupon is limited to the first 1,000 enrollments. Click 'Enroll Now' to secure your spot and dive into this course on Udemy before it reaches its enrollment limits!
