All Posts by n.ashutosh

Get Free Copies of the Tableau book

Tableau Data Visualization Cookbook was published on August 26th and my publisher, Packt Publishing, is offering free copies of the book in exchange for reviews on Amazon or on your blog. With this book, you can: Quickly create impressive and effective graphics which would usually take hours in other tools See lots of illustrations to […]

Continue reading
learning skills

Learning to Learn skills

Learning skills is hard and takes a lot of efforts to learn them well. I have used these following steps to learn various things such as speaking, data visualization, Excel, writing. It is painful going through this process, but at the end, the joy of knowing a skill easily removes that pain. Here’s your roadmap: […]

Continue reading
Anscombe's quartet

How to Perform Linear Regression in Excel

These instructions read better in this Linear Regression Excel Directions PDF file Linear Regression in Excel Introduction Linear regression is a statistical technique used to observe trends, determine correlation, and predict future observations. The underlying principle of this technique is called the least-squared, which is the process of minimizing the distance between the predicted value […]

Continue reading

2 Linked Table Query Returning Incorrect Results

We had this annoying problem: a simple query in Access to a linked table (using ODBC and MS SQL server) returned incorrect results, though the same query returned correct results in MS SQL server. By incorrect I mean the field values were different, so rather than returning AZ, the query returned BZ (some other value […]

Continue reading
1 5 6 7 8 9 21
>