During my job search I have applied for lots of positions online, usually in a web form that is part of a company’s application tracking system. These systems send an automatic email when you apply. And typically at some point, whether it’s automatically through some algorithm or when a human presses a button, I’ll get a form email notifying me that I am no longer being considered for the position....
I’m currently seeking my next challenge as a Data Analyst or Business Intelligence Analyst. With 10 years of experience in data analytics, business intelligence, and data engineering, I’ve worked across diverse industries, including energy management, telecommunications, hospitality, and automotive services. While I’m proud of my versatility, I consider myself industry-agnostic, ready to dive into any domain to solve meaningful problems with data. Throughout my career, I’ve collaborated with internal stakeholders, supported customers, consulted with teams, and even traveled the world to make data-driven decisions....
What this book is about: Notes Black Swan has three attributes outlier - lier outside realm of regular expectations - nothing in the past can convincingly point to its possibility extreme impact human nature makes us want to explain it ie: RARITY, EXTEME IMPACT, RETROSPECTIVE certain professionals in environments subject to Black Swans think they are experts but they are not- they are better at narrating or making things sound complex...
What this book is about: This is a book about how most humans only live about 4,000 weeks, and we should realize that In the long run, we’re all dead Notes face the reality that time is limited once you deeply grasp that fact that doing everything is impossible, you’ll be newly empowered to resist doing everything, and to focus instead on building the most meaningful life you can know that you will not achieve peace of mind just by doing more things....
For some reason I wanted to know if there was any trend in first names of MLB draftees. If you ask me, the first names of MLB draftees & players have some kind of perceived stereotype, and I wanted to see if that was true. For example, it seems like a lot of JJs are drafted. First Step: Get (Extract) the data From googling around and just looking at data on the internet for many years, I knew there was an MLB Stats-API....
What this book is about: This is a book about the art of conversation It has some case studies and lays some rules out on how to have good conversations Notes people love talking to people who let them come away feeling “a little smarter, funnier, more interesting” people want to feel as if they have been heard and like they have some kind of bond with who they are talking a goal for meaning for discussions is to have a “learning conversation” learn how people around us see the world and help them understand out perspectives to communicate with someone we must connect with them absorb what someone is saying and comprehend what we say when a good conversation happens brains align, bodies synchronize and neural simultaneity occurs To become a supercomminiucator: listen close to what is said and unsaid ask right questions recognize and match others moods make our own feelings easy for others to perceive Three types of conversations: Decision Making - What’s this really about?...
Here is SQL test I took during a job interview. First is the description, or you can skip directly to the answer. Description: A social network under development needs a query that returns all profiles and the types of their relationships with each other. The result should have the following columns: profile | %related_profile_1% .. %related_profile_N% - type of relation of specific profiles: The column name is the related profile username....
Here is SQL test I took during a job interview. First is the description, or you can skip directly to the answer. Description: As part of developing the call history functionality of a dialer application, create a query that returns a list of all contacts, the total duration of their calls, and the number of calls during the work week and weekends. The result should have the following column: full_name | phone | type | workweek | weekend....
I took this SQL test during a job interview. The instructions are (spelling mistake is theirs): “We’d like a data model for quick lookup per user. Create a query that returns 1 row per user containing information on their first purchance and their last.” We have a table that looks like this - the table is called subscriptions which can also be considered transactions. Table "public.subscriptions" Column | Type | Collation | Nullable | Default ----------------+-----------------------------+-----------+----------+--------- transaction_id | character(36) | | not null | purchased_at | timestamp without time zone | | not null | purchase_price | double precision | | not null | user_id | character varying(255) | | not null | The way I did this was with two sub queries....
Here’s how to convert a numeric integer field of seconds to HH:MM:SS. Use the INTERVAL PostgreSQL data type. The INTERVAL data type is used to store and manipulate a time period. Example SELECT 120 * interval '1 sec'; Output |120 seconds to HH:MM:SS| |-----------------------| |00:02:00| An example with a table of rows of call records that have the length of call in seconds in a column called duration. select duration , duration * interval '1 sec' seconds_to_hh_mm_ss , duration * interval '1 min' min_to_hh_mm_ss from calls; Output...