Host and co-creator of Radiolab, More Perfect, Dolly Parton’s America, and more, Jad Abumrad has inspired the sounds of thousands of podcasts and radio shows around the world (Kerning Cultures Network shows included). In this course, adapted from the podcast al empire, Hebah Fisher talks with Jad about his career as a storyteller and student of curiosity. Jad describes childhood influences and what it is to straddle the line between being Lebanese and being American. He discusses what led him to be a storyteller, then goes into his first successful pitch to NPR and the beginnings of Radiolab. Jad talks about receiving the MacArthur “Genius” Grant and his plans to continue Radiolab. He concludes with what guides his curiosity and how he avoids burning out.

Note: This course was created by al empire. We are pleased to host this training in our library.

Are you wondering how a podcast can benefit your organization? Could you use it for marketing? What about PR and corporate communications, or even talent development? How can you make your podcast secure? Instructor Danny Ozment answers these questions and more, in this course. Danny explains several important reasons why podcasts work, such as building thought leadership and establishing evergreen content. He goes into some podcast uses that are specific to enterprise podcasting, like how you can use podcasts for internal training and for conveying messages and statements from organization leaders, then concludes with practical advice on developing a plan for your enterprise podcast.

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.

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.

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.

Power BI is a powerful data analytics and visualization tool that allows business users to monitor data, analyze trends, and make decisions. Every month, Microsoft pushes Power BI updates out to the end users, and the growth of Power BI is a key part of Microsoft’s current strategy. This course showcases existing AI and machine learning capabilities available directly in accessible Power BI functionalities. Data analytics and business analysis expert Helen Wall gives you a useful overview of Power BI, then dives into the steps to configure Power Query and your data model. Helen steps through analyzing single variables and shows you the tools and techniques to measure relationships between variables. She shows you visuals that you can use to pose and answer questions in Power BI, explains useful techniques to enhance your analysis of time series data, and walks you through some best practices for sharing your analysis.

Almost every presentation is more impactful with graphics, animations, or just simple pictures. Visual presentations simply leave a bigger impression than words alone. And while most people who give presentations might not have a background in design or any visual-related field, with PowerPoint, you don’t need to be a designer to create great-looking presentations. In this course, George Maestri shows you the tools you need to create, edit, and share compelling and highly-visual presentations. He gets into all the basics that modern presentations should consider, like layouts and colors, text and tables, images and graphics, and animations and videos. George also covers organizing your slides so they look professional and clear. Lastly, he gives tips on how to deliver your presentations, from adding speaker notes that only you can see, to automating a presentation and ways to present on multiple screens, to methods for sharing your presentation for the audience to reference or distribute later.

Enhance your PowerPoint abilities—and get on-the-spot solutions to common questions—with this collection of quick, bite-sized tutorials. Each video is self-contained and about one to two minutes in length, making it easy for you to squeeze in a few learning opportunities throughout your workday. Instructors Jess Stratton, Garrick Chow, and Nick Brazzi share tips and tricks that can help you work smarter with this popular presentation platform. Learn how to add a watermark to slides, turn your presentation into a video, add transitions and animations, create PowerPoint templates, and much more.

Making your PowerPoint slides more polished and engaging is easier than you think. In this short course, presentation guru Jole Simmons shares some helpful tricks to take your PowerPoint game to a new level. First, Jole teaches how to take both the presenter and the audience into account in your design approach. Next, learn to identify the main points of the story you’re trying to tell in PowerPoint. Find out how to go the extra mile in making design calls. Explore some ways to convey your information without forcing everybody to read what's on the slide. Learn how to break information into threes, for better learning retention. Jole also discusses how to make sure your presentation is inclusive and geared towards a variety of people. Then, discover ways to add life to your slides with a well-placed surprise. Jole explains continuity, flow, and how to bring it all together.

PowerShell is a great tool for managing core infrastructure, general server and client administration, specific Windows services, and even elements of Azure. Jump-start your career and your IT environment by learning to use the latest version, PowerShell 7. Instructor Liam Cleary shows you how to ensure you’re using the administrator option in PowerShell, how to modify the PowerShell console, and how to choose a development environment. He introduces new features in PowerShell 7 and walks you through how to use PowerShell modules. Liam explains how to choose and execute commands, how to use variables, and how to create and manage objects. He steps you through how to enable the execution of scripts, how to create a reusable script, and how to create parameters. Liam covers different commands to use and how to execute them, then goes into when to use JavaScript Object Notation (JSON) and how to import it. In conclusion, he discusses when to use remoting and the implications of doing so.

Influencing is happening in every meeting you have. Other people are influencing you, and you are influencing them. It's a vital life skill. In this course, instructor Chris Croft brings an engineer's mind to the subject. Chris presents a six-step process that you can follow in any influencing situation, with techniques that you can use at each stage, depending on the type of person you would like to influence. He explains how you can use this process to prepare for meetings and get the best from every relationship, whether at work or at home, with customers, bosses, suppliers, friends, or relatives. Chris goes over the ethics of influencing, as well. Understanding the psychology of influencing helps you to build better relationships and get better outcomes with everyone you meet.

