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

seeders: 1
leechers: 41
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...

Files

[ FreeCourseWeb.com ] Udemy - The Data Analyst's Toolkit - Excel, SQL, Python, Power BI
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1. Introduction to Data Analysis
    • 1. Introduction.mp4 (1.5 MB)
    • 2. Course Introduction.html (1.9 KB)
    • 3. Data Analysis Overview.mp4 (30.7 MB)
    • 4. Roles in Data Analysis.mp4 (39.2 MB)
    • 5. Tasks of a Data Analyst.mp4 (51.0 MB)
    • 6. Importance of Data-Driven Decision Making.html (3.2 KB)
    2. Excel Fundamentals
    • 1. Introduction to Excel.mp4 (13.4 MB)
    • 10. Adding a title to worksheet.mp4 (17.6 MB)
    • 11. Saving your work.mp4 (24.4 MB)
    • 12. Introduction to Excel Functions and Formulas.mp4 (23.9 MB)
    • 13. Using formulas for arithmetic tasks.mp4 (28.1 MB)
    • 14. Re-using formulas.mp4 (20.2 MB)
    • 15. Calculating YTD Profits.mp4 (35.2 MB)
    • 16. Calculating percentage change.mp4 (27.8 MB)
    • 17. Relative and absolute reference.mp4 (42.2 MB)
    • 18. Using Rank Function.mp4 (18.7 MB)
    • 19. STD Function.mp4 (11.1 MB)
    • 2. Opening a new workbook.mp4 (29.8 MB)
    • 20. Small and Large Functions.mp4 (17.5 MB)
    • 21. Median Function.mp4 (9.1 MB)
    • 22. Count and Counta Functions.mp4 (17.4 MB)
    • 23. Exploring fonts.mp4 (24.8 MB)
    • 24. Adjusting column width and row height.mp4 (34.5 MB)
    • 25. Using alignment.mp4 (29.5 MB)
    • 26. Designing borders.mp4 (26.3 MB)
    • 27. Formatting Numbers.mp4 (38.2 MB)
    • 28. Conditional formatting.mp4 (43.3 MB)
    • 29. Creating tables.mp4 (42.8 MB)
    • 3. Entering data in Excel.mp4 (31.7 MB)
    • 30. Inserting shapes.mp4 (37.8 MB)
    • 4. Basic data entry in Excel.mp4 (28.1 MB)
    • 5. Entering data with autofil.mp4 (27.4 MB)
    • 6. Entering date.mp4 (24.2 MB)
    • 7. Entering time.mp4 (28.6 MB)
    • 8. Undo and redo changes.mp4 (27.9 MB)
    • 9. Adding comments.mp4 (19.1 MB)
    3. Data Analysis & Visualization with Excel
    • 1. What is Power Query.mp4 (13.6 MB)
    • 10. Importing data and creating relationships.mp4 (40.6 MB)
    • 10.1 AddData.xlsx (14.8 MB)
    • 11. Creating lookups with DAX.mp4 (39.9 MB)
    • 11.1 Lookups.xlsx (14.8 MB)
    • 12. Analyze data with Pivot Tables.mp4 (49.7 MB)
    • 13. Analyze data with Pivot Charts.mp4 (52.4 MB)
    • 13.1 Charts.xlsx (17.3 MB)
    • 14. Refreshing source data.mp4 (49.1 MB)
    • 14.1 Refresh.xlsx (17.3 MB)
    • 15. Updating queries.mp4 (66.4 MB)
    • 15.1 Update.xlsx (17.3 MB)
    • 16. Creating new reports.mp4 (43.6 MB)
    • 2. Connecting to a data source.mp4 (31.1 MB)
    • 3. Please Read.html (0.2 KB)
    • 4. Preparing the query.mp4 (45.3 MB)
    • 4.1 Prep.xlsx (14.8 MB)
    • 5. Cleaning the data.mp4 (73.4 MB)
    • 5.1 Cleansing.xlsx (14.8 MB)
    • 6. Enhancing the query.mp4 (79.2 MB)
    • 6.1 Enhance.xlsx (13.4 MB)
    • 7. What is Power Pivot.mp4 (2.9 MB)
    • 8. How to enable Power Pivot.mp4 (7.2 MB)
    • 9. Create a data model.mp4 (48.0 MB)
    • 9.1 PrepPP.xlsx (13.9 MB)
    • EV sales (King county).csv (27.6 MB)
    4. SQL and MySQL Fundamentals
    • 1. Introduction to SQL.mp4 (17.4 MB)
    • 10. Joining Multiple Tables with INNER Join.mp4 (58.7 MB)
    • 11. Joining Multiple Tables with LEFT Join.mp4 (29.5 MB)
    • 12. Joining Multiple Tables with RIGHT Join.mp4 (20.5 MB)
    • 13. Joining Multiple Tables with SELF Join.mp4 (39.6 MB)
    • 14. Removing duplicates from query results.mp4 (27.7 MB)
    • 15. Group data by combing rows.mp4 (19.4 MB)
    • 16. Filter grouped results.mp4 (38.8 MB)
    • 17. Sort query results.mp4 (42.1 MB)
    • 18. Filtering rows of data.mp4 (12.2 MB)
    • 19. Introduction to aggregate functions.mp4 (6.2 MB)
    • 2. Introduction to MySQL.mp4 (16.4 MB)
    • 20. Using COUNT Aggregate Function.mp4 (44.6 MB)
    • 21. Using SUM Aggregate Function.mp4 (20.1 MB)
    • 22. Using AVG Aggregate Function.mp4 (15.4 MB)
    • 23. Using MIN Aggregate Function.mp4 (10.4 MB)
    • 24. Using MAX Aggregate Function.mp4 (12.1 MB)
    • 25. What are Subqueries.mp4 (21.1 MB)
    • 26. Using Nested Subqueries.mp4 (15.3 MB)
    • 3. MySQL Installation (Windows).mp4 (69.6 MB)
    • 4. MySQL Installation (Mac).mp4 (41.3 MB)
    • 5. What is MySQL Workbench.mp4 (33.8 MB)
    • 6. Basic database concepts.mp4 (34.8 MB)
    • 7. What is a Schema.mp4 (9.6 MB)
    • 8. Database Schema.mp4 (21.7 MB)
    • 9. MySQL Data Types.mp4 (23.6 MB)
    5. Python Fundamental
    • 1. What is Python.mp4 (16.7 MB)
    • 10. The Notebook user interface.mp4 (16.4 MB)
    • 11. Creating a new notebook.mp4 (20.0 MB)
    • 12. Python expressions.mp4 (10.2 MB)
    • 13. Python statements.mp4 (14.5 MB)
    • 14. Python Comments.mp4 (13.0 MB)
    • 15. Python data types.mp4 (15.0 MB)
    • 16. Casting data types.mp4 (7.8 MB)
    • 17. Python Variables.mp4 (24.5 MB)
    • 18. Python List.mp4 (35.6 MB)
    • 19. Python Tuple.mp4 (24.2 MB)
    • 2. Installing Python on Windows.mp4 (22.8 MB)
    • 20. Python dictionaries.mp4 (41.4 MB)
    • 21. Python Operators.mp4 (54.6 MB)
    • 22. Python Conditional statements.mp4 (24.8 MB)
    • 23. Python Loops.mp4 (30.3 MB)
    • 24. Python Functions.mp4 (22.1 MB)
    • 3. Installing Python on Macs.mp4 (28.9 MB)
    • 4. What is Jupyter Notebook.mp4 (4.5 MB)
    • 5. Installing Jupyter Notebook.mp4 (30.3 MB)
    • 6. Running Jupyter Notebook Server.mp4 (42.0 MB)
    • 7. Some Jupyter Notebook Commands.mp4 (28.1 MB)
    • 8. Jupyter Notebook Components.mp4 (21.4 MB)
    • 9. The Notebook Dashboard.mp4 (21.7 MB)
    6. Data Analysis and Visualization with Python and SQL

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.



Download torrent
3.6 GB
seeders:1
leechers:41
Udemy - The Data Analyst's Toolkit - Excel, SQL, Python, Power BI

Trackers

tracker name
udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce
µTorrent compatible trackers list

Download torrent
3.6 GB
seeders:1
leechers:41
Udemy - The Data Analyst's Toolkit - Excel, SQL, Python, Power BI

Torrent hash: 622D3693F9E9FA7AF694C9BB60C4EE303DA22003