FUNDAMENTALS OF DATA ANALYTICS
Course Overview
In this course you will learn the skill of how to tell a story with data.
World Economic Forum forecasts that data analysts will be in demand due
to increase in data collection and usage. According to the Economist,
organizations view data analysis as one of the most crucial future specialties
due to the value that can be derived from data. Data is considered to be the
new oil of the digital age & one of the most valuable resources for an
organization; thus protecting and analyzing data is becoming extremely
important. Furthermore, Data is more abundant and accessible than ever in
today’s business environment. In fact, according to Forbes, 2.5 quintillion
bytes of data are created each day. With an ever-increasing skill gap in
data analytics, the value of data analysts is continuing to grow, creating
new jobs and career advancement opportunities.
Professionals planning to enter the Data Science and Analytics field
will have their pick of jobs and enjoy lucrative salaries. According to an IBM
report, data and analytics jobs are predicted to increase by 15 percent to
2.72 million jobs by 2020, with the most significant demand for data analysts
is in finance, insurance & information technology.
This Course is designed to teach data analysis and business
intelligence in a hands-on manner and prepare the participants for a career
in this field. The course will provide instruction and hands-on training for
students to feel confident and to begin work in the industry as a Business
Intelligence Analyst or a Data Analyst.
A Data Analyst profile can be associated with mining, extraction,
transformation, cleansing, modeling and loading of data according to
business requirements. For those with an analytical mind, this is the place
to be. There is limited talent available in the industry for this work and the
scope is growing fast. Every industry wants Business Intelligence in order
to make smarter decisions.
Course Content and Topics:
The program will provide instruction and training for the participants to feel
confident to start working in the industry. By the end of this program
participants would have learned the following:
• Introduction to the world of data
• Database Management System a Basic Over View
• Database Structure and SQL Select statements
• Filtering Data in SQL
• Sorting data in SQL
• Functions in SQL
• Set operators and derived tables in SQL
• Joins and subqueries in SQL
• Data definition language (DDL)
• Normalization and database design
• Connecting data to Power BI
• Data storytelling and data transformation using Power BI
• How to filters data and create hierarchies
• Calculated fields and Measures
• Sharing and Publishing Dashboards
• Security Features in Power BI
• Understanding Big Data and Data warehousing
• Class Project or Exam
Note: After completing this course you should be able to sit for the
following Certification Examinations - Analyzing and Visualizing Data with
Microsoft Power BI (Exam 70 - 778)