Data Analytics コース

コース情報

数週間でデータアナリストの基本スキル
をマスター
することができます。

データソーシングを理解する

ビジネスKPIを発見し、様々なソースからデータを収集し、一般的な分析（チャーン、ファネル、CAC、ABテスト、コンバージョンまでの時間など）を実行する方法を学びます
。

Google Sheets
Payment
CRM

マスターデータの抽出と変換

API、自動化ツール、プロダクトトラッキングを使用したデータ抽出を学びます。適切なデータレイヤーを構築し、高度なSQLを使用してデータを変換し、ウェアハウスにロードします。

SQL
Google Analytics
Fivetran

BIとデータビジュアライゼーションを学ぶ

最もよく使われるBIツールを使って、適切なビジュアライゼーションと自動ダッシュボードを構築し、結果を明確に伝えることができます。

Power BI
Google Data Studio

データ分析のためのPythonを学ぼう
。

PythonとJupyter notebookを使ってビッグデータセットで分析を実行する。Pythonを使った機械学習の基礎を学び、データサイエンティストやMLエンジニアとのコラボレーションを実現する

。

Python
Machine Learning

無料で始められます！ウェブ開発、データ分析、UXデザインのライブウェビナーに参加する。

私たちのData Analyticsブートキャンプはどのようなものか

日々のカリキュラム例です

準備運動：ブートキャンプを始める準備をする

40h

Our Data Analytics course is intense. To be prepared and make the most out of the bootcamp, you must complete a 40 hours preparation work to gives you basic tech foundations and culture.

Understanding the concept of KPIs and discovering the basics of data analysis
Introduction to Google Sheets
Introduction to SQL
Introduction to Python

実践で行うこと

40 hours of online tutorials

Google Sheetsでデータを理解し操作する

40h

What data is available? Where are they found? What KPIs do we want to follow? In this module, you will conduct in-depth analysis on business data and build automated dashboards with Google Sheets.

Product analysis - Retention, lifetime value, cohort analyses, etc.
Sales analysis - Funnel, average basket, time to convert, etc.
Marketing analysis - AARRR framework, conversion rate, etc.
Finance analysis - Margin, results, etc.

練習で行うこと

Learn how to identify the data sources to use
Build a sales funnel for a sales team
Analyze campaign performance for a marketing team
Analyze customer retention for a product team

抽出します。データを自動的に復元・クリーニングする方法

64h

You're not going to spend all day updating your charts! Master ELT tools (Extract, Load, Transform), APIs or No-code / Low-code tools to extract data from different sources and centralize it. Also learn how to track the data of your web app by creating a tagging plan.

Understand the principle of APIs with the Airbyte tool
Learn the best automation tools: Zapier & n8n
Use the world leader in ELTs: Fivetran
Analyse website trafic with Google Tag Manager & Google Analytics 4

実践で行うこと

Use APIs and implement webhooks
Build an automated lead acquisition workflow for a growth team
Track a new website event for a Marketing team
Duplicate CRM data in the Data warehouse for a Data team

SQL。データアナリストの言語をマスターし、実用的なデータウェアハウスを構築する。

56h

Learn all the techniques to centralize and transform your data in a data warehouse. Create effective dashboards and conduct in-depth analysis for business teams.

Get started with Bigquery, Google's Data Warehouse
Master SQL queries for analytics
Segment your data into “Data Layers” with the DBT tool
Study the different data architectures of tech companies

実践で行うこと

Query the database to respond to business requests
Clean data from business rules
Build data models for marketing, sales and product teams
Perform analytical queries and optimize your queries

データビジュアライゼーションとビジネスインテリジェンス

56h

Learn how to build the clearest, most interactive charts and dashboards possible for your teams.

Uncover insights from your data by adopting the right analysis methodology.

Adopt the best visualization techniques
Master the leading tools on the market
Conduct relevant analysis and interpret the results
Check the significance of your recommendations with statistics

実践で行うこと

Choose the most suitable graphic, add context and order the information
Create marketing, sales and product dashboards on Google Data Studio and PowerBI
Recommend actions based on your data analytics
Interpret AB testing results to develop the product

データ解析と予測のためのPython

64h

Learn how to manipulate large volumes of data and how to represent them. Master the basics of Machine Learning to predict results and perform complex analysis. Collaborate better with data science and engineering teams.

Discover the Jupyter Notebook format
Collaborate and manage your environments on Jupyterhub
Learn to predict the future with the Python sklearn and prophet libraries
Create clusters from your data
Automate the execution of your scripts with Airflow

実践で行うこと

Create your environments and practice versioning with git
Predict which users are most at risk of leaving
Identify the most discriminating variables among your data
Predict future revenue and group your customers by category

最終プロジェクト：パートナー企業のデータアナリストになる!

80h

Perform an A-Z data analysis project with real data from our partners. Learn how to properly pose the problem, identify, extract, centralize and process your data. Conduct your analyzes and create automated dashboards that will bring value.

プロジェクト例

Food delivery market analysis. Define the go to market strategy for Fox Intelligence by Nielsen.
Define the key factors for success in the Highway Code with Ornikar's data.
Optimize student placement rate through data analysis with JobTeaser's data.

... And many others!