Published 12/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.93 GB | Duration: 10h 43m
Gain Real World Skills By Mastering Excel, SQL, Python, Power BI, and Tableau for Data Analysts
What you'll learn
Develop a foundational understanding of data analysis principles and techniques.
Master Excel functions and formulas for data manipulation, analysis, and visualization.
Learn SQL for data querying, manipulation, and retrieval from relational databases.
Acquire programming skills in Python for data handling, manipulation, and analysis.
Create compelling data visualizations and dashboards using Power BI and Tableau.
Apply learned skills to real-world data sets and scenarios.
Requirements
Basic Computer Skills: Familiarity with navigating computer systems, using software applications, and basic file management is recommended.
Fundamental Math Skills: A foundational understanding of basic mathematical concepts like arithmetic, algebra, and statistics will be beneficial for comprehending data analysis principles.
No Prior Programming Knowledge Required: While prior programming experience is not mandatory, a willingness to learn and engage with programming concepts is essential for the Python section of the course.
Access to a Computer: Learners should have access to a computer or laptop with internet connectivity to participate in the course modules and complete exercises.
Software and Tools: Access to software such as Microsoft Excel, SQL client (e.g., MySQL Workbench), Python (Anaconda distribution recommended), Power BI Desktop, and Tableau Public (free version) will be necessary for hands-on practice during the course. Free trials or open-source alternatives are available for some tools.
For Beginners: No prior experience or specific skills are mandatory to embark on this course.
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.