Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Business Intelligence-Power BI-SQL SERVER MANAGEMENT STUDIO
2 students

Business Intelligence-Power BI-SQL SERVER MANAGEMENT STUDIO

Comprehensive BI Course: How to Work with Power BI, SQL Queries, and Dashboard Creation from Basics to Advance
Created byPouya Rezaei
Last updated 1/2025
English

What you'll learn

  • Concept of Business Intelligence and the key aspects you need to be aware of
  • Infrastructures and processes of BI
  • Downloading and Installing Power BI, Microsoft SQL Server and SSMS
  • Introduction to the SSMS Environment
  • General structure of a query
  • Important Commands in query writing
  • Presentation of classified information in the form of charts and diagrams
  • OR, AND, WHERE Clauses
  • String Operations in SQL
  • Everything with regard to NULL and DISTINCT
  • How to copy certain columns from a table into a new table
  • Different kinds of Wildcards
  • DELETE, TRUNCATE and their main difference
  • Different types of JOINS
  • How to apply HAVING and GROUP BY
  • How to create a TABLE and how to create a VIEW
  • Date Functions such as DATEPART, DAYOFYEAR and FORMAT
  • Comparison of Connection Methods in Power BI
  • How to work with filtering tool, called SLICER
  • How to use POWER QUERY for cleaning data

Course content

4 sections • 21 lectures • 1h 40m total length

  • What is Business Intelligence?2:53
  • The Business Intelligence Process3:49
  • Downloading and Installing Power BI3:41
  • Basic Introduction to Working with Power BI through an Example5:33

Requirements

  • For this course, a basic understanding of data concepts and related software like Microsoft Excel would be helpful. However, there are no specific prerequisites for joining the course, as we will cover the essential concepts of Power BI and SQL Server from the beginning

Description

NOTE: Throughout this training course, I’ve incorporated real-world examples in every session to bring the concepts to life and enhance your understanding.


In this course, you will learn how to work professionally with the tools of Power BI and SQL Server. At the beginning of the course, you will be introduced to the concept and history of Business Intelligence, and later, you will learn how to install the necessary programs. Next, we will explore the environment and tools of these programs, and discuss query writing, as well as the rules and commands related to it. By the end of the course, you will be able to import raw data into the software, format it according to your preferences, and present it as a professional dashboard

I've streamlined the content to highlight key concepts that are vital for your analytical toolkit, ensuring you leave with practical knowledge that you can apply immediately in your work. Join me and transform your data analysis skills!

Headlines:

-The Business Intelligence Process

-Downloading and Installing Power BI and Microsoft SQL Server and SSMS

-Basic Introduction to Power BI

-Introduction to the SSMS Environment

-How to write queries

-Connecting to Data in Power BI

-POWER QUERY


Who this course is for:

  • Data Analysts
  • Managers and Decision Makers
  • Developers
  • Anyone interested in Data Analysis and Business Intelligence

Report abuse