SQL for Power BI Users
Level up your SQL query fluency even without prior SQL experience.
An outline of this training course
The immense capability of Power BI in terms of visualization and analysis makes it a prime business intelligence tool for data analysts. More to this, it has a capability of easily connecting and integrating to Databases, which is an integral component in developing reports.
Common to Power BI users who are working with large amount of data and numerous data transactions is building reports based on a SQL source.
Having the knowledge in SQL will definitely provide more advantage as it allows you to efficiently perform data transformations and improve the design of your data model with your preferred format or shape.
In this course, Hafiz Zubair Sultan will make you confident in using SQL in Power BI even without prior experience.
- 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
- More than 3 hours of self-paced video training
- Resource pack with demo exercises
Course Level: Beginner
SQL for Power BI Users - can be accessed through a purchase of an Enterprise DNA Membership
This course was created in March 2022
Testimonials
For a list of all courses available through Enterprise DNA view here
Your Instructor
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.
Course Curriculum
-
StartDownload and Install SQL and SSMS (15:47)
-
StartQuery Folding and Connecting to SQL Server (11:16)
-
StartSELECT, TOP and ORDER BY (11:33)
-
StartFilter using WHERE (9:58)
-
StartFilter using IN, NOT IN, LIKE, NOT LIKE (9:20)
-
StartBasic SQL function (11:33)
-
StartCASE and ISNULL (10:37)
-
StartSubquery (6:35)
-
StartJOIN Types and Inner JOIN (14:41)
-
StartLEFT JOIN and FULL OUTER JOIN (12:18)
-
StartAggregate Functions and Group By (13:21)
-
StartFiltering on Aggregate-HAVING (7:17)
-
StartCommon Table Expressions(CTE) (10:23)
-
StartBasic Table Operations (9:38)
-
StartTemporary Tables and Views (11:30)
-
StartStored Procedures (12:10)
-
StartOFFFSET and FETCH (4:18)
-
StartWindow Function - Solve Complex Data Problems (15:50)
Frequently Asked Questions
Passionate about empowering users of Power BI
"My goal is to teach others that you have almost unlimited analytical power when harnessing all the features in Power BI.
Through training across a number of different mediums, I've reached over 100,000 Power BI users, showing them a range of tips and tricks in Power BI development.
I'm a true believer that Power BI is the future of analysis and know individuals with the right training can now create advanced analytics in a scalable way that can have a real impact in the way insights are found and consumed within organisations."
Sam McKay, CFA - Founder & CEO, Enterprise DNA