SQL Server Microsoft Excel Integration Tips
Charts
Connection Strings
Data
- Use Excel Parameters to Dynamically Export SQL Server Data
- Using Microsoft Query in Excel to Retreive SQL Server Data
Data Explorer
Export
File System
GeoFlow
Import and Export
- Export data from SQL Server to Excel
- Import Excel data into SQL Server using copy and paste
- Import Excel data with SQL Server Integration Services
- Insert, Update or Delete Data in SQL Server from Excel
Linked Servers
Power Query
- Extracting a SharePoint List with Power Query
- Introduction to Power Query for Excel
- Query Folding in Power Query to Improve Performance
Power View
- Automate field selection from SSAS Tabular Models in Power View reports
- Creating Power View Reports in Excel 2013
- Getting started with Power View Reports with SharePoint, Excel and SQL Server
- Teach Business Users How To Create Power View Reports With SQL Server Data Sources
PowerPivot
- Building Key Performance Indicators (KPIs) with PowerPivot
- Combining Data from Multiple Relational Data Sources into One Table in PowerPivot for Excel
- Compare Tabular Databases vs. PowerPivot
- Creating Hierarchies in PowerPivot for Excel
- Creating Linked Tables in PowerPivot for Excel
- Importing SQL Server Data from Multiple Data Sources into PowerPivot for Excel
- Introduction to PowerPivot for Excel and SQL Server
- PowerPivot Example with SQL Server 2012
- PowerPivot with Excel 2013
- Using source data from an SSRS report in PowerPivot for Excel
- Working with Columns and Properties in PowerPivot for Excel
PowerShell
R Language
Reporting
- Analyze SQL Server Results in Excel with Conditional Formatting
- Passing Dynamic Query Values from Excel to SQL Server
- SQL Server Reporting with Microsoft Excel
T-SQL