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)
5,803
students
8 hours
content
Nov 2022
last update
$79.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
Screenshots
Related Topics
2550105
udemy ID
9/8/2019
course created date
9/12/2019
course indexed date
Bot
course submited by