News

Pitt Business Analytics Institute Information

The purpose of this institute is to provide students with resources and support to be analytic professionals. The institute comprises two programs: first the LEAP Excel Fundamentals program, which then pipelines into the Advanced Analytics program. Students are to complete at least four of the six LEAP Excel Fundamental workshops in order to be eligible for applying for the Analytic Application program. Three workshops will be held in Fall 2023 and the remaining four will be held in Spring 2024. Students who attend at least four out of six LEAP Excel Fundamentals workshops will receive a Pitt Business Analytics Institute Certification.

LEAP Excel Fundamentals is open to everyone! This is a great opportunity to develop your skills, gain more analytics experience outside of the classroom, and receive accreditation for your analytics knowledge. By the end of the series, your analytical skills will be competitive for all internships, careers, and classes. Hosted by the leadership team for the League of Emerging Analytics Professionals, this series is an interactive and fun way to increase your analytical IQ.

Topics Covered Include:

Basic statistical formulas (Mean, Median, Mode, Sum, Average)
Shortcuts, Conditional formatting
Pivot Tables, Pivot Charts, VLookup
PowerQuery, PowerPivot
IF Statements
CountIF, IFError, SumIF

Macros, Solver, Regression

LEAP will hold their first Spring workshop of the series on Thursday, January 18th from 7-8 PM, with the other workshops also occurring on Thursdays at 7 PM. The other dates for the LEAP Excel Fundamentals are February 15th , February 29nd , and April 5th.

The Analytic Applications, a program intended to follow the initial LEAP Excel Fundamentals Certificate, is an advanced overview of analytics and optimization. Students have to have either received the LEAP Excel Fundamentals certificate or demonstrate intermediate analytics knowledge through an application process. Hosted by TechBlue’s Claye Green, this course covers optimization, predictive analytics tools, decision analytics, and more!

If you are interested in this program or want to learn more about Claye Green, see his Executive in Residence profile on Pitt Business's website: https://cba.pitt.edu/claye-greene/. He shares meaningful insight into analytics at this company, his analytics career, and teaches hands-on workshops using many of the analytics applications used in the Excel Fundamentals Certificate program.

League of Emerging Analytics Professionals Core Excel Curriculum

LEAP is proud to be partnered with PittBusiness to provide students with certified Excel training that acts as a prerequisite to the PittBusiness Analytics Institute. This course equips students with basic and intermediate Excel functions through informative lectures and engaging projects. Students can begin to develop their analytics portfolio and gain foundational knowledge to help with their careers and success in the Analytics Institute. We will put official sign up information and details on our main page closer to the start of the fall semester.

The year-long curriculum consists of six sessions:

Fall

Session 1: Introduction to Excel

This course will begin with a brief introduction to excel and business analytics. It will focus on basic statistical formulas like mean, median, mode, average, and sum, and functions like shortcuts and conditional formatting. It will also serve as an introduction to the Analytics Institute.

Session 2: Data Cleansing with Excel

This course will build off the basic knowledge to teach intermediate functions for data cleansing and visualization like Pivot Tables, Pivot Charts, and VLookup.

Session 3: Big Data Manipulation

The final course for the semester will focus on large dataset manipulation functions using PowerQuery and PowerPivot. These play integral roles in data importing and cleansing. This creates a transition into LEAP workshops involving PowerBI.

Spring

Session 4: Automated Analysis in Excel

The first course of the spring semester will include a brief review of the functions learned in the fall semester. Afterward, it will focus on one of the most important data analysis tools in Excel: IF Statements. Finally, the session will conclude with a brief tutorial on macros, which enables students to automate tasks in Excel.

Session 5: Excel Data Analysis Add-On

This course explores Excel’s Data Analysis Add-on, focusing on Solver and Regression. Solver is particularly important in data analysis, and can be used to find an optimal value given certain constraints. Knowledge of this function is also necessary to the core PittBusiness class Quantitative Methods, giving students who participate in this session a head start.

Session 6: Capstone Project

The final session of the Spring semester and the LEAP Core Curriculum continues with Excel’s What If? Analysis feature. It also engages students in a final data analysis project where they effectively demonstrate the skills they have learned to complete an analysis using real data.

The League of Emerging Analytics Professionals is honored to announce our recognition as one of the Pitt Business Student Organizations of the Year. By integrating a philanthropic aspect to our organization, increasing member engagement through membership prizes, and expanding our analytics awareness to new aspects of the university, our efforts have been rewarded. We are thankful for everyone who has put work into our organization to get us to where we are today, including previous board members, advisors, mentors, speakers, and our general body members. Our executive boards will continue to take the extra initiative to make LEAP a well-rounded, positive experience for our members.

Page updated

Google Sites

Report abuse