SQL Azure Database
Explore SQL Azure Database fundamentals, features, and best practices with expert Vitor Faria Tomaz in this comprehensive Portuguese-language session.
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.
Create Amazing 3D Topographic Maps in Excel
Create stunning 3D topographic maps in Excel using Power Query and 3D Maps. Learn practical applications and advanced techniques for data visualization and analysis.
Modular Data Extraction and Integration Patterns
Explore modular data extraction and integration patterns for efficient business analytics, enhancing data-driven decision-making processes.
Hacking Exposé Too - Just How Transparent is TDE?
Explore Transparent Data Encryption (TDE) in SQL Server, its implementation, and potential vulnerabilities through hands-on demonstrations and practical insights.
Index Internals - RowStore, ColumnStore, and NoStore
Explore index internals in SQL Server, covering RowStore, ColumnStore, and NoStore structures. Learn when to use each type and understand their performance implications.
Building a Scalable Analytical Solution Using IaaS and Elasticsearch
Learn to build a scalable analytical solution using Infrastructure as a Service and Elasticsearch, exploring key concepts and best practices for efficient data processing and analysis.
Taking the Scare out of Monster Reports - Pam Shaw
Learn techniques to simplify complex reporting tasks, focusing on breaking down large projects, handling disparate data, and creating efficient dashboard and control table solutions.
Integrating SQL Server Analysis Services with Hadoop
Explore the integration of SQL Server Analysis Services with Hadoop, focusing on leveraging big data for enhanced business intelligence and analytics capabilities.
Upgrade and Migration Planning BI Features for SQL Server 2014 and 2016
Explore upgrade and migration strategies for SQL Server 2014 and 2016 BI features, focusing on planning and implementation best practices for seamless transitions.
Optimize All Data with a Modern Data Warehouse Solution
Explore modern data warehouse solutions for optimizing data lifecycle, enhancing business insights, and maximizing value from your data infrastructure.
Take the SQL Server Index Quiz
Explore SQL Server indexing through an interactive quiz, covering non-clustered indexes, query optimization, filtered indexes, and indexed views. Gain practical insights and best practices.
50 Things All SQL Server Developers Need to Know
Discover 50 essential SQL Server development tips, covering database design, T-SQL best practices, and query optimization techniques for improved performance and efficiency.
7 Tips to Performance Tuning, Optimization, and Everything
Learn essential performance tuning and optimization techniques for databases from expert Pinal Dave. Discover practical tips to enhance efficiency and solve common challenges.
SQL Server Internals - The Practical Angle
Explore SQL Server internals from a practical perspective, focusing on performance optimization and efficient database management techniques.
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.
The Top 8 Reasons for Your Transaction Performance Problems
Explore the top 8 causes of transaction performance issues and learn effective strategies to identify, troubleshoot, and optimize database performance for improved efficiency.