Data Analytics for Managers
Davenport University's Institute for Professional Excellence
Course description
Data Analytics for Managers
Analyzing data to find issues, timely insights, and opportunities is now a critical part of many job roles. Leveraging data effectively can create a significant competitive advantage. Beyond the analysis, managers must also be able to effectively present and communicate findings in visually compelling ways. Learn to perform robust data analysis and visualization using Microsoft Excel in Davenport University’s Data Analytics for Managers. Experience interactive classes and hands-on projects for analyzing and interpreting data to understand business performance, impact, and trends.
Who should attend?
Who Should Attend:
This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel. To ensure success, participants should have baseline skill using Microsoft Excel worksheets.
Training content
Data Analysis Fundamentals and Visualizing Data with Excel
Identify, manipulate, and visualize data with Excel.
Analyzing Data with Formulas & Functions
Analyze data with formulas and functions in Excel. Implement data validation and create visualizations.
Analyzing Data with PivotTables and Presenting Visual Insights with Dashboards
Create and analyze PivotTable data, visualize and filter data, and create dashboards.
Transforming Data
Combine, shape and transform data using queries, data models, map charts, and visualizations.
Data Insights and Reports
Identify trends and forecasts using reports to guide more effective decision-making.
Certification / Credits
Credits: .15 CEUs
Credits: 15 PDCs
After completing this course, you will be able to:
- Perform fundamental data analysis
- Get and transform data for decisions
- Visualize data with Excel
- Analyze data with formulas, functions, and PivotTables
- Present visual insights with dashboards in Excel
- Perform statistical analysis
- Model and analyze data with Power Pivot
- Present insights with dashboards and reports
Why choose IPEx?
With over 150 years of innovative experience in leading-academic thought, Davenport brings the real world of business into each class.
Having strategically partnered with hundreds of businesses and organizations over the last 25 years, Davenport University’s IPEx has the experience to help organizations meet goals and achieve their vision of success.
From Michigan to Malaysia, as well as India, Canada, China, Australia, Brazil and beyond, IPEx has a global presence where learning happens with our international participants.
About IPEx
Davenport University's Institute for Professional Excellence
Grow through professional development delivered the IPEx way — with an eye on your time and your budget. Davenport University’s Institute for Professional Excellence (IPEx) offers professional development courses focused on topics with real-world relevance, aimed at making you more...
Contact this provider
Contact info
Davenport University's Institute for Professional Excellence
Have a question about this course? Fill out this form and the provider will get in touch with you shortly
No reviews available
Need help with your search?
findcourses.com offers a free consultancy service to help compare training for you and your team
