BI Analyst Tools: (Excel, VBA, SQL, Power Query, Power BI)

Focused View

Bluelime Learning Solutions

13:36:15

172 View

1. Introduction to Data Analysis

1. Introduction.html

2. Introduction to Data Analysis.html

3. Overview of Data Analysis.mp4

08:14

4. Roles in Data.mp4

09:14

5. Role and importance of data analysis in business.html

6. Task of a Data Analyst.mp4

10:38

7. Overview of data analysis tools.html

8. Introduction to Power BI, SQL, and Excel.html

9. Comparisons between Power BI, SQL, and Excel.html

10. Introduction to DAX.html

11. Introduction to Dashboards.html

12. What is a dashboard and its importance.html

13. Components of a dashboard.html

2. MySQL Database Server Setup

1. What is MySQL.mp4

03:31

2. MySQL Installation on Windows.mp4

14:55

3. MySQL Installation on Mac.mp4

06:58

4. Introduction to MySQL Workbench.mp4

06:04

5. Installing MySQL Workbench on Macs.mp4

05:36

6. Basic Database Concepts.mp4

09:00

7. What is a Schema.mp4

02:50

8. Database Schema.mp4

04:50

9. MySQL Data Types.mp4

06:56

3. Basics of SQL

1. Introduction to SQL.html

2. SQL Syntax.html

3. Data Definition Language (DDL).html

4. CREATE Database Statement.mp4

01:57

5. CREATE Table Statement.mp4

06:46

6.1 insert+data+into+tables.zip

6. INSERT INTO Statement.mp4

08:48

7. SELECT Statement.mp4

08:22

8. UPDATE Statement.mp4

10:51

9. DELETE Statement.mp4

05:06

10. Intermediate SQL.html

11. SQL Indexes.html

12. Introduction to Table Joins.html

13. INNER Join.mp4

11:57

14. LEFT Join.mp4

06:05

15. RIGHT Join.mp4

04:13

16. SELF Join.mp4

08:07

17. Introduction to Views.mp4

05:15

18.1 create+replace+view.zip

18.2 create+view.zip

18. Creating Views.mp4

04:07

19. Querying Views.mp4

03:38

20.1 alter+view.zip

20. Modifying Views.mp4

06:16

21. Dropping Views.mp4

02:50

22. Introduction to Sub queries.mp4

04:37

23. Nested Sub queries.mp4

03:22

24. Grouping Rows of data using GROUP BY CLAUSE.mp4

03:56

25. Filtering groups using HAVING CLAUSE.mp4

06:31

26. Sorting data using ORDER BY Clause.mp4

06:10

27. Filtering rows of data using WHERE Clause.mp4

02:37

28. Introduction to Aggregate Functions.mp4

02:05

29. AVG Function.mp4

03:29

30. COUNT Function.mp4

08:49

31. SUM Function.mp4

04:22

32. MIN Function.mp4

02:25

33. MAX Function.mp4

02:48

34. What are stored procedures.mp4

03:46

35.1 creating+stored+procedure.zip

35. Creating stored procedure.mp4

06:54

36.1 modifying+stored+procedure.zip

36. Modifying stored procedure.mp4

05:13

37.1 advanced+stored+procedure.zip

37. Creating an advanced stored procedure.mp4

07:26

38. Calling and deleting stored procedures.mp4

05:32

39. Stored procedures and functions.html

40. SQL for Data Analysis.html

4. Data Analysis with Excel

1. Basic Excel for Data Analysis.html

2. Opening a new workbook.mp4

07:18

3. Basic data entry in excel.mp4

08:21

4. Data entry with autofil.mp4

05:58

5. Data entry with date.mp4

05:23

6. Data entry with time.mp4

05:37

7. Undo and redo changes.mp4

05:52

8. Adding comments.mp4

04:13

9. Giving worksheet a title.mp4

03:51

10. Saving your work.mp4

05:55

11. Introduction to Functions and Formulas.mp4

