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
Duration : 10 hours
Batch Date: 14th November to 19th November 2024
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
Introduction
- Welcome!
- What is Power BI?
- Download & Installing Power BI
- Getting to know the interface
- Mini Project: Transform Data
- Mini Project: Visualize Data
- Mini Project: Creating a Data Model
Data Transformation – The
- Exploring the Query Editor
- Connecting to our data source
- Editing rows
- Changing data types
- Replacing values
- Close & Apply
- Connecting to a csv file
- Connecting to a web page
- Extracing characters
- Splitting & merging columns
- Creating conditional columns
- A little note regarding the next
- Creating columns from examples
- Merging Queries
- Pivoting & Unpivoting
- Appending Queries
- Practise & Solution: Population table
- The Fact-Dimension-Model
- Practise: Load the dimension table
- Organizing our queries in groups
- Text to be used in the next lecture
- Entering data manually
- Creating an index column
- Workflow & more transformations
Data Visualization
- Our first visual
- The format tab
- Understanding tables
- Conditional formatting
- The Pie Chart
- All about the filter visual
- The filter pane for developers
