Category Archives: Data Analysis
What type of chart to use to compare data in Excel
Following are the best chart types for comparing data in excel: Column Chart, Bar Chart, Line Chart, Combination Chart. If you want to compare 2 to 4 data series then use a clustered column chart....
Following are the best chart types for comparing data in excel: Column Chart, Bar Chart, Line Chart, Combination Chart. If you want to compare 2 to 4 data series then use a clustered column chart....
Data Visualization in Excel Tutorial
Data visualization is the presentation of data (both qualitative and quantitative data) in graphical format. In Excel, charts and graphs are used to make a visual representation of data....
Data visualization is the presentation of data (both qualitative and quantitative data) in graphical format. In Excel, charts and graphs are used to make a visual representation of data....
KPI Meaning (What is a KPI?), Examples & Calculations – Tutorial
Beginner's guide to Key Performance Indicators with examples. Learn to find Good KPIs and determine KPI performance. Learn about internal & external KPIs....
Beginner's guide to Key Performance Indicators with examples. Learn to find Good KPIs and determine KPI performance. Learn about internal & external KPIs....
Best Excel Charts Types for Data Analysis, Presentation and Reporting
Learn to select best Excel Charts for Data Analysis, Presentation and Reporting within 15 minutes. Learn about the various excel charts types....
Learn to select best Excel Charts for Data Analysis, Presentation and Reporting within 15 minutes. Learn about the various excel charts types....
What You Should Know about Historical Data in Web Analytics
Historical data in web analytics is important because it help in optimizing marketing campaigns but when interpreted incorrectly can result in monetary loss....
Historical data in web analytics is important because it help in optimizing marketing campaigns but when interpreted incorrectly can result in monetary loss....
Making Good Marketing Decisions Despite of Faulty Analytics Data
Learn to make good Marketing decisions despite of Faulty Analytics data....
Learn to make good Marketing decisions despite of Faulty Analytics data....
Google Analytics Pivot Tables – Tutorial
Pivot tables are hidden gems in Google Analytics reports. They are extremely powerful data summarization tools and are commonly used in spreadsheet programs like Microsoft Excel. Through pivot tables you can quickly summarize data in desired format a...
Pivot tables are hidden gems in Google Analytics reports. They are extremely powerful data summarization tools and are commonly used in spreadsheet programs like Microsoft Excel. Through pivot tables you can quickly summarize data in desired format a...
How Google Analytics Attributes Conversions to Direct Traffic
Today I am going to reveal one of the most kept secret in Google Analytics which will fundamentally change the way you look at revenue and conversions generated through direct traffic, for good....
Today I am going to reveal one of the most kept secret in Google Analytics which will fundamentally change the way you look at revenue and conversions generated through direct traffic, for good....
Understanding Data Sampling in Google Analytics
Understand data sampling in Google Analytics. Learn to find and fix data sampling issues. Learn about data tables, single day & multi day processed tables....
Understand data sampling in Google Analytics. Learn to find and fix data sampling issues. Learn about data tables, single day & multi day processed tables....
Understanding the Analytics behind Google Ads (Adwords)
Learn the Analytics behind Google Ads (Google Adwords). Learn to analyze adwords marketing campaigns. Learn everything about Google Ads Analytics....
Learn the Analytics behind Google Ads (Google Adwords). Learn to analyze adwords marketing campaigns. Learn everything about Google Ads Analytics....
Google Analytics Mistakes That Kill Your Analysis & Conversions
Learn about the Common Google Analytics Mistakes that kill your Analysis, Reporting and Conversions....
Learn about the Common Google Analytics Mistakes that kill your Analysis, Reporting and Conversions....
Analyzing and Reporting Conversion Rate in Google Analytics
Learn the best way to analyze and report conversion rate in Google Analytics. Learn to calculate the true conversion rate....
Learn the best way to analyze and report conversion rate in Google Analytics. Learn to calculate the true conversion rate....
10 tips to analyse data trends in Google Analytics
Ten 10 tips to analyse data trends in Google Analytics...
Ten 10 tips to analyse data trends in Google Analytics...
How to Analyze and Report above AVERAGE
Learn to Analyze and Report above AVERAGE. We need to stop being obsessed about all the metrics which are ‘average and take the insight they provide with a huge grain of salt....
Learn to Analyze and Report above AVERAGE. We need to stop being obsessed about all the metrics which are ‘average and take the insight they provide with a huge grain of salt....
7 Powerful KPIs to Measure your Link Building Outreach
Learn about the 7 Powerful KPIs to Measure your Link Building Outreach. Learn to calculate the ROI of your outreach campaigns....
Learn about the 7 Powerful KPIs to Measure your Link Building Outreach. Learn to calculate the ROI of your outreach campaigns....
Direct Traffic in Google Analytics – Tutorial
Learn everything about direct traffic in Google Analytics and retaining referral data. Learn to send referrer data from HTTPS to non-HTTPS websites. Learn to measure the impact of Organic search and paid search traffic on Direct Traffic....
Learn everything about direct traffic in Google Analytics and retaining referral data. Learn to send referrer data from HTTPS to non-HTTPS websites. Learn to measure the impact of Organic search and paid search traffic on Direct Traffic....
You are doing conversion tracking all wrong. Here is why
If your conversions are goal conversions and not ecommerce transactions then there is always a possibility that they are adding little to no value to your business bottomline. In fact it could be more likely than you think....
If your conversions are goal conversions and not ecommerce transactions then there is always a possibility that they are adding little to no value to your business bottomline. In fact it could be more likely than you think....
Top 10 KPIs for SEO
Have you ever wondered which are the most important internal KPIs you should be tracking for SEO and any other online marketing campaign?...
Have you ever wondered which are the most important internal KPIs you should be tracking for SEO and any other online marketing campaign?...
Bounce Rate Optimization in Google Analytics – Complete Guide
If people are not sticking around your website then it is highly unlikely that they will make a purchase or complete any other conversion. ...
If people are not sticking around your website then it is highly unlikely that they will make a purchase or complete any other conversion. ...
How Google identifies and measures social media engagement
A long time ago, in a galaxy far, far away, there exists a social media analytics company called ‘PostRank‘. It was launched in mid-2007 and was acquired by Google in June of 2011. PostRank Analytics was one of my favorite analytics tool...
A long time ago, in a galaxy far, far away, there exists a social media analytics company called ‘PostRank‘. It was launched in mid-2007 and was acquired by Google in June of 2011. PostRank Analytics was one of my favorite analytics tool...