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

Focused View

Tech Academy

4:08:05

106 View

1 - Introduction to Business Intelligence and SQL BI Developer

1 - Introduction.mp4

00:20

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.mp4

04:45

8 - Download SQL Server.mp4

04:31

9 - Install SQL Server.mp4

09:43

10 - SQL Server Configuration Manager.mp4

08:10

11 - Installing SQL Server Management Studio SSMS.mp4

05:48

12 - Connecting SSMS to SQL Server.mp4

02:16

13 - Restore sample DW Database.mp4

05:49

14 - Restore Database.mp4

06:28

15 - Database Concepts.mp4

04:31

3 - Visual Studio Setup

16 - What is Visual Studio.html

17 - Visual Studio Installation Requirements.html

18 - Visual Studio Workload.mp4

03:59

19 - Installing Visual Studio.mp4

06:46

20 - Installing SQL Server Data Tools SSDT.mp4

04:09

21 - Installing SSDT Extensions.mp4

06:21

4 - Introduction to TSQL Stored Procedures

22 - What is TSQL.html

23 - Introduction to stored procedures.html

24 - Creating stored procedures.mp4

07:33

25 - Modifying stored procedures.mp4

02:07

26 - Properties page of a stored procedure.mp4

04:35

27 - Viewing dependencies of a stored procedure.mp4

02:14

28 - Deleting Store Procedures.mp4

01:31

29 - Viewing the definition of a stored procedures.mp4

02:26

5 - Implementing ETL with SQL Server Integration Services SSIS

30 - Introduction to SSIS.html

31 - What is ETL.mp4

05:41

32 - Creating an SSIS package.mp4

02:13

33 - SSIS Designer.mp4

02:18

34 - Add and configure a flat file connection manager.mp4

06:26

34 - SampleCurrencyData.txt

35 - Remapping column data types.mp4

11:12

36 - Add and configure an OLE DB Connection manager.mp4

04:28

37 - Add a Data Flow task to the package.mp4

05:02

38 - Add and configure the flat file source.mp4

04:28

39 - Add and configure the lookup transformations.mp4

11:29

39 - lookupsqlquery.txt

40 - Add and configure and lookup for datekey transformation.mp4

09:28

41 - Add and configure the OLE DB Destination.mp4

07:53

42 - Test and run the package.mp4

02:02

6 - Introduction to SQL Server Reporting Services SSRS

43 - Introduction to SSRS.html

44 - Create a report server project.mp4

02:05

45 - Create a report definition file.mp4

01:56

46 - Configure a data source for the report.mp4

02:32

47 - Define a dataset for the report.mp4

04:51

48 - Add a table to the report.mp4

03:33

49 - Format the report.mp4

04:43

50 - Grouping data in the report.mp4

03:50

51 - Adding totals to the report.mp4

04:38

52 - Previewing the report.mp4

00:54

53 - Exporting the report.mp4

00:49

7 - Data Analysis Visualization with Power BI

54 - What is Power BI.html

55 - Installing Power BI Desktop.mp4

02:55

56 - Microsoft 365 Business Standard.mp4

03:43

57 - Getting started with Microsoft 365 Business Standard.mp4

04:04

58 - Adding new user to Microsoft 365.mp4

02:54

59 - Exploring Power BI Desktop.mp4

05:02

60 - Connect to data.mp4

03:26

60 - Financial-Sample.xlsx

61 - Transform data.mp4

03:20

62 - Model Data.mp4

02:56

63 - Visualize Data.mp4

09:20

64 - Publish data to Power BI Service.mp4

02:25

65 - Build dashboard.mp4

08:16

66 - Collaborate and share.mp4

03:11

Description

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

What You'll Learn?

Understand the fundamentals of Business Intelligence (BI) and the role of SQL BI Developers in the industry.
Gain a understanding of SQL Server, including its installation requirements, management tools, and key features, such as T-SQL and stored procedures
Analyze, transform and load data with Power BI
Create visualizations and dashboards with Power BI
Understand the importance of ETL (Extract, Transform, Load) processes in BI development
learn how to use SQL Server Integration Services (SSIS) to create and manage data integration packages.
Learn best practices for error handling, performance optimization, and ETL process management in SSIS.
Acquire the skills necessary to excel in the competitive field of BI development, enabling you to create data-driven solutions that drive business growth and em

Who is this for?

Aspiring BI Developers: Individuals looking to start a career in the field of business intelligence and data analysis, who want to gain a comprehensive understanding of SQL Server, SSRS, Power BI, and ETL tools.

Data Analysts: Professionals already working with data who want to enhance their skillset by learning how to leverage SQL BI tools to create more advanced reports and dashboards for improved decision-making.

Database Administrators and Developers: Those who work with SQL databases and want to expand their knowledge of BI development, learn how to create visually appealing reports, and integrate BI solutions into their existing projects.

