For decades, T-SQL (Structured Query Language) has been the primary language for storing, retrieving, and manipulating data in databases. As greater amounts of data are imported into environments, organizations need individuals that have built their database knowledge upon strong fundamentals. In this session, Mitchell Pearson will teach you how to get started with T-SQL quickly and efficiently. You will learn database fundamentals and concepts, then dive into writing T-SQL queries. You’ll also learn how to filter, find data, and tackle writing multi-table joins. After watching our Learn session, you will have acquired the skills and confidence to begin writing and querying data in your very own environment!
Overview
COURSE DIFFICULTY
COURSE DURATION
3h 18m
Skills Learned
After completing this online training course, students will be able to:
Build interactive dashboards and reports in Power BI
Publish and share reports through Power BI Service
Design paginated reports for operational reporting needs
Create bookmarks and drill-through pages for navigation
BI Developers, Data Analysts, Database Administrators
None
01. Class Introduction
02. Introduction to Power BI Reporting (Overview)
03. Introduction to Power BI Reporting (Licensing)
04. Introduction to the Reporting Environment (Getting to Know the Paginated Report Builder)
05. Introduction to the Reporting Environment (Designing Report Layouts)
06. Introduction to the Reporting Environment (Setting Dynamic Properties)
07. Building Your First Report
08. Bringing Data Into Your Report (Creating A Data Source)
09. Bringing Data Into Your Report (Creating A Dataset)
10. Bringing Data Into Your Report (Previewing Data Options)
11. Using Report Items (Line, Textbox, Rectangle)
12. Using Report Items (Working with Images)
13. Understanding The Table And Matrix (Table)
14. Understanding The Table And Matrix (Matrix)
15. Building A Report With Parameters (Parameter Basics)
16. Building A Report With Parameters (Cascading Parameters)
17. Making Reports Dynamic (Expressions)
18. Making Reports Dynamic (Date Expressions)
19. Visualizing Report Data (Charts)
20. Visualizing Report Data (Maps)
21. Visualizing Report Data (Databars And Sparklines)
22. Visualizing Report Data (Subreports And Drillthroughs)
23. Visualizing Report Data (Indicators)
24. Visualizing Report Data (Embedding In Power Bi)
25. Working With Power Bi Datasets
26. Beyond Report Development (Publishing)
27. Beyond Report Development (Delivering And Consuming Reports)
28. Beyond Report Development (Embedding Reports)
29. Beyond Report Development (Exporting Reports)
30. Beyond Report Development (When To Use Paginated Reports)
31. Beyond Report Development (Migrate Ssrs Reports)
32. Class Outro
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Build interactive dashboards and reports in Power BI
Publish and share reports through Power BI Service
Design paginated reports for operational reporting needs
Create bookmarks and drill-through pages for navigation
WHO SHOULD ATTEND
BI Developers, Data Analysts, Database Administrators
PREREQUISITES
None
COURSE OUTLINE
01. Class Introduction
02. Introduction to Power BI Reporting (Overview)
03. Introduction to Power BI Reporting (Licensing)
04. Introduction to the Reporting Environment (Getting to Know the Paginated Report Builder)
05. Introduction to the Reporting Environment (Designing Report Layouts)
06. Introduction to the Reporting Environment (Setting Dynamic Properties)
07. Building Your First Report
08. Bringing Data Into Your Report (Creating A Data Source)
09. Bringing Data Into Your Report (Creating A Dataset)
10. Bringing Data Into Your Report (Previewing Data Options)
11. Using Report Items (Line, Textbox, Rectangle)
12. Using Report Items (Working with Images)
13. Understanding The Table And Matrix (Table)
14. Understanding The Table And Matrix (Matrix)
15. Building A Report With Parameters (Parameter Basics)
16. Building A Report With Parameters (Cascading Parameters)
17. Making Reports Dynamic (Expressions)
18. Making Reports Dynamic (Date Expressions)
19. Visualizing Report Data (Charts)
20. Visualizing Report Data (Maps)
21. Visualizing Report Data (Databars And Sparklines)
22. Visualizing Report Data (Subreports And Drillthroughs)
23. Visualizing Report Data (Indicators)
24. Visualizing Report Data (Embedding In Power Bi)
25. Working With Power Bi Datasets
26. Beyond Report Development (Publishing)
27. Beyond Report Development (Delivering And Consuming Reports)
28. Beyond Report Development (Embedding Reports)
29. Beyond Report Development (Exporting Reports)
30. Beyond Report Development (When To Use Paginated Reports)
31. Beyond Report Development (Migrate Ssrs Reports)
32. Class Outro
