Dhaval's Tech Zone

Search This Blog

Visualization using Tableau

on September 28, 2020

Get link
Facebook
X
Pinterest
Email
Other Apps

Visualizing - Nify P/E

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

How to learn SQL?

Over the years many people have approached me to seek some guidance on “How to learn SQL?”. I have been pointing them to various online tutorials and emulators. Since this is a repetitive ask, I thought of creating a blogpost to keep it handy. When it comes to SQL, or anything else for that matter, just the theory knowledge won’t help. You need to try out the queries on your own and practice them with a dummy database to understand the concepts. Here are the topics that one should practice. Basics Concepts: RDBMS Concepts Datatypes CRUD operations ( C reate, R ead, U pdate, and D elete, i.e. syntax for INSERT, SELECT, UPDATE, and DELETE queries) DML, DDL Statements Where clause Intermediate Concepts: Table Joins Aggregate Functions & Having Clause Views Sub Queries Triggers Advanced Concepts: Index Functions Stored Procedures CTE (Common Table Expression) Materialized Views Query Optimization If y...

“Project Manager” vs “Program Manager”

“Project Manager” and “Program Manager” - while some people use these words interchangeably, they are in fact two different roles. Let me try to identify some key difference in this post. Project Manager Program Manager Definition Project - is a set of tasks, performed to achieve a specific goal, which has limited resources and timeline. Program - is composed of multiple inter related projects, which aligns with long-term business objective for an organizational strategy. Role Manages single or multiple projects and in many organizations reports to a Program Manager. Manages multiple projects and might manage multiple programs. They generally report into senior leadership of the organization. Deals with Manages the project teams and executes the project with defined scope, schedule and resources. They have a deeper view of the projects being managed. May interact with multiple project teams...

Deep Learning - Loss function returning 'nan'

If you have tried training some deep learning models, then occasionally you would have come across scenarios where loss returns 'nan' and you are clueless about what to do. In my experience so far most of the time it was one of the following two reasons for 'nan'. Invalid inputs - null, nan, blank, etc... in numerical fields Data not normalized Please refer to the below links for other possible reasons for 'nan' loss https://stackoverflow.com/questions/40050397/deep-learning-nan-loss-reasons https://datascience.stackexchange.com/questions/68331/keras-sequential-model-returns-loss-nan

Powered by Blogger

Visualization using Tableau

Comments

Post a Comment