Mastering Data Analysis For Business Development And Research

Rajshahi university science club
REGSITER now

Greetings from RUSC

Here’s good news for all the enthusiastic students interested in Data Analysis and Research.

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.

Courses

Advanced Excel
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.
Power BI
Microsoft Power BI is a business intelligence (BI) platform that provides nontechnical business users with tools for aggregating, analyzing, visualizing, and sharing data.
SQL
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.
Survey sampling
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!

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

Google Meet

Class Plan

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

go to event

Contact Information

Convener

Shawmik Al Mobin
IT Secretary
+8801828672873
shawmikalmobin17@gmail.com

President

Md. Abdul Latif
+8801916503270
latif@rusc.org.bd

General Secretary

Masud
+8801976961162
masud@rusc.org.bd

REGSITER now

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.

Contact Us