https://www.datacamp.com/community/podcast/scaling-ai-adoption-in-financial-services

<p>In this episode of DataFramed, we speak with Shameek Kundu, former group CDO at Standard Chartered Bank, and Chief Strategy Officer &amp; Head of Financial Services at TruEra Inc about Scaling AI Adoption throughout financial services.</p>

In this episode of DataFramed, we speak with Shameek Kundu, former group CDO at Standard Chartered Bank, and Chief Strategy Officer & Head of Financial Services at TruEra Inc about Scaling AI Adoption throughout financial services.

Scaling AI Adoption in Financial Services

https://www.datacamp.com/community/blog/scaling-ai-adoption-in-financial-services

https://www.datacamp.com/community/podcast/building-high-performing-data-teams

<p>In this episode of DataFramed, we speak with Syafri Bahar, VP of Data Science at Gojek about building high-performing data teams, and how data science is central to Gojek’s success.&nbsp;</p>

In this episode of DataFramed, we speak with Syafri Bahar, VP of Data Science at Gojek about building high-performing data teams, and how data science is central to Gojek’s success. 

Building High Performing Data Teams

https://www.datacamp.com/community/blog/building-high-performing-data-teams

https://www.datacamp.com/community/news/creating-smart-cities-with-data-science-ofs0psrh048

Amen Ra Mashariki deep dives into the state of data literacy in government agencies, the use cases he worked on to make the City of New York smarter, and more!

Creating Smart Cities With Data Science

https://www.datacamp.com/community/news/the-credibility-crisis-in-data-science-with-skipper-seabold-6bbmgpwy1qm

Skipper Seabold, a Director of Data Science at Civis Analytics, discusses the current and looming credibility crisis in data science.

The Credibility Crisis in Data Science (with Skipper Seabold)

https://www.datacamp.com/community/news/sql-tutorial-how-to-write-better-queries-d2nj398ov1l

Structured Query Language (SQL) is an indispensable skill in the data science industry and generally speaking, learning this skill is fairly easy. However, most forget that SQL isn't just about writing queries, which is just the first step down the road. Ensuring that queries are performant or that 

SQL Tutorial: How To Write Better Queries

<h2 id="why-did-we-launch-data-science-competitions-">Why did we launch data science competitions?</h2>
<p>We started DataCamp to help everyone build their data skills, through learning by doing. We’re constantly innovating, making it easier for learners to go from learning to applying their skills to solve real-world challenges. For example, we’ve created over 80 different projects, we’ve launched our in-browser tool Workspace, and we’ve designed two of our certification’s assessments to be based upon how well learners can apply what they know.</p>
<p>We are now pleased to announce the launch of <a href="https://app.datacamp.com/learn/competitions">data science competitions</a>, in which you’ll perform an analysis based on a dataset and problem statement. This data analysis will be performed and presented in a Workspace notebook, and it will then be assessed through an upvote system and a panel of experienced data scientists. There are huge prizes to be won and these will be a regular occurrence, starting today!</p>
<br><center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1634599264/competitionsprizes_gd4a8t.png" /></center><br>

<h2 id="what-is-the-first-datacamp-data-science-competition-">What is the first DataCamp data science competition?</h2>
<p>Our first data science competition, &quot;<a href="https://app.datacamp.com/learn/competitions/russian-alcohol-promotions">Designing a promo strategy for a drinks company</a>&quot;, is now live, so if you’re curious go check it out.</p>
<br><center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1634599265/Screenshot_2021-10-18_at_15.09.45_dplfq6.png" /></center><br>

<p>In this challenge, you’re asked to create promotion recommendations for a drinks company based on previous promotions and historical alcohol consumption data in various regions of Russia.</p>
<h2 id="what-entering-datacamp-competitions-can-do-for-your-career-">What entering DataCamp competitions can do for your career?</h2>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1634599270/wes-hicks-4-EeTnaC1S4-unsplash_fendqd.jpg" /></center><br>

