Become an SQL BI Developer – SSRS, Power BI, SQL Server, ETL

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

Master SQL BI Developer Tools: SSRS, Power BI, SQL Server, ETL

1 - Introduction to Business Intelligence and SQL BI Developer

1 - Introduction

2 - Overview of Business Intelligence BI.html

3 - Role of SQL BI Developer in the industry.html

4 - Introduction to SQL Server SSRS Power BI and ETL tools.html

5 - BI project lifecycle.html

2 - Microsoft SQL Server Setup

6 - SQL Server Installation Requirements.html

7 - SQL Server Editions

8 - Download SQL Server

9 - Install SQL Server

10 - SQL Server Configuration Manager

11 - Installing SQL Server Management Studio SSMS

12 - Connecting SSMS to SQL Server

13 - Restore sample DW Database

14 - Restore Database

15 - Database Concepts

3 - Visual Studio Setup

16 - What is Visual Studio.html

17 - Visual Studio Installation Requirements.html

18 - Visual Studio Workload

19 - Installing Visual Studio

20 - Installing SQL Server Data Tools SSDT

21 - Installing SSDT Extensions

4 - Introduction to TSQL Stored Procedures

22 - What is TSQL.html

23 - Introduction to stored procedures.html

24 - Creating stored procedures

25 - Modifying stored procedures

26 - Properties page of a stored procedure

27 - Viewing dependencies of a stored procedure

28 - Deleting Store Procedures

29 - Viewing the definition of a stored procedures

5 - Implementing ETL with SQL Server Integration Services SSIS

30 - Introduction to SSIS.html

31 - What is ETL

32 - Creating an SSIS package

33 - SSIS Designer

34 - Add and configure a flat file connection manager

34 - SampleCurrencyData.txt

35 - Remapping column data types

36 - Add and configure an OLE DB Connection manager

37 - Add a Data Flow task to the package

38 - Add and configure the flat file source

39 - Add and configure the lookup transformations

39 - lookupsqlquery.txt

40 - Add and configure and lookup for datekey transformation

41 - Add and configure the OLE DB Destination

42 - Test and run the package

6 - Introduction to SQL Server Reporting Services SSRS

43 - Introduction to SSRS.html

44 - Create a report server project

45 - Create a report definition file

46 - Configure a data source for the report

47 - Define a dataset for the report

48 - Add a table to the report

49 - Format the report

50 - Grouping data in the report

51 - Adding totals to the report

52 - Previewing the report

53 - Exporting the report

7 - Data Analysis Visualization with Power BI

54 - What is Power BI.html

55 - Installing Power BI Desktop

56 - Microsoft 365 Business Standard

57 - Getting started with Microsoft 365 Business Standard

58 - Adding new user to Microsoft 365

59 - Exploring Power BI Desktop

60 - Connect to data

60 - Financial-Sample.xlsx

61 - Transform data

62 - Model Data

63 - Visualize Data

64 - Publish data to Power BI Service

65 - Build dashboard

66 - Collaborate and share

179,000 تومان

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

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

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

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