Data Analysts Toolbox: Excel, SQL, Python, Power BI, Tableau

Focused View

Bluelime Learning Solutions

10:22:32

13 View

1. Introduction to Data Analysis

1. Introduction.mp4

00:20

2. Understanding the role of a data analyst.html

3. Overview of data analysis tools and their importance.html

4. Introduction to key concepts in data analysis.html

2. Excel for Data Analysis

1. Introduction to Excel for Data Analysis.html

2. Basic to advanced Excel functions and formulas.html

3. Hands-on Practice of Functions and Formulas.mp4

05:21

4. Using Formulas for Arithmetic Tasks.mp4

05:55

5. Re-using Formulas.mp4

04:15

6. Calculating YTD Profits.mp4

06:49

7. Calculating Percentage Change.mp4

06:42

8. Relative and Absolute Reference.mp4

09:39

9. Using RANK Function.mp4

03:59

10. STD Function.mp4

02:29

11. Small and Large Functions.mp4

03:44

12. Median Functions.mp4

01:58

13. COUNT and COUNTA Functions.mp4

03:43

14. What is Power Query.mp4

03:30

15.1 EV sales (King county).zip

15. Connecting to a data source.mp4

04:26

16. Please Read.html

17.1 Prep.xlsx

17. Preparing your query.mp4

04:51

18.1 Cleansing.xlsx

18. Cleansing data.mp4

07:37

19.1 Enhance.xlsx

19. Enhancing query.mp4

09:21

20. What is Power Pivot.mp4

01:02

21.1 PrepPP.xlsx

21. Creating a data model.mp4

06:02

22.1 AddData.xlsx

22. Importing data and creating relationships.mp4

06:56

23.1 Lookups.xlsx

23. Create lookups with DAX.mp4

07:01

24.1 Pivot.xlsx

24. Analyze data with Pivot Tables.mp4

08:42

25.1 Charts.xlsx

25. Analyze data with Pivot Charts.mp4

08:14

3. SQL Fundamentals

1. Introduction to SQL and its applications in data analysis.html

2. What is MySQL.html

3. MySQL Installation (Windows).mp4

14:55

4. MySQL Installation (Mac).mp4

06:58

5. What is MySQL Workbench.mp4

06:04

6. Installing MySQL Workbench ( Mac).mp4

05:36

7. Database Concepts.mp4

09:00

8. What is a Schema.mp4

02:50

9. What is a Database Schema.mp4

04:50

10. MySQL Data Types.mp4

06:56

11. Exploring Basic SQL Commands.mp4

02:40

12. Showing existing databases.mp4

02:57

13. Showing lists of tables.mp4

02:40

14. Create a table.mp4

06:59

15. Displaying table structure.mp4

04:24

16. Changing table structure.mp4

05:04

17. Creating MySQL Database.mp4

06:31

18.1 table+create+script.zip

18. Creating MySQL Table.mp4

12:43

19. Setting a default database.mp4

05:03

20. Primary Keys.mp4

04:09

21. Foreign Keys.mp4

06:00

22. SQL & MySQL SELECT Statement.mp4

08:22

23.1 insert+data+into+tables.zip

23. SQL & MySQL INSERT Statement.mp4

08:48

24. SQL & MySQL UPDATE Statement.mp4

10:51

25. SQL & MySQL DELETE Statement.mp4

05:06

26. Introduction to Joins.html

27. INNER JOIN.mp4

11:57

28. LEFT JOIN.mp4

06:05

29. RIGHT JOIN.mp4

04:13

30. SELF JOIN.mp4

08:07

31. What is sub query.mp4

04:37

32. Nested sub query.mp4

03:22

33. Filtering data with WHERE Clause.mp4

02:37

34. Sorting data with ORDER BY Clause.mp4

06:10

35. Grouping data with GROUP BY Clause.mp4

03:56

36. What are aggregate functions.mp4

02:05

37. AVG Aggregate Function.mp4

03:29

38. COUNT Aggregate Function.mp4

08:49

39. SUM Aggregate Function.mp4

04:22

40. MIN Aggregate Function.mp4

02:25

41. MAX Aggregate Function.mp4

02:48

4. Data Analysis with Python and Jupyter Notebook

1. What is Python.html

2. Using Python in Data Analysis.html

3. What is Jupyter Notebook.html

4. Installing Jupyter Notebook Server.mp4

06:45

5. Running Jupyter Notebook Server.mp4

08:44

6. Jupyter Notebook Components.mp4

04:26

7. Jupyter Notebook Dashboard.mp4

04:20

8. Jupyter Notebook User Interface.mp4

05:44

9. Creating a new notebook.mp4

06:45

10. Kaggle Data Sets.mp4

03:06

11.1 us_baby_names.zip

11. Tabular Data.mp4