05:21

12. Using formulas for arithmetic tasks.mp4

05:55

13. Re-using Formulas.mp4

04:15

14. Calculating YTD Profits.mp4

06:49

15. Calculating Percentage Change.mp4

06:43

16. Relative and Absolute Reference.mp4

09:39

17. Using RANK Function.mp4

03:59

18. STD Function.mp4

02:29

19. Small and Large Functions.mp4

03:44

20. Median Function.mp4

01:58

21. Count and counta functions.mp4

03:43

22. What is Power Query.mp4

03:30

23.1 EV sales (King county).zip

23. Connecting to a data source.mp4

04:26

24. PLEASE READ.html

25.1 Prep.xlsx

25. Preparing your query.mp4

04:51

26.1 Cleansing.xlsx

26. Cleansing data.mp4

07:37

27.1 Enhance.xlsx

27. Enhancing query.mp4

09:21

28. What is Power Pivot.mp4

01:02

29.1 EV sales (King county).zip

29. Creating a data model.mp4

06:02

30.1 AddData.xlsx

30. Importing data and creating relationships.mp4

06:56

31.1 Lookups.xlsx

31. Create lookups with DAX.mp4

07:01

32.1 Pivot.xlsx

32. Analyze data with Pivot Tables.mp4

08:42

33. Analyze data with Pivot Charts.mp4

08:14

34.1 Refresh.xlsx

34. Refreshing Source Data.mp4

07:34

35.1 Update.xlsx

35. Updating Queries.mp4

09:18

36.1 NewReports.xlsx

36. Creating new reports.mp4

07:18

37. Data sorting and filtering.html

38. Formulas and functions.html

39. PivotTables and PivotCharts.html

40. Intermediate Excel for Data Analysis.html

41. Conditional formatting.html

42. Lookup & Reference Functions (VLOOKUP, HLOOKUP, INDEX, MATCH).html

43. Advanced Excel for Data Analysis.html

44. Data validation.html

45. What-If Analysis.html

5. Introduction to Macros

1. Introduction to macros.html

2. What are Macros.mp4

01:29

3. What is VBA.mp4

01:00

4. Activating Macros and VBA Tools.mp4

02:07

5. Exploring VBA Tools.mp4

07:33

6.1 Expenses.xlsx

6. Creating a basic Macro.mp4

10:48

7.1 Expenses.xlsx

7. Saving a worksheet with a macro.mp4

01:57

8.1 employees macro.zip

8.2 employees.xlsx

8. Creating a another macro Part 1.mp4

06:09

9.1 employees macro.zip

9.2 employees.xlsx

9. Creating a another macro Part 2.mp4

04:55

10.1 Font Styles.xlsx

10. Exploring Macros with VBA Editor.mp4

07:29

11.1 font styles macro.zip

11. Commenting and deleting macro code.mp4

06:29

12.1 font styles macro.zip

12. Editing Macros.mp4

03:33

13.1 employees macro.zip

13. Sorting data with Macros.mp4

04:12

14.1 employees macro.zip

14. Filtering Data with Macros.mp4

05:41

15.1 employees macro.zip

15. Creating buttons to run Macros.mp4

05:48

16.1 Cell Protect Macro.xlsx

16. Protecting cells and sheets with Macros.mp4

06:26

17.1 debugging.zip

17. Debugging Macros Part 1.mp4

07:54

18. Debugging Macros Part 2.mp4

12:24

19. Debugging Macros Part 3.mp4

07:48

20.1 Creating Macros from Scratch.xlsx

20. Manually Create Macros.mp4

11:48

6. Introduction to Power BI and DAX

1. What is Power BI.mp4

05:47

2. What is Power BI Desktop.mp4

03:40

3. Installing Power BI Desktop.mp4

02:55

4. Exploring Power BI Desktop Interface.mp4

05:02

5. Microsoft 365 Setup.mp4

03:43

