All Courses Learn Excel Learn MySQL

Data Analyst’s Toolbox: Excel to MySQL – Learn To Code

Data Analyst's Toolbox: Excel to MySQL - Learn To Code

Data Analyst’s Toolbox: Excel to MySQL – Learn To Code

Learn 4 groups of skills for world-class data analysis — MS Excel, Statistics, MySQL and Power BI in one course.

What you’ll learn

Data Analyst’s Toolbox: Excel to MySQL – Learn To Code

  • Get 4 groups of skills that need each data analyst
  • Learn MS Excel for cleaning, preparing, calculating and analyzing data
  • Learn Statistics by Data Analysis ToolPak including Linear regression
  • The SQL from scratch for extracting and manipulating big data by MySQL Workbench
  • Learn Power BI for analyzing and visualizing data and creating interactive dashboards
  • Put all 4 groups of skills together for identifying insights and trends based on data

Requirements

  • Only the passion for data
  • MS Excel 2010, 2013, 2016, 2019
  • Other software used in this course are open sources

Description

Use Excel, Statistics, SQL, and Power BI to identify trends and drive business decisions with real‐world data.

1. MS Excel:

Unlock the power of MS Excel to utilize its analytical tools — no matter your experience level.

Practice applying the PivotTable tool for data analysis of a sample business case.

Use the VLOOKUP, INDEX and MATCH functions to manipulate data sets in MS Excel.
[adss]

2. Statistics

Understand the value of descriptive and inferential statistics.

Learn to describe data using its mean, median, mode, range, and variance.

Practice applying statistical functions in MS Excel.

Create a Linear regression Model by using Data Analysis ToolPak in MS Excel.

3. MySQL

Filter data using advanced SQL commands (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.

Create advanced interactive dashboards for presentation.

Who this course is for:

  • Data Analysts, Business Analysts, Financial Analysis, Marketing Analysts
  • Content From: https://www.udemy.com/course/data-analysts-toolbox-excel-to-mysql-am/
  • Learn Android Programming From Scratch
[adss] Download Now [ads]