IT Professionals: Individuals working in the IT industry who want to broaden their understanding of BI tools and techniques to support data-driven decision-making within their organizations.

Business Professionals: Managers, analysts, and decision-makers who want to learn how to utilize BI tools like SSRS and Power BI to better analyze and understand their organization's data, driving informed decisions and business growth.

Students: Students in computer science, information technology, or related fields who want to acquire practical BI development skills to enhance their academic knowledge and improve their career prospects upon graduation.

Anyone interested in learning about BI development, data analysis, or data visualization: Individuals with a curiosity or passion for working with data, who want to learn the tools and techniques used by BI developers to create insightful reports and dashboards.

What You Need to Know?

Familiarity with basic database concepts: Understanding of fundamental database concepts, such as tables, columns, rows, primary keys, and foreign keys

Basic knowledge of SQL: Knowing how to write simple SQL queries for data retrieval and manipulation (e.g., SELECT, INSERT, UPDATE, DELETE)

General computer literacy: Comfort with using a computer, navigating the operating system, installing software, and managing files

Basic programming knowledge (optional): While not mandatory, having some experience with a programming language can be beneficial when learning about scripting

An eagerness to learn: A willingness to learn new concepts, tools, and techniques is crucial for success in this course

More details

Description
Unlock the Power of Data: Become an SQL BI Developer - SSRS, Power BI, SQL Server, ETL is an all-encompassing course designed to equip you with the skills and knowledge required to excel as a Business Intelligence (BI) Developer using SQL Server, SSRS, Power BI, and ETL tools. This comprehensive course takes you on a journey through the world of BI development, covering all essential aspects, from understanding the BI concepts to mastering the art of data analysis and visualization.
As a BI Developer, you'll play a pivotal role in transforming raw data into meaningful insights that drive business growth and help organizations make informed decisions. This course is meticulously crafted to ensure you learn and master every aspect of SQL BI development, from data extraction to creating visually appealing reports and dashboards.
You will learn about the various components of the Microsoft BI stack, including SQL Server, SSRS, Power BI, and ETL tools.
We'llÂ explore SQL Server and its installation requirements, management tools, and key features, such as T-SQL and stored procedures, which form the backbone of any BI solution. The course will then introduce you to SQL Server Reporting Services (SSRS), a powerful reporting platform that allows you to create, manage, and deliver interactive, print-ready reports from various data sources.
Power BI, a popular data visualization and analytics tool, is also covered extensively in the course. You will learn how to connect to various data sources,Â and create interactive dashboard .
The course also delves into ETL (Extract, Transform, Load) processes, which are critical to BI development. You will learn about SQL Server Integration Services (SSIS), a versatile data integration platform designed to help organizations extract, transform, and load data from various sources into a target database or data warehouse.
You will be well-equipped to create data-driven solutions that drive business growth and empower organizations to make informed decisions. Embark on this exciting journey to unlock the power of data and become an in-demand SQL BI Developer today!

By the end of this course, students will have a solid foundation in SQL BI development using SSRS, Power BI, SQL Server, and ETL tools. They will be well-equipped to apply their skills and knowledge in real-world scenarios, making them valuable assets in the field of BI development and data analysis.

Who this course is for:
Aspiring BI Developers: Individuals looking to start a career in the field of business intelligence and data analysis, who want to gain a comprehensive understanding of SQL Server, SSRS, Power BI, and ETL tools.
Data Analysts: Professionals already working with data who want to enhance their skillset by learning how to leverage SQL BI tools to create more advanced reports and dashboards for improved decision-making.
Database Administrators and Developers: Those who work with SQL databases and want to expand their knowledge of BI development, learn how to create visually appealing reports, and integrate BI solutions into their existing projects.
IT Professionals: Individuals working in the IT industry who want to broaden their understanding of BI tools and techniques to support data-driven decision-making within their organizations.
Business Professionals: Managers, analysts, and decision-makers who want to learn how to utilize BI tools like SSRS and Power BI to better analyze and understand their organization's data, driving informed decisions and business growth.
Students: Students in computer science, information technology, or related fields who want to acquire practical BI development skills to enhance their academic knowledge and improve their career prospects upon graduation.
Anyone interested in learning about BI development, data analysis, or data visualization: Individuals with a curiosity or passion for working with data, who want to learn the tools and techniques used by BI developers to create insightful reports and dashboards.

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

SQL Server

Microsoft Power BI

Tech Academy

Instructor's Courses

Tech Academy is a UK based e-learning provider that offers a range of high quality elearning solutions that teach real life technical skills that are essential and relevant in today's commercial environment. Our instructors have a wealth of experience in their respective courses and currently provide consultancy services to fortune 100 companies. Our courses are presented in HD and are clear and concise to enable retention and provide intuitive learning experience for absolute beginners.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.