[ FreeCourseWeb.com ] Udemy - The Data Analyst's Toolkit - Excel, SQL, Python, Power BI

File Name

Size

Get Bonus Downloads Here.url

183 B

~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

31 MB

~Get Your Files Here !/1. Introduction to Data Analysis/4. Roles in Data Analysis.mp4

39 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 MB

~Get Your Files Here !/2. Excel Fundamentals/10. Adding a title to worksheet.mp4

18 MB

~Get Your Files Here !/2. Excel Fundamentals/11. Saving your work.mp4

24 MB

~Get Your Files Here !/2. Excel Fundamentals/12. Introduction to Excel Functions and Formulas.mp4

24 MB

~Get Your Files Here !/2. Excel Fundamentals/13. Using formulas for arithmetic tasks.mp4

28 MB

~Get Your Files Here !/2. Excel Fundamentals/14. Re-using formulas.mp4

20 MB

~Get Your Files Here !/2. Excel Fundamentals/15. Calculating YTD Profits.mp4

35 MB

~Get Your Files Here !/2. Excel Fundamentals/16. Calculating percentage change.mp4

28 MB

~Get Your Files Here !/2. Excel Fundamentals/17. Relative and absolute reference.mp4

42 MB

~Get Your Files Here !/2. Excel Fundamentals/18. Using Rank Function.mp4

19 MB

~Get Your Files Here !/2. Excel Fundamentals/19. STD Function.mp4

11 MB

~Get Your Files Here !/2. Excel Fundamentals/2. Opening a new workbook.mp4

30 MB

~Get Your Files Here !/2. Excel Fundamentals/20. Small and Large Functions.mp4

18 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 MB

~Get Your Files Here !/2. Excel Fundamentals/23. Exploring fonts.mp4

25 MB

~Get Your Files Here !/2. Excel Fundamentals/24. Adjusting column width and row height.mp4

34 MB

~Get Your Files Here !/2. Excel Fundamentals/25. Using alignment.mp4

30 MB

~Get Your Files Here !/2. Excel Fundamentals/26. Designing borders.mp4

26 MB

~Get Your Files Here !/2. Excel Fundamentals/27. Formatting Numbers.mp4

38 MB

~Get Your Files Here !/2. Excel Fundamentals/28. Conditional formatting.mp4

43 MB

~Get Your Files Here !/2. Excel Fundamentals/29. Creating tables.mp4

43 MB

~Get Your Files Here !/2. Excel Fundamentals/3. Entering data in Excel.mp4

32 MB

~Get Your Files Here !/2. Excel Fundamentals/30. Inserting shapes.mp4

38 MB

~Get Your Files Here !/2. Excel Fundamentals/4. Basic data entry in Excel.mp4

28 MB

~Get Your Files Here !/2. Excel Fundamentals/5. Entering data with autofil.mp4

27 MB

~Get Your Files Here !/2. Excel Fundamentals/6. Entering date.mp4

24 MB

~Get Your Files Here !/2. Excel Fundamentals/7. Entering time.mp4

29 MB

~Get Your Files Here !/2. Excel Fundamentals/8. Undo and redo changes.mp4

28 MB

~Get Your Files Here !/2. Excel Fundamentals/9. Adding comments.mp4

19 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/1. What is Power Query.mp4

14 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/10. Importing data and creating relationships.mp4

41 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/10.1 AddData.xlsx

15 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/11. Creating lookups with DAX.mp4

40 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/11.1 Lookups.xlsx

15 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/12. Analyze data with Pivot Tables.mp4

50 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/13. Analyze data with Pivot Charts.mp4

52 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/13.1 Charts.xlsx

17 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/14. Refreshing source data.mp4

49 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/14.1 Refresh.xlsx

17 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/15. Updating queries.mp4

66 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/15.1 Update.xlsx

17 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/16. Creating new reports.mp4

44 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/2. Connecting to a data source.mp4

31 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 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/4.1 Prep.xlsx

15 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/5. Cleaning the data.mp4

73 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/5.1 Cleansing.xlsx

15 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/6. Enhancing the query.mp4

79 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/6.1 Enhance.xlsx

13 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

14 MB

~Get Your Files Here !/3. Data Analysis & Visualization with Excel/EV sales (King county).csv

28 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/1. Introduction to SQL.mp4

17 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/10. Joining Multiple Tables with INNER Join.mp4

59 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/11. Joining Multiple Tables with LEFT Join.mp4

30 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/12. Joining Multiple Tables with RIGHT Join.mp4

20 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/13. Joining Multiple Tables with SELF Join.mp4

40 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/14. Removing duplicates from query results.mp4

28 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/15. Group data by combing rows.mp4

19 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/16. Filter grouped results.mp4

39 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/17. Sort query results.mp4

42 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/18. Filtering rows of data.mp4

12 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 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/20. Using COUNT Aggregate Function.mp4

45 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/21. Using SUM Aggregate Function.mp4

20 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/22. Using AVG Aggregate Function.mp4

15 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/23. Using MIN Aggregate Function.mp4

10 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/24. Using MAX Aggregate Function.mp4

12 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/25. What are Subqueries.mp4

21 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/26. Using Nested Subqueries.mp4

15 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/3. MySQL Installation (Windows).mp4

70 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/4. MySQL Installation (Mac).mp4

41 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/5. What is MySQL Workbench.mp4

34 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/6. Basic database concepts.mp4

35 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

22 MB

~Get Your Files Here !/4. SQL and MySQL Fundamentals/9. MySQL Data Types.mp4

24 MB

~Get Your Files Here !/5. Python Fundamental/1. What is Python.mp4

17 MB

~Get Your Files Here !/5. Python Fundamental/10. The Notebook user interface.mp4

