NEW FEATURES MORE

Search

Dan B.

Atlanta, GA

$50/hour

Tutoring in SQL Server, Matlab and R for Data Analysis

100+ Hours
Background check passed as of 4/10/15
4.9 average from 61 ratings
Great Tutor, Extremely Knowledgeable
— Sashi, Bronx, NY on 11/13/14

$50/Hour


Send a message explaining your needs and Dan will reply soon.

Response time: 3 hours

Contact Dan

Drew University
Mathematics

Education

Drew University (Mathematics)

About Dan

Modern business runs on data, and the tools used to handle that data are increasingly more complex. Students and professionals have shown a strong interest not only in getting started, but also in developing advanced skills with these tools. Although I custom craft tutorials for each student's unique skills and interests, very broadly my tutorials break down into these categories.

Excel

Excel, Microsoft's preeminent spreadsheet application, has as many different uses as there are businesses. Popular tutorial tracks include Introductory Excel, Excel for Financial Analysis, and Programming with Excel VBA. Other topics include Power Pivot pivot tables and Microsoft's new Power BI for exciting data visualizations.

Power BI

Microsoft's Power BI is the "new kid on the block" for visually exploring data, but there are a lot of details to master, including how to correctly organize and load data into Power BI's data engine. It's easy to get started; Microsoft has decided that the desktop version of Power BI will be a free download.

SQL

SQL is the native language of the relational database and an essential tool for people working with and analyzing data. Most students want a solid foundation in SQL working with a commercial platform like SQL Server. Some students push the limits with advanced analytical SQL queries.

Data Analysis and Business Intelligence

Few fields are as fast-moving today as business intelligence and data mining. Whether you are a professional looking to add new skills or a student just getting started, I can help you learn the principles and techniques SPSS, Matlab, and R.

My Background

I've been working in research and data analysis ever since graduating with a degree in mathematics from Drew University in New Jersey (summa cum laude). In 1997 I was cofounder of a company devoted to advanced training in computer programming, application development, and database technology. After leaving the company, I started my own consulting firm focusing on data technology. While I am a great admirer of Linux, the bulk of my commercial experience has been on the Windows platform.

I'm a Microsoft Certified Solution Developer (MCSD), skilled in both .NET development using C# and in database design and SQL development for Microsoft SQL Server. I've been developing SQL queries and program code for over 18 years. When a project is more math-oriented than development-oriented, I work with MATLAB or its open-source counterpart, SciLab. For math-related projects I also write code using Python or Microsoft's new functional language, F#. When I am not traveling to a corporate client site in my role as an independent consultant, I enjoy taking time to help out as a Wyzant tutor in Excel, data analysis, and software development.
Modern business runs on data, and the tools used to handle that data are increasingly more complex. Students and professionals have shown a strong interest not only in getting started, but also in developing advanced skills with these tools. Although I custom craft tutorials for each student's unique skills and interests, very broadly my tutorials Read more

Policies
Cancellation
24 hours notice required
Travel Radius
Travels within 20 miles of Atlanta, GA 30337
Background Check: Passed

"Great Tutor, Extremely Knowledgeable"

- Sashi, Bronx, NY on 11/13/14

"Patient and Knowledgeable"

- Lisa, Scottsdale, AZ on 1/12/17

"A+ tutor"

- Nicolas, New York, NY on 11/9/15

"Great Tutor"

- Ann-Marie, New York, NY on 2/12/15

"Great. Dan makes difficult and muddy database concepts clear."

- James, New York, NY on 11/19/14

"Great Tutor"

- Robert, Yonkers, NY on 8/1/14
Computer:
C#,
Computer Programming, Computer Science, MATLAB,
Microsoft Excel,
R, SPSS,
SQL
Business:
Microsoft Excel

Approved subjects are in bold.

Approved subjects

In most cases, tutors gain approval in a subject by passing a proficiency exam. For some subject areas, like music and art, tutors submit written requests to demonstrate their proficiency to potential students. If a tutor is interested but not yet approved in a subject, the subject will appear in non-bold font. Tutors need to be approved in a subject prior to beginning lessons.

C#

I have been a Microsoft Certified Solution Developer (MCSD) for over 10 years. This certification includes not only .NET programming, but also web development techniques and database technology. My experience with C# development and .NET began in the early testing phases before .NET was officially released as a programming and development environment. More recently, I have studied development using Microsoft's new programming language F# which is especially valuable for applications requiring advanced mathematics and analytical techniques.

Linear Algebra

I graduated college with a bachelor's degree in mathematics, summa cum laude. Since that time, I have used linear algebra extensively in the applied sciences. I have tutored people in linear algebra in the context of economic theory and the general linear model in statistics.

MATLAB

As a database design and data analysis professional, I must use many different tools, each of which has its unique primary strengths. I use Matlab when the mathematics required for a particular set of data goes well beyond that provided by tools like Excel. I also use Matlab for its graphics, which is more oriented towards research than the business-presentation style of Excel. Like many others, I use Matlab for exploratory data analysis, or EDA, where program code must sometimes be written for specialized functions, but writing a self-contained program using C# or C++ would not be cost-effective.

Matlab, of course, is a tool of enormous depth. Though I consider myself well-versed in the use of Matlab for data manipulations and graphics, I am less experienced in its use in partial differential equations and dynamics. I have no experience with Matlab's Simulink toolset.

I am also experienced with SciLab, which is an open-source mathematics program that shares much of the functionality of Matlab.

Microsoft Excel

My Excel experience is extensive, and ranges from developing custom menu ribbons to creating Add-Ins in both VBA (Visual Basic for Applications) and .NET program code. I have developed many data-centric workbooks using PowerPivot, which is a downloadable Add-In for Excel 2010 but which is part of the normal Excel installation for Excel 2013. PowerPivot empowers Excel users to develop many of the analytical and data visualization tools that in the past required the cooperation of Database Administrators.

SPSS

In my regular work I am primarily a database consultant and I work with tools like SPSS everyday and have considerable experience with the math and statistics used by SPSS in the analysis of data. SPSS is a very powerful program, but in the world of computer software "powerful" rarely means "easy to use". I've helped many students in the New York area get over the SPSS hurdle to analyze their data and achieve success with their coursework.

SQL

I've been working with SQL Server since version 6.5 in the mid-1990s. I have a good working knowledge of administrative tasks, but my primary skill is SQL query development, stored procedures and performance tuning. My consulting clients value my skill in dimensional modeling for data warehouses and advanced analytical SQL queries.

Since 2000, I have been teaching the staff of Fortune 500 companies and government agencies how to master the intricacies of SQL Server using the latest techniques.

Statistics

Professionally I spend a lot of time working on business analytics. My primary tool for this is Microsoft Excel, but I also use SPSS and the powerful open-source statistics package R. Most of my work uses techniques of multiple regression, but I am also familiar with analysis of variance (ANOVA) and analysis of covariance (ANCOVA).

Drew University
Mathematics

Education

Drew University (Mathematics)

Great Tutor, Extremely Knowledgeable

Dan has been extremely helpful in pointing out promising directions to go with my research, navigating and highlighting applicable topics in existing research, and great with helping me better understand and work with the data I have on hand.

— Sashi, Bronx, NY on 11/13/14

Hourly rate

Standard Hourly Rate: $50.00

Cancellation: 24 hours notice required

Travel policy

Dan will travel within 20 miles of Atlanta, GA 30337.