Excel Data Masterclass Archives - KuduTek.com

Category Archives for "Excel Data Masterclass"

Export Update SQL Server table data with Excel

Learn how to Export and Update SQL Server table data using Excel Step by Step

This is a long video but I really wanted to try and make my steps and explanations as clear as possible to follow. I hope that you will this video informative and helpful in your endeavor to develop an Excel tool to export, insert and update SQL database data using Excel. Please leave comments below and let me know what you thought of the video and if you have any questions.

PART 1:

This will be the first part of my video training series where I will teach you how to Export and Update SQL Server table data using Excel in a step by step approach. In this first video I will show you how to add a button in Excel with VBA code behind the button that will export SQL data from an SQL table out of the AdventureWorks2014 sample SQL Server database.

Continue reading

Excel Data Intelligence and Visualization Ninja

Follow Jon Muller at Kudutek.com for Excel SQL and Data Tips and Tricks

In recent years most businesses have started to take business analysis to the next level by adopting various data visualization and analytics solutions, methodologies and technologies. Solutions like Tableau, PowerBI, SSRS, InetSoft and QlikView, to mention only a few, are widely used as data visualization tools.

However, many businesses struggle with these solutions because it either becomes costly or because they simply do not have the people with the necessary skills in-house to implement these solutions effectively.

From my own experience most of these products have impressive capabilities, however the learning curve is steep. You see companies send their employees out on a 2-5-day course to learn these tools hands-on. However, so much information is conveyed, and people need to digest it. They do some quick exercises based on ideal demo data and they get a certificate for successfully completing the course and once they return to their post at work, guess what? …

Continue reading

7 reasons why Excel is great for database data bulk editing

Follow Jon Muller at Kudutek.com for Excel SQL and Data Tips and Tricks

Excel spreadsheets facilitate the overall bigger picture of the data on hand, all in one familiar sheet, and gives the user “data situational awareness”. Therefore it is easier for the user to make data cleaning and standardizing easier because the user can consider all the data in the same context.

It enables the data project owner to share spreadsheets with other individuals, in different departments, to review and edit the data in familiar Excel within their specific area of focus and data knowledge, without having to be logged into a specific software program.

Enables separation of data cleanup work from specific software program user login sessions.

The Excel approach eliminates multiple GUI steps to view, edit or add data.

Excel makes it easier to do data batch validation before actually posting data back, or inserting new data into database.

The use of copies of an Excel file for before and after serves as a simple archiving and backup solution of original data and data revisions. It adds a lot of flexibility.

Makes it easy to copy data from source to destination databases.

Flexibility and versatility of Excel functions for ad hoc data sort, filter, find and replace, cut or copy and paste, Excel data validation features, the sky is the limit!

Upcoming Excel Data Masterclass Videos

Follow Jon Muller at Kudutek.com for Excel SQL and Data Tips and Tricks

Hi, my name is Jon Muller, founder of the company KuduTek.

About 2 years ago I posted my first video on my youtube channel with the long title: Bulk Update Data with Excel | Excel SQL Database Update and Insert Utility.

I created that video because I wanted to promote the concept of using Excel as a viable and practical solution to edit and insert data in a SQL database in bulk. I also wanted to use that opportunity to promote my company KuduTek and my excel consulting service, and showcased the concept through demonstrating a specific example of how I developed the so-called “e-automate Equipment Maintenance Utility”.

Continue reading

Video: SQL Bulk Update Data with Excel

Follow Jon Muller at Kudutek.com for Excel SQL and Data Tips and Tricks

Excel is an excellent tool for bulk data updating and importing into SQL databases. It may sound unsophisticated, but Excel is a powerful yet simple solution for bulk data editing. No third-party programming is involved other than using SQL and Visual Basic for Applications (VBA) – which are already part of Excel. Sometimes the simplest solution is the most effective.

You can see a demonstration of how this works here:

Continue reading
>