Loading...
Learn techniques to effectively produce actionable reports and visualizations from data and data sets. You research data sets from a variety of business disciplines using Microsoft Excel, Excel Add-ins, Microsoft Power BI and Google Analytics. Through hands-on exercises, you leverage statistical, data-querying and dashboard tools to create products that accurately convey crucial business trends and themes.
Course Outline
Expand or collapse section
Course Objectives
- Explore a range of analytics and visual processes to effectively determine the best tools for the job.
- Learn to analyze and process data from spreadsheets and relational databases.
- Research the varieties of Internet data, and learn how to effectively represent them for business purposes.
- Learn to produce reports and dashboards that can successfully be converted to mobile platforms.
What You Learn
- Data analytics and visualization (A&V)
- Statistics for A&V
- Data from spreadsheets and relational databases
- Data from the Internet
- Microsoft Excel and add-ins for A&V
- Popular tools for A&V
- Microsoft Power BI for A&V
- Dashboard design
- Selecting visualizations
- Designing for mobile
- Validating your design
- Examples of dashboards
- Google Analytics for A&V
- Advanced topics
How You Learn
- In-class presentations by the instructor and A&V industry professionals
- Individual analysis and design papers
- In-class exercises and quizzes
- Team-programming assignments using a popular A&V platform
Is This Course Right for You?
This course is intended professionals, students and job-seekers interested in learning data analytics and visualization for business intelligence careers.