Explore the techniques to handle very large data in Excel from Azure. Use any of Microsoft Azure storage options like HDInsight (Hive), CosmoDB, Azure Storage or MongoDB in Azure with Azure Analysis Services from Excel and Power Query.
Python and Excel are both powerful tools for data exploration and analysis. They're both powerful, and even more so together. There are different libraries that have been created over the past several years to integrate Excel and Python or vice versa.
Comparing two data sets in Excel is quite easy using Power Query and the Merge operation. The Merge operation can perform inner and outer join operations on your data. This article will explain the different types of operations.
Execute PowerShell command (cmdlets) directly from T-SQL on SQL Server. Also execute PS1 script files from T-SQL on SQL Server and optional store the data in a SQL Table.
While Power BI has the technology to allow users to import data from many data sources easily, many data analyst and business users don't realize that it is just as easy to export data from Power BI. I will show you how.
Adding a few lines of VBA code to Excel will allow you to dynamically export your data in a Worksheet to a Microsoft SQL Server without the need of a programmer.
In our world of data analytics and big data, there is no getting away from our beloved data crunching and wrangling tool: Excel. However, with large data sets, Excel starts to huff and puff. These 10 tips will help crunch your data for the last minute meeting like a pro.
Create beautiful custom control radio buttons and checkboxes for your iOS (iPhone, iPad) applications. Follow this simple tutorial to create radio buttons and checkboxes that fit the style of your app and requires very little code.
Open any PDF directly in an iOS application for reading. This simple sample iOS iPhone app provides the code and detailed instructions.
Learn to create PDF documents using the APIs in the iOS UIKit. Use the UIGraphicsBeginPDFContextToFile and the UIGraphicsBeginPDFContextToData to quickly create and save PDF files with this sample iOS iPhone app.
Run WMI queries and process or another DOS or Windows process from SQL Server using the SQL xp_cmdshell function. This tutorial walks you through how to setup xp_cmdshell on the server and execute different types of queries and storing those values in tables.
Use the CommandLine, VBScript, or JScript to export a Windows Registry or keys.
A free and complete software development proposal template with budget, ROI and CAGR formulas and instructions. Detailed instructions to help you prepare a winning software development proposal.
Reduce Excel file size using this techniques like file compression, data management, switching to a binary format and using PowerPivot or PowerQuery.
Create AVPlayer applications for iPAD that uses AirPlay. This tutorial provides complete instructions
This tutorial demonstrates how to display data in a detail view controller for an iOS app, based on the selection in the UITableView.
This Storyboard Connections tutorial provides insight on how to create connection in a Storyboard, set delegates, add code to interact with the different objects. It is designed for new programmers or at least programmers just learning the technology. It also show how to dismiss the keyboard suing...
It is easy to create standalone application using C# or even VB.Net. This tutorial provides the step by step instructions on how to create your own.
There are several ways to use Objective-C to read, write and create files and directories. This tutorial presents one way, which is adapted for the IOS 5 SDK.
(c) klanguedoc 2010. iOS SQLite Database is a tutorial that demonstrates how to create an iOS iPhone and iPad applications with a SQLite database.
This tutorial demonstrates how to make a silent connection using VBA (or Visual Basic), either from an Excel worksheet or VB client. The tutorial uses the BAPI Control and SAP Logon Control, both of which, are included with the SAPGui and RFC SDK.
This is a tutorial on using the SAP .Net Connector, NCO 188.8.131.52 for .Net 4 and Visual Studio
Since getItemIndex doesn't return a match lookup value,instead always returns -1, this solution is a great workaround, even on long lists
SQL Server offers many different technologies for system integration. This tutorial demonstrates how to link an Excel 2007 file with SQL Server 2008.
The Transact-SQL language has many far fetched functions and commands. This tutorial show how to use cmdshell to execute DOS commands and insert the results into a table.
How to Develop an Excel App using the VSTO Interop services (com) and C#. This hub also demonstrates how to add a ribbon and interact with the app from the ribbon.
Transact-SQL boast many specialized stored procedures, enabling the developer or administrator to interface with every part of the Microsoft platform. This tutorial presents some example on how -to use vbscript to obtain information about the file system (files, directories, attributes)