Menu
Medical Data Analytics & Visualization
RELATED RECENT PLACEMENTS
Anupama Yeragudipati
Kabira Mobility
Gurunanak Khalsa College
Arun Kumar
Riverstone
Anna University
Paul Willington
DGS Technical Services Pvt. Ltd.
SAVEETHA SCHOOL OF ENGINEERING ,CHENNAI
IVIN TROY
Kabira Mobility
College of Engineering and Management,Punnapra
Karuthapandi K
DGS Technical Services Pvt. Ltd.
S. Veerasamy Chettiar college of engineering and technology
Gowsikraj M
Hyundai Motor India Ltd
Sri krishna college of technology
Mujahidoddin Saudagar
Hyundai Motor India Ltd
G.H Raisoni college of engineering and management Amravati
Krutika Ravikumar
Genpact
R.V.College of Engineering
Syllabus
This course is full of best-in-class content by leading faculty and industry experts in the form of videos and projects
Course Overview
- Data analysis and visualization are at the core of business operations in organizations across many industries. As a result of this, there’s an ever-growing demand for engineers skilled in data analysis using tools such as Microsoft Excel, Tableau, and R. Through data visualization, organizations can draw inferences, compare data, identify errors, recognize patterns, and present all their findings in one place.
- In this course, you will learn how to analyze, visualize, and draw inferences from a dataset.
- You will gain an established understanding of key concepts such as data types, sorting, blending, grouping, filtering, and table calculations.
- By taking this course, you will learn how to build a complete dashboard, while adhering to best practices followed in the industry.
- This course will progress into advanced calculations and analytics, nested Level of Details (LODs), dynamic designs, and Tooltip visualizations.
Course Syllabus
On a daily basis we talk to companies in the likes of Tata Elxsi and Mahindra to fine tune our curriculum.
Module 1 - Course Introduction and Fundamentals
- Launching Excel and Version Check
- Basics of the Interface
- Saving an Excel Document
- Common Shortcuts
- Entering and Editing Data
- Relative and Absolute Cell References
- Formatting
- Customizing the Quick Access Toolbar
- Excel Self Help
Module 2 - Basic Excel Functions and Modification of Worksheets
- Basic Functions
- Design of Excel Functions
- Understanding SUM(), MIN() & MAX()
- Understanding AVERAGE()
- Understanding COUNT()
- AutoSum and Autofill/Flash fill
- Modification
- Inserting New Sheets, Rows and Columns
- Deleting Sheets, Rows and Columns
- Moving or Copying Sheets
- Sheet formatting
- Excel Options
- Customize Ribbon
Module 3 - Data Formatting, Working with Shapes & Images, Creating your First Chart
- Data Formatting
- Cell formatting – Merge, Alignment
- Borders
- Currencies and Percentages
- Format Painter
- Conditional Formatting
- Find & Search
- Shapes & Images
- Inserting Shapes & Images
- Formatting Excel Shapes
- SmartArt
- Creating your First Chart
- Creating Chart
- Chart Options
- Types of Charts
- Chart formatting
- Date Functions
- DATE() & DATEVALUE()
- NETWORKDAYS()
- EOMONTH() & EDATE()
Module 4 - Excel Templates, Excel Options and Printing your Excel Worksheets, Introduction to Tables
- Excel Templates
- Importing Excel Template
- Custom Template
- Printing Worksheets
- Print Preview
- Margins and Scaling
- Page Layout
- Headers and Footers
- Specific Range
- Tables
- Table Options
- Table Formatting
- Table References
- Working with Formulas
- Benefits of Tables
Module 5 - Conditional Functions and Other Functions
- Conditional Functions
- Understanding IF()
- Understanding SUMIF() & SUMIFS()
- Understanding COUNTIF()
- Use of AND & OR with IF()
- Understanding IFERROR()
- Other Functions and Text Functions
- Understanding COLUMN() & ROW()
- Understanding TEXT()
- Understanding LEFT(), RIGHT() & MID()
- Understanding LEN(), CONCAT()
- Understanding TRIM(), PROPER(), FIND()
Module 6 - Pivot Tables and Lookup Functions
- Pivot Tables
- Data source
- Pivot Table Structuring
- Pivot Table Options
- Pivot Table Formatting
- Lookup Functions
- Understanding VLOOKUP()
- Understanding HLOOKUP()
- Understanding INDEX & MATCH
- Understanding XLOOKUP()
- Understanding OFFSET()
Module 7 - New Functions, Data Tab, and Introduction to Power Query
- New Functions
- Understanding UNIQUE()
- Understanding FILTER()
- Understanding IFS()
- Understanding SORT(), SORTBY()
- Understanding SWITCH()
- Data Tab
- Data Import
- Data Cleaning and Transform
- What is Power Query?
- Use of Power Query
Module 8 - Advanced Pivot Table Functions and PowerPivot Tools
- Advanced Pivot Table Functions
- Fields, Items & Sets
- Pivot Charts
- Slicers and Timeline
- Group & Ungroup
- GETPIVOTDATA()
- PowerPivot Tools
- Basics of Excel Power Pivot
- More Tables and Relationships
- Creating Data Models
- KPIs
Module 9 - Large Data Sets, File Protection, Named Ranges, and More in Data Tab
- Working with Large Data Sets
- Freeze Panes
- Grouping Data
- Consolidating Data from Multiple Worksheets
- File Protection
- Protecting Specific Cells in a Worksheet
- Protecting the Structure of a Workbook
- Adding a Workbook Password
- Data Tab
- Custom Sorting
- What-If Analysis
- Text to Columns
- Data Validation
- Understanding Data Validation
- Custom Data Validation Error
- Dynamic Formulas in Validation
Module 10 - List Functions and Excel Automation using Macros
- List Functions
- Understanding DSUM()
- Understanding DSUM() with AND/OR()
- Understanding DAVERAGE()
- Understanding DCOUNT()
- Understanding SUBTOTAL()
- Excel Automation using Macros
- Understanding Macros
- Creating Macro with Macro Recorder
- Editing Macros with VBA
- Creating Buttons
Module 11 - VBA Basics
- Basics of VBA
- VBA Editor
- Adding Code to VBA procedure
- VBA variables
- IF Statements
- Loops
- Automating Tasks
- Input and User Messages
- Handling Errors
Module 12 - Email Automation and Industry Application
- Email Automation
- Basics of Emailing Section
- Understanding Email Routine
- Email Loop
- Excel Tips and Tricks
- Industry Standards
- How to Apply your Learning?
Module 13 - Introduction to Tableau
- Basics and Installation of Tableau
- Types of Products and Roles
- Interface and Workflow
- Tableau Dashboards vs PPT
- Connecting to Data
- Data Source & its Types
- Live and Extracts Connections
Module 14 - Shelves, Cards, and Analytics Pane
- Basics of Data Pane
- Quick Visualisations
- Marks and its Properties
- Pages Shelf
- Menu and Toolbar
- Analytics Pane
Module 15 - Data Types, Sorting, Grouping
- Sheet Interface
- Data Types
- Dimensions and Measures
- Sorting & Custom Sort and Grouping
- Sets & Combines Sets and Hierarchies
- Highlight Data
- Split & Custom Split
Module 16 - Filtering & Table Calculations
- Filters, Filter Types, and Order Process
- Highlighted Data
- Context Filter and its Uses
- Calculated Fields
- Aggregations and their Uses
- Table Calculations
- Level of Detail Expression (LODs)
- Bins and its Uses
Module 17 - Complete Dashboard Building and Best Practices
- Parameters
- Action Filters
- Dashboard Layout
- Sizing and Object
- Formatting
- Stories
- Best Practices
Module 18 - Distribution and Publishing
- Distribution
- Exporting
- Workbook File Types
- Publishing
- Replacing Data Sources
Module 19 - Joins and Blending
- Joins
- Inner and Outer Join
- Left and Right Join
- Blending
- Union
Module 20 - Relationships (2020.2 and Later Versions)
- Relationships
- Data Models
- Relationships vs Joins
- Creating and Optimizing a Relationship
- Types of Relationships
- Smart Aggregations and their Types
Module 21 - Data Preparations, Parameter & Set Actions
- Pivot
- Custom Split
- Hide & Unhide Fields
- Sampling the Data
- Interactivity
- Parameter Actions
- Set Actions
Module 22 - Advanced Calculations and Analytics
- Advanced Calculations
- Regular Expressions
- Table Calculations
- Use Cases
- Trend Lines
- Clustering and Forecasting
Module 23 - Nested LODs and Mapping Functions
- Nested LOD and Use Cases
- Geo Mapping
- Geospatial Data and Use Cases
- Standard Maps
- Map Hierarchies
- Map Layers
- Background Maps
- Common Issues
Module 24 - Dynamic Designs, Extensions, and Tooltip Visualizations
- Dynamic Designs
- Ways to Create
- Interactivity
- Extensions
- Tooltip in Visualizations
- Performance Recording
- Design Principles
Module 25 - Introduction to Power BI
- Power BI: Introduction
- Why Power BI?
- Installing Power BI
- Power BI Query Editor: Introduction
- Types of Power BI Data Connectors
- Basic Table Transformation
Module 26 - Transform Data (Query Editor) - Part 1
- Data Transformation in Power BI
- Basic Table Transformation
- Text, Number & Date Tools
- Index & Conditional Columns
- Grouping & Aggregating Data
- Pivoting & UnPivoting
Module 27 - Transform Data (Query Editor) - Part 2
- Merging, Modifying & Appending Queries
- Connecting to Folders
- Defining Hierarchies & Categories
- Best Practices of Query Editing & Power BI
Module 28 - Relational Data Model - Part 1
- Data Model
- Database Normalization
- Data Table Types
- Creating Power BI Table Relationships
- Table Schemas
- Relationships
Module 29 - Relational Data Model - Part 2
- Relationship Cardinality
- Connecting Multiple Data Tables
- Filter Flow
- Two Way Filter
- Filtering & Cross-Filtering
- Hiding Fields from the Power BI Report View
- Data Modeling & Power BI Best Practices
Module 30 - Basics of DAX - Part 1
- Data Analysis Expressions (DAX): Introduction
- Calculated Columns vs Measures
- DAX Syntax and Operators
- Common DAX Functions
- Basic Date and Time Formulas
Module 31 - Basics of DAX - Part 2
- DAX Syntax
- Common DAX Functions
- Text Functions
- Related
- Basic Mathematical & Statistics Functions
- Calculate
- All
- Filter
- Time Intelligence Functions
Module 32 - Advanced DAX Functions
- Calculated Joins between Tables
- Relationship Functions
- Advanced Time Intelligence
Module 33 - Creating Interactive Reports - Part 1
- Power BI Report View: Introduction
- Adding Basic Charts to Power BI Reports
- Create a Visualization
- Filtering Options
- Matrix Visualization
- Slicers & Timelines
- Key Performance Indicator (KPIs) Chart
- Power BI Map Visuals (Basic, Fill, ArcGIS)
Module 34 - Creating Interactive Reports - Part 2
- TreeMaps, Lines, Areas & Gauges
- Editing Report Interactions
- Adding Drill through Filters
- Linking to Report Bookmarks
- Using "What-If" Parameters
- Managing & Viewing Roles
Module 35 - Creating Interactive Reports - Part 3
- Power BI Service: Introduction
- Power BI Service Administration
- Connecting to Multiple Types of Data
Our courses have been designed by industry experts to help students achieve their dream careers
Industry Projects
Our projects are designed by experts in the industry to reflect industry standards. By working through our projects, Learners will gain a practical understanding of what they will take on at a larger-scale in the industry. In total, there are 3 Projects that are available in this program.
COVID-19 Vaccinations Trend Analysis
In this project, learners have to track and analyze COVID-19 vaccination trends to see doses administered by manufacturer, country, region, age, and gender.
Data Cleaning and Transformation using Pivot Table and Charts
In this project, you will be given a large set of data from ABC Private Limited that is manufacturing and selling various types of automobiles. With this information, you will have to format the data and summarize product sales (in terms of the total sum of sales, average sales, the standard deviation of sales, the variance of sales, maximum sales, and minimum sales). In addition to this, you will also have to create a spreadsheet with information on fields status, product line, and sales using Pivot Table. From the concepts learned in the course, you will have to make customized ribbons, analyze the ordered quantities, present the data appropriately, clean the data, and highlight the top 10% of values using conditional formatting.
Developing a Dashboard on Tableau - Women in STEM Fields
Learners are required to develop a dashboard on Tableau with a given data set. The data set will have data about the women who graduated (year of graduation, number of employed women, those in STEM jobs, educational level, and salary comparisons). At the end of this project, learners are to deliver a dashboard that resembles an article predicting basic issues. It should be titled “Women in STEM Fields” and have pie graphs as well as comparisons regarding the statistics. Learners are also to write insights regarding the gender game in the STEM industry.
Our courses have been designed by industry experts to help students achieve their dream careers
Ratings & Reviews by Learners
Skill-Lync has received honest feedback from our learners around the globe.
Flexible Pricing
Talk to our career counsellors to get flexible payment options.
INR 40,000
Inclusive of all charges
Become job ready with our comprehensive industry focused curriculum for freshers & early career professionals
1 Year Accessto Skill-Lync’s Learning Management System (LMS)
Personalized Pageto showcase Projects & Certifications
Live Individual & Group Sessionsto resolve queries, Discuss Progress and Study Plans.
Personalized & Hands-OnSupport over Mail, Telephone for Query Resolution & Overall Learner Progress.
Job-Oriented Industry Relevant Curriculumavailable at your fingertips curated by Global Industry Experts along with Live Sessions.
Instructors profiles
Our courses are designed by leading academicians and experienced industry professionals.
3 industry experts
Our instructors are industry experts along with a passion to teach.
8 - 12 years in the experience range
Instructors with 8 - 12 years extensive industry experience.
Areas of expertise
- Tableau
- Full Stack development
- SQL
- Power BI
Similar Courses
Got more questions?
Talk to our Team Directly
Please fill in your number & an expert from our team will call you shortly.