08:00

12. what is Pandas DataFrame.html

13. Exploring Pandas DataFrame.mp4

02:20

14. Manipulating a Pandas DataFrame.mp4

12:57

15. What is data cleaning.mp4

03:28

16.1 crime_boston.zip

16. Basic data cleaning process.mp4

22:42

17.1 listings.zip

17. What is data visualization.mp4

02:35

18. Visualizing Qualitative Data.mp4

12:00

19. Visualizing Quantitative Data.mp4

13:49

5. Data Analysis with Power BI

1. What is Power BI.html

2. What is Power BI Desktop.mp4

03:40

3. Installing Power BI Desktop.mp4

02:55

4. Exploring Power BI Desktop.mp4

05:02

5.1 Financial+Sample.xlsx

5. Power BI Overview Part 1.mp4

04:24

6. Power BI Overview Part 2.mp4

04:05

7. Power BI Overview Part 3.mp4

04:49

8. Components of Power BI.mp4

02:57

9. Building Blocks of Power BI.mp4

09:31

10. Explore Power BI Service.mp4

04:28

11. Connect to web data.mp4

05:07

12. Clean and transform data Part 1.mp4

07:12

13. Clean and transform data Part 2.mp4

09:45

14. Combining Data Sources.mp4

07:59

15. Visualizing Data Part 1.mp4

06:09

16. Visualizing Data Part 2.mp4

05:23

17. Publishing Reports to Power BI Service.mp4

04:47

6. Data Analysis with Tableau

1. What is Tableau.html

2. Using Tableau for Data Analysis.html

3. Tableau Public Desktop.mp4

01:17

4.1 World_Bank_CO2.xlsx

4. Tableau Public Desktop Overview Part 1.mp4

06:36

5. Tableau Public Desktop Overview Part 2.mp4

08:49

6. Tableau Online.mp4

02:38

7. Tableau Data Sources.mp4

02:19

8.1 SampleData.xlsx

8. Connecting to data source.mp4

03:25

9.1 JoinExamples.xlsx

9. Join related data sources.mp4

09:03

10.1 DifferentNames.xlsx

10. Join data sources with inconsistent fields.mp4

06:27

11.1 CleanData.xlsx

11. Data cleaning.mp4

06:27

12. Tableau Interface.mp4

04:46

13. Reordering Visualization.mp4

04:14

14. Change summary.mp4

02:54

15.1 split.zip

15. Split text into multiple columns.mp4

04:21

16.1 storylines.zip

16. Presenting data using stories.mp4

06:18

Description

Gain Real World Skills By Mastering Excel, SQL, Python, Power BI, and Tableau for Data Analysts

What You'll Learn?

Develop a foundational understanding of data analysis principles and techniques.
Master Excel functions and formulas for data manipulation, analysis, and visualization.
Learn SQL for data querying, manipulation, and retrieval from relational databases.
Acquire programming skills in Python for data handling, manipulation, and analysis.
Create compelling data visualizations and dashboards using Power BI and Tableau.
Apply learned skills to real-world data sets and scenarios.

Who is this for?

Aspiring Data Analysts: Individuals keen on pursuing a career in data analysis or transitioning into the field will find immense value in this course. It serves as a comprehensive introduction to the essential tools and techniques used in the data analytics domain.

Professionals Seeking to Upskill: Professionals working in diverse fields such as business, finance, marketing, healthcare, or any industry reliant on data-driven decision-making will benefit from enhancing their data analysis skills. Whether you're a business analyst, financial analyst, marketing professional, or from another field, this course equips you with the tools to extract meaningful insights from data.

Students and Graduates: Students pursuing degrees in fields related to data science, computer science, business analytics, or any discipline with an interest in data will discover a solid foundation in data analysis methodologies and tools, setting them on the path to excel in their academic pursuits and future careers.

Entrepreneurs and Small Business Owners: Entrepreneurs and small business owners seeking to harness the power of data to drive business growth and make informed decisions will find this course invaluable. Understanding how to analyze and visualize data can aid in optimizing strategies, identifying trends, and making data-driven decisions crucial for success.

Anyone Curious About Data Analysis: Individuals with a general interest in data analysis, regardless of their professional background, will benefit from acquiring practical skills in Excel, SQL, Python, Power BI, and Tableau. Whether you're a hobbyist, a curious mind, or someone looking to explore new horizons, this course provides a comprehensive understanding of data analysis tools.

This course caters to a diverse audience by delivering a structured learning experience that accommodates various skill levels and backgrounds. It's designed to empower learners with the essential skills required to navigate the intricate landscape of data analysis confidently, fostering a community of individuals passionate about deriving insights from data.

What You Need to Know?

Basic Computer Skills: Familiarity with navigating computer systems, using software applications, and basic file management is recommended.

