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

Power BI Developer (Power BI,DAX,Power Query,Datamodelling)

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

Power BI Hands-on learning experience- Data Analytics, Data Visualization,DAX,Power Query,Datamodelling,Databases


1. Power BI Setup
  • 1. Introduction
  • 2. What is Power BI
  • 3. What is Power BI Desktop
  • 4. Install Power BI Desktop
  • 5. Exploring Power BI Desktop Interface
  • 6. Microsoft 365 Setup
  • 7. Getting started with Microsoft 365
  • 8. Creating a new user account in Microsoft 365

  • 2. Connecting to Data Sources
  • 1. Introduction.html
  • 2. Connecting to online data sources.html
  • 3. Connecting to NOSQL Database.html
  • 4. Getting data into Power BI Desktop
  • 5. Create and save a new Power BI Desktop file
  • 6. Set Power BI Desktop options
  • 7. Get data from SQL Server
  • 8. Preview SQL Server queries
  • 9. Getting data from files.html
  • 10. Get data from a CSV file
  • 11. Get additional data from a CSV file
  • 12. Connect to data in a database
  • 13. Connect to data in Power Platform
  • 14. Connect to Azure SQL Database
  • 15. Data Source Settings
  • 16. Storage Modes
  • 17. Change the source file.html
  • 18. Selecting a storage mode.html

  • 3. Power BI Overview
  • 1. Introduction
  • 2.1 Financial+Sample.xlsx
  • 2. Power BI Overview Part 1
  • 3. Power BI Overview Part 2
  • 4. Power BI Overview Part 3
  • 5. Parts of Power BI
  • 6. Power BI Building blocks
  • 7. Exploring Power BI Service

  • 4. Connect & Transform Online Data
  • 1. Connect to Web Data
  • 2. Clean & transform data Part 1
  • 3. Clean & transform data Part 2
  • 4. Combine data sources
  • 5. Creating Data Visuals Part 1
  • 6. Creating Data Visuals Part 2
  • 7. Publish report to Power BI Service

  • 5. Power BI Databases Interaction
  • 1. Download SQL Server
  • 2. SQL Server Installation
  • 3. Installing SQL Server Management Studio
  • 4. Connect to SQL Server with SSMS
  • 5. Install Database
  • 6. Restore AdventureWorksDW2020 Database
  • 7. Connecting to SQL Server Database with Power BI Desktop
  • 8. Install PostgreSQL
  • 9. Connecting to PostgreSQL Database Server Part 1
  • 10. Connecting to PostgreSQL Database Server Part 2
  • 11. Download and load sample database
  • 12. Connect to PostgreSQL Databases
  • 13. Connect to PostgreSQL with Power BI Desktop - Part 1
  • 14. Connect to PostgreSQL with Power BI Desktop - Part 2
  • 15. Importing and Transforming Data from an Access Database File

  • 6. Clean, transform, and load SQL Server data in Power BI
  • 1. Shaping initial data.html
  • 2. Configure the Salesperson query
  • 3. Configure the SalespersonRegion query
  • 4. Configure the Product query
  • 5. Configure the Reseller query
  • 6. Configure the Region query
  • 7. Configure the Sales query
  • 8. Configure the Targets query
  • 9. Configure the ColorFormats query
  • 10. Update the Product query
  • 11. Update the ColorFormats query

  • 7. Data Modelling
  • 1. What is Data Modelling.html
  • 2. Create Model Relationships
  • 3. Configure the Product table
  • 4. Configure the Region table
  • 5. Configure the Reseller table
  • 6. Configure the Sales table
  • 7. Bulk update properties
  • 8. Review the model interface
  • 9. Create quick measures
  • 10. Create a many-to-many relationship
  • 11. Relate the Targets Table
  • 12. Enforce row-level security

  • 8. Introduction to DAX In Power BI Desktop
  • 1. What is DAX.html
  • 2. Create the Salesperson Calculated table
  • 3. Create the Date calculated table
  • 4. Create calculated columns
  • 5. Complete the Date table
  • 6. Mark the Date table
  • 7. Create simple Measures
  • 8. Create additional measures
  • 9. Time Intelligence.html
  • 10. Create a matrix visual
  • 11. Manipulate filter context
  • 12. Create a YTD measure
  • 13. Create a YoY growth measure
  • 14. Publish Power BI Desktop File

  • 9. Building Reports in Power BI
  • 1. Create a new file
  • 2. Create a live connection
  • 3. Design page 1
  • 4. Design page 2
  • 5. Design page 3
  • 6. Publish report
  • 7. Explore the report
  • 8. Configure Sync Slicers
  • 9. Configure drill through page
  • 10. Add Conditional Formatting
  • 11. Add Bookmarks to Report
  • 12. Add Buttons to Report
  • 13. Publish Updated Report
  • 14. Explore Updated Report

  • 10. Building Dashboards Perform Data Analysis
  • 1. What are Dashboards.html
  • 2. Create a dashboard
  • 3. Configure an alert
  • 4. Refresh the dataset
  • 5. Create the report
  • 6. Connect to the Sales Analysis Dataset
  • 7. Create an animated scatter chart
  • 8. Create a forecast
  • 9. Work with a decomposition tree
  • 10. Work with key influencers

  • 11. Building Paginated Reports
  • 1. What are Paginated Reports
  • 2. Installing Power BI Report Builder
  • 3. Create a blank report
  • 4. Configure the report header
  • 5. Create a data source and dataset
  • 6. Configure the report parameter
  • 7. Add textboxes to report header region
  • 8. Add a table to the report
  • 9. Format the table data region
  • 10. Finalize the report design
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 9715
    حجم: 3824 مگابایت
    مدت زمان: 610 دقیقه
    تاریخ انتشار: 26 فروردین 1402
    طراحی سایت و خدمات سئو

    45,900 تومان
    افزودن به سبد خرید