Platform Access

SQL for Power BI Users

Level up your knowledge in SQL query fluency even without prior SQL experience with this Power BI and SQL course. Perform data transformations and improve the design of your data model with your preferred format or shape.

Enroll Now
 SQL for Power BI Users

Here's What You'll Get With The Course

More than 3 of self-paced video training

Resource pack with demo exercises

 SQL for Power BI Users

Power BI improves expertise in data analyst and tools

  • Professional report building by working with large and numerous amount of data transactions

  • Perform and improve data transformation and design with chosen format

Details Of What You Will Learn

During This Course

  • Speak - the language used by most IT professionals. Better SQL knowledge allows you to effectively communicate with IT
  • Use - SQL source to improve data refresh timings and report performance. Better SQL knowledge will help users utilize the advanced features of Power BI such as aggregation and incremental refresh
  • Explore - data before extracting to Power BI
  • Manipulate - data quickly to speed up development time
  • Extract - the data in the shape and format required for efficient data model
 SQL for Power BI Users

This Course Module is Tailored for:

Data Analysts

Reporting Managers

Excel Users

If you are a beginner user of SQL and Power BI, report developer or any other professional who wants to work in business analytics/data analytics field, this is the course for you!

LEARN HOW TO

Utilize the key features within Power BI

 SQL for Power BI Users
  • Perform and improve data transformation and design with chosen format
  • Power Bi is best when it comes to large and numerous amount of data
  • Best tool for visualization and analysis for business
  • Can connect and integrate to database easily
  • Improve confidence in using SQL without prior experience
  • Improve your proficiency in using the tools or a data analyst
  • Report developer or any other professional who wants to work in business analytics/data analytics field

Course Curriculum

1. Introduction

  • Course Overview
  • Let's get started
  • Resource Pack
  • Course Introduction

2. SQL for Power BI Users

  • Download and Install SQL and SSMS
  • Query Folding and Connecting to SQL Server
  • SELECT, TOP and ORDER BY
  • Filter using WHERE
  • Filter using IN, NOT IN, LIKE, NOT LIKE
  • Basic SQL function
  • CASE and ISNULL
  • Subquery
  • JOIN Types and Inner JOIN
  • LEFT JOIN and FULL OUTER JOIN
  • Aggregate Functions and Group By
  • Filtering on Aggregate-HAVING
  • Common Table Expressions(CTE)
  • Basic Table Operations
  • Temporary Tables and Views
  • Stored Procedures
  • OFFFSET and FETCH
  • Window Function - Solve Complex Data Problems

What our Students Say

Your Instructor

Hafix Zubair Sultan Photo

Hafiz Zubair Sultan

Hafiz has over 14 years of experience working in IT and Telecommunications field and worked in industries such as telecom, construction, legal, finance and education.

He has an extensive experience on other Microsoft BI tools, those include SSIS (ETL packages), SSAS (Tabular cubes), SSMS (SQL queries) and SSRS (reports) and is particularly interested in solving complex problems using DAX and always eager to learn from online resources and blogs.

He is also a big fan of Power Query and how it can help organizations to improve efficiency by quickly transforming and cleaning data for analysis.

Frequently Asked Questions

  • How long do I have access to the course? You have access to this course as long as you have Enterprise DNA On-Demand Subscription.

  • Can I purchase a single course instead of the Enterprise DNA On-Demand? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full On-Demand Subscription here.
  • Do you offer one-off support or coaching? All support around Power BI and Enterprise DNA's online training content now occurs at the Enterprise DNA Forum. You must have an Enterprise DNA On-Demand Subscription or CoE access to receive support.

  • What if I need to train my team? We recommend exploring Enterprise DNA For Business. To learn more, see here.

Get full access to unparalleled training

& skill-building resourcess

For Individuals

Enterprise DNA

On-Demand

Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities

For Teams

Enterprise DNA

For Business

Training, tools, and guidance to unify and upskill the data analysts in your workplace