<p>DataCamp Competitions are designed to help users gain real-world data science experience—similar to what a data analyst would typically encounter in the workplace. All learners stand to strengthen their data science experience and coding skills by participating, as well as the opportunity to build a strong portfolio whose contents will be given an upvote score as part of the judging process. Furthermore, non-participants will have the opportunity to learn from submitted publications by seeing how others have found creative solutions to complex data problems.</p>
<h2 id="what-competitions-entail">What competitions entail</h2>
<p>Every week a new challenge is launched based upon a real-world dataset and problem statement drawn up by our team. Once a competition is launched, learners have two weeks to complete their analysis and publish it using Workspace, our online data science notebook.</p>
<p>Once you’ve submitted your analysis you can share your publication with your friends and on your social media to get upvotes on it. This will also enable them to upvote it early, before voting to the wider public begins.</p>
<p>After the submission deadline, the judging process begins. This step is two-fold:</p>
<ul>
<li>DataCamp learners and other data science enthusiasts give publications upvotes, and the most popular will be reviewed by the judges.</li>
<li>The judges will spend the following week evaluating these publications and selecting their own top five out of these.</li>
</ul>
<p>In the case of “Designing a promo strategy for a drinks company&quot;:</p>
<ul>
<li>Submissions will close on October 31, 2021 at 11:59 PM PT and voting will start on November 1. On this date all workspace notebook publications will be opened to the wider public for upvoting, and you’ll be able to upvote your favorite publications to boost their chances of winning.</li>
<li>Voting will end on November 7.</li>
<li>Judges will determine 5 winners, then announce them by November 12.</li>
</ul>
<h2 id="what-skill-level-datacamp-competitions-are-intended-for-">What skill level DataCamp competitions are intended for?</h2>
<p>DataCamp competitions are open-ended challenges intended to test your analytical, storytelling, and visualization skills. As a recommendation, we would say complete the skill track relevant to the tool you’ll be using in your analysis. DataCamp competitions are similar in certain respects to Kaggle, although they will have more of a focus on real-world analytics so are more accessible to a wider audience.</p>
<h2 id="what-else-is-coming-up-">What else is coming up?</h2>
<p>If you haven’t already, be sure to follow DataCamp on Facebook, Twitter, LinkedIn, and Instagram, where every week we will announce the launch and topic of new competitions!</p>
<br><center><a href="https://app.datacamp.com/learn/competitions"><img src="https://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1634599264/Group_1127_koksuy.png" /></a></center><br>

<p>Curious? You can learn more about our <a href="https://support.datacamp.com/hc/en-us/articles/4410791195031">data science competitions here</a>, and if you’d like some inspiration you can check out the winning publications of our Workspace competition.</p>
<ul>
<li><a href="https://tinyurl.com/5cfv44k7">First place—Loan Data by Kok Kwang Ng</a></li>
<li><a href="https://tinyurl.com/4sz37tww">Second place—Loan Data by Nikolaos Christoforidis</a></li>
<li><a href="https://tinyurl.com/sazjdemc">Third place—Optimizing Gower Weights in Feature Engineering by Patrick Coulombe</a></li>
<li><a href="https://tinyurl.com/xcfx3aks">Fourth place—Internet News and Consumer Engagement by Renaat de Rudere</a></li>
<li><a href="https://tinyurl.com/cm6nxsbx">Fifth place—Internet News and Consumer Engagement</a></li>
</ul>


https://www.datacamp.com/community/blog/introducing-data-science-competitions

DataCamp’s data science competitions are now live! You’ll be able to put your data science skills into practice for the chance to win prizes, get new additions to your portfolio, and learn new approaches to a single problem from other people who solved it.

DataCamp’s data science competitions are now live! You’ll be able to put your data science skills into practice for the chance to win prizes, get new additions to your portfolio, and more!

Introducing DataCamp Competitions!

In this episode of DataFramed, we speak with Shameek Kundu,  Chief Strategy Officer & Head of Financial Services at TruEra Inc about Scaling AI Adoption throughout financial services.

<h2>Retrieving Data From The Database</h2><p>This chapter provides a brief introduction to working with relational databases in a marketing context. You'll learn about their structure,  how to talk about them using database lingo, and how to begin an  analysis by using simple SQL commands to select and summarize columns  from database tables.</p><h2>Filter Data And Limit Your Output</h2><p>In this chapter, you'll learn how to filter tables for rows that satisfy your criteria of interest with the help of basic comparison operators and combinations of multiple criteria.</p><h2>What's Next?</h2><p>Besides selecting columns and filtering rows, there is much more that you can do with SQL! This chapter will present you with some examples that will motivate you to continue to develop this newly gained skill!</p>