16 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 MB

~Get Your Files Here !/5. Python Fundamental/13. Python statements.mp4

14 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 MB

~Get Your Files Here !/5. Python Fundamental/18. Python List.mp4

36 MB

~Get Your Files Here !/5. Python Fundamental/19. Python Tuple.mp4

24 MB

~Get Your Files Here !/5. Python Fundamental/2. Installing Python on Windows.mp4

23 MB

~Get Your Files Here !/5. Python Fundamental/20. Python dictionaries.mp4

41 MB

~Get Your Files Here !/5. Python Fundamental/21. Python Operators.mp4

55 MB

~Get Your Files Here !/5. Python Fundamental/22. Python Conditional statements.mp4

25 MB

~Get Your Files Here !/5. Python Fundamental/23. Python Loops.mp4

30 MB

~Get Your Files Here !/5. Python Fundamental/24. Python Functions.mp4

22 MB

~Get Your Files Here !/5. Python Fundamental/3. Installing Python on Macs.mp4

29 MB

~Get Your Files Here !/5. Python Fundamental/4. What is Jupyter Notebook.mp4

4.5 MB

~Get Your Files Here !/5. Python Fundamental/5. Installing Jupyter Notebook.mp4

30 MB

~Get Your Files Here !/5. Python Fundamental/6. Running Jupyter Notebook Server.mp4

42 MB

~Get Your Files Here !/5. Python Fundamental/7. Some Jupyter Notebook Commands.mp4

28 MB

~Get Your Files Here !/5. Python Fundamental/8. Jupyter Notebook Components.mp4

21 MB

~Get Your Files Here !/5. Python Fundamental/9. The Notebook Dashboard.mp4

22 MB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/1. Create a virtual environment on Windows.mp4

16 MB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/10. The Sakilla Database.mp4

6.4 MB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/11. Establishing a connection to the database.mp4

21 MB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/12. Write a Python function to execute SQL queries.mp4

11 MB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/13. Asking relevant questions about the data.html

1.1 kB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/14. What are the most popular film categories rented by customers.mp4

78 MB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/15. How does the average rental duration vary across film categories.mp4

43 MB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/16. Which actors are featured in the most rented films.html

3.0 kB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/17. Are there any seasonal trends in the rental volume.html

4.3 kB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/18. What is the average rental cost by film category.html

2.8 kB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/19. How does the revenue contribution from different film categories compare.html

3.1 kB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/2. Create a virtual environment on Macs.mp4

22 MB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/20. Are there any correlations between film length and rental frequency.html

2.8 kB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/21. Download the Python files.html

45 B

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/3. Activate a virtual environment on Windows.mp4

4.3 MB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/4. Activate a virtual environment on Macs.mp4

12 MB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/5. Upgrade Pip.mp4

6.4 MB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/6. Install Visual Studio Code.mp4

31 MB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/7. Required Python Packages.html

2.6 kB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/8. Installing Python Packages.mp4

12 MB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/9. Import packages into a Python file.mp4

9.1 MB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/scripts/averagerentalcostbyfilmcategory.py

940 B

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/scripts/averagerentaldurationforfilmcategories.py

881 B

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/scripts/comparerevenuefromdifferentfilmcategories.py

1.0 kB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/scripts/correlationsbetweenfilmlengthandrentalfrequency.py

873 B

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/scripts/mostfeaturedactorsinrentedfilm.py

1.1 kB

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/scripts/popularcategoryrentedbycustomers.py

953 B

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/scripts/rentalvolumeseasonaltrends.py

801 B

~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/scripts/sakilla_utils.py

358 B

~Get Your Files Here !/7. Introduction to Power BI/1. What is Power BI.mp4

37 MB

~Get Your Files Here !/7. Introduction to Power BI/2. What is Power BI Desktop.mp4

12 MB

~Get Your Files Here !/7. Introduction to Power BI/3. Install Power BI Desktop.mp4

14 MB

~Get Your Files Here !/7. Introduction to Power BI/4. Explore Power BI Desktop Interface.mp4

25 MB

~Get Your Files Here !/7. Introduction to Power BI/5. Microsoft 365 Setup.mp4

23 MB

~Get Your Files Here !/7. Introduction to Power BI/6. Getting started with Microsoft 365.mp4

22 MB

~Get Your Files Here !/7. Introduction to Power BI/7. Create a new user account in Microsoft 365.mp4

11 MB

~Get Your Files Here !/7. Introduction to Power BI/8. Components of Power BI.mp4

8.7 MB

~Get Your Files Here !/7. Introduction to Power BI/9. Getting data into Power BI Desktop.mp4

28 MB

~Get Your Files Here !/8. Data Analysis and Visualization with Power BI/1. Connect to data source.mp4

17 MB

~Get Your Files Here !/8. Data Analysis and Visualization with Power BI/1.1 Financial+Sample.xlsx

82 kB

~Get Your Files Here !/8. Data Analysis and Visualization with Power BI/2. Transform the data.mp4

27 MB

~Get Your Files Here !/8. Data Analysis and Visualization with Power BI/3. Model the data.mp4

18 MB

~Get Your Files Here !/8. Data Analysis and Visualization with Power BI/4. Visualize the data.mp4

59 MB

~Get Your Files Here !/8. Data Analysis and Visualization with Power BI/5. Publish report to Power BI Service.mp4

12 MB

~Get Your Files Here !/8. Data Analysis and Visualization with Power BI/6. Build a dashboard.mp4

44 MB

~Get Your Files Here !/8. Data Analysis and Visualization with Power BI/7. Collaborate and share.mp4

12 MB

~Get Your Files Here !/Bonus Resources.txt

386 B