The data analytics course provides fundamental concepts of data analytics through real world case studies and examples and gives insights into how to apply data and analytics principles in your business. You’ll learn about project lifecycles, the difference between data analytics, data science, and machine learning; building an analytics framework, and using analytics tools to draw business insights.
Course Objective:
We see how we can work on complex data and make dashboards with it, we also work on Power BI which is a data analytics tool that makes map, charts and beautiful dashboard and story.
Prerequisites:
- This Introduction to Data Analytics course has been designed for all levels, regardless of prior knowledge of analytics, statistics, or coding. Familiarity with mathematics is helpful for this course.
WIIFM (What’s in it for Me):
When you complete this Introduction to Data Analytics course, you will be able to accomplish the following:
- Understand how to solve analytical problems in real-world scenarios
- Define effective objectives for analytics projects
- Work with different types of data
- Understand the importance of data visualization to drive more effective business decisions and ROI
- Understand charts, graphs, and tools used for analytics and use them to gain valuable insights
- Create an analytics adoption framework Identify upcoming trends in data analytics
Delivery Mode: 100% Online Live Instructor-led learning
Batch Date: Batch to be announced
Curriculum
Working with the Web and External Data
- Inserting a Hyperlink
- Importing Data from an Access Database or Text File
- Importing Data from the Web and Other Sources
- Working with Existing Data Connections
Working with PivotTables
- Creating a PivotTable
- Specifying PivotTable Data
- Changing a PivotTable’s Calculation
- Filtering and Sorting a PivotTable
- Working with PivotTable Layout
- Grouping PivotTable Items
- Updating a PivotTable
- Formatting a PivotTable
- Creating a PivotChart
- Using Slicers
- Sharing Slicers Between PivotTables
It’s super easy to get Started
- Welcome! What is Tableau & Course Overview
- Installation
Tableau Basics Your First Bar chart
- The Business Challenge – Who Gets the Annual Bonus
- Connecting Tableau to a Data File – CSV File
- Navigating Tableau
- Creating Calculated Fields
- Adding Colors
- Adding Labels and Formatting
- Exporting Your Worksheet
- Get The Viz!
Time series, Aggregation, and Filters
- Section Intro
- Working with Data Extracts in Tableau
- Working with Time Series
- Understanding Aggregation, Granularity, and Level of Detail
- Creating an Area Chart & Learning About Highlighting
- Adding a Filter
Maps, Scatterplots, and Your First Dashboard
- Section Intro
- Joining Data in Tableau
- Creating a Map, Working with Hierarchies
- Creating a Scatter Plot, Applying Filters to Multiple Worksheets
- Let’s Create our First Dashboard!
- Adding an Interactive Action – Filter
- Adding an Interactive Action – Highlighting
Joining and Blending Data, PLUS Dual Axis Charts
- Section Intro
- Understanding how LEFT, RIGHT, INNER, and OUTER Joins Work
- Joins With Duplicate Values
- Joining on Multiple Fields
- Data Blending in Tableau
- The Showdown Joining Data v
- Dual Axis Chart
- Creating Calculated Fields in a Blend (Advanced Topic)
- Section Recap
