Connecting SQL Tables and data in Excel spreadsheets
For more videos on technology, visit http://www.Techytube.com
By Jayanth@techytube
SQL server is a powerful database platform, this means that it can also be complex to understand and work with. However the major users of the data in the database are still a non-technical business user. A key problem that most business users face when it comes to working with SQL Server is the dependency on an IT professional to query and return the data in a CSV format or Excel sheet. With the ability of MS Excel to be able to connect to SQL Server via the ODBC Drivers allows users to work with SQL tables within the familiar Excel User interface. This approach allows users to be productive with SQL Server without having to know Transact SQL. The feature set provided with MS Excel and newer versions of SQL allow business users to do much more than just query the database. These include the ability to query and view data in pivot format for large data sets using power pivot. Perform ad hoc calculations to underlying data and create models that are specific to their business case using the powerful DAX language. Embedding reports in SharePoint services using PowerPivot.
Working with Excel is one of the most powerful ways that end users can work with MS SQL Server to deliver results faster and improve productivity.
Видео Connecting SQL Tables and data in Excel spreadsheets канала techytube
By Jayanth@techytube
SQL server is a powerful database platform, this means that it can also be complex to understand and work with. However the major users of the data in the database are still a non-technical business user. A key problem that most business users face when it comes to working with SQL Server is the dependency on an IT professional to query and return the data in a CSV format or Excel sheet. With the ability of MS Excel to be able to connect to SQL Server via the ODBC Drivers allows users to work with SQL tables within the familiar Excel User interface. This approach allows users to be productive with SQL Server without having to know Transact SQL. The feature set provided with MS Excel and newer versions of SQL allow business users to do much more than just query the database. These include the ability to query and view data in pivot format for large data sets using power pivot. Perform ad hoc calculations to underlying data and create models that are specific to their business case using the powerful DAX language. Embedding reports in SharePoint services using PowerPivot.
Working with Excel is one of the most powerful ways that end users can work with MS SQL Server to deliver results faster and improve productivity.
Видео Connecting SQL Tables and data in Excel spreadsheets канала techytube
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Connect SQL to ExcelCreating a Database in Excel [Excel is a Database]Introduction to SQL Programming for Excel Users Part 1 - OverviewWhat is SQL? [in 4 minutes for beginners]How to Automate Excel Reports Using SQL [CSV to SQL to Excel Automation]Import Data from SQL Server to Excel | Create a report in secondsExcel Import MySQL Table with ODBC Database QueryHow Power Query Will Change the Way You Use ExcelExcel Alternative: How to use SQL to perform EXCEL tasks (SQL for Data Analysis)MSPTDA 11: Power Query to Import from SQL Server Database in Excel or Power BI DesktopHow to Pull Data from SQL Server to excel to create your own report, excel sql queryMS Excel - Import Live Data From Web to ExcelConnect SQL Server from Excel and retrieve dataImporting XML Data Into ExcelQuerying SQL Server Data in Excel with a ParameterSonicwall SSLVPN WhitelistingRunning a SQL Stored Procedure in Excel without VBAHow to Use SQL with Excel using PythonHow to Export Table and Query Data to an Excel 2010/2013 File Using SSIS 2012Creating Easy Data Entry Forms in Excel