Annual Picnic 2023

Rajshahi university science club

Join us for a comprehensive workshop on “Mastering Data Analysis For Business Development And Research“. 

This workshop is designed for professionals, researchers, and students who are seeking to advance their skills in data analysis and visualization.

The workshop will cover a range of topics including advanced Excel techniques, SQL database management, Power BI data visualization, and sampling survey methods. You will learn how to efficiently manage large datasets, analyze data using statistical methods, and create engaging data visualizations to effectively communicate your findings.

Advanced Excel Functions refers to the features and functions of Microsoft Excel, which helps the user to perform complex calculations, perform data analysis, automate to process of large volumes of data, and much more. With the rise of big data and data analytics, advanced Excel skills are a real asset both during the job hunt and everyday work tasks.

Structured query language (SQL) is a programming language to operate databases; it includes Database Creation, Database Deletion, Fetching Data Rows, Modifying & Deleting Data rows, etc.

Microsoft Power BI is a business intelligence (BI) platform that provides nontechnical business users with tools for aggregating, analyzing, visualizing, and sharing data.

Survey sampling is a procedure within the design of an investigation through which data is collected through tools such as questionnaires or surveys.

The workshop is led by industry experts and experienced trainers who have extensive experience in data analysis and business development. You will have the opportunity to learn from their real-world experiences and gain practical insights into data analysis techniques that are relevant to business and research contexts.

Don’t miss this opportunity to enhance your data analysis skills and take your career to the next level. Register today and join us for this exciting workshop!

>>>Class Plan at A Glance <<<

Advanced Excel, Power BI, SQL & Sampling Survey 

????Day -1

◾Advanced Excel

  • Some Essential Excel Formulas
  • Analytical Thoughts with Pivot-Tables
  • Data Modelling with Excel
  • Power Excel with Power Query
  • Power Pivot 

 

????Day – 2

◾Power Bi for Business Intelligence

  • Getting started with Power Bi 
  • Connecting & Shaping Data with Power BI Desktop
  • Creating Table Relationships & Data Models in Power BI
  • Analyzing Data with DAX Calculations in Power BI
  • Visualizing Data with Power BI Reports 

 

????Day – 3

◾SQL & Sampling Survey

  • Setup Environment
  • Syntax intro
  • Select Query with Aliases
  • Select Distinct
  • Condition-wise Select (Where, And, Or, Not, Null Values)
  • Order By (Desc /Asc )
  • Insert into, Update, Delete
  • Mathematical Function (Operators, Min, Max, Count, Avg, Sum …..)
  • Comparison ( Like, In, Between, Having )
  • Joins(SQL Inner Join, Left Join, Right Join, Full Join, Self Join, Union)
  • Group By, Case Function
  • Create Table, Drop Table, Truncate table 
  • Sampling Survey

 

Program Schedule

▪️11 May 2023(Thursday):  10.00 AM – 01.00 PM

                                       :   03.00 PM – 06.00 PM

▪️12 May 2023 (Friday):   09.30 AM – 12.30 PM

                                       :   03.00 pm – 06.00 PM

▪️13 May 2023(Saturday):   10.00 AM – 01.00 PM

                           :   03.00 PM – 06.00 PM

 

Our Trainer :

Mr. Sohanur Rahman

Data Analyst- V2 Technologies Ltd.

Mathematical Analysis & Data Analysis Instructor – AiQuest Intelligence

 

Platform: Google meet 

 

Registration Fee:

For Professionals: 600 BDT

For students: 300 BDT 

 

Registration link:

 

Registration Deadline: 9 May 2023

 

For any Queries 

Contact:
Md. Abdul Latif
Phone: 01916503270
E-mail: [email protected]
President
Rajshahi University Science Club

Masud
Phone: 01976961162
E-mail: [email protected]
General Secretary
Rajshahi University Science Club

Shawmik Al Mobin (01828672873)

Convenor 

Mastering Data Analysis For Business Development And Research“. 

IT Secretary
Rajshahi University Science Club

Schedule

}

5 December 2023    >    7:00 AM – 5:00 PM

Green Valley Park, Natore

Contact Information

Convener

Jinnat Ara Jebin
Organizing Secretary
+8801784263861
[email protected]

President

Md. Abdul Latif
+8801916503270
[email protected]

General Secretary

Masud
+8801976961162
[email protected]

Registration Process

Registration Deadline

Day(s)

:

Hour(s)

:

Minute(s)

:

Second(s)

After selecting your category from below, click the “Proceed to Submission” button. It will take you to the submission page. Submit the required information by clicking the “Submit” button.

 

This product is currently out of stock and unavailable.