Presentation File:

Big Data Fundamental – Day 1

Big Data Fundamental – Day 2

Related Materials:

  • Data Concept
    • To know more about Data Concept you can click [this] link.

Primary Requirements

  • Some programming experience (Optional)
  • At least high school level math skills will be required.
  • Passion to learn

BI Tools 

  • We will use popular BI tools Tableau. You can download Tableau Public Version from here.

Machine Learning Tools 

  • For No Code Machine Learning, we will use Azure ML Studio (Classic).

    Step 1 : Please go to this site https://studio.azureml.net/

    Step 2 : Use any Microsoft Account(youremail@hotmail.com / outlook.com) to Register and Login

Super Store Sales Data Analysis

We will explore different Business questions using Tableau BI Tools. 

Data 

Download [Store Sales Data]

Loan Application Case Study

We will explore different Business questions using Tableau BI Tools. 

Data 

Download [Loan Approval Data]

Mind Map

Lecture Summary Mindap

https://gitmind.com/app/doc/64c3464243

 

Explanatory Slides:

1. Brief on Hadoop

2. MapReduce

3. Pig

4. SparkIntro

5. SparkStreaming

6. Hive

7. hbase

8. Cassandra

9. Drill

10. Phoenix

11. Kafka

12. Flume

13. ZooKeeper

Books

Expert Hadoop Administration – Managing, Tuning, and Securing Spark, YARN, and HDFS

For Discussion : Click here!

  • To give your opinion please write your name in “Subject” Area and your comment in “Write something beautiful ..” area

I hope you enjoyed the session. Please send your feedback on mail2arif@arif.works 

Practical Activity 01
Create a new Google Data Studio report

  1. Name the report Practical Activity

  2. Create a header for the report with a title

Create the following Scorecard visualizations

  1. Sessions with optional metrics for Number of Sessions per user and % New Sessions

  2. Users with optional metrics for New Users

  3. Average Session Duration

  4. Pages / Session

Add a new Date filter to the report

For each Scorecard set the comparison to previous period

  1. View the report

  2. Change the Date filter to:

  3. Last 14 days

  4. Last month

  5. Last year

Practical Activity 02

Open the Practical Activity report

  1. Create a table displaying Users by Page Title

Add metrics for

  1. Avg. Session Duration

  2. Pages / Session

  3. Use a heatmap to display the Avg. Session Duration

  4. Use a bar to display the Pages / Session

Create a new table displaying Session by Sources

  1. Create running total for Sessions

  2. Create a new table displaying Users by Default Channel Group

  3. Make the table interactive

Experiment by selecting different Channels

Practical Activity 03

  1. Open the Practical Activity report

  2. Create a new page in the report

  3. Create a Time Series graph for the number of New Users

  4. Add a Date filter to the report

  5. Add a cumulative graph for the Time Series graph

  6. Add a date comparison to the graph for the previous period

  7. Create a new graph to display Users by Year and Month for this Year

  8. Create a new graph to display Users by Day of the Week – change the style to display a column graph

Interactive Dashboards Page 1

In this practical activity you are going to create an interactive report for your Google Analytics data.

  1. Create a new report

  2. Name the report – Google Analytics Dashboard

  3. Create a connection to the Sample Google Analytics data connection or to your own web site data

  4. Create a header and title for your report

Create the following Scorecards

  1. Sessions

  2. Users

  3. New Users

  4. Bounce Rate

Create a stacked area graph displaying sessions by Device Category – Create optional metrics for Users and New Users

Create a bar graph displaying Sessions by Source – Show the Top 15 – make the graph interactive

Create a filter for Country

Create a Date filter

Experiment with selecting different Countries and Sources

Interactive Dashboard Page 2

Practical Activity
In this practical activity you are going to create a second page for your Google Analytics report.

  1. Add Page 2 to your report

  2. Add a table displaying the number of Pageviews for each Page Title – make the table interactive

  3. Create a world map displaying the number of new users by Country – make interactive

  4. Create a Pie graph displaying the New Users by Gender – make interactive

  5. Create a Column graph displaying the New Users by Age – make interactive

  6. Create a Pie graphs displaying the New Users by Device Category – make interactive

  7. Add a Date filter

  8. Experiment with selecting different options to filter the report.