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.
Biomedical · Course
Medical Data Analytics & Visualization
Learn about Medical Data Analytics & Visualization.
- Duration
- 35 weeks
- Content
- 54 hours
- Projects
- 3
- Mode
- Online
OverviewWhat you'll
What you'll
be able to do.
- 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.
Tools you'll use
TableauPower BIMS Excel
Curriculum35 modules,
35 modules,
built with industry.
01Medical Data Analytics & Visualization
- Module 1 - Course Introduction and FundamentalsW01
- 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 WorksheetsW02
- 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 ChartW03
- 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 TablesW04
- 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 FunctionsW05
- 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 FunctionsW06
- 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 QueryW07
- 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 ToolsW08
- 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 TabW09
- 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 MacrosW10
- 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 BasicsW11
- 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 ApplicationW12
- Email Automation
- Basics of Emailing Section
- Understanding Email Routine
- Email Loop
- Excel Tips and Tricks
- Industry Standards
- How to Apply your Learning?
- Email Automation
- Module 13 - Introduction to TableauW13
- 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 PaneW14
- Basics of Data Pane
- Quick Visualisations
- Marks and its Properties
- Pages Shelf
- Menu and Toolbar
- Analytics Pane
- Module 15 - Data Types, Sorting, GroupingW15
- 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 CalculationsW16
- 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 PracticesW17
- Parameters
- Action Filters
- Dashboard Layout
- Sizing and Object
- Formatting
- Stories
- Best Practices
- Module 18 - Distribution and PublishingW18
- Distribution
- Exporting
- Workbook File Types
- Publishing
- Replacing Data Sources
- Module 19 - Joins and BlendingW19
- Joins
- Inner and Outer Join
- Left and Right Join
- Blending
- Union
- Module 20 - Relationships (2020.2 and Later Versions)W20
- 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 ActionsW21
- Pivot
- Custom Split
- Hide & Unhide Fields
- Sampling the Data
- Interactivity
- Parameter Actions
- Set Actions
- Module 22 - Advanced Calculations and AnalyticsW22
- Advanced Calculations
- Regular Expressions
- Table Calculations
- Use Cases
- Trend Lines
- Clustering and Forecasting
- Module 23 - Nested LODs and Mapping FunctionsW23
- 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 VisualizationsW24
- Dynamic Designs
- Ways to Create
- Interactivity
- Extensions
- Tooltip in Visualizations
- Performance Recording
- Design Principles
- Module 25 - Introduction to Power BIW25
- 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 1W26
- 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 2W27
- Merging, Modifying & Appending Queries
- Connecting to Folders
- Defining Hierarchies & Categories
- Best Practices of Query Editing & Power BI
- Module 28 - Relational Data Model - Part 1W28
- Data Model
- Database Normalization
- Data Table Types
- Creating Power BI Table Relationships
- Table Schemas
- Relationships
- Module 29 - Relational Data Model - Part 2W29
- 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 1W30
- 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 2W31
- DAX Syntax
- Common DAX Functions
- Text Functions
- Related
- Basic Mathematical & Statistics Functions
- Calculate
- All
- Filter
- Time Intelligence Functions
- Module 32 - Advanced DAX FunctionsW32
- Calculated Joins between Tables
- Relationship Functions
- Advanced Time Intelligence
- Module 33 - Creating Interactive Reports - Part 1W33
- 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 2W34
- 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 3W35
- Power BI Service: Introduction
- Power BI Service Administration
- Connecting to Multiple Types of Data
- Module 1 - Course Introduction and FundamentalsW01
Industry projects3 projects
3 projects
you'll ship.
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.
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…
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 wom…
FeeOne fee.
One fee.
Everything included.
Become job ready with our comprehensive industry focused curriculum for freshers & early career professionals
Premium
₹40,000
Inclusive of all charges- 1 Year Access
- Personalized Page
- Live Individual & Group Sessions
- Personalized & Hands-On
- Job-Oriented Industry Relevant Curriculum
Related
You might also like.
Course · 6 weeksIntroduction to Medical Image Processing→Course · 5 weeksDesign for Manufacturability (DFM)→Course · 11 weeksMedical Imaging and Radiology→Course · 12 weeksAdvanced Medical Image Processing in Clinical Applications→Course · 14 weeksRegulatory Process, Standards and Certifications for Medical Devices→Course · 16 weeksFrontiers in Biomedical Engineering→
Next stepNot sure it's
Not sure it's
the right fit?
A counsellor will walk you through the syllabus, projects and fee options — and tell you honestly if another course suits you better.