Data Analysis for Non Programmers has been an idea stuck in my mind since 2017 and after a long period of procrastination and ignorance, in July 2020 I announced on my Instagram that DANP is finally coming up. View this post on Instagram A post shared by Data Analyst | Entrepreneur (@doingdata) on Aug 12, 2020 at 4:58am PDT I interviewed and talked to more than 70 people in two weeks. Finally, 34 of us decided to come together and start learning from 1st August 2020. It is a very interesting and diverse set of audiences and we all were quite excited from class 1. One major challenge was to ac ..read more

What is Tableau HyperAPI? The Hyper API contains a set of functions you can use to automate your interactions with Tableau extract (.hyper) files. You can use the API to create new extracts or to open existing extracts, and then insert, delete, update, or read data from those files. Using the Hyper API developers and administrators can perform: Create extract files for data sources not currently supported by Tableau. Automate custom extract, transform and load (ETL) processes (for example, implement rolling window updates or custom incremental updates). Retrieve data from an extract file ..read more

What are KPIs and How are they Used Note: This post is first part of Building KPIs dashboard Series. I. What are KPIs II. KPI Comparison III. Drilldown into KPI IV. Wireframing A Dashboard V. Build KPI Dashboard VI. Best practices for KPI analysis What are Key Performance Indicators ..read more

What are KPIs and How are they Used Note: This post is first part of Building KPIs dashboard Series. I. What are KPIs II. KPI Comparison III. Drilldown into KPI IV. Wireframing A Dashboard V. Build KPI Dashboard VI. Best practices for KPI analysis What are Key Performance Indicators ..read more

What are KPIs and How are they Used Note: This post is first part of Building KPIs dashboard Series. I. What are KPIs II. KPI Comparison III. Drilldown into KPI IV. Wireframing A Dashboard V. Build KPI Dashboard VI. Best practices for KPI analysis What is a KPI Peter Drucker once said, ”What gets measured gets managed.” Since then the quote has been so much overused, it has almost lost its essence and has become a cliché. But just because something has become cliché doesn’t mean it doesn’t hold true any longer. Imagine it is the start of nice spring weather and you have bought ..read more

    Heat-maps Generally, 2 dimensions and 1 measure are required. 1 dimension goes on X-Axis other dimension goes on Y-axis The measure goes on the color intensity   Basic Structure The chart is used to reveal hotspots and patterns Diverging color preferred over continuous Measures used are mostly ratio instead of SUM Both dimensions are cross-sectional, not hierarchical   Variations Calendar Heatmap for daily and weekly pattern Long term changes for slowly changing measures like global temperature Geographic heatmaps to find geo-clusters Layout based h ..read more

View this post on Instagram A post shared by Data Analyst | Entrepreneur (@doingdata) on Apr 27, 2020 at 9:20am PDT ..read more

View this post on Instagram A post shared by Data Analyst | Entrepreneur (@doingdata) on Mar 14, 2020 at 8:56pm PDT ..read more

View this post on Instagram A post shared by Data Analyst | Entrepreneur (@doingdata) on Feb 22, 2020 at 6:06pm PST ..read more

View this post on Instagram A post shared by Data Analyst | Entrepreneur (@doingdata) on Feb 16, 2020 at 7:08pm PST ..read more