ICTO

Information and Communication Technologies
in Organizations and Society

Data science & Information System

Séance 1. Introduction

Séance 2. Big data analytics

Cours

 
 

Cas 

Questions:
1- With your team, you have to identify the impact of Big Data Analytics on the pillars of the Business Model (BM) of TalkingData.  You  can  use the BM CANVAS as a  general framework  for  your  team  analysis .
2- You need to perform a SWOT, 5 Factors of MP, or PESTEL analysis especially on its  focus on marketing and finance businesses. 

Veuillez développer vos réponses sur word, powerpoint ou en pdf. 
Envoyez les  par mail à harfoant@yahoo.com

Economic Intelligence

L'analyse du Macro-environnement: PESTEL

L'analyse du Micro-environnement:  Les 5 facteurs de Porter

L'analyse SWOT: SWOT

L'analyse du Business Model: CANVAS 

 
 

Séance 3. Big Data & Analyses descriptives

3.1. Introduction au Big data

Qu'est ce que le Big Data: vidéo

Utilisation du Big Data: vidéo

3.2. Analyses Descriptives

Faire de l'analyse descriptive : utilité et objectifs

3.3. Utiliser Tableau pour analyser les Big data

Veuillez télécharger la version essaie de Tableau/ Please download the free trial version of Tableau following this link :

Start a Free Tableau Trial: Download your trial here

Comment utiliser tableau pour réaliser des analyses descriptives: Vidéo

 
 

Case study

Mission

This mission is related to the case Web Analytics at Quality Alloys

Mission (Team Work)

Your job, as a trusted advisor to QA management, is to examine the value of QA’s website.

You can analyze not just graphs related to website metrics (e.g., visitors, pages/visit, time per visit, etc.), but also the graphs associated (non-web-based) financial measures of sales, profit and amount of merchandise sold. (For example, one focus of your efforts should be an analysis for senior management regarding the effectiveness of QA’s promotional effort). All the needed graphs can be found in the document “Graphs”.

You are invited to submit an executive summary, of five to ten slides.

Your executive summary has to summarize results and provide recommendations to QA managers as to how they might best market their business with an aim towards improving sales and improving the general situation of the company. Your recommendations must rely on your knowledge from the course, but your suggestions must ALWAYS be supported by the data and your analyses

 

Séance 4. BDA et Analyses prédictives

L'utilisation de Tableau pour faire des prévisions et des corrélations

Séance 5. AI and Data analytics

2. Latest trend  in AI: vidéo

Learning example 1

4. Deep Learning video

5.  Deep fake era: lien

6. AI and art: video

Autonomous farm work: video

Session Feb 15th:

Data sets

Vidéos 

  1. Getting Started

Introducing SAP Cloud Analytics

https://youtu.be/eGGZ33fzxK0

SAP Cloud Analytics Product overview

https://youtu.be/7bYo_EZlO4w

Interface description

https://youtu.be/nTf-oSZyP-c

Connecting and logging

https://youtu.be/Ulr30Qvf09g

Create data model

https://youtu.be/J6oh2u10tPk

Privacy model

https://youtu.be/jrd6nO-2b7g

At this stage, make sure to show the key areas of SAP Cloud Analytics (home, create a story, etc)


  1. Data

Import data

https://youtu.be/y6SjUaWGTs4

Data preparation

https://youtu.be/jVfaNKe8GgQ

Data modeling

https://youtu.be/y6SjUaWGTs4

Create a hierarchy

https://www.sapanalytics.cloud/resources-taxonomic-hierarchy/

https://youtu.be/8cTo8zTEhTk

Create level-based hierarchies

https://youtu.be/L2D7fHcvmsc

Create multiple parent-child hierarchies in a dimension

https://youtu.be/aThWyAykvVQ



  1. Exploring Story : Data Cleaning

Take a Product Tour (Starting and exploring )

https://youtu.be/ZP2EPUhtAk4

Importing data into stories:

https://youtu.be/jqQbHJ63md8

Now, please check your data by verifying that measures are actual measures and dimensions are actual dimensions. You will see that The Number of Reported Issues was considered as Dimension. Thus, please click on it and change it to a Measure.


  1. Basic functions

Create charts

https://youtu.be/FRYwXeyn1vY

Waterfall charts

https://youtu.be/ijsmVMC9qh4

Add variance in the chart

https://youtu.be/HUb5UKfxjZw

Pin data in the charts

https://youtu.be/uuxlxOenb1c

Add dynamic time calculation to the chart

https://youtu.be/wuq5hPKCwD8

Apply chart scaling

https://youtu.be/kTd4FhZyyaA


  1. Reference line and thresholds

Reference line

https://youtu.be/O9uaL_ZAfxI

Show fixed reference (set to a specific value)

Show dynamic reference line

Threshold

https://youtu.be/-UCE_B8uQ2w

Trelli

https://youtu.be/jzMaD40_5F4


  1. Use filters

Filters

https://youtu.be/PjQNsG_KcHE

Input control

https://youtu.be/3n8CxGp85HY

Advanced filtering

https://youtu.be/iJ6OjTUHLqU

Linked analysis

https://youtu.be/nq8Em5nIU-4


  1. Smart insights

Smart Analytics

https://youtu.be/7hfw1tZNvsw

Use smart insights for specific data points

https://youtu.be/3S_uyYbf8L0

Smart features

https://youtu.be/fIVpUcSpgfc


  1. Create calculations

Create calculated measures

https://youtu.be/erfGCVA_A7g

Calculate measures and dimensions

https://youtu.be/zYwp19l4puI


  1. Geo map

Create geo maps

https://youtu.be/KEMOeAm54nI

enrich geographic dimensions

https://youtu.be/qS6pQ5Yxfx0


  1. Predictive Analytics

https://youtu.be/dnM-mE2knzs

https://youtu.be/o2lM70pKBtc


  1. Working with Stories

https://youtu.be/uscWvtITb7g




Examen

Your team works for a well-know IT consulting company and you were selected by the one of the CEOs of GBI/Best run Corp to help him figuring-out the challenges associated with the current situation and to provide 5 main recommendations.


To do so you will need to give 10 quantifiable and visual rationale (Discriptive Analytics)

To do so, you will use the BI tool Tableau /or   SAP Cloud Analytics.


Now, you need to  download the data set GBI V2/ or Best run corp


You have to work-out the report in teams in class (today)