# reckonanalytics.com > AI-optimized mirror of reckonanalytics.com containing 50 pages totalling 20,790 words of clean markdown content, structured data, and semantic HTML. Original source: https://reckonanalytics.com/. Last updated: 2026-06-14T03:14:51.087Z. Each page is available as HTML (with JSON-LD structured data) and Markdown (text-only, ideal for LLMs and RAG). ## Homepage - [site-root.html](/content/site-root.html) (1 words) ## Articles & Blog Posts - [October 2024 – Reckon Analytics](/content/2024/10/index.html): 1 post published by Deepak Gupta during October 2024 (103 words) - [Problem:](/content/category/python/index.html): Python Programs and Tutorials (240 words) - [2018/03/08/credit-risk-prediction-using-artificial-neural-network-algorithm.html](/content/2018/03/08/credit-risk-prediction-using-artificial-neural-network-algorithm.html) (1 words) - [2017/11/11/email-classification-into-relevant-category-using-neural-networks.html](/content/2017/11/11/email-classification-into-relevant-category-using-neural-networks.html) (1 words) - [2019/08/17/dynamic-google-analytics-api-using-python/index.html](/content/2019/08/17/dynamic-google-analytics-api-using-python/index.html) (1 words) - [Tableau Dashboard- MySQL & AdWords – Reckon Analytics](/content/2016/08/28/tableau-dashboard-mysql-adwords/index.html): Now use the power of Tableau to find business insights for AdWords data. With this implement you can forget the days of manually uploading .csv files into Tableau Software to perform data analysis. Now you have to just connect to your database, build dashboard, storyline and many more things. With the help of Tableau Online… (923 words) - [SAS Video Tutorials](/content/2016/08/04/sas-video-tutorials/index.html): If you want to learn SAS in a very short period of time, please use following YouTube tutorial. If you are new to SAS or SAS programming then please start with The Little SAS Book which you can buy from Amazon or any other Book shop. or buy Base SAS Programming Black Book https://www.youtube.com/watch?v=dwKfZq9lPFM   https://www.youtube.com/watch?v=4UaAlL7VwY0 https://www.youtube.com/watch?v=zlDMwF3kQ6s… (443 words) - [122 Analytics Companies in India – Reckon Analytics](/content/2016/08/04/122-analytics-companies-in-india/index.html):   Sr No Company Name Location-1 Location-2 1 24/7, Inc Bangalore 2 Absolutdata Hyderabad Gurgaon 3 Accenture Gurgaon Bangalore 4 Actiknow consulting Delhi Delhi 5 Airtel Gurgaon 6 Amazon Chennai 7 Amba Research Bangalore 8 Ameriprise 9 Amex(American Express) Gurgaon 10 Analytics eye Bangalore 11 Analytics Quotient Bangalore 12 ANZ Bangalore 13 AOL 14 Bank… (779 words) - [QVC – Reckon Analytics](/content/2017/05/01/qvc/index.html): var divElement = document.getElementById('viz1493909286527'); var vizElement = divElement.getElementsByTagName('object')[0]; vizElement.style.width='100%';vizElement.style.height=(divElement.offsetWidth*0.75)+'px'; var scriptElement = document.createElement('script'); scriptElement.src = 'https://public.tableau.com/javascripts/api/viz_v1.js'; vizElement.parentNode.insertBefore(scriptElement, vizElement); The objective of this challenge was to create a Decision Support System so that QVC can make strategic decisions to answer some of the business questions such as customer next buy (product and product category), top products… (1,129 words) - [Adwords and Bing](/content/2016/08/04/5-ways-to-optimize-your-google-adwords-account-in-10-minutes-or-less.html): Most savvy digital marketers understand the importance of ranking high in today's most popular search engines - namely Google, Bing and Yahoo. There are numerous techniques to helping improve your organic search ranking, such as focusing on inbound marketing, producing videos, and guest blogging, just to name a few. But for small to medium-size businesses… (1,216 words) - [Rate this:](/content/2016/10/01/converting-date-price-format-in-sas/index.html) (383 words) - [Find Average of Score: SAS – Reckon Analytics](/content/2016/10/01/218/index.html): OUT PUT LOG: 37 /* 38 Chapter 3 39 Question 1 : To find average of score : To find average of score : To find average of score : To find average of score : To find average of score : To find average of score : To find average of score : To… (786 words) - [What is Covid-19?](/content/blog/index.html): Its All About Analytics (582 words) - [1. **Databases and Schemas in Unity Catalog**](/content/2024/10/18/databricks-unity-catalog-explained-for-sql-server-folks.html): If you’re coming from a SQL Server background, think of Databricks Unity Catalog as a centralized metadata management system that simplifies how data is organized, governed, and shared across different data platforms. It’s designed for modern data lakes (such as those in Azure and AWS) but incorporates familiar concepts for SQL users. Let’s break it… (975 words) - [Install Dropbox.api package using NuGet package manager in Visual Studio](/content/2019/08/12/how-to-upload-filestream-to-dropbox-using-csharp/index.html): Install Dropbox.api package using NuGet package manager in Visual Studio This code won't work standable. You need to integrate it with your existing project just like an API to use dropbox file uploader in C#. using Dropbox.Api; using Dropbox.Api.Files; using System; using System.IO; using System.IO.Compression; using System.Linq; namespace Dropbox.Functions { class DropboxUploader { static string… (474 words) - [Product / Service Categories](/content/portfolio-2/index.html): Product / Service Categories Project Name Talk about this portfolio piece--who you did it for and why, plus what the results were (potential customers love to hear about real-world results). Discuss any unique facets of the project--was it accomplished under an impossible deadline?--and show how your business went above and beyond to make the impossible… (188 words) - [TabPy Tutorial: Integration of Python in Tableau – Reckon Analytics](/content/2017/01/16/tabpy-tutorial-integration-of-python-in-tableau/index.html): This tutorial will give a walk through the installation and connecting Tableau with TabPy. After this tutorial, one will be able to execute a simple python function from Tableau to perform some analytics calculation such as correlations etc 1. Installation of Python and TabPy Windows Users: https://github.com/tableau/TabPy Download this official TabPy Integration from above link.… (486 words) - [Rate this:](/content/2016/08/08/alpha-client-adwords-performance-analysis/index.html):       (339 words) - [Six Simple Steps to Improve Stored Procedures in SQL Server – Reckon Analytics](/content/2019/09/05/six-simple-steps-to-improve-stored-procedures-in-sql-server.html): 1. SET NOCOUNT ON: Stop the message that shows the count of rows affected by a T-SQL statments. These messages can be suppressed with SET NOCOUNT ON and can increase performance by decreasing network traffic 2. IF EXISTS(): Use IF EXISTS() to check if data exist in a table or not. You can write something… (649 words) - [AdWords Case Study #2 – Reckon Analytics](/content/2016/08/24/adwords-case-study-2/index.html): Business Overview: India’s premium watch reseller, which sell watches of premium brands such as Rado, Rolex etc. Average order value is approx. INR 1.5 Lakh Highlights of case study Cost per transaction reduced by 90%. CPC reduced by 58% CTR increased by 40% Challenges  As average order value is very high and client products made for… (580 words) - [Who we are](/content/privacy-policy/index.html): Who we areOur website address is: http://www.reckonanalytics.com.What personal data we collect and why we collect itCommentsWhen visitors leave comments on the site we collect the data shown in the comments form, and also the visitor’s IP address and browser user agent string to help spam detection.An anonymized string created from your email address (also called… (704 words) - [Q. Tableau vs Qlikview, the differences between these platforms?](/content/2016/08/22/tableau-vs-qlikview-the-differences-between-these-platforms.html): Q. Tableau vs Qlikview, the differences between these platforms? Best Answer: Both, QlikView and Tableau are fabulous tools, which are changing the way BI used to happen traditionally. Both have their own pros and cons. Let me provide my perspective on it: Benefits / Pros for both the tools: 1. Fast implementation - typically it… (657 words) - [Rate this:](/content/2018/02/01/u-s-household-income-distribution-by-state-makeover-monday-week-3.html): https://app.powerbi.com/view?r=eyJrIjoiYmMzNDA3MTItNDY2ZC00M2YwLWIyMTQtYmIxNTVmZGU5ODYxIiwidCI6IjZkNjJiMjE0LWQyMWYtNDc0YS05MmEyLWFlNjE4NzNiNjA5ZCIsImMiOjl9 This week we are Visualizing Household Income Distribution in the U.S. by State Data Source: data.world (329 words) - [**Hi** **! I’m Deepak, Senior Consultant with Prodata**](/content/deepak/index.html): Hi ! I'm Deepak, Senior Consultant with Prodata Passionate about driving business growth through data-driven insights and technology innovation. I'm thrilled to share a bit about my journey in the data world! Over the past 9 years, I've been passionately immersed in Data Platforms, crafting and bringing to life transformative analytical solutions. My tech toolkit… (446 words) - [Rate this:](/content/2017/03/23/clustering-in-r/index.html): help(kmeans) set.seed(1) x=matrix(rnorm(50*2), ncol=2) plot(x) x[1:25,1]=x[1:25,1]+3 x[1:25,2]=x[1:25,2]-4 plot(x) km.out=kmeans(x,2,nstart=20) km.out K-means clustering with 2 clusters of sizes 25, 25 Cluster means: [,1] [,2] 1 0.03223135 0.06924384 2 3.16866521 -3.83459093 Clustering vector: [1] 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2… (1,082 words) - [Hailstones – Python – Reckon Analytics](/content/2016/10/01/hailstones-python/index.html) (245 words) - [AdWords Case Study #1 – Reckon Analytics](/content/2016/08/24/adwords-case-study-1/index.html): About Business:  Client is one of the world's leading manufacturers of home improvement and building products, as well as a leading provider of services that include the installation of insulation and other building products. Also, they deliver exceptionally well-made, stylish faucets and related kitchen and bath accessories that are both beautiful inside and outside Highlights of the case… (603 words) - [Palindrome series – Python – Reckon Analytics](/content/2016/10/01/palindrome-series-python/index.html) (197 words) - [What People Say](/content/about-2/index.html): Visitors will want to know who is on the other side of the page. Use this space to write about yourself, your site, your business, or anything you want. Use the testimonials below to quote others, talking about the same thing – in their own words. This is sample content, included with the template to… (195 words) - [How to Build customize maps in Power BI? – Reckon Analytics](/content/2017/12/12/how-to-build-customize-maps-in-power-bi/index.html): In Today’s data era, it is very important to represent data in a way which is suitable for every type of user (Technical or Non-Technical). Use of data visualizations is getting increased exponentially. We have various data visualization tools available in the market such as QlikView, Power BI, Tableau, Google DI studio. Power BI provides… (709 words) - [n-gon function using Turtle – Python – Reckon Analytics](/content/2016/10/01/n-gon-function-using-turtle-python/index.html) (189 words) - [Creating a calendar in Python without using “import Calendar” – Reckon Analytics](/content/2016/10/17/creating-a-calendar-in-python-without-using-import-calendar.html) (252 words) - [Fibonacci Series – Python – Reckon Analytics](/content/2016/10/01/fibonacci-series-python/index.html) (183 words) - [Calculate Probability of Elements in Histogram – Reckon Analytics](/content/2016/09/28/calculate-probability-of-elements-in-histogram/index.html) (216 words) - [**Requirements:**](/content/2017/05/25/using-r-in-tableau/index.html): Requirements: Tableau Professional Edition R Studio or R Console Setting Up Tableau Desktop with R: Install following packages in R: install.packages(RServe) Once it is installed then start R Server by entering following command in the console: > library(RServe) > RServe() Configuring Rserve Connection: In Tableau go to following menu setting: Help -> Settings and Performance… (488 words) - [23Gon using Turtle- Python – Reckon Analytics](/content/2016/10/01/23gon-using-turtle-python/index.html) (178 words) - [**What is Covid-19?**](/content/2020/04/13/covid-19-how-it-started/index.html): What is Covid-19? In December 2019, a pneumonia outbreak was reported in Wuhan, China. On 31 December 2019, the outbreak was traced to a novel strain of coronavirus,which was given the interim name 2019-nCoV by the World Health Organization (WHO), later renamed SARS-CoV-2 by the International Committee on Taxonomy of Viruses. Some researchers have suggested… (395 words) - [Makeover Monday - Week 22](/content/2017/05/30/week-22-mom-internet-user-per-100-people-in-world/index.html): Makeover Monday -Week 22 This is the first time when I contributed to #MakeoverMondaytableau community work. I really enjoyed working with a different set of data and finding insights which might be useful for the betterment of our society. Looking forward to doing more #MakeoverMonday from next week. About Dataset: Internet users per 100 people This… (490 words) - [Shruti is a Senior Consultant (Solution Architect) at Prodata.](/content/shruti/index.html): Shruti is a Senior Consultant (Solution Architect) at Prodata. Shruti holds a degree in MSc Business Analytics from UCD Michael Smurfit Graduate Business School Shruti Goyal is a seasoned Senior Consultant passionate about crafting innovative solutions in data engineering and analytics. With over nine years of hands-on experience, Shruti has honed her skills in leveraging… (457 words) - [Tableau + PDF = Yayay!](/content/2017/06/18/tutorial-reading-data-from-pdf-sheets-in-tableau/index.html): Tableau + PDF = Yayay! Tableau just released latest version 10.3 with exciting features which include the capability of extracting data from PDFs files. Now, you can directly import your market research report, quarterly revenue sheet etc directly into Tableau to build amazing vizs to find hidden insights. How to Connect to PDF files? First step download/update… (488 words) - [What is Covid-19?](/content/2020/04/05/coronavirus-disease-covid-19-situation-dashboard/index.html): https://app.powerbi.com/view?r=eyJrIjoiMzRlMDk3M2EtZWU2Yy00NTZlLWFjYmEtOTJhYmVhZDhiNjU4IiwidCI6IjZkNjJiMjE0LWQyMWYtNDc0YS05MmEyLWFlNjE4NzNiNjA5ZCIsImMiOjl9 (250 words) - [Default Sorting in Power BI:](/content/2018/05/29/sort-by-year-week-in-power-bi/index.html): In Power BI, if you are creating year-week sales report, then you will encounter a most common issue. i.e Power BI by default return single digit week number/month number. Default Sorting in Power BI: But desired results is: 2018-12 2018-11 2018-09 2017-01 Using this formula once can fix this problem: Year-Month= Data[a_date].[Year]&"-"&FORMAT(Data[a_date].[MonthNo],"00") Year-Week= Data[a_date].[Year]&"-"&FORMAT((Data[a_date].[MonthNo],1),"00") (350 words) - [Shruti Goyal](/content/team/index.html): We are a small team of talented professionals with a wide range of skills and experience. We love what we do, and we do it with passion. We look forward to working with you. Shruti Goyal Co-Founder Certified: Microsoft Power BI, ITIL, TM1 BI Suite, SAS Deepak Gupta Co-Founder Certified: Microsoft Power BI, SAS v9,Google… (135 words) - [Makeover Monday -Week 22](/content/2017/05/31/week-22-mom-internet-user-per-100-people-in-world-v2.html): Makeover Monday -Week 22 This is the first time when I contributed to #MakeoverMondaytableau community work. I really enjoyed working with a different set of data and finding insights which might be useful for the betterment of our society. Looking forward to doing more #MakeoverMonday from next week. About Dataset: Internet users per 100 people This… (489 words) - [MOM Week 24: Turner vs Not Turner – Artwork from The Tate Collection – Reckon Analytics](/content/2017/06/18/mom-week-24-turner-vs-not-turner-artwork-from-the-tate-collection.html): This visualisation is based on the dataset provided by Makeover Monday for week 24. The Tate collection dataset contains the records of all the artists and artworks in the collection. The overview of the distribution of the collection over years has been of uttermost importance. A large amount of data represents artworks designed by Joseph… (434 words) - [Your Testimonial Archive Currently Has No Entries](/content/recommendations/index.html) (91 words) - [Starter](/content/pricing/index.html): Starter € 99 - Online support and assistance for small enterprise - Once-off Power BI Dashboard/Report development Buy Now 1:1 Consulting € 199/hr -Design and Development of executive BI dashboards - Custom Solutions or Training for Power BI Buy Now Adaptable Pricing that fits Different Users' Needs Your organization needs to cater to all users, however not… (211 words) - [Databricks Unity Catalog Explained for SQL Server Folks](/content/sitemap-xml.html) (47 words) - [news-sitemap-xml.html](/content/news-sitemap-xml.html) (1 words) ## Resources - [Full Page Index](/index.html): Browse all cached pages with rich metadata - [About This Cache](/content/about.html): Methodology, technical details, and usage guidelines - [XML Sitemap](/sitemap.xml): Machine-readable sitemap for crawler discovery - [Robots.txt](/robots.txt): Crawler directives