6. Getting Started with Microsoft 365.mp4

04:04

7. Creating a new user account in Microsoft 365.mp4

02:54

8. Connecting to data sources.html

9.1 Financial+Sample (1).xlsx

9. Power BI Overview - Part 1.mp4

04:24

10. Power BI Overview - Part 2.mp4

04:05

11. Power BI Overview - Part 3.mp4

04:49

12. Components of Power BI.mp4

02:57

13. Building blocks of Power BI.mp4

09:31

14. Exploring Power BI Service.mp4

04:28

15. Connecting to online data.mp4

05:07

16. Clean and transform data - part 1.mp4

07:12

17. Clean and transform data - part 2.mp4

09:45

18. Combine data sources.mp4

07:59

19. Power BI Visualizations.html

20. Creating charts, graphs, and tables.html

21. Interactive visuals.html

22. Visualizing data - Part 1.mp4

06:09

23. Visualizing data - Part 2.mp4

05:23

24. Publishing report to Power BI Service.mp4

04:47

25.1 AccessDatabasePowerBI.zip

25. Connecting to Microsoft Access Data Source.mp4

07:09

26. Power Query Editor.mp4

06:49

27. Creating and managing Query Groups.mp4

04:35

28. Renaming Queries.mp4

04:54

29. Splitting Columns.mp4

07:06

30. Changing data types.mp4

05:47

31. Removing and reordering columns.mp4

06:54

32. Creating conditional columns.mp4

06:18

33.1 International.rar

33. Connecting to files in folder.mp4

07:17

34. Appending queries.mp4

06:58

35. Merging Queries.mp4

05:35

36. Query dependency view.mp4

04:32

37. Power BI Transformations.html

38. Data cleaning and transformations.html

39.1 Multi-Level-Spreadsheet.xlsx

39. Transforming less structured data.mp4

09:10

40. Creating tables.mp4

03:47

41.1 SalesByCountry.xlsx

41. Query Parameters.mp4

09:28

42. Data Modelling.mp4

00:42

43. Data Modeling in Power BI.html

44. Relationships in Power BI.html

45. Creating and managing data relationships.mp4

11:53

46. Creating calculated columns.mp4

10:49

47. Optimizing models for reporting.mp4

06:41

48. Applying Filters to Visualizations.mp4

03:19

49. Time Intelligence.mp4

04:20

50. Time intelligence functions.html

51. Introduction to DAX.html

52. Basic DAX functions and syntax.html

53. DAX measures and calculated columns.html

54. Advanced DAX.html

55. Filter and value DAX functions.html

56. Star Schema and Snowflake Schema.html

7. 6 Dashboards and Data Storytelling

1. Designing Dashboards in Power BI.html

2. Principles of good dashboard design.html

3. Power BI Dashboard vs Power BI Report.html

4. Data Storytelling.html

5. Importance of storytelling in data analysis.html

6. Techniques for effective data storytelling.html

7. Project Build Your Own Dashboard.html

8. Build a business-oriented dashboard using learned tools.html

8. Example Captone Project using the tools

1. Example Project.html

Description

Mastering Data Visualization and Analytics with BI Tools: (Excel, VBA, SQL, Power Query, DAX, Macros, Power BI)

What You'll Learn?

Understanding the importance and role of data analysis in a business context.
Familiarity with key tools in data analysis, including Power BI, SQL, Excel, and DAX.
Ability to connect Power BI to various data sources.
Skills to clean and transform raw data for analysis using Power Query in Power BI.
Proficiency in writing SQL queries for data extraction and manipulation.
Developing and working with databases in SQL, including concepts such as Joins, Views, and Stored Procedures.
Understanding how to use Excel for data analysis, including sorting, filtering, and use of formulas and functions.
Advanced Excel skills such as data validation and what-if analysis.
Mastery of PivotTables and PivotCharts in Excel.
Understanding the basics of DAX, including its syntax and various functions.
Ability to create calculated columns and measures using DAX.
Mastering advanced DAX concepts like Time Intelligence functions.
Creating relational data models in Power BI.
Designing interactive visuals in Power BI, including charts, graphs, and tables.
Understanding the principles of good dashboard design.
Creating effective, business-oriented dashboards in Power BI.
Ability to tell compelling stories with data.
Ability to tell compelling stories with data.
Hands-on experience of building a business-oriented dashboard in a Capstone Project.
Confidence and competence to use Power BI, SQL, Excel, and DAX in real-world business scenarios for data analysis and visualization.