https://www.datacamp.com/community/open-courses/sql-tutorial-for-marketers

The best marketers and growth hackers are data-driven. Learn how to use Structured Query Language (SQL) to query a database containing bank clients and marketing campaigns data.

SQL Tutorial for Marketers

https://www.datacamp.com/community/tutorials/sql

Are you ready to begin your SQL journey? Here’s a step-by-step guide on how to get started.

SQL Tutorial for Beginners | DataCamp

SQL Tutorial for Beginners

<p>SQL Server is a relational database management system. One of the key principles of the relational database is that data is stored across multiple tables.</p>
<center><img src="https://res.cloudinary.com/dyd911kmh/image/upload/c_scale,f_auto,q_auto:best,w_564/v1603485855/join1_nitybm.png" /></center>

<p>We will need to be able to join tables together in order to extract the data we need. We use <code>primary</code> and <code>foreign</code> keys to join tables.</p>
<h2 id="primary-key">Primary Key</h2>
<p>A primary key is a column that is used to uniquely identify each row in a table. This uniqueness can be achieved by using a sequential integer as an identity column. Or sometimes, existing columns naturally contain unique values, and they can be used.</p>
<p>In the below example, we can see the first few rows from the <code>artist</code> table. It has two columns, <code>artist_id</code>, and <code>name</code>. The <code>artist_id</code> column acts as a primary key for this table, it is an integer column, and each value is different.</p>
<pre><code>+-----------+-------------------+
| artist_id | name              |
|-----------+-------------------|
| 1         | AC/DC             |
| 2         | Accept            |
| 3         | Aerosmith         |
| 4         | Alanis Morissette |
| 5         | Alice In Chains   |
+-----------+-------------------+
</code></pre><p>Now let&#39;s look at the <code>album</code> table. Can you spot the primary key? Yes, it&#39;s the <code>album_id</code> column. It&#39;s common for the primary key to be named &quot;table-name underscore id&quot;. But, you&#39;ll have noticed there is also an <code>artist_id</code> column. That also consists of integers and has the same name as the <code>artist_id</code> column in the artist table. What does this mean?</p>
<pre><code>+----------+-------------------------+-----------+
| album_id | title                   | artist_id |  
|----------+-------------------------+-----------|
| 1        | For Those About To Rock | 1         |
| 2        | Balls to the Wall       | 2         |
| 3        | Restless and Wild       | 2         |
| 4        | Let There Be Rock       | 1         |
| 5        | Big Ones                | 3         |
+----------+-------------------------+-----------+
</code></pre><h2 id="foreign-keys">Foreign Keys</h2>
<p>Well, from the previous output, it is clear that the <code>artist_id</code> in the artist table acts as a <code>Foreign_key</code> to the album table. The <code>FOREIGN KEY</code> constraint is used to prevent actions that would destroy links between tables.</p>
<ul>
<li><code>artist</code> table</li>
</ul>
<pre><code>+-----------+-------------------+
| artist_id | name              |
|-----------+-------------------|
| 1         | AC/DC             |
| 2         | Accept            |
| 3         | Aerosmith         |
| 4         | Alanis Morissette |
| 5         | Alice In Chains   |
+-----------+-------------------+
</code></pre><ul>
<li><code>album</code> table</li>
</ul>
<pre><code>+----------+-------------------------+-----------+
| album_id | title                   | artist_id |  
|----------+-------------------------+-----------|
| 1        | For Those About To Rock | 1         |
| 2        | Balls to the Wall       | 2         |
| 3        | Restless and Wild       | 2         |
| 4        | Let There Be Rock       | 1         |
| 5        | Big Ones                | 3         |
+----------+-------------------------+-----------+
</code></pre><p>This means that when the <code>artist_id</code> in the album table matches the <code>artist_id</code> in the artist table, those rows can be linked as a <code>JOIN</code>.</p>
<h2 id="joining-album-and-artist">Joining Album and Artist</h2>
<p>Rows 1 and 4 of the artist table have an <code>artist_id</code> of 1. The <code>artist_id</code> 1 in the artist table is AC/DC. So, when we join the two tables together, we return the album details from the album table, and the corresponding artist details from the artist table - joined using the <code>artist_id</code> field, which is common to both tables.</p>
<p>This is known as an <code>inner</code> join.</p>
<pre><code class="lang-SQL">SELECT
  album_id,
  title,
  album.artist_id,
  name AS artist_name
