The Data School

MAY 2, 2019

Miscellaneous chapters related to teaching people SQL

40

40

The Data School

MAY 9, 2019

In depth post about using SQL to detect outliers using simple techniques and using inter quartile range

40

40

The Data School

JUNE 4, 2019

Learn how indexing works and why it is a critical part of optimizing your data warehouse

Data Warehouse 40

Data Warehouse Optimization IT 40

The Data School

APRIL 22, 2019

Visualize how SQL is joining two tables using a Union All

Visualization 40

Visualization 40

The Data School

APRIL 22, 2019

Learn the most common reasons you will get a SQL error due to syntax.

40

40

The Data School

APRIL 22, 2019

Learn quick tips for how to optimize your SQL queries

Optimization 40

Optimization 40

The Data School

APRIL 22, 2019

Learn the most common reasons you will get 0 rows returned from your SQL query.

40

40

The Data School

JUNE 13, 2019

Learn how to use CASE WHEN to create if then statements within SQL

40

40

The Data School

JUNE 17, 2019

Learn how to use Regex within SQL queries

40

40

The Data School

APRIL 22, 2019

Visualize how SQL is joining two tables using an Inner JOIN

Visualization 40

Visualization 40

The Data School

JUNE 13, 2019

Learn how to use ALTER to edit columns, tables, and databases

40

40

The Data School

APRIL 22, 2019

Visualize how SQL is joining two tables using a Cross Join

Visualization 40

Visualization 40

The Data School

APRIL 22, 2019

Visualize how SQL is joining two tables using a Left JOIN and a Right JOIN

Visualization 40

Visualization 40

The Data School

JUNE 6, 2019

Learn how to copy data into a new table or copy data into an existing table

40

40

The Data School

MAY 24, 2019

Learn how to create csv files from postgresl on the server side or client side

40

40

The Data School

APRIL 22, 2019

Visualize how SQL is joining two tables using a Full Outer JOIN

Visualization 40

Visualization 40

The Data School

JUNE 17, 2019

Learn how to optimize your Postgres queries using EXPLAIN ANALYZE

Optimization 45

Optimization 45

The Data School

JUNE 11, 2019

Learn how to import a CSV into a table in your postgres database

40

40

The Data School

JUNE 17, 2019

Learn how window functions work

40

40

The Data School

MAY 24, 2019

Learn what a query plan is and how it effects your SQL queries

IT 40

IT 40

The Data School

JUNE 5, 2019

Learn how to quickly get a postgres database up an running on your mac

40

40

The Data School

MAY 22, 2019

Create a copy of a database in postgres using psql

40

40

datapine

MARCH 31, 2022

How do you get into this field? Table of Contents. 1) Why Shift To A BI Career? 2) Top 10 Necessary BI Skills. 3) What Are the First Steps To Getting Started? 4) Business Intelligence Job Roles. 5) Main Challenges Of A BI Career. 6) Main Players In The BI Industry. Does data excite, inspire, or even amaze you? billion by the end of 2021.

Business Intelligence 239

Business Intelligence Statistics Visualization Data-driven 239

O'Reilly on Data

MARCH 31, 2020

You already know the game and how it is played: you’re the coordinator who ties everything together, from the developers and designers to the executives. For example, if engineers are training a neural network, then this data teaches the network to approximate a function that behaves similarly to the pairs they pass through it.

Management 332

Management Machine Learning Experimentation Metrics 332

Sisense

APRIL 21, 2020

Healthy Data is your window into how data can help organizations address this crisis. Many governments have instituted lockdowns, businesses have closed, and people everywhere have been practicing social distancing to slow the spread of the virus. How are such predictions made? How are such predictions made? The dataset.

Visualization 86

Visualization Management Reporting Modeling 86

FineReport

APRIL 15, 2020

So far, over 600k people in the United States have been infected with COVID-19, and the growth rate has exceeded imagination, seriously affecting people’s daily lives. This article will tell you how to make a dashboard of the world epidemic of various data. How to F ind the D ata you W ant? Design layout.

Dashboards 98

Dashboards Visualization Publishing Software 98

