Open in app

Sign In

Write

Sign In

Narayan Subramoniam
Narayan Subramoniam

16 Followers

Home

Lists

About

Jul 17, 2022

Some things movies can’t capture

I used to see a lot of movies and assumed life was pretty much going to be similar. Besides being incredibly wrong about that, here’s a list of some things I don’t think a visual medium can get. Talking in the dark. Almost every movie scene with dialogue has lighting…

1 min read

1 min read


Jul 16, 2022

Lessons from a little running

I had a back-of-the-mind goal to run a half marathon by the end of the semester. There were many internal points against doing something like this. A small one is that a marathon distance is quite arbitrary and setting a numbers goal when that number didn’t feel personal to me…

Running

3 min read

Running

3 min read


Dec 17, 2021

Incomplete thoughts about veganism

carnism, fake spiritual epiphanies, and lobster pets — 3 ones this time, folks. 1/3 Carnism is a cool, dark word. The word vegan isn’t just a diet choice. It carries a lot of carry-on baggage. What this person values. What they’ll talk about at the dinner table, to you, when you don’t ask. Their stance on animal welfare, social welfare, communism, organic fair trade coffee…

Carnism

3 min read

Incomplete thoughts about veganism
Incomplete thoughts about veganism
Carnism

3 min read


Published in Dropbase

·Nov 12, 2021

4.5 Ways to Convert Excel Files to Databases Quickly

Learn four (and a half) ways to quickly turn your Excel data into databases or SQL queries. Streamline your data uploading, transformation and loading with these handy tools. — Data in Excel can be analyzed and visualized within the software but you might want to export the data to a database or query the data using SQL. You could be getting files that by themselves don’t exceed Excel’s row limit but when combined can’t fit in one file. Sure…

Excel

8 min read

4.5 Ways to Convert Excel Files to Databases Quickly
4.5 Ways to Convert Excel Files to Databases Quickly
Excel

8 min read


Published in Dropbase

·Nov 8, 2021

2 ways to connect Shopify to Power BI

We cover 2 ways to connect Shopify data to Power BI. The first is to use Power BI Connector — a Shopify app with free options. — Analyzing your Shopify store data is integral to maximizing your store’s impact. One way you can dig deep into your data is by using Shopify’s inbuilt Analytics feature. This is great if you want to run some ad-hoc analyses, get results, and act on it immediately. However, this route isn’t…

Shopify

3 min read

2 ways to connect Shopify to Power BI
2 ways to connect Shopify to Power BI
Shopify

3 min read


Published in Dropbase

·Nov 8, 2021

How to work with really large Excel files that slow you down

We cover using Power Query in Excel for very large csv’s and it’s drawbacks. Followed by a Bring Your Own Database solution and the ease of using Dropbase to solve all of your flat file conundrums — Sometimes, Excel’s million row limit is far below what you need for your work. You can experience sluggishness, formatting errors, and random crashes at far below the limit as well. So, what can you do if you have a data file that has something close to or over 1,048,576 rows…

Excel

5 min read

How to work with really large Excel files that slow you down
How to work with really large Excel files that slow you down
Excel

5 min read


Published in Dropbase

·Nov 8, 2021

Dropbase Pipelines and how they solve all your ETL problems

Learn how Dropbase Pipelines can help automate your ETL workflows — even with offline, flat files! We discuss how Dropbase provides an at-the-edge ETL experience, and share a video demo of Dropbase Pipelines. — What are Data Pipelines and “at the edge ETL “? Data pipelines are a sequence of steps that extract data from many sources, possibly apply any transformations and then load the data to a destination. Data pipelines are commonly abbreviated as ETL or ELT, depending on when the data is transformed.

Pipeline

4 min read

Dropbase Pipelines and how they solve all your ETL problems
Dropbase Pipelines and how they solve all your ETL problems
Pipeline

4 min read


Published in Dropbase

·Nov 8, 2021

When’s the right time for startups to get a data warehouse?

We cover the quantitative (the IPO model) and qualitative factors to help with your team’s data warehouse decision. — Consider the following scenarios: You’re in a fast-growing startup fresh out of funding and you now have to tighten up on reporting to your angel investors. Your company is thinking of an expansion to a new location and wants to consolidate its data. Or, The lean startup you’re in spends…

Analytics

4 min read

When’s the right time for startups to get a data warehouse?
When’s the right time for startups to get a data warehouse?
Analytics

4 min read


Published in Dropbase

·Nov 8, 2021

A Business Analyst’s Quick Review of Holistics

Learn about how Holistics Software can solve your Business Intelligence (BI) needs. — A company that grows fast has to be informed about a seemingly endless amount of information: Sales revenue, customer acquisition costs, churn, retention, etc. To create those actionable insights, you could continue doing something like this: Get weekly data emailed to you as a .csv Clean and format the data…

Bi Tools

4 min read

A Business Analyst’s Quick Review of Holistics
A Business Analyst’s Quick Review of Holistics
Bi Tools

4 min read


Sep 5, 2021

3 — The hikes of Navi Mumbai

I’ve been lying so far. I’m not technically in Mumbai, but in an adjacent city called Navi Mumbai (literally, “New Mumbai”). To the Canadians out there, I’m in the North York of India’s Toronto. Navi Mumbaikers love saying what’s better here: wider roads, cleaner roads, trees on roads … and…

Mumbai

5 min read

3 — The hikes of Navi Mumbai
3 — The hikes of Navi Mumbai
Mumbai

5 min read

Narayan Subramoniam

Narayan Subramoniam

16 Followers

Bio (optional, max 160 characters). Gotcha!

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech