Subscribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: Dec 19th @8:00PM

Faculty: Mrs. Divya (7+ Yrs of Exp,..)

Duration : 2 Months

Venue :
DURGA SOFTWARE SOLUTIONS,
Flat No : 202, 2nd Floor,
HUDA Maitrivanam,
Ameerpet, Hyderabad - 500038

Ph.No: +91 - 9246212143, 80 96 96 96 96

Syllabus:

DATA ANALYTICS

POWER BI

• Index of Power BI
  
  
• What is Power BI
• Life cycle
• Features
• Skill set
• Power BI Architecture with components
  
  
• Working on Power BI Architecture
• Power BI Desktop Installation
• Connect to Power BI Desktop
  
  
• Source connections:
  
  
• Get data from various datasources
• Load data from multiple datasources
  
  
• Data Preparation and Transformation using Power Query
  
  
• Removing Missing values
• Removing Duplicates
• Change datatype
• Merge Unwanted columns
• Rename columns
• Split columns
• Pivot tables
• Date formats
• Adding Custom columns
• Replacing values
  
  
• Introduction to Data Visualization
  
  
• Power BI visuals
• Introduction to Data Modelling in Power BI
• Data Modeling (Practical)
• Explanation about what charts are used for what kind of data.
  1. Bar chart
  2. Column chart
  3. Line chart
  4. Area chart
  5. Pie chart
  6. Donut chart
  7. Tree map
  8. Map
  9. Filled Map
  10. Gauge
  11. Ribbon chart
  12. Waterfall chart
  13. Slicer
  14. Funnel
  15. Scatter chart
  16. Card
  17. Multi-row card
  
  
• Power BI filters
  
  
• Slicers
• Basic & Advanced Filters
• Top N filters
• Drill through
  
  
• Introduction to DAX
  
  
• Date/Time and date dim
• Text Functions
• Logical Functions
• Math Functions
• Aggregation Functions
• Filter Functions
• String Functions
• Time Intelligence Functions
• Information functions
• Other important functions
  
  
• Working with Dashboards
  
  
• Creating Dashboard
• Functionalities of Dashboard
• Practicals
  
  
• Best practices in DAX
• Quick measures
• Calculated columns and tables
  
  
• Interview Questions
• Sample Interview Questions

MYSQL

• Index of SQL w/r Data Analysis
  
  
• Introduction to Databases, SQL
• Creation of simple Databases & Tables
• Data Types
• INSERT
• UPDATE
• DELETE
• DROP
• Truncate, Keys
• SELECT
• WHERE
• Constraints
• ALTER
• Range & Membership operators
• DISTINCT & LIMIT
• Wildcards
  
  
• Functions :
• String Functions
• Numeric Functions
• Temporal Functions
• Date Functions
  
  
• JOINS :
• Inner
• Left, Right
• Outer
• Self join
• cross join
• Natural Joins
  
  
• Regular Expression
• GROUP BY
• Aggregation
• Generating Groups
  
  
• Sub Queries:
  
  
• Non correlated
• Correlated
  
  
• Normalizations
• Normal Forms (1NF,2NF,3NF)
• ER Diagrams
• Denormalization
  
  
• Conditional Logic
• Common Table Expressions(CTE)
  
  
• Recursive CTE
• Views
• Temporary Tables
• Indexing
• Stored Procedures
  
  
• Live project on Instagram Database