Description
Data Analyst’s Toolbox course: Excel SQL Power BI. Why choose to learn data analysis tools? Data analysis is the process of inspecting, cleaning, transforming and modeling data with the aim of discovering useful information, informing conclusions and supporting decision making. Data analyst is one of the hottest jobs right now. Knowing Excel, MySQL, Power BI and Statistics can elevate you and make you a rock star in your company. Why participate in this particular course? This course focuses on the most important tools for performing data analysis at work. In this course you will play the role of a data analyst in a delivery company and work with real data sets. You will learn both technical and business thinking skills and gain important employability skills. You don’t need to spend months learning data analysis tools. By completing the course, you will be able to immediately apply what you have learned to your job. The author of this course has more than 10 years of experience working in large financial organizations and more than 5 years of experience in online and face-to-face training. He has dozens of courses in Excel, SQL, Power BI, Access and a total of more than 20,000 students. Surely he knows what you need.
What you will learn in the Data Analyst’s Toolbox: Excel SQL Power BI course
-
Get hands-on experience with the 4 skill sets every data analyst needs – Excel, SQL, Statistics and Power BI
-
MS Excel training to clean, prepare, calculate and analyze data
-
Learn how to write advanced Excel formulas using SUBTOTAL, SUMIFS, COUNTIFS, AVERAGEIFS, VLOOKUP, INDEX, MATCH and more than 50 other functions.
-
Learn pivot tables so you can quickly get statistical information from your data
-
Teaching statistical analysis in MS Excel by Data Analysis ToolPak including descriptive statistics and linear regression
-
Learn how to do A/B testing and what P-value is
-
Start using MySQL – the #1 database management system
-
Learn how to write complex SQL queries to retrieve useful information from the database
-
Learn Microsoft Power BI for data analysis and visualization
-
Learn how to connect Power BI to an Excel file and MySQL database and create interactive dashboards for these datasets.
-
Combine all 4 groups of skills to identify insights and trends based on real data sets.
This course is suitable for people who
- Anyone looking for practical data analysis course and real projects
- Anyone looking for a career in data analytics or business intelligence
- Business professionals are looking to improve their analytical skills and learn more tools for it
- Anyone looking to learn different software for effective data analysis
- Data analysts are looking to continue their professional development and career advancement
- Students who want a comprehensive, engaging and highly interactive approach to education
Course specifications Data Analyst’s Toolbox: Excel SQL Power BI
- Publisher: Udemy
- teacher: Vardges Zardaryan
- Training level: beginner to advanced
- Training duration: 8 hours and 3 minutes
- Number of courses
Course topics Data Analyst’s Toolbox: Excel SQL Power BI
Data Analyst’s Toolbox course prerequisites: Excel SQL Power BI
- MS Excel 2010, 2013, 2016, 2019
- Other softwares used in this course are open sources
- Only the passion for data analysis
Course images
Sample video of the course
Installation guide
After Extract, view with your favorite Player.
English subtitle
Quality: 720p
download link
File(s) password: www.downloadly.ir
Volume
3.87 GB
Be the first to comment