MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .VTT | Duration: 6.5 hour | Size: 3.37 GB
Learn 4 groups of skills for world-class data analysis -- MS Excel, Statistics, MySQL and Power BI in one course.
What you'll learn
Get 4 groups of skills that needs each data analyst
Learn MS Excel for cleaning, preparing, calculating and analysing data
Learn Statistics by Data Analysis ToolPak including Linear regression
Learn SQL from scratch for extracting and manipulating big data by MySQL Workbench
Learn Power BI for analysing 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 softwares 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.
Execute conditional aggregation commands (SUBTOTAL, SUMIFS, COUNTIFS, etc.) to summarize data sets.
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.
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 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.
Analyze and visualize your data in Power BI in order to answer basic questions.
Create advanced interactive dashboards for presentation.
Who this course is for:
Data Analysts, Business Analysts, Financial Analysis, Marketing Analysts
[i][/i]Screenshots
Buy Premium Account for Download With Full Speed:
rapidgator_net:
https://rapidgator.net/file/42a701369042ebceccb7ffe4b0ee0a1d
https://rapidgator.net/file/aa9379cae335359611de0a9d13b6b96e
https://rapidgator.net/file/ea3398e3106a4da74ed84369105e1479
https://rapidgator.net/file/f91dd0095f4fa93cd68f7491b62f6ecd
uploadgig_com:
https://uploadgig.com/file/download/a7f0D128b6709e52/.Data Analysts Toolbox Excel to MySQL.part1.rar
https://uploadgig.com/file/download/1EB003b9365c5103/.Data Analysts Toolbox Excel to MySQL.part2.rar
https://uploadgig.com/file/download/02e82120312c191c/.Data Analysts Toolbox Excel to MySQL.part3.rar
https://uploadgig.com/file/download/90Ab71BD43601d69/.Data Analysts Toolbox Excel to MySQL.part4.rar
https://rapidgator.net/file/42a701369042ebceccb7ffe4b0ee0a1d
https://rapidgator.net/file/aa9379cae335359611de0a9d13b6b96e
https://rapidgator.net/file/ea3398e3106a4da74ed84369105e1479
https://rapidgator.net/file/f91dd0095f4fa93cd68f7491b62f6ecd
uploadgig_com:
https://uploadgig.com/file/download/a7f0D128b6709e52/.Data Analysts Toolbox Excel to MySQL.part1.rar
https://uploadgig.com/file/download/1EB003b9365c5103/.Data Analysts Toolbox Excel to MySQL.part2.rar
https://uploadgig.com/file/download/02e82120312c191c/.Data Analysts Toolbox Excel to MySQL.part3.rar
https://uploadgig.com/file/download/90Ab71BD43601d69/.Data Analysts Toolbox Excel to MySQL.part4.rar
Links are Interchangeable - No Password - Single Extraction