DAX is essential for working with data and data models in Excel and Power BI. Many analysts start building complex DAX formulas, without a solid grounding in DAX basics, context manipulation, and time intelligence. In this course, we’ll quickly review the basics of DAX formulas for creating Measures and Calculated Columns. We’ll explore the difference between DAX functions … [Read more...] about Intermediate DAX & Time Intelligence
Finance
Market Microstructure
Within this course you will learn about price formation and liquidity in securities markets. You will discover the determinants of market depth and security trading. In particular, the course focuses on price formation and liquidity in securities markets. The main issues covered are how to measure trading costs; how security prices, their liquidity and speed of price … [Read more...] about Market Microstructure
Cloud FinOps
Placeholder for empty Reading"Fundamentals of Cloud FinOps" is a short course designed to navigate the complexities of cloud computing economics, focusing on optimizing costs while leveraging the full power of the cloud. It comprises four modules that sequentially build knowledge from cloud computing basics and pricing strategies to the specialized field of Cloud Financial … [Read more...] about Cloud FinOps
Compare Stock Returns with Google Sheets
In this 1-hour long project-based course, you will learn how to compare the performance of different securities using financial statistics (normal distributions) and the Google Sheets toolkit to decide which one performed the best in terms of risk-to-return (risk-to-reward) metrics. This will teach you how basic risk management using quantitative analysis is done and is applied … [Read more...] about Compare Stock Returns with Google Sheets
Power Query Fundamentals
In this online Power Query Fundamentals course, we’ll explore the world of data transformation and automation. You’ll learn to extract data from multiple different sources, and transform it into layouts more suited to analysis. We will show you how to automate data connections and transformations, as well as how to extract and consolidate data from multiple files. Finally, … [Read more...] about Power Query Fundamentals
