-
-
- Online Learning
- Custom Programs
-
-
-
- Academic Services
- Course and Program Information
-
-
-
Berkeley Global
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, 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.
Prerequisites:
- Successful completion of a math or statistics undergraduate course.
- Proficiency with Microsoft Excel features for managing data in spreadsheets.
- Basic understanding of the goals, processes and operations of business enterprises.
- A laptop running Windows and Excel. You can use Mac laptops but will be responsible for installing Windows on your Mac using one of the many utilities available.
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 responsive dashboards and reports that successfully display on laptops, mobile devices, or digital signs.
What You Learn
- Data analytics and visualization (DAV)
- Statistics for DAV
- Data from spreadsheets and relational databases
- Data from the Internet and IoT
- Microsoft Excel for DAV
- Popular tools for DAV
- Microsoft Power BI
- Dashboard design
- Selecting visualizations
- Designing for mobile
- Validating your design
- Google Analytics
- Advanced topic: Statistical forecasting
How You Learn
- In-class presentations by the instructor and DAV industry professionals
- Individual analysis and design papers
- In-class exercises and quizzes
- Team-programming assignment using a team-chosen DAV platform such as Tableau
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.
Loading...