Apache Arrow and Substrait - The Secret Foundations of Data Engineering
Explore Apache Arrow and Substrait's impact on data engineering, including their role in interoperability, query planning, and building efficient database systems with minimal code.
Unlocking the Power of What-If Analysis for BI, Data, and AI with Taipy
Explore practical implementation of what-if analysis using Taipy for data exploration and decision-making. Learn to assess outcomes by varying input parameters in datasets.
Interactive, Animated Reports and Dashboards in Streamlit with Ipyvizzu
Create interactive, animated reports and dashboards using Streamlit and ipyvizzu. Learn to build data apps that non-data scientists can explore, enabling them to apply business expertise and find insights.
Using NLP to Detect Knots in Protein Structures
Explore how NLP and machine learning detect protein knots from amino acid sequences, uncovering their impact on function and stability using Python-based tools like Biopython and Hugging Face.
We Can Get More from Spatial, GIS, and Public Domain Datasets
Explore spatial data analysis and interpolation techniques using pyinterpolate for insights on rental prices, pollution mapping, and socio-economic factors at various scales.
Windows Azure SQL Database Design - Silver Lining and Dark Side
Explore Windows Azure SQL Database design, covering editions, limitations, costs, data types, and modeling. Learn 10 tips for effective design and migration strategies.
Building Your T-SQL Tool Kit - Window Function Fundamentals
Explore T-SQL window functions to enhance data analysis skills, improve query performance, and solve complex business problems efficiently.
Microsoft's Data Platform
Explore Microsoft's data platform vision and strategy, including latest innovations and future directions in database technology and analytics.
Data Mining in SQL Server Analysis Services
Explore advanced data mining techniques using SQL Server Analysis Services to uncover hidden patterns and gain valuable insights from your datasets.
Business Analytics 2013 - From Data to Insight - Views from Microsoft Finance
Explore Microsoft Finance's approach to transforming data into actionable insights, enhancing decision-making and business performance through advanced analytics techniques.
Dashboard Design Do's and Don'ts
Learn essential principles for creating effective business dashboards, including best practices and common pitfalls to avoid in data visualization and design.
Business Analytics 2013 - Visualizing Data with Power View
Explore data visualization techniques using Power View to create interactive reports and enhance business analytics capabilities.
24HoP Spanish - Procesando XML de estructuras complejas con SSIS
Aprenda a procesar estructuras XML complejas utilizando SQL Server Integration Services (SSIS) para una eficiente manipulación y transformación de datos.
Principios de diseño para procesos de ETL
Aprende principios de diseño para procesos ETL eficientes, abordando desafíos comunes y mejores prácticas para una arquitectura sólida en el manejo de datos.
24HoP Spanish - Cuadros de Mando El todo es más que la suma de las partes
Aprende a crear cuadros de mando efectivos en español, explorando cómo integrar elementos para obtener insights valiosos más allá de la simple suma de datos.
Analizando patrones con SQL, Excel, Azure ML, R y más
Explora técnicas avanzadas de análisis de patrones utilizando SQL, Excel, Azure ML y R para obtener insights valiosos y mejorar la toma de decisiones en ciencia de datos.
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.
Business Analytics Marathon - Moving From Excel to Power BI
Transition from Excel to Power BI for advanced business analytics, covering reporting, visualization, and SharePoint integration.
Making Informed Decisions
Learn to create effective business analytics dashboards, focusing on data scope, strategic vs operational metrics, and best practices for informed decision-making.
Business Analytics Marathon - Implementing Data-Based Decision Making
Implement data-driven decision-making strategies through advanced analytics techniques and best practices for effective business intelligence.
Creating Outstanding Spreadsheet Models
Learn to create outstanding spreadsheet models with expert tips on layout, naming conventions, error handling, and data visualization for effective business analytics.