The course will start with understanding the basic concepts of Data Analytics. During the first phase of the course, students will focus on the science of analysing data and making conclusions for effective business decisions. Students will also learn basic data techniques in Microsoft Excel and create dashboards for managing the data. During the second phase of the course, students will focus on getting hands-on experience with SQL and creating databases using Microsoft SQL Server 2016. This will enable students to format and design databases for organizations.
Lastly, we will focus on visualizations using PowerBI. This will help students analyse the data and get relevant findings. The course will conclude with an overview of Data Analysis Expression (DAX).
- Introduction to the Fundamentals of Data
- Building a dashboard in Excel using different data format techniques
- Introduction to Database Management Solutions??
- Addressing SQL queries and exploring details (DDL vs DML)
- Using PowerBI for visualization
Please note: We provide tailored versions of our courses to cater to the specific needs of organisations. The pricing for customised courses may differ from that of our open-enrollment courses. For more details on pricing and instructor information, kindly reach out to us via email email@example.com.
Course Fee: PKR 45,000/-
Please go through Policies & Code of Conduct
Participants must register online through CES website by clicking on their desired course and filling out a one-page form. Before starting the registration process, please ensure that you have a formal scanned picture (for CES smart card) and CNIC details. Incorrect information provided during the registration process will lead towards cancellation of your enrolment at any stage and participants will not be entitled to claim a refund.
Once you have completed your online registration for your desired course, you may proceed to payment section. You have the option to pay online using your bank debit/credit cards through LUMS online payment system??https://pay.lums.edu.pk??OR by downloading the fee vouchers and depositing cash in any branch of designated banks specified on the fee voucher. Once you make your payment, you will receive a confirmation email within 24 to 48 working hours and your payment status will be updated to "PAID" in the online application portal.