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

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 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 16975
    حجم: 4890 مگابایت
    مدت زمان: 817 دقیقه
    تاریخ انتشار: ۸ مرداد ۱۴۰۲
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید