Be Concious Be More

Tag Data Analysis

Getting Started with Power Query

Power Query is a data automation tool. It can be used to perform ETL tasks like importing data from external sources, common tasks on the imported data like cleanse & prepare data, stack or merge data sets, group & summarize… Continue Reading →

Microsoft Forms : Getting Started Guide

Microsoft Forms can be used to create surveys, quizzes, polls and questionnaires. These features can be used at organizations to survey employees or customers on any topic, gather feedback on training and coaching, ask for advice on projects and key… Continue Reading →

AppSheet : The No-code App Development Platform

I was using MS Excel to keep track of my expenses and was thinking about using Excel VBA to automate the entry. But when i came across the Google AppSheet platform i had no more thoughts about automating with Excel… Continue Reading →

Data Visualization : Google Data Studio Dashboard Basics

In one of my previous blogs i had detailed upon dashboard creation using MS Excel. Here, i will be focusing on the Google Data Studio dashboard creation. MS Excel, Google sheets are spreadsheet programs that can be used to capture,… Continue Reading →

Data Visualization : MS Excel Dashboard Basics

Dashboards are reporting tools meant to help users or decision makers make business decisions. They provide a simple view that presents all information to understand the key results, show trends and risky areas. By the way, the term “dashboard” is… Continue Reading →

Understanding Google Sheets Basics

In case you are familiar with MS Excel, by first look you might feel that Google Sheets and Excel are similar. Though it is true to some extent, however you need to know a few things in order to utilize… Continue Reading →

Working on MS Excel using Python OpenPyXL Library

Openpyxl is a Python library to read/write Excel xlsx/xlsm/xltx/xltm files. This can be particularly helpful in data analysis wherein, user might have to go through thousands of rows and pick out few handful information to make small changes based on… Continue Reading →

Data Analysis using Excel

Introduction With the flood of data available to businesses these days, companies are turning to analytics solutions to extract meaning from the huge volumes of data to help improve decision making and boost businesses across industries. Data analytics is a… Continue Reading →

Data Analysis using Python

Excel can handle substantial amounts of data but python has an even greater capacity to manipulate large amounts of data. Since VBA is integrated into Excel, you have the advantage of using Excel as a GUI. It is also really… Continue Reading →

Getting started with Excel Macros

A macro is a piece of programming code that runs in Excel environment and helps automate routine tasks. In a layman’s language, a macro is a recording of your routine steps in Excel that you can replay using a single… Continue Reading →

© 2022 Sampath Kumar Ananda — Powered by WordPress

Theme by Anders NorenUp ↑