Insightful Analytics: Using either PowerBI or Excel Dashboards for Informed Decision-Making
Timeline
-
April 1, 2024Experience start
-
April 30, 2024Experience end
Experience scope
Categories
Accounting Data analysis Talent recruitmentSkills
econometric modeling communication data analysis power bi dashboard business intelligence accounting innovation forecastingWelcome to Assiniboine Community College's Advanced Software Applications course! Our institution prides itself on fostering innovative partnerships between industry and education, providing students with real-world experiences to enhance their skills and knowledge.
Prepping data for analysis by cleaning data using Excel or Power Query Editor. Analyzing data in Excel using PivotTables and various functions. Creating dashboards in Excel for analysis purposes. Use PowerBI desktop to create reports. Students are in a two-year diploma program with specializations in Accounting or Human Resources.
Steps for Matching:
- Match Request Submission: Business owners, submit your project match requests! Upon submission, the professor will engage in a personalized discussion with you, ensuring the project's alignment with course objectives.
- Pre-Approval: Upon mutual agreement, both parties will confirm the match on the Riipen platform. It's important to note that projects are pre-approved at this stage, awaiting student selection.
- Educator and Students Choosing: Projects will be available for student selection. Our students, specializing in Accounting or Human Resources, will choose projects aligning with their interests and career aspirations.
- Collaboration Starts: Communication thrives on the Riipen platform, fostering an environment where educators, employers, and learners come together seamlessly.
Ideal Partner:
We seek partners committed to innovative collaboration, willing to engage with students in meaningful projects that challenge and inspire. Ideal partners possess a genuine interest in the intersection of econometric modeling and forecasting, and value the contributions of emerging talent.
Learners
Excel dashboard created from provided data to assist the company in analyzing data for a stated purpose.
Power BI report created to assist the company in analyzing data for a stated purpose.
Purpose of analyzing data could be for a solution to a Human Resources issue or Accounting related.
Project timeline
-
April 1, 2024Experience start
-
April 30, 2024Experience end
Project Examples
Requirements
Students have worked with small and large datasets to clean and analyze data using Excel and Power BI. Data analysis is done by creating PivotTables, Pivot Charts or reports.
- "Predictive Workforce Analytics: Leveraging Econometric Models in Human Resources"
- "Financial Forecasting for Small Businesses: Excel Dashboard Development"
- "Optimizing Budget Allocation: Data Analysis for Strategic Accounting"
- "Trend Analysis and Visualization: Utilizing Power BI in Marketing Strategy"
- "Employee Performance Evaluation: Econometric Modeling for HR Decision Making"
Additional company criteria
Companies must answer the following questions to submit a match request to this experience:
Can you provide examples of how Excel and Power BI will be utilized in the project?
Timeline
-
April 1, 2024Experience start
-
April 30, 2024Experience end