Business Intelligence-Power BI-SQL SERVER MANAGEMENT STUDIO
Published 1/2025
Created by Pouya Rezaei
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: All | Genre: eLearning | Language: English | Duration: 21 Lectures ( 1h 40m ) | Size: 819 MB
Comprehensive BI Course: How to Work with Power BI, SQL Queries, and Dashboard Creation from Basics to Advance
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
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 dashboardI’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
BUSIENRTSGDHINTERLLSGERJHSREFRSAKEL
you must be registered member to see linkes Register Now