Note: This course was created by Chris Croft. We are pleased to host this training in our library.

Are you a data science practitioner, looking to develop or enhance your skills in predictive analysis and data mining? This course provides several “big picture” insights, via instructor Keith McCormick, a veteran practitioner who has completed dozens of real-world projects. Keith begins by introducing you to key definitions and processes that you will need to complete the course successfully. He steps you through defining the problem you need your predictive analysis to address, then focuses on how to make sure you meet the data requirements and how good data preparation improves your data mining projects. Keith dives into the skill sets and resources that you need and the problems you will face. Then he goes over the steps to find the solution and put it to work with probabilities, propensities, missing data, meta modeling, and much more. Keith finishes up with detailed explanations of CRISP-DM and Tom Khabaza’s nine laws of data mining, plus Tom’s new 10th law.

Nothing is more important to the future of predictive analytics teams than proving their projects have long-term value. Measuring the return on investment (ROI) often can help turn analytics into a visible profit center for your organization. Estimating ROI early—before a project even begins—can also help fast-track approval. Here Keith McCormick shows how to address ROI both before and after the predictive model is built. Learn how to create your estimate before the project starts by estimating the overall size of the problem, assigning value to possible outcomes, and judging the impact of model performance. Keith then shows a different method for calculating ROI after the model is built, during the evaluation and deployment phases, and provides tips for the ongoing monitoring of the project. He also takes a retrospective look assessed one year after model deployment. These two strategies will give you the data you need to get buy-in for your projects and provide ongoing metrics on their performance.

Premiere Pro 2021 is here. Learn all about the new features in the latest version of this premiere editing program. Instructor Rich Harrington starts with the new camera support and export options, which make it easier to work with a wider range of devices and file formats. Then learn how to intelligently reframe footage with the AI-powered Auto Reframe effect, and leverage other editing improvements such as increased audio range and temporal and spatial interpolation on keyframes. Rich also reviews the enhancements to the Essential Graphics panel—the new home of motion graphic templates (MOGRTS)—for text formatting and layer management.

This course was created by Rhed Pixel. We are pleased to offer this training in our library.

There are many reasons for shooting with multiple cameras. Perhaps it's to save time or achieve multiple angles. Or it might be to capture what's happening across a large area, like a sports arena or the stage during a concert. Luckily for editors, Adobe Premiere Pro supports editing and syncing footage from multiple cameras in situations like these. The multi-camera editing process in Premiere is similar to live switching that occurs in mobile studios and newsrooms, and helps speed up the post-processing workflow. In this course, Rich Harrington reviews that workflow, showing you how to ingest footage and align it properly, as well as finish your video with color-correction and color-matching techniques.

Compression affects every aspect of video work. Compress too much, and you'll lose quality. Compress too little, and the file size is too big. Use the wrong compression, and your client cannot see the video at all. In this course, instructor Luisa Winters explains what compression is, how to use it, and how to optimize it to give your work the greatest impact. Learn how to finesse export settings in Premiere Pro and Adobe Media Encoder for the best-looking video.

Learn new techniques to improve speed and efficiency while editing and performing everyday actions in Adobe Premiere Pro application panels. Instructor Christine Steele covers topics like Source, Program and Timeline panel editing techniques, streamlined effects and finishing skills, and alternative workflows and shortcuts that reduce repetitive actions. Christine shows you how to improve fluidity when performing tasks with standard tools, as well as learning to use less-well-known menu items. The course is set up for quickly learning new techniques, gaining speed while editing, and enhancing recall of the available tools and shortcuts. With Christine’s tips, you can improve your performance and agility in Premiere Pro, so you can stay focused on creative efforts and avoid more cumbersome steps to achieve a desired result.

If you’re looking for work as a junior data analyst, engineer, or scientist, this course gives you the best techniques to land jobs in data science. Instructor Ben Sullins explores a hiring manager’s mindset and shows you how to prepare a demo that you can bring to your job interview. Ben explains some best practices for being physically and mentally healthy and well-prepared for your interview. He covers what to bring to your interview, then goes over follow-up methods and steps you should take to negotiate what you want most from an offer. Ben’s methods give you the confidence and practice that you need to land a job in data science.

Note: This course was created by Ben Sullins and Free the Data Academy. We are pleased to host this training in our library.

The success of an audit is measured solely by the opinion of an independent auditor. But preparing the paperwork, people, and processes to support an audit is also crucial to ensure it runs smoothly. In this course, financial expert Jason Schenker explains how preparation, transparency, project management, communication, and feedback integration are critical elements of audit success. He introduces a big picture view of an independent audit, the laws and regulations governing the process, and that data you need to gather to make sure everything runs smoothly. Company leaders and staff alike can use this course to understand the value of the audit, the information that is important to share, the roles people play in the process, and what to do with auditor feedback once the audit is complete.

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