From Spreadsheets to DataFrames
Learn to transition from spreadsheets to Python DataFrames, exploring web scraping, data processing, analysis, and visualization using popular libraries like Pandas and Matplotlib. Gain skills for efficient data management and problem-solving.
Metaprogramming - From Decorators to Macros
Explore metaprogramming techniques in Python, from decorators and metaclasses to macros, with practical examples and insights into their applications and benefits.
Business Analytics Marathon - Tools for Exploratory Data Analysis
Explore essential tools for data analysis, including Power Query and Pivot Tables, with practical demos and insights into machine learning applications.
Visualizing Data - The Good, the Bad, and the Ugly
Explore effective data visualization techniques, from time series to deviations, using Excel, Power BI, and other tools. Learn to create impactful charts and avoid common pitfalls in data presentation.
DAX Formulas in Action
Explore DAX formulas for BI solutions in Excel and SQL Server. Learn to create calculated columns, measures, and effective PivotTable analysis through hands-on demonstrations.
End-to-End SQL Server PowerPivot
Explore SQL Server PowerPivot add-ins for Excel and SharePoint, enabling large-scale data analysis, multidimensional modeling, and collaborative business intelligence within familiar Microsoft tools.
PowerPivot - A Cool Reporting Tool
Explore PowerPivot for Excel to combine diverse data sources, create analytics, and overcome Excel limitations. Learn to import, pivot, and visualize data for self-service business intelligence.
End-to-End SQL Server PowerPivot
Explore SQL Server PowerPivot add-ins for Excel and SharePoint, enabling large-scale data analysis, multidimensional modeling, and collaborative BI solutions with scheduled data refreshes and IT management.
Modern Excel - The Supercomputer Hiding on Everyone’s Desktop
Discover game-changing Excel tools for data-driven decisions. Learn multi-source import, rapid data shaping, portable formulas, and insightful reporting techniques to supercharge your spreadsheet skills.
Handling Role Playing Dimensions in Tabular Models
Explore various methods for implementing role-playing dimensions in tabular models, including DAX expressions, with a focus on model maintainability and user experience in data analysis.
Inside the VertiPaq Engine
Explore VertiPaq engine internals, database architecture, and optimization techniques for improved performance and compression in SQL Server Analysis Services Tabular, Power BI, and Power Pivot.
Using C, C++ and Objective C Frameworks in Swift Apps
Learn to integrate C, C++, and Objective-C frameworks into Swift projects, expanding your app development possibilities. Discover setup techniques, memory management, and leveraging existing libraries for unique Swift applications.
Swift Expression Macros - A Practical Introduction
Practical introduction to Swift Expression Macros, exploring their implementation, benefits, and potential applications. Learn how to use macros effectively to extend Swift's capabilities without compromising code readability.
Metaprogramming 2.0
Explore Scala metaprogramming's evolution, current capabilities, and future prospects. Learn about Scala Meta, its applications, and improvements in macros for enhanced code analysis and manipulation.
Roll Your Own Shapeless
Explore advanced Scala type system techniques to recreate Shapeless framework elements, focusing on HList, context-dependence, and Peano arithmetic without macros.
Introduction to Code Generation with Scalameta
Explore scalameta for code generation in Scala. Learn basics, composable DSL, and advanced use cases. Includes live demo and discussion on potential applications and comparison with traditional macros.
Adventures in Metaprogramming - Macros versus Shapeless
Explore metaprogramming techniques in Scala, comparing macros, shapeless, and code generation to eliminate boilerplate and improve code maintainability for intermediate developers.
Bifurcation Without Schism - The Scala Ecosystem
Explore Scala's ecosystem duality: functional programming vs. practical development. Discover challenges, opportunities, and strategies for leveraging this unique community structure to create powerful libraries and a productive language.
Metaprogramming in Dotty
Explore advanced metaprogramming techniques in Dotty, the next-generation Scala compiler, to enhance code generation and manipulation capabilities for more powerful and flexible programming.
Asynchronous Streams in Direct Style With and Without Macros
Explore asynchronous streams in Scala using for-comprehensions, scala-async, and macro-based implementations, with insights on Reactive Streams and Project Loom.
Magnum - A "New Look" for Scala 3 Database Clients
Explore Magnum, a new Scala 3 database client combining macros and structural types for typesafe, IDE-refactorable SQL interfaces across JDBC-supported databases.