Certificate Course in Data Analysis (C-DA)

A certificate course in MIS, Advanced Excel, and Power BI, equipping you to manipulate, analyze, and visualize data for actionable insights and a successful career in data analysis.

Key Highlights:

• Comprehensive curriculum
• MIS with Advanced Excel and Power BI comprehensively, our curriculum equips you with the essential skills to manipulate, analyze, and visualize data effectively, enabling you to make data-driven decisions and deliver impactful reports.
• Hands-on experience
• By engaging in practical exercises and real-world examples, you'll gain hands-on experience and develop the confidence to apply your data analysis skills effectively in professional settings
• Data visualization
• Data manipulation, analysis, and visualization
• Data manipulation, analysis, and visualization techniques for diverse datasets, you will develop a comprehensive skill set to tackle various data analysis challenges
• Mastery of advanced Excel
• Advanced Excel functions and formulas for data analysis, you will be equipped with the necessary tools to efficiently manipulate, analyze, and derive meaningful insights from data.
• creating interactive dashboards and reports using Power BI, you'll be able to effectively analyze and present data in a visually appealing and user-friendly manner.
• Career prospects
• MIS Executives and Dashboard Designers offer exciting opportunities to work with data, analyze trends, and contribute to informed decision-making processes.

Eligibility Criteria?

• Aspiring data analysts, business analysts, researchers, and professionals who want to gain skills in data analysis should consider this course.

Course Content:

• Data Analytics Overview
• Data Visualization for Decision making
• Data Analytics in Different Sectors
• Understanding of the importance of data visualization
• Excel Essentials
• Excel Essentials
• Working with Multiple Worksheet
• Cell Referencing
• Working with Data Lists
• Conditional Formatting
• Data Validation
• What-If Analysis
• Formula Auditing
• Protection
• Formulas & Functions
• Conditional Function
• Text & Statistical Function
• Financial Function
• Creating HLOOKUP and VLOOKUP Functions
• Advanced Conditional Formatting
• Advanced Lookup and Reference Functions
• Dashboard Designing (MIS)
• Creating Dashboard
• Charts & Sparkline’s
• Use of Power Pivots for Data Analysis
• Use of Power Queries & Power Map
• Pivot table Dashboard with Slicers
• Automation
• Working with External Data
• Exporting & Importing Data
• Excel, Access, PPT, TXT, CSV
• Updating Charts, Table in PowerPoint
• Converting Reports into PDF
• Exporting Charts, Tables to PowerPoint
• Introduction to Power BI
• What is Power BI
• Installing Power BI Desktop
• Exploring the Power BI Workflow
• Transforming Data with Power BI Desktop
• Connecting to different sources
• Different connecting Options
• Shaping and transforming data with Power Query
• Editing, Merging, Appending queries etc.
• Modeling with Power BI
• Introduction to Modeling
• Building Relational Models
• Creating table relationships
• Understanding the filter flow
• Cardinality and Cross filtering
• Introduction to DAX
• Understanding DAX Syntax
• DAX calculation types
• DAX functions
• Using variables in DAX expressions
• Table relationships and DAX
• DAX tables and filtering
• M Language
• IF...ELSE Conditions, Transform Column () Types
• Remove Column (), Spilt Columns (), Replace value ()
• Table. Distinct option and Group BY option Table.
• Group (), Table. Sort () With Type Conversions PIVOT
• Operation and Table. Pivot (). List Functions Using
• Parameters with M language
• Visualizing Data with Reports
• Creating Visualisations
• Color & Conditional Formatting
• Sort Order
• Scatter & Bubble Charts & Play Axis
• Tooltips, Slicers
• Timeline Slicers & Sync Slicers
• Cross Filtering and Highlighting
• Visual, Page and Report Level Filters
• Drill Down/Up, Hierarchies
• Constant Lines
• Tables, Matrices Table Conditional Formatting
• Map Visualisations
• Creating Dashboards
• Pin Visuals and Pin Live Report Pages to Dashboard
• Advantages of Dashboards
• Interacting with Dashboards
• Formatting Dashboard
• Sharing Dashboard