Dark Matter - Domain Experts & Nextgen Spreadsheets Are Our Future
Unlocking organizational potential through domain expertise and advanced spreadsheets. Learn to leverage existing knowledge, improve data strategies, and turn Excel into a competitive advantage.
Extending Your Hadoop Implementations to the Cloud
Explore cloud-based Hadoop deployment benefits, including scalability and cost-efficiency. Learn to integrate on-premise and cloud implementations for optimal performance and flexibility.
The Modern Data Warehouse
Explore Microsoft's approach to evolving data warehouse infrastructure, addressing explosive data growth and new data types. Learn about scale-out technologies, in-memory performance, and Hadoop integration.
Using Amazon's Cloud for the SQL Server Professional
Explore Amazon Web Services for SQL Server pros: EC2, S3, RDS, NoSQL, and more. Learn to leverage cloud storage, virtual machines, and PaaS solutions for efficient data management and processing.
Introduction to Data Mining in SQL Server Analysis Services
Learn to create and integrate data mining models in SQL Server Analysis Services for customer prediction, marketing optimization, and forecasting using various algorithms and tools.
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.
Developing and Managing a Business Intelligence Semantic Model in SQL Server Analysis Services
Learn to create, manage, and troubleshoot BI Semantic Models using SQL Server "Denali" features, with PowerPivot as a starting point for enhanced business intelligence capabilities.
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.
SQL Server 2016 Reporting Services & Mobile BI
Explore modern reporting with SQL Server 2016, featuring enhanced paginated reports, mobile BI, and integration with Power BI. Learn to create interactive, responsive reports for various platforms.
Treasure Map - Choosing the Right Algorithm in Azure ML
Discover how to select optimal algorithms in Azure ML for data analysis and predictive modeling, enhancing your machine learning capabilities and decision-making processes.
A Lap Around Columnstore and 2016 Operational Analytics
Explore Columnstore and 2016 Operational Analytics in SQL Server, focusing on performance improvements and real-time analytics capabilities for data-driven decision making.
SQL Server 2016 Hero Features in Action - Full Lifecycle of Financial Data
Explore SQL Server 2016's hero features, including record-breaking performance, enhanced availability, in-memory OLTP, and secure data protection, with practical applications in financial data management.
Relational Databases vs Non Relational Databases vs Hadoop
Explore the differences between relational, non-relational databases, and Hadoop, covering origins, key features, use cases, and Microsoft's data platform solutions.
Using JSON with SQL Server 2016
Explore JSON integration in SQL Server 2016, covering history, examples, support features, and practical applications for efficient data handling and querying.
A Gentle Introduction to Data Analytics in SQL Server 2016
Explore data analytics using SQL Server 2016, comparing it to BI and data science. Learn to organize data, use Power BI, R, and Analysis Services for exploration and visualization techniques.
What's New in SQL Server 2016 Analysis Services
Explore new features in SQL Server 2016 Analysis Services, including Extended Events, Tabular Mode enhancements, DAX functions, and Direct Query improvements for more powerful data analysis.
Common Data Science Mistakes
Explore common pitfalls in data science, from data preparation to analysis. Learn to avoid mistakes in statistics, outlier handling, and visualization for more accurate insights and predictions.
Turning Membership Surveys Into Action - Predictive Analytics
Learn to transform membership survey data into actionable insights using factor analysis and predictive modeling techniques for more effective decision-making and stakeholder engagement.
Digital Storytelling with Power BI
Learn to leverage Power BI's features for effective data storytelling, guiding users to better understand their information through visualization and narrative techniques.
Data Storytelling 101
Learn effective data storytelling techniques to create impactful visual narratives, focusing on key elements like goal-setting, snapshots, and actionable insights for compelling business intelligence presentations.