FROM album
INNER JOIN artist ON artist.artist_id = album.artist_id
WHERE album.artist_id = 1;
</code></pre>
<pre><code>+----------+-------------------------+-----------+-------------+
| album_id | title                   | artist_id | artist_name |
|----------+---------------------------------------+-----------|
| 1        | For Those About To Rock | 1         | AC/DC       |
| 4        | Let There Be Rock       | 1         | AC/DC       |
+----------+-------------------------+-----------+-------------|
</code></pre><p>We joined the album and artist tables by matching the <code>artist_id</code> from the artist table to the <code>artist_id</code> in the album table.</p>
<p>When selecting columns with the same name from different tables, you must fully qualify the column name. Otherwise, SQL Server will not know which table to <code>SELECT</code> the column from.</p>
<p>To fully qualify a column, you have to prefix it with the relevant table name, followed by a period.</p>
<h3 id="inner-join-syntax">Inner Join Syntax</h3>
<p>Here&#39;s a generic example to remind you of the syntax. When we select the relevant columns from the main table, <code>table_A</code> in this case, then select any additional column we want to join to, which in this case is <code>table_B</code>. Then we specify the join using the keywords <code>INNER JOIN</code> and <code>ON</code>, providing the necessary key columns from both the tables.</p>
<pre><code class="lang-sql">SELECT
    table_A.columnX,
    table_A.columnY,
    table_B.columnZ,
FROM table_A
INNER JOIN table_B ON table_B.foreign_key = table_A.primary_key;
</code></pre>
<h2 id="not-using-a-where-clause">Not Using a <code>WHERE</code> Clause</h2>
<p>In this example, we don&#39;t specify a <code>WHERE</code> clause, so we return ALL combinations of ALL matches between the artist and album tables, again, based on the <code>artist_id</code> column, which is common to both.</p>
<pre><code class="lang-SQL">SELECT
  album_id,
  title,
  album.artist_id,
  name AS artist_name
FROM album
INNER JOIN artist on artist.artist_id = album.artist_id;
</code></pre>
<pre><code>+----------+---------------------------------------+-----------+
| album_id | title                   | artist_id | artist_name |
|----------+---------------------------------------+-----------|
| 1        | For Those About To Rock | 1         | AC/DC       |
| 4        | Let There Be Rock       | 1         | AC/DC       |
| 2        | Balls To The Wall       | 2         | Accept      |
| 3        | Restless and Wild       | 2         | Accept      |
+----------+---------------------------------------+-----------+
</code></pre><h2 id="multiple-inner-join">Multiple Inner Join</h2>
<p>You can also join more than two tables using <code>INNER JOINS</code>. You simply provide an additional <code>INNER JOIN</code> for each combination of tables. In our code below, we join tables A and B, and also B and C.</p>
<pre><code class="lang-SQL">SELECT
  table_A.columnX,
  table_A.columnY,
  table_B.columnZ table_C columnW
FROM table_A
INNER JOIN table_B ON table_B.foreign_key = table_A.primary_key
INNER JOIN table_C ON table_C.foreign_key = table_B.primary_key;
</code></pre>
<p>To learn more about joining tables, please see this video from our course <a href="https://campus.datacamp.com/courses/introduction-to-sql-server/joining-tables?ex=1">Introduction to SQL Server</a>.</p>
<iframe width="560" height="315" src="https://www.youtube.com/embed/DRDFtejKZs8" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

<p>This content is taken from DataCamp’s <a href="https://www.datacamp.com/courses/introduction-to-sql-server">Introduction to SQL Server</a> course by John MacKintosh.</p>


https://www.datacamp.com/community/tutorials/sql-joins

community

datacamp

sql

News (7)

Creating Smart Cities With Data Science

Creating Smart Cities With Data Science

Creating Smart Cities With Data Science

Tutorials (44)

SQL Tutorial for Beginners

Joins in SQL

Cheat Sheets (0)

Open Courses (1)

SQL Tutorial for Marketers

Podcast (12)

Scaling AI Adoption in Financial Services (with Shameek Kundu)

Blog Posts (40)

Introducing DataCamp Competitions!

Tech Thoughts (0)