Last Update: 7/2020Duration: 8h 3m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 44.1 kHz, 2ch | Size: 4.16 GBGenre: eLearning | Language: English
Gain hands-on experience with Excel, Statistics, MySQL and Power BI to drive powerful analysis and communicate insights
What you'll 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
Requirements:
MS Excel 2010, 2013, 2016, 2019
Other softwares used in this course are open sources
Only the passion for data analysis
Description:
Join to over 5,000 students and learn Excel, Statistics, SQL, and Power BI in one course to analyze data, identify trends, design visualizations, and drive business decisions with real‐world data sets.