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

Torrent Details

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

NAME
Udemy - The Data Analyst's Toolkit - Excel, SQL, Python, Power BI.torrent
CATEGORY
Other
INFOHASH
622d3693f9e9fa7af694c9bb60c4ee303da22003
SIZE
3.6 GB in 98 files
ADDED
Uploaded on 15-05-2023 by our crawler pet called "Spidey".
SWARM
0 seeders & 0 peers
RATING
No votes yet.

Please login to vote for this torrent.


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

Discussion

Comments 0

Post Your Comment

Files in this torrent

FILENAMESIZE
~Get Your Files Here !/1. Introduction to Data Analysis/1. Introduction.mp41.5 MB
~Get Your Files Here !/1. Introduction to Data Analysis/2. Course Introduction.html1.9 KB
~Get Your Files Here !/1. Introduction to Data Analysis/3. Data Analysis Overview.mp430.7 MB
~Get Your Files Here !/1. Introduction to Data Analysis/4. Roles in Data Analysis.mp439.2 MB
~Get Your Files Here !/1. Introduction to Data Analysis/5. Tasks of a Data Analyst.mp451 MB
~Get Your Files Here !/1. Introduction to Data Analysis/6. Importance of Data-Driven Decision Making.html3.2 KB
~Get Your Files Here !/2. Excel Fundamentals/1. Introduction to Excel.mp413.4 MB
~Get Your Files Here !/2. Excel Fundamentals/10. Adding a title to worksheet.mp417.6 MB
~Get Your Files Here !/2. Excel Fundamentals/11. Saving your work.mp424.4 MB
~Get Your Files Here !/2. Excel Fundamentals/12. Introduction to Excel Functions and Formulas.mp423.9 MB
~Get Your Files Here !/2. Excel Fundamentals/13. Using formulas for arithmetic tasks.mp428.1 MB
~Get Your Files Here !/2. Excel Fundamentals/14. Re-using formulas.mp420.2 MB
~Get Your Files Here !/2. Excel Fundamentals/15. Calculating YTD Profits.mp435.2 MB
~Get Your Files Here !/2. Excel Fundamentals/16. Calculating percentage change.mp427.8 MB
~Get Your Files Here !/2. Excel Fundamentals/17. Relative and absolute reference.mp442.2 MB
~Get Your Files Here !/2. Excel Fundamentals/18. Using Rank Function.mp418.7 MB
~Get Your Files Here !/2. Excel Fundamentals/19. STD Function.mp411.1 MB
~Get Your Files Here !/2. Excel Fundamentals/2. Opening a new workbook.mp429.8 MB
~Get Your Files Here !/2. Excel Fundamentals/20. Small and Large Functions.mp417.5 MB
~Get Your Files Here !/2. Excel Fundamentals/21. Median Function.mp49.1 MB
~Get Your Files Here !/2. Excel Fundamentals/22. Count and Counta Functions.mp417.4 MB
~Get Your Files Here !/2. Excel Fundamentals/23. Exploring fonts.mp424.8 MB
~Get Your Files Here !/2. Excel Fundamentals/24. Adjusting column width and row height.mp434.5 MB
~Get Your Files Here !/2. Excel Fundamentals/25. Using alignment.mp429.5 MB
~Get Your Files Here !/2. Excel Fundamentals/26. Designing borders.mp426.3 MB
~Get Your Files Here !/2. Excel Fundamentals/27. Formatting Numbers.mp438.2 MB
~Get Your Files Here !/2. Excel Fundamentals/28. Conditional formatting.mp443.3 MB
~Get Your Files Here !/2. Excel Fundamentals/29. Creating tables.mp442.8 MB
~Get Your Files Here !/2. Excel Fundamentals/3. Entering data in Excel.mp431.7 MB
~Get Your Files Here !/2. Excel Fundamentals/30. Inserting shapes.mp437.8 MB
~Get Your Files Here !/2. Excel Fundamentals/4. Basic data entry in Excel.mp428.1 MB
~Get Your Files Here !/2. Excel Fundamentals/5. Entering data with autofil.mp427.4 MB
~Get Your Files Here !/2. Excel Fundamentals/6. Entering date.mp424.2 MB
~Get Your Files Here !/2. Excel Fundamentals/7. Entering time.mp428.6 MB
~Get Your Files Here !/2. Excel Fundamentals/8. Undo and redo changes.mp427.9 MB
~Get Your Files Here !/2. Excel Fundamentals/9. Adding comments.mp419.1 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/1. What is Power Query.mp413.6 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/10. Importing data and creating relationships.mp440.6 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/10.1 AddData.xlsx14.8 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/11. Creating lookups with DAX.mp439.9 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/11.1 Lookups.xlsx14.8 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/12. Analyze data with Pivot Tables.mp449.7 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/13. Analyze data with Pivot Charts.mp452.4 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/13.1 Charts.xlsx17.3 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/14. Refreshing source data.mp449.1 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/14.1 Refresh.xlsx17.3 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/15. Updating queries.mp466.4 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/15.1 Update.xlsx17.3 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/16. Creating new reports.mp443.6 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/2. Connecting to a data source.mp431.1 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/3. Please Read.html189 B
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/4. Preparing the query.mp445.3 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/4.1 Prep.xlsx14.8 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/5. Cleaning the data.mp473.4 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/5.1 Cleansing.xlsx14.8 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/6. Enhancing the query.mp479.2 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/6.1 Enhance.xlsx13.4 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/7. What is Power Pivot.mp42.9 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/8. How to enable Power Pivot.mp47.2 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/9. Create a data model.mp448 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/9.1 PrepPP.xlsx13.9 MB
~Get Your Files Here !/3. Data Analysis & Visualization with Excel/EV sales (King county).csv27.6 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/1. Introduction to SQL.mp417.4 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/10. Joining Multiple Tables with INNER Join.mp458.7 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/11. Joining Multiple Tables with LEFT Join.mp429.5 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/12. Joining Multiple Tables with RIGHT Join.mp420.5 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/13. Joining Multiple Tables with SELF Join.mp439.6 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/14. Removing duplicates from query results.mp427.7 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/15. Group data by combing rows.mp419.4 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/16. Filter grouped results.mp438.8 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/17. Sort query results.mp442.1 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/18. Filtering rows of data.mp412.2 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/19. Introduction to aggregate functions.mp46.2 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/2. Introduction to MySQL.mp416.4 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/20. Using COUNT Aggregate Function.mp444.6 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/21. Using SUM Aggregate Function.mp420.1 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/22. Using AVG Aggregate Function.mp415.4 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/23. Using MIN Aggregate Function.mp410.4 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/24. Using MAX Aggregate Function.mp412.1 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/25. What are Subqueries.mp421.1 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/26. Using Nested Subqueries.mp415.3 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/3. MySQL Installation (Windows).mp469.6 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/4. MySQL Installation (Mac).mp441.3 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/5. What is MySQL Workbench.mp433.8 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/6. Basic database concepts.mp434.8 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/7. What is a Schema.mp49.6 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/8. Database Schema.mp421.7 MB
~Get Your Files Here !/4. SQL and MySQL Fundamentals/9. MySQL Data Types.mp423.6 MB
~Get Your Files Here !/5. Python Fundamental/1. What is Python.mp416.7 MB
~Get Your Files Here !/5. Python Fundamental/10. The Notebook user interface.mp416.4 MB
~Get Your Files Here !/5. Python Fundamental/11. Creating a new notebook.mp420 MB
~Get Your Files Here !/5. Python Fundamental/12. Python expressions.mp410.2 MB
~Get Your Files Here !/5. Python Fundamental/13. Python statements.mp414.5 MB
~Get Your Files Here !/5. Python Fundamental/14. Python Comments.mp413 MB
~Get Your Files Here !/5. Python Fundamental/15. Python data types.mp415 MB
~Get Your Files Here !/5. Python Fundamental/16. Casting data types.mp47.8 MB
~Get Your Files Here !/5. Python Fundamental/17. Python Variables.mp424.5 MB
~Get Your Files Here !/5. Python Fundamental/18. Python List.mp435.6 MB

Alternative Torrents for 'Udemy Data Analyst&;s Toolkit Excel SQL Python Power BI'.

There are no alternative torrents found.