Who is this for?

Beginners interested in learning data analysis and business intelligence tools.

Professionals who want to enhance their data analysis skills.

Data analysts aiming to learn new tools and techniques.

Students in the fields of business, data science, or related disciplines looking to augment their skills.

What You Need to Know?

While this course starts with the basics, a general understanding of computers and software is required. No prior knowledge of Power BI, SQL, Excel, or DAX is needed. A willingness to learn and an interest in data analysis are the main prerequisites.

More details

Description
Welcome to " BI Analyst Tools: Unleashing Business Intelligence," an immersive course designed to guide you through the world of data analysis using state-of-the-art tools such as Power BI, SQL, Excel, and DAX. Whether you're a novice just starting your journey, or an established professional seeking to enhance your toolkit, this course offers an expansive insight into the realm of data analysis, visualization, and business intelligence.
Today, the business landscape is becoming increasingly data-driven. Every business decision is underpinned by data, insights, and analytics. Recognizing this shift, our course intends to impart the skills necessary to navigate, analyze, and interpret complex data, allowing you to harness its power and drive strategic decision-making.
The course kicks off with a fundamental understanding of data analysis, its role, and significance in business. As we progress, we'll delve into the basics of Power BI, SQL, Excel, and DAX, essential tools for any data analyst. You'll learn how to gather, clean, and transform data, preparing it for insightful analysis.
As we dive deeper, we'll explore DAX, a library of functions and operators that provide the muscle for crunching numerical data. We'll then move on to one of the most exciting aspects of data analysis: visualizations. You'll learn how to design and implement interactive charts, graphs, and other visuals, and arrange them in a compelling dashboard that tells the story hidden within your data.
Excel, a classic tool with robust capabilities, plays an essential role in our course. We'll navigate its features, from basic functions to pivot tables, exploring how it can be employed in data analysis. With SQL, we'll show you how to query databases to retrieve and manipulate data, essential skills for working with large datasets.
Perhaps one of the most rewarding parts of this course is the Capstone Project. You'll apply the skills you've learned to create a business-oriented dashboard, incorporating elements from Power BI, SQL, Excel, and DAX. This hands-on experience is designed to solidify your learning and provide a taste of real-world data analysis projects.
This course is for anyone with a desire to understand data and draw insights from it. No prior knowledge of Power BI, SQL, Excel, or DAX is requiredâ€”only a willingness to learn and a fascination with data. The course is ideal for beginners interested in data analysis, professionals seeking to enhance their data analysis skills, business professionals, and students in business or data science disciplines.
In conclusion, " BI Analyst Tools: Unleashing Business Intelligence" is more than just a courseâ€”it's your gateway to the intriguing world of data analysis. Upon completion, you'll not only understand how to use Power BI, SQL, Excel, and DAX, but you'll also know how to weave them together to create captivating dashboards that make data speak. Embark on this journey with us and discover the transformative power of data analysis and business intelligence.

Who this course is for:
Beginners interested in learning data analysis and business intelligence tools.
Professionals who want to enhance their data analysis skills.
Data analysts aiming to learn new tools and techniques.
Data analysts aiming to learn new tools and techniques.
Students in the fields of business, data science, or related disciplines looking to augment their skills.

User Reviews

Rating

average 0

Total votes0

Focused display

Business Intelligence

Microsoft Power BI

Excel Formulas and Functions

R Programming

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.