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

Become a Microsoft Power BI Data Analyst

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

Prepare Data | Model Data | Visualize and Analyse Data | Deploy and Maintain Assets


1. Introduction to Microsoft Data Analytics
  • 1. Introduction.html
  • 2. Microsoft Data Analytics
  • 3. Overview of Data Analysis
  • 4. Roles in Data Analysis
  • 5. Tasks of a Data Analyst
  • 6. Data Analytics Quiz.html

  • 2. Power BI Setup
  • 1. What is Power BI
  • 2. What is Power BI Desktop
  • 3. Install 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

  • 3. Building with Power BI
  • 1. Power BI Overview Part 1
  • 2. Power BI Overview Part 2
  • 3. Power BI Overview Part 3
  • 4. Parts of Power BI
  • 5. Power BI Building blocks (Video)
  • 6. Exploring Power BI Service
  • 7. Building blocks of Power BI.html
  • 8. The flow of work in Power BI.html
  • 9. Tour and use of Power BI Service.html
  • 10. Update data in Power BI Service.html
  • 11. Summary.html
  • 12. Get started with Power BI.html

  • 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. SQL Server Setup
  • 1. What is SQL Server
  • 2. SQL Server Editions
  • 3. SQL Server Installation Requirements
  • 4. Download SQL Server
  • 5. SQL Server Installation
  • 6. SQL Server Configuration Manager
  • 7. Installing SQL Server Management Studio
  • 8. Connect to SQL Server with SSMS
  • 9.1 AdventureWorksDW2020.zip
  • 9. Restore AdventureWorksDW2020 Database
  • 10. Download Sample Database

  • 6. Prepare data ( Get data from different data sources )
  • 1. Introduction.html
  • 2. Get data from online services.html
  • 3. Get data from a NoSQL database.html
  • 4. Create and save a new Power BI Desktop file
  • 5. Set Power BI Desktop options
  • 6. Get data from relational data sources
  • 7. Preview SQL Server queries
  • 8. Get data from files.html
  • 9.1 ColorFormats.csv
  • 9.2 ResellerSales 202006.csv
  • 9.3 ResellerSalesTargets.csv
  • 9. Get data from a CSV file
  • 10. Get additional data from a CSV file
  • 11. Change the source file.html
  • 12. Selecting a storage mode.html
  • 13. Get data from Azure Analysis Services.html
  • 14. Fix performance issues.html
  • 15. Resolve data import errors.html
  • 16. Summary.html
  • 17. Getting Data.html

  • 7. Clean, transform, and load data in Power BI
  • 1. Introduction.html
  • 2. Shape the initial data.html
  • 3. Configure the Salesperson query
  • 4. Configure the SalespersonRegion query
  • 5. Configure the Product query
  • 6. Configure the Reseller query
  • 7. Configure the Region query
  • 8. Configure the Sales query
  • 9. Configure the Targets query
  • 10. Configure the ColorFormats query
  • 11. Update the Product query
  • 12. Update the ColorFormats query
  • 13. Load and Transform Data.html

  • 8. Model Data In Power BI Desktop
  • 1. Introduction.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. Model Data In Power BI Desktop.html
  • 11. Create a many-to-many relationship
  • 12. Relate the Targets Table
  • 13. Enforce row-level security

  • 9. Introduction to DAX In Power BI Desktop
  • 1. Create the Salesperson Calculated table
  • 2. Create the Date calculated table
  • 3. Create calculated columns
  • 4. Complete the Date table
  • 5. Mark the Date table
  • 6. Create simple Measures
  • 7. Create additional measures

  • 10. Time Intelligence and Measures in DAX
  • 1. Create a matrix visual
  • 2. Manipulate filter context
  • 3. Create a YTD measure
  • 4. Create a YoY growth measure
  • 5. Publish Power BI Desktop File
  • 6. Time Intelligence Quiz.html

  • 11. Design a report in Power BI Desktop
  • 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. Power BI Dashboard.html
  • 15. Explore Updated Report
  • 16. Designing Reports.html

  • 12. Create a Power BI dashboard (Create a sales monitoring dashboard)
  • 1. Create a dashboard
  • 2. Configure an alert
  • 3.1 ResellerSales 202006.csv
  • 3.2 updatedatabase-2.zip
  • 3. Refresh the dataset

  • 13. Perform data analysis in Power BI Desktop
  • 1. Create the report
  • 2. Connect to the Sales Analysis Dataset
  • 3. Create an animated scatter chart
  • 4. Create a forecast
  • 5. Work with a decomposition tree
  • 6. Work with key influencers
  • 7. Perform data analysis in Power BI Desktop.html

  • 14. Exam PL-300 Microsoft Power BI Data Analyst Preparation
  • 1. Introduction.html
  • 2. What is the exam Format.html
  • 3. Prepare the Data (15-20%).html
  • 4. Model the Data (30-35%).html
  • 5. Visualize and Analyze the Data (25-30%).html
  • 6. Deploy and Maintain Assets (20-25%).html
  • 7. PL-300 Exam Braindumps.html
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 8756
    حجم: 3353 مگابایت
    مدت زمان: 516 دقیقه
    تاریخ انتشار: 10 فروردین 1402
    طراحی سایت و خدمات سئو

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