Data Analyst's Toolbox: Excel, SQL, Power BI

Gain hands-on experience with Excel, Statistics, MySQL and Power BI to drive powerful analysis and communicate insights
4.37 (277 reviews)
Udemy
platform
English
language
Data & Analytics
category
Data Analyst's Toolbox: Excel, SQL, Power BI
5 804
students
8 hours
content
Nov 2022
last update
$13.99
regular price

What you will learn

Get hands-on experience with 4 groups of skills that needs each data analyst - Excel, SQL, Statistics, and Power BI

Learn MS Excel for cleaning, preparing, calculating and analysing data

Learn how to write advanced Excel formulas by SUBTOTAL, SUMIFS, COUNTIFS, AVERAGEIFS, VLOOKUP, INDEX, MATCH and other 50+ functions

Learn Pivot Tables so you can quickly get insights from your data

Learn Statistical Analysis in MS Excel by Data Analysis ToolPak including Descriptive statistics and Linear regression

Learn how to perform A/B testing and what is P-value

Start using MySQL – the #1 Database Management System

Learn how to write complex SQL queries to obtain useful information from the database

Learn Microsoft Power BI for analysing and visualizing data

Learn how to connect Power BI to an Excel file and MySQL database and create interactive dashboards for these datasets

Put all 4 groups of skills together for identifying insights and trends based on real-life data sets

Course Gallery

Data Analyst's Toolbox: Excel, SQL, Power BI – Screenshot 1
Screenshot 1Data Analyst's Toolbox: Excel, SQL, Power BI
Data Analyst's Toolbox: Excel, SQL, Power BI – Screenshot 2
Screenshot 2Data Analyst's Toolbox: Excel, SQL, Power BI
Data Analyst's Toolbox: Excel, SQL, Power BI – Screenshot 3
Screenshot 3Data Analyst's Toolbox: Excel, SQL, Power BI
Data Analyst's Toolbox: Excel, SQL, Power BI – Screenshot 4
Screenshot 4Data Analyst's Toolbox: Excel, SQL, Power BI

Charts

Students
Price
Rating & Reviews
Coupons Issued
Enrollment Distribution
2550105
udemy ID
08/09/2019
course created date
12/09/2019
course indexed date
Bot
course submited by