|  

Udemy - The Data Analyst's Toolkit - Excel, SQL, Python, Power BI
Size :3.6 GB
Peers : Seeders : 0      Leechers : 0
Added : 1 year ago » by freecoursewb » in Other
Language : English
Last Updated :7 months ago
Info_Hash :622D3693F9E9FA7AF694C9BB60C4EE303DA22003

Torrent File Contents

Udemy - The Data Analyst's Toolkit - Excel, SQL, Python, Power BI
  Get Bonus Downloads Here.url
  -  183 Bytes

  ~Get Your Files Here !/1. Introduction to Data Analysis/1. Introduction.mp4
  -  1.48 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.66 MB

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

  ~Get Your Files Here !/1. Introduction to Data Analysis/5. Tasks of a Data Analyst.mp4
  -  50.96 MB

  ~Get Your Files Here !/1. Introduction to Data Analysis/6. Importance of Data-Driven Decision Making.html
  -  3.24 KB

  ~Get Your Files Here !/2. Excel Fundamentals/1. Introduction to Excel.mp4
  -  13.39 MB

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

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

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

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

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

  ~Get Your Files Here !/2. Excel Fundamentals/15. Calculating YTD Profits.mp4
  -  35.18 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.24 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.77 MB

  ~Get Your Files Here !/2. Excel Fundamentals/20. Small and Large Functions.mp4
  -  17.54 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.36 MB

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

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

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

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

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

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

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

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

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

  ~Get Your Files Here !/2. Excel Fundamentals/4. Basic data entry in Excel.mp4
  -  28.13 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.18 MB

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

  ~Get Your Files Here !/2. Excel Fundamentals/8. Undo and redo changes.mp4
  -  27.88 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.62 MB

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

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

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

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

  ~Get Your Files Here !/3. Data Analysis & Visualization with Excel/12. Analyze data with Pivot Tables.mp4
  -  49.68 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.28 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.28 MB

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

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

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

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

  ~Get Your Files Here !/3. Data Analysis & Visualization with Excel/3. Please Read.html
  -  189 Bytes

  ~Get Your Files Here !/3. Data Analysis & Visualization with Excel/4. Preparing the query.mp4
  -  45.33 MB

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

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

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

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

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

  ~Get Your Files Here !/3. Data Analysis & Visualization with Excel/7. What is Power Pivot.mp4
  -  2.91 MB

  ~Get Your Files Here !/3. Data Analysis & Visualization with Excel/8. How to enable Power Pivot.mp4
  -  7.19 MB

  ~Get Your Files Here !/3. Data Analysis & Visualization with Excel/9. Create a data model.mp4
  -  47.98 MB

  ~Get Your Files Here !/3. Data Analysis & Visualization with Excel/9.1 PrepPP.xlsx
  -  13.95 MB

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

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

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

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

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

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

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

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

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

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

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

  ~Get Your Files Here !/4. SQL and MySQL Fundamentals/19. Introduction to aggregate functions.mp4
  -  6.21 MB

  ~Get Your Files Here !/4. SQL and MySQL Fundamentals/2. Introduction to MySQL.mp4
  -  16.44 MB

  ~Get Your Files Here !/4. SQL and MySQL Fundamentals/20. Using COUNT Aggregate Function.mp4
  -  44.58 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.41 MB

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

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

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

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

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

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

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

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

  ~Get Your Files Here !/4. SQL and MySQL Fundamentals/7. What is a Schema.mp4
  -  9.56 MB

  ~Get Your Files Here !/4. SQL and MySQL Fundamentals/8. Database Schema.mp4
  -  21.72 MB

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

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

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

  ~Get Your Files Here !/5. Python Fundamental/11. Creating a new notebook.mp4
  -  20.02 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.55 MB

  ~Get Your Files Here !/5. Python Fundamental/14. Python Comments.mp4
  -  12.96 MB

  ~Get Your Files Here !/5. Python Fundamental/15. Python data types.mp4
  -  14.95 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.51 MB

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  ~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/11. Establishing a connection to the database.mp4
  -  21.1 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.04 MB

  ~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/13. Asking relevant questions about the data.html
  -  1.08 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
  -  77.69 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
  -  42.62 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 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.26 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.11 KB

  ~Get Your Files Here !/6. Data Analysis and Visualization with Python and SQL/2. Create a virtual environment on Macs.mp4
  -  22.27 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.83 KB

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

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

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

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

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

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

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

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

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

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

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

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

  ~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 Bytes

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  ~Get Your Files Here !/Bonus Resources.txt
  -  386 Bytes



Torrent Description

The Data Analyst's Toolkit: Excel, SQL, Python, Power BI



https://FreeCourseWeb.com

Published 5/2023
Created by Digital Learning Academy
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 139 Lectures ( 12h 9m ) | Size: 3.53 GB

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.