FreeCourseWeb com Udemy The Data Analyst Toolkit Excel SQL Python Power BI

FreeCourseWeb com Udemy The Data Analyst Toolkit Excel SQL Python Power BI

Name	[ FreeCourseWeb.com ] Udemy - The Data Analyst's Toolkit - Excel, SQL, Python, Power BI	DOWNLOAD Copy Link
Total Size	3.8 GB
Total Files	160
Last Seen	2024-09-29 00:47
Hash	622D3693F9E9FA7AF694C9BB60C4EE303DA22003

/
Get Bonus Downloads Here.url	0.2 KB
/.../1. Introduction to Data Analysis/
1. Introduction.mp4	1.6 MB
2. Course Introduction.html	1.9 KB
3. Data Analysis Overview.mp4	32.1 MB
4. Roles in Data Analysis.mp4	41.1 MB
5. Tasks of a Data Analyst.mp4	53.4 MB
6. Importance of Data-Driven Decision Making.html	3.3 KB
/2. Excel Fundamentals/
1. Introduction to Excel.mp4	14.0 MB
10. Adding a title to worksheet.mp4	18.5 MB
11. Saving your work.mp4	25.6 MB
12. Introduction to Excel Functions and Formulas.mp4	25.0 MB
13. Using formulas for arithmetic tasks.mp4	29.5 MB
14. Re-using formulas.mp4	21.2 MB
15. Calculating YTD Profits.mp4	36.9 MB
16. Calculating percentage change.mp4	29.1 MB
17. Relative and absolute reference.mp4	44.3 MB
18. Using Rank Function.mp4	19.6 MB
19. STD Function.mp4	11.6 MB
2. Opening a new workbook.mp4	31.2 MB
20. Small and Large Functions.mp4	18.4 MB
21. Median Function.mp4	9.5 MB
22. Count and Counta Functions.mp4	18.2 MB
23. Exploring fonts.mp4	26.1 MB
24. Adjusting column width and row height.mp4	36.2 MB
25. Using alignment.mp4	30.9 MB
26. Designing borders.mp4	27.6 MB
27. Formatting Numbers.mp4	40.1 MB
28. Conditional formatting.mp4	45.4 MB
29. Creating tables.mp4	44.9 MB
3. Entering data in Excel.mp4	33.3 MB
30. Inserting shapes.mp4	39.6 MB
4. Basic data entry in Excel.mp4	29.5 MB
5. Entering data with autofil.mp4	28.7 MB
6. Entering date.mp4	25.4 MB
7. Entering time.mp4	30.0 MB
8. Undo and redo changes.mp4	29.2 MB
9. Adding comments.mp4	20.0 MB
/.../3. Data Analysis & Visualization with Excel/
1. What is Power Query.mp4	14.3 MB
10. Importing data and creating relationships.mp4	42.5 MB
10.1 AddData.xlsx	15.5 MB
11. Creating lookups with DAX.mp4	41.8 MB
11.1 Lookups.xlsx	15.6 MB
12. Analyze data with Pivot Tables.mp4	52.1 MB
13. Analyze data with Pivot Charts.mp4	54.9 MB
13.1 Charts.xlsx	18.1 MB
14. Refreshing source data.mp4	51.5 MB
14.1 Refresh.xlsx	18.1 MB
15. Updating queries.mp4	69.7 MB
15.1 Update.xlsx	18.1 MB
16. Creating new reports.mp4	45.7 MB
2. Connecting to a data source.mp4	32.6 MB
3. Please Read.html	0.2 KB
4. Preparing the query.mp4	47.5 MB
4.1 Prep.xlsx	15.5 MB
5. Cleaning the data.mp4	77.0 MB
5.1 Cleansing.xlsx	15.5 MB
6. Enhancing the query.mp4	83.1 MB
6.1 Enhance.xlsx	14.0 MB
7. What is Power Pivot.mp4	3.1 MB
8. How to enable Power Pivot.mp4	7.5 MB
9. Create a data model.mp4	50.3 MB
9.1 PrepPP.xlsx	14.6 MB
EV sales (King county).csv	28.9 MB
/.../4. SQL and MySQL Fundamentals/
1. Introduction to SQL.mp4	18.2 MB
10. Joining Multiple Tables with INNER Join.mp4	61.5 MB
11. Joining Multiple Tables with LEFT Join.mp4	30.9 MB
12. Joining Multiple Tables with RIGHT Join.mp4	21.5 MB
13. Joining Multiple Tables with SELF Join.mp4	41.5 MB
14. Removing duplicates from query results.mp4	29.1 MB
15. Group data by combing rows.mp4	20.3 MB
16. Filter grouped results.mp4	40.7 MB
17. Sort query results.mp4	44.2 MB
18. Filtering rows of data.mp4	12.8 MB
19. Introduction to aggregate functions.mp4	6.5 MB
2. Introduction to MySQL.mp4	17.2 MB
20. Using COUNT Aggregate Function.mp4	46.7 MB
21. Using SUM Aggregate Function.mp4	21.1 MB
22. Using AVG Aggregate Function.mp4	16.2 MB
23. Using MIN Aggregate Function.mp4	11.0 MB
24. Using MAX Aggregate Function.mp4	12.7 MB
25. What are Subqueries.mp4	22.1 MB
26. Using Nested Subqueries.mp4	16.0 MB
3. MySQL Installation (Windows).mp4	73.0 MB
4. MySQL Installation (Mac).mp4	43.4 MB
5. What is MySQL Workbench.mp4	35.4 MB
6. Basic database concepts.mp4	36.4 MB
7. What is a Schema.mp4	10.0 MB
8. Database Schema.mp4	22.8 MB
9. MySQL Data Types.mp4	24.8 MB
/5. Python Fundamental/
1. What is Python.mp4	17.5 MB
10. The Notebook user interface.mp4	17.2 MB
11. Creating a new notebook.mp4	21.0 MB
12. Python expressions.mp4	10.7 MB
13. Python statements.mp4	15.3 MB
14. Python Comments.mp4	13.6 MB
15. Python data types.mp4	15.7 MB
16. Casting data types.mp4	8.2 MB
17. Python Variables.mp4	25.7 MB
18. Python List.mp4	37.3 MB
19. Python Tuple.mp4	25.4 MB
2. Installing Python on Windows.mp4	23.9 MB
20. Python dictionaries.mp4	43.4 MB
21. Python Operators.mp4	57.2 MB
22. Python Conditional statements.mp4	26.0 MB
23. Python Loops.mp4	31.7 MB
24. Python Functions.mp4	23.2 MB
3. Installing Python on Macs.mp4	30.3 MB
4. What is Jupyter Notebook.mp4	4.7 MB
5. Installing Jupyter Notebook.mp4	31.7 MB
6. Running Jupyter Notebook Server.mp4	44.1 MB
7. Some Jupyter Notebook Commands.mp4	29.5 MB
8. Jupyter Notebook Components.mp4	22.5 MB
9. The Notebook Dashboard.mp4	22.8 MB
/.../6. Data Analysis and Visualization with Python and SQL/
1. Create a virtual environment on Windows.mp4	17.0 MB
10. The Sakilla Database.mp4	6.7 MB
11. Establishing a connection to the database.mp4	22.1 MB
12. Write a Python function to execute SQL queries.mp4	11.6 MB
13. Asking relevant questions about the data.html	1.1 KB
14. What are the most popular film categories rented by customers.mp4	81.5 MB
15. How does the average rental duration vary across film categories.mp4	44.7 MB
16. Which actors are featured in the most rented films.html	3.1 KB
17. Are there any seasonal trends in the rental volume.html	4.4 KB
18. What is the average rental cost by film category.html	2.9 KB
19. How does the revenue contribution from different film categories compare.html	3.2 KB
2. Create a virtual environment on Macs.mp4	23.3 MB
20. Are there any correlations between film length and rental frequency.html	2.9 KB
21. Download the Python files.html	0.0 KB
3. Activate a virtual environment on Windows.mp4	4.5 MB
4. Activate a virtual environment on Macs.mp4	12.7 MB
5. Upgrade Pip.mp4	6.7 MB
6. Install Visual Studio Code.mp4	32.8 MB
7. Required Python Packages.html	2.6 KB
8. Installing Python Packages.mp4	12.8 MB
9. Import packages into a Python file.mp4	9.5 MB
/.../6. Data Analysis and Visualization with Python and SQL/scripts/
averagerentalcostbyfilmcategory.py	0.9 KB
averagerentaldurationforfilmcategories.py	0.9 KB
comparerevenuefromdifferentfilmcategories.py	1.1 KB
correlationsbetweenfilmlengthandrentalfrequency.py	0.9 KB
mostfeaturedactorsinrentedfilm.py	1.1 KB
popularcategoryrentedbycustomers.py	1.0 KB
rentalvolumeseasonaltrends.py	0.8 KB
sakilla_utils.py	0.4 KB
/.../7. Introduction to Power BI/
1. What is Power BI.mp4	38.8 MB
2. What is Power BI Desktop.mp4	12.4 MB
3. Install Power BI Desktop.mp4	14.8 MB
4. Explore Power BI Desktop Interface.mp4	26.0 MB
5. Microsoft 365 Setup.mp4	24.4 MB
6. Getting started with Microsoft 365.mp4	23.2 MB
7. Create a new user account in Microsoft 365.mp4	11.8 MB
8. Components of Power BI.mp4	9.2 MB
9. Getting data into Power BI Desktop.mp4	28.8 MB
/.../8. Data Analysis and Visualization with Power BI/
1. Connect to data source.mp4	18.1 MB
1.1 Financial+Sample.xlsx	83.4 KB
2. Transform the data.mp4	27.9 MB
3. Model the data.mp4	18.5 MB
4. Visualize the data.mp4	61.6 MB
5. Publish report to Power BI Service.mp4	12.2 MB
6. Build a dashboard.mp4	46.0 MB
7. Collaborate and share.mp4	13.0 MB
/~Get Your Files Here !/
Bonus Resources.txt	0.4 KB
Total files 160