17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Udemy - The Data Analyst's Toolkit - Excel, SQL, Python, Power BI
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
Data Mastery for the Modern Analyst: Excel, SQL, Python, and Power BI Techniques
What you'll learn
The roles and responsibilities of a data analyst
The importance of data-driven decision-making in organizations.
How to use Microsoft Excel for data manipulation and analysis.
Data cleaning and formatting techniques in Excel.
How to create and use pivot tables
Data visualization techniques using Excel charts.
Writing basic SQL queries for data retrieval from relational databases.
Advanced SQL techniques, such as filtering, sorting, aggregating, and joining multiple tables.
The basics of the Python programming language for data analysis.
How to use Python libraries like Pandas for data manipulation.
Data visualization techniques using Python libraries such as Matplotlib.
Connecting to data sources, data cleaning, and transformation in Power BI.
Creating interactive dashboards and reports using Power BI.
Requirements
Basic computer literacy: Students should be comfortable using computers and navigating various software applications, as well as have a general understanding of file management.
Familiarity with Microsoft Office Suite: A basic understanding of Microsoft Office applications, particularly Excel, will be helpful for students as they dive into more advanced data analysis techniques using Excel.
Problem-solving mindset: A curiosity for solving problems and a willingness to explore various approaches to data analysis will help students succeed in this course.
No prior programming experience is required, but a basic understanding of programming concepts and logic will be beneficial when learning Python and SQL.
Access to required software: Students should have access to a computer with Microsoft Excel, Power BI, and a Python development environment (e.g., Anaconda) installed. Access to a SQL database environment (e.g., MySQL, PostgreSQL, or SQL Server) is also recommended for practicing SQL queries.
If You Need More Stuff, kindly Visit and Support Us -->> https://DevCourseWeb.com
Get More Tutorials and Support Us -->> https://CourseWikia.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/1. Introduction to Data Analysis/1. Introduction.mp4
1.5 MB
~Get Your Files Here !/1. Introduction to Data Analysis/2. Course Introduction.html
1.9 KB
~Get Your Files Here !/1. Introduction to Data Analysis/3. Data Analysis Overview.mp4
30.7 MB
~Get Your Files Here !/1. Introduction to Data Analysis/4. Roles in Data Analysis.mp4
39.2 MB
~Get Your Files Here !/1. Introduction to Data Analysis/5. Tasks of a Data Analyst.mp4
51 MB
~Get Your Files Here !/1. Introduction to Data Analysis/6. Importance of Data-Driven Decision Making.html
3.2 KB
~Get Your Files Here !/2. Excel Fundamentals/1. Introduction to Excel.mp4
13.4 MB
~Get Your Files Here !/2. Excel Fundamentals/10. Adding a title to worksheet.mp4
17.6 MB
~Get Your Files Here !/2. Excel Fundamentals/11. Saving your work.mp4
24.4 MB
~Get Your Files Here !/2. Excel Fundamentals/12. Introduction to Excel Functions and Formulas.mp4
23.9 MB
~Get Your Files Here !/2. Excel Fundamentals/13. Using formulas for arithmetic tasks.mp4
28.1 MB
~Get Your Files Here !/2. Excel Fundamentals/14. Re-using formulas.mp4
20.2 MB
~Get Your Files Here !/2. Excel Fundamentals/15. Calculating YTD Profits.mp4
35.2 MB
~Get Your Files Here !/2. Excel Fundamentals/16. Calculating percentage change.mp4
27.8 MB
~Get Your Files Here !/2. Excel Fundamentals/17. Relative and absolute reference.mp4
42.2 MB
~Get Your Files Here !/2. Excel Fundamentals/18. Using Rank Function.mp4
18.7 MB
~Get Your Files Here !/2. Excel Fundamentals/19. STD Function.mp4
11.1 MB
~Get Your Files Here !/2. Excel Fundamentals/2. Opening a new workbook.mp4
29.8 MB
~Get Your Files Here !/2. Excel Fundamentals/20. Small and Large Functions.mp4
17.5 MB
~Get Your Files Here !/2. Excel Fundamentals/21. Median Function.mp4
9.1 MB
~Get Your Files Here !/2. Excel Fundamentals/22. Count and Counta Functions.mp4
17.4 MB
~Get Your Files Here !/2. Excel Fundamentals/23. Exploring fonts.mp4
24.8 MB
~Get Your Files Here !/2. Excel Fundamentals/24. Adjusting column width and row height.mp4
34.5 MB
~Get Your Files Here !/2. Excel Fundamentals/25. Using alignment.mp4
29.5 MB
~Get Your Files Here !/2. Excel Fundamentals/26. Designing borders.mp4
26.3 MB
~Get Your Files Here !/2. Excel Fundamentals/27. Formatting Numbers.mp4
38.2 MB
~Get Your Files Here !/2. Excel Fundamentals/28. Conditional formatting.mp4
43.3 MB
~Get Your Files Here !/2. Excel Fundamentals/29. Creating tables.mp4
42.8 MB
~Get Your Files Here !/2. Excel Fundamentals/3. Entering data in Excel.mp4
31.7 MB
~Get Your Files Here !/2. Excel Fundamentals/30. Inserting shapes.mp4
37.8 MB
~Get Your Files Here !/2. Excel Fundamentals/4. Basic data entry in Excel.mp4
28.1 MB
~Get Your Files Here !/2. Excel Fundamentals/5. Entering data with autofil.mp4
27.4 MB
~Get Your Files Here !/2. Excel Fundamentals/6. Entering date.mp4
24.2 MB
~Get Your Files Here !/2. Excel Fundamentals/7. Entering time.mp4
28.6 MB
~Get Your Files Here !/2. Excel Fundamentals/8. Undo and redo changes.mp4
27.9 MB
~Get Your Files Here !/2. Excel Fundamentals/9. Adding comments.mp4
19.1 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/1. What is Power Query.mp4
13.6 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/10. Importing data and creating relationships.mp4
40.6 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/10.1 AddData.xlsx
14.8 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/11. Creating lookups with DAX.mp4
39.9 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/11.1 Lookups.xlsx
14.8 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/12. Analyze data with Pivot Tables.mp4
49.7 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/13. Analyze data with Pivot Charts.mp4
52.4 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/13.1 Charts.xlsx
17.3 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/14. Refreshing source data.mp4
49.1 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/14.1 Refresh.xlsx
17.3 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/15. Updating queries.mp4
66.4 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/15.1 Update.xlsx
17.3 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/16. Creating new reports.mp4
43.6 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/2. Connecting to a data source.mp4
31.1 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/3. Please Read.html
189 B
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/4. Preparing the query.mp4
45.3 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/4.1 Prep.xlsx
14.8 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/5. Cleaning the data.mp4
73.4 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/5.1 Cleansing.xlsx
14.8 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/6. Enhancing the query.mp4
79.2 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/6.1 Enhance.xlsx
13.4 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/7. What is Power Pivot.mp4
2.9 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/8. How to enable Power Pivot.mp4
7.2 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/9. Create a data model.mp4
48 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/9.1 PrepPP.xlsx
13.9 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/EV sales (King county).csv
27.6 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/1. Introduction to SQL.mp4
17.4 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/10. Joining Multiple Tables with INNER Join.mp4
58.7 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/11. Joining Multiple Tables with LEFT Join.mp4
29.5 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/12. Joining Multiple Tables with RIGHT Join.mp4
20.5 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/13. Joining Multiple Tables with SELF Join.mp4
39.6 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/14. Removing duplicates from query results.mp4
27.7 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/15. Group data by combing rows.mp4
19.4 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/16. Filter grouped results.mp4
38.8 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/17. Sort query results.mp4
42.1 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/18. Filtering rows of data.mp4
12.2 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/19. Introduction to aggregate functions.mp4
6.2 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/2. Introduction to MySQL.mp4
16.4 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/20. Using COUNT Aggregate Function.mp4
44.6 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/21. Using SUM Aggregate Function.mp4
20.1 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/22. Using AVG Aggregate Function.mp4
15.4 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/23. Using MIN Aggregate Function.mp4
10.4 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/24. Using MAX Aggregate Function.mp4
12.1 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/25. What are Subqueries.mp4
21.1 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/26. Using Nested Subqueries.mp4
15.3 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/3. MySQL Installation (Windows).mp4
69.6 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/4. MySQL Installation (Mac).mp4
41.3 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/5. What is MySQL Workbench.mp4
33.8 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/6. Basic database concepts.mp4
34.8 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/7. What is a Schema.mp4
9.6 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/8. Database Schema.mp4
21.7 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/9. MySQL Data Types.mp4
23.6 MB
~Get Your Files Here !/5. Python Fundamental/1. What is Python.mp4
16.7 MB
~Get Your Files Here !/5. Python Fundamental/10. The Notebook user interface.mp4
16.4 MB
~Get Your Files Here !/5. Python Fundamental/11. Creating a new notebook.mp4
20 MB
~Get Your Files Here !/5. Python Fundamental/12. Python expressions.mp4
10.2 MB
~Get Your Files Here !/5. Python Fundamental/13. Python statements.mp4
14.5 MB
~Get Your Files Here !/5. Python Fundamental/14. Python Comments.mp4
13 MB
~Get Your Files Here !/5. Python Fundamental/15. Python data types.mp4
15 MB
~Get Your Files Here !/5. Python Fundamental/16. Casting data types.mp4
7.8 MB
~Get Your Files Here !/5. Python Fundamental/17. Python Variables.mp4
24.5 MB
~Get Your Files Here !/5. Python Fundamental/18. Python List.mp4