Fundamental Math Skills: A foundational understanding of basic mathematical concepts like arithmetic, algebra, and statistics will be beneficial for comprehending data analysis principles.

No Prior Programming Knowledge Required: While prior programming experience is not mandatory, a willingness to learn and engage with programming concepts is essential for the Python section of the course.

Access to a Computer: Learners should have access to a computer or laptop with internet connectivity to participate in the course modules and complete exercises.

Software and Tools: Access to software such as Microsoft Excel, SQL client (e.g., MySQL Workbench), Python (Anaconda distribution recommended), Power BI Desktop, and Tableau Public (free version) will be necessary for hands-on practice during the course. Free trials or open-source alternatives are available for some tools.

For Beginners: No prior experience or specific skills are mandatory to embark on this course.

More details

Description
The Data Analyst's Toolbox course is designed to equip learners with essential skills in Excel, SQL, Python, Power BI, and Tableau, enabling them to efficiently collect, analyze, visualize, and present data. Through hands-on exercises, real-world applications, and practical examples, participants will gain proficiency in utilizing these tools to extract insights from data, make informed decisions, and communicate findings effectively.
Embark on an exhilarating journey into the world of data-driven insights with our comprehensive course, the "Data Analyst's Toolbox: Excel, SQL, Python, Power BI, Tableau." Dive headfirst into a dynamic learning experience tailored for aspiring data analysts, professionals seeking to upskill, or anyone intrigued by the power of data.
In this transformative course, you'll unearth the fundamental pillars of data analysis through an immersive blend of theory and hands-on application. Beginning with the bedrock of Excel, you'll harness its prowess, unraveling its complex functions and formulas to wield data manipulation and visualization like a seasoned pro. Seamlessly transition into the realm of SQL, where you'll unravel the enigmatic databases, querying and manipulating data with finesse.
But that's just the beginning. Brace yourself for an odyssey through Python, the programming language du jour in the data analytics sphere. From data wrangling with Pandas to crafting captivating visualizations using Matplotlib, you'll discover Python's unparalleled versatility in unlocking data's hidden tales.
Yet, the adventure doesn't halt there. Traverse through the landscape of Power BI and Tableau, where you'll sculpt interactive dashboards and reports that breathe life into raw data. Witness how these tools metamorphose complex data sets into compelling visual narratives, empowering you to extract actionable insights effortlessly.
This course transcends the confines of theory, intertwining real-world applications and case studies that beckon you to apply newfound skills to tangible scenarios. Engage in a transformative capstone project, amalgamating all your knowledge and skills into a masterpiece that showcases your prowess in the data realm.
Join us on this transformative expedition, guided by seasoned industry experts committed to nurturing your analytical acumen. Whether you're stepping into the data universe for the first time or seeking to fortify your skill set, this course promises an immersive, exhilarating voyage that unlocks the gates to a world brimming with data-driven possibilities. Unleash your potential as a data maestro and chart your course toward becoming a proficient, sought-after data analyst.

Who this course is for:
Aspiring Data Analysts: Individuals keen on pursuing a career in data analysis or transitioning into the field will find immense value in this course. It serves as a comprehensive introduction to the essential tools and techniques used in the data analytics domain.
Professionals Seeking to Upskill: Professionals working in diverse fields such as business, finance, marketing, healthcare, or any industry reliant on data-driven decision-making will benefit from enhancing their data analysis skills. Whether you're a business analyst, financial analyst, marketing professional, or from another field, this course equips you with the tools to extract meaningful insights from data.
Students and Graduates: Students pursuing degrees in fields related to data science, computer science, business analytics, or any discipline with an interest in data will discover a solid foundation in data analysis methodologies and tools, setting them on the path to excel in their academic pursuits and future careers.
Entrepreneurs and Small Business Owners: Entrepreneurs and small business owners seeking to harness the power of data to drive business growth and make informed decisions will find this course invaluable. Understanding how to analyze and visualize data can aid in optimizing strategies, identifying trends, and making data-driven decisions crucial for success.
Anyone Curious About Data Analysis: Individuals with a general interest in data analysis, regardless of their professional background, will benefit from acquiring practical skills in Excel, SQL, Python, Power BI, and Tableau. Whether you're a hobbyist, a curious mind, or someone looking to explore new horizons, this course provides a comprehensive understanding of data analysis tools.
This course caters to a diverse audience by delivering a structured learning experience that accommodates various skill levels and backgrounds. It's designed to empower learners with the essential skills required to navigate the intricate landscape of data analysis confidently, fostering a community of individuals passionate about deriving insights from data.

User Reviews

Rating

average 0

Total votes0

Focused display

Python

Data Analysis

Microsoft Power BI

Tableau

Excel

Bluelime Learning Solutions

Instructor's Courses

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.