Lighting is one of the most important aspects of portraiture. Learn ten ways that you can use just one light source to take great portraits.

Discover techniques and tools for being highly productive under the crush of information, data, and tasks associated with being a video editor.

Learn how to set up and work with PostgreSQL, one of the world’s most popular open-source database platforms. Learn how to build a database, retrieve data with queries, and more.

In this course, database expert Adam Wilbert introduces you to a number of advanced query techniques that you can use to better understand your data. Statistical analyses involve understanding the shape and size of the full data set, and deeper insights can be gained by grouping data together to obtain some very useful metrics. Adam shows you how to create basic groups and apply aggregate calculations, then moves into window functions that create subgroups for more granular analysis. He goes over statistics that are based on sorted data within groups, such as the median value, the first and third quartiles of a dataset, the most frequent value, and more. Adam also covers ranking, hypothetical sets, percentile functions, and conditional expressions for further manipulating query result sets. He concludes with some additional querying techniques that you may find useful in solving common problems.

PostgreSQL is one of the most popular open-source database management systems. In this course, Adam Wilbert introduces you to the command line tools used in professional PostgreSQL database administration. These tools are used for remote management of the server and provide detailed insight into the configuration and operation of the server. Adam starts by locating or installing the tools, then explores the operation of the main utility, psql. Psql provides a wide array of configurable options that can be combined to create flexible workflows for sending SQL commands to the server, or for exporting query results to external files. Adam finishes the course with a detailed look at the command line utilities used to create and restore database backups.

Learn how to write and run automated API tests with Postman.

Learn how to connect Excel and Power Apps to create data-driven business applications.

Prepare yourself for a career in BIM (building information modeling) with this introduction to Power BI. Learn about organizing your data, creating powerful visualizations, and more.

Get a comprehensive overview of the data end of Power BI—also known as Power Query—and learn how to use it to automate the data querying process and restructuring of data sets.

Take your data modeling skills to the next level. Learn how to leverage Data Analysis Expressions (DAX) to create formulas for Power BI that extend your data model.

Power BI is a software that lets users visualize and report data flexibly and share it in a number of ways. It is rapidly gaining market share, as it is affordable and well-integrated with other Microsoft tools. In this course, instructor Emma Saunders shows you how you can use Power BI to create reports and visualizations with flair and share them easily with colleagues. Emma explains the Power BI app (desktop) and service (web browser). She takes you through a sample report to show how it’s built, then goes over how and why to design and structure a report, including how to structure tabs, how many visuals to put on a page, and how to draw attention to one visual over another. Emma covers more advanced visuals, as well, including statistical diagrams and maps for geographic data. She walks you through how to design reports like a pro in the Power BI service, from basic layouts to choosing specific themes and fonts.

Boost efficiency and eliminate duplicate work by learning how to use Power BI dataflows. Discover how to scale the ETL process across many users of Power BI data and dashboards.

Get started with Power BI. Learn how to use this powerful set of business analytics tools to create and share visualizations with others in your organization.

Learn how to use the robust Power BI tool from Microsoft to quickly and precisely assess your marketing efforts.

As a data expert using Microsoft Power BI, your goal is to always be growing your skills. In this course, instructor John David Ariansen helps grow your skills by learning mistakes to avoid. First, John introduces you to a few challenges of Power BI. He shows you how to become a systems thinker, improve your analysis skills, and use visualization effectively. He emphasizes the importance of pulling in the right amount of data, eliminating extra steps, profiling your data sources, and removing unnecessary data. John teaches you how to use lookup tables and a star schema. Then he goes over why you need to eliminate two-way relationships when modeling and what you should do instead. He discusses creating visualizations from time series data and how to use groups, slicers, and custom tooltips effectively. He steps you through conducting a Top-N analysis, then concludes by explaining how to use the right amount of color.

This course was created by Madecraft. We are pleased to host this training in our library.

Watch quick videos to learn helpful, timesaving tips for how to use the features of Power Bl Online. Explore ways to eliminate obstacles and be more efficient using Power BI.

Learn how to use one of the most popular analytics tools available: Microsoft Power BI.