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

سرفصل های دوره

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

1. Introduction to Data Analysis

1. Introduction.html

2. Introduction to Data Analysis.html

3. Overview of Data Analysis

4. Roles in Data

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

6. Task of a Data Analyst

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

2. MySQL Installation on Windows

3. MySQL Installation on Mac

4. Introduction to MySQL Workbench

5. Installing MySQL Workbench on Macs

6. Basic Database Concepts

7. What is a Schema

8. Database Schema

9. MySQL Data Types

3. Basics of SQL

1. Introduction to SQL.html

2. SQL Syntax.html

3. Data Definition Language (DDL).html

4. CREATE Database Statement

5. CREATE Table Statement

6.1 insert+data+into+tables.zip

6. INSERT INTO Statement

7. SELECT Statement

8. UPDATE Statement

9. DELETE Statement

10. Intermediate SQL.html

11. SQL Indexes.html

12. Introduction to Table Joins.html

13. INNER Join

14. LEFT Join

15. RIGHT Join

16. SELF Join

17. Introduction to Views

18.1 create+replace+view.zip

18.2 create+view.zip

18. Creating Views

19. Querying Views

20.1 alter+view.zip

20. Modifying Views

21. Dropping Views

22. Introduction to Sub queries

23. Nested Sub queries

24. Grouping Rows of data using GROUP BY CLAUSE

25. Filtering groups using HAVING CLAUSE

26. Sorting data using ORDER BY Clause

27. Filtering rows of data using WHERE Clause

28. Introduction to Aggregate Functions

29. AVG Function

30. COUNT Function

31. SUM Function

32. MIN Function

33. MAX Function

34. What are stored procedures

35.1 creating+stored+procedure.zip

35. Creating stored procedure

36.1 modifying+stored+procedure.zip

36. Modifying stored procedure

37.1 advanced+stored+procedure.zip

37. Creating an advanced stored procedure

38. Calling and deleting stored procedures

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

3. Basic data entry in excel

4. Data entry with autofil

5. Data entry with date

6. Data entry with time

7. Undo and redo changes

8. Adding comments

9. Giving worksheet a title

10. Saving your work

11. Introduction to Functions and Formulas

12. Using formulas for arithmetic tasks

13. Re-using Formulas

14. Calculating YTD Profits

15. Calculating Percentage Change

16. Relative and Absolute Reference

17. Using RANK Function

18. STD Function

19. Small and Large Functions

20. Median Function

21. Count and counta functions

22. What is Power Query

23.1 EV sales (King county).zip

23. Connecting to a data source

24. PLEASE READ.html

25.1 Prep.xlsx

25. Preparing your query

26.1 Cleansing.xlsx

26. Cleansing data

27.1 Enhance.xlsx

27. Enhancing query

28. What is Power Pivot

29.1 EV sales (King county).zip

29. Creating a data model

30.1 AddData.xlsx

30. Importing data and creating relationships

31.1 Lookups.xlsx

31. Create lookups with DAX

32.1 Pivot.xlsx

32. Analyze data with Pivot Tables

33. Analyze data with Pivot Charts

34.1 Refresh.xlsx

34. Refreshing Source Data

35.1 Update.xlsx

35. Updating Queries

36.1 NewReports.xlsx

36. Creating new reports

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

3. What is VBA

4. Activating Macros and VBA Tools

5. Exploring VBA Tools

6.1 Expenses.xlsx

6. Creating a basic Macro

7.1 Expenses.xlsx

7. Saving a worksheet with a macro

8.1 employees macro.zip

8.2 employees.xlsx

8. Creating a another macro Part 1

9.1 employees macro.zip

9.2 employees.xlsx

9. Creating a another macro Part 2

10.1 Font Styles.xlsx

10. Exploring Macros with VBA Editor

11.1 font styles macro.zip

11. Commenting and deleting macro code

12.1 font styles macro.zip

12. Editing Macros

13.1 employees macro.zip

13. Sorting data with Macros

14.1 employees macro.zip

14. Filtering Data with Macros

15.1 employees macro.zip

15. Creating buttons to run Macros

16.1 Cell Protect Macro.xlsx

16. Protecting cells and sheets with Macros

17.1 debugging.zip

17. Debugging Macros Part 1

18. Debugging Macros Part 2

19. Debugging Macros Part 3

20.1 Creating Macros from Scratch.xlsx

20. Manually Create Macros

6. Introduction to Power BI and DAX

1. What is Power BI

2. What is Power BI Desktop

3. Installing Power BI Desktop

4. Exploring Power BI Desktop Interface

5. Microsoft 365 Setup

6. Getting Started with Microsoft 365

7. Creating a new user account in Microsoft 365

8. Connecting to data sources.html

9.1 Financial+Sample (1).xlsx

9. Power BI Overview - Part 1

10. Power BI Overview - Part 2

11. Power BI Overview - Part 3

12. Components of Power BI

13. Building blocks of Power BI

14. Exploring Power BI Service

15. Connecting to online data

16. Clean and transform data - part 1

17. Clean and transform data - part 2

18. Combine data sources

19. Power BI Visualizations.html

20. Creating charts, graphs, and tables.html

21. Interactive visuals.html

22. Visualizing data - Part 1

23. Visualizing data - Part 2

24. Publishing report to Power BI Service

25.1 AccessDatabasePowerBI.zip

25. Connecting to Microsoft Access Data Source

26. Power Query Editor

27. Creating and managing Query Groups

28. Renaming Queries

29. Splitting Columns

30. Changing data types

31. Removing and reordering columns

32. Creating conditional columns

33.1 International.rar

33. Connecting to files in folder

34. Appending queries

35. Merging Queries

36. Query dependency view

37. Power BI Transformations.html

38. Data cleaning and transformations.html

39.1 Multi-Level-Spreadsheet.xlsx

39. Transforming less structured data

40. Creating tables

41.1 SalesByCountry.xlsx

41. Query Parameters

42. Data Modelling

43. Data Modeling in Power BI.html

44. Relationships in Power BI.html

45. Creating and managing data relationships

46. Creating calculated columns

47. Optimizing models for reporting

48. Applying Filters to Visualizations

49. Time Intelligence

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

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training