Smart Data Collective

MAY 20, 2021

This is a field in which demand is increasing as many companies turn to using big data analysis , and they require experts who know how to do this. This is a field in which demand is increasing as many companies turn to using big data analysis , and they require experts who know how to do this. Business Analytics Basics.

Business Analytics 106

Business Analytics Analytics Cost-Benefit Data-driven 106

Sisense

APRIL 10, 2020

Healthy Data is your window into how data is helping these organizations address this crisis. As COVID-19 continues to spread, healthcare groups and companies of all kinds are under pressure to provide care in the face of increasing demand. Let’s get started. The importance and impact of reliable data.

Visualization 105

Visualization Reporting Data Processing Dashboards 105

Jen Stirrup

OCTOBER 23, 2019

In this 10-week course, you’ll learn how to understand and analyze data. You’ll learn how to articulate business problems and identify required data. Using Microsoft Excel and SQL, you’ll practice gathering, cleaning and organizing data. Finally you’ll use Tableau to effectively describe, analyze and visualize data.

Visualization 40

Visualization IT Business Intelligence 40

AWS Big Data

NOVEMBER 8, 2023

Join us as we delve into the world of real-time streaming data at re:Invent 2023 and discover how you can use real-time streaming data to build new use cases, optimize existing projects and processes, and reimagine what’s possible. re:Invent is a learning conference organized by AWS for the global cloud computing community. Register now!

Data-driven 87

Data-driven Data Lake Machine Learning Cost-Benefit 87

IBM Big Data Hub

JULY 6, 2023

In a nutshell, data science brings structure to big data while machine learning focuses on learning from the data itself. This post will dive deeper into the nuances of each field. What is data science? Data science is a broad, multidisciplinary field that extracts value from today’s massive data sets. What is machine learning?

Machine Learning 59

Machine Learning Data Science Statistics Deep Learning 59

AWS Big Data

MARCH 27, 2023

In this post, we demonstrate how Amazon Athena , Amazon QuickSight , and Confluent work together to enable visualization of data streams in near-real time. This is a guest post written by Ahmed Saef Zamzam and Geetha Anne from Confluent. ksqlDB is one solution that made stream processing accessible to a wider range of users.

Visualization 74

Visualization Data Lake Interactive Data-driven 74

Domino Data Lab

JANUARY 6, 2019

I’ve been teaching data science since 2008 privately for employers – exec staff, investors, IT teams, and the data teams I’ve led – and since 2013, for industry professionals in general. How do options such as mentoring programs fit into this picture, both for organizations and for the individuals involved? Introduction.

Data Science 56

Data Science Machine Learning Reporting Visualization 56

Alation

FEBRUARY 20, 2020

Born into a world where information often seems more overwhelming than helpful, Aaron was inspired, along with Venky Ganti, Feng Niu and myself, to build a collaborative software platform that helps people find, understand and take advantage of data to make better decisions. Today, we call this data literacy. A human-centric approach.

Machine Learning 52

Machine Learning Interactive Data-driven Software 52

FineReport

NOVEMBER 7, 2019

So how can we create a good dashboard, especially for beginners? According to the above scoring criteria, how many points can you achieve in your dashboard design? If you want a perfect presentation of dashboard, you need the technicians, UI designers, and business people to coordinate the work. Now, let’s get started!

Dashboards 76

Dashboards Visualization Sales Interactive 76

Alation

MARCH 31, 2022

The writer Richard Millar Devens used “business intelligence” to describe how a banker had the foresight to gather and act on information thus getting the jump on his competition. In the breakneck world of data, which I have been privy to since the mid 1990s, business intelligence remains one of the most enduring terms. Early Days.

Business Intelligence 52

Business Intelligence Data-driven Data Warehouse Reporting 52

Jen Stirrup

JULY 26, 2021

I’m not going to repeat the various dogpiling here and I can see why people are so angry and hurt. Judging from my twitter DMs, people are afraid to speak out and they are hoping that I will do it for them. I am not a JW now, but the process did teach me a lot about putting others before yourself, and also about community.

IT 91

IT Technology Visualization Interactive 91