Don't like banners? Log in and we will make sure you see no banners. For free.
No cover art

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

Other
Size
3.6 GB
Seeders
9
Leechers
0
Files
98
Category
Other
Added
at 10:48pm GMT+1
Infohash
622d3693f9e9fa7af694c9bb60c4ee303da22003
Direct linkTorrent fileDownload now
Don't like banners? Log in and we will make sure you see no banners. For free.

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



If You Need More Stuff, kindly Visit and Support Us -->> 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.



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...



Image error



Image error

File list
  • Udemy - The Data Analyst's Toolkit - Excel, SQL, Python, Power BI
  • ~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 35.6 MB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
2.5 GB109
10.4 GB91
2.9 GB11
2.4 GB01
3.1 GB04
1.4 GB01
3.3 GB00