सक्षम -Analytics Essential - Innozant MIS & Data Analytics & Data Science

Administrator Expert

Description

सक्षम Program intends to make you capable to stand out in the field of MIS & Data Analytics by learning minimum required industry required skill now a days.
Its a certification program in which students are taught about the:
MS Advanced Excel + SQL Analytics + MS Power BI
Now a days skills are more important than higher education. This course is designed to teach you the basics of MIS & Data Analysis. Our certification programs targets graduates/under-graduates student and those working professionals who either want to enter or switch into the vast field of MIS and Data Analysis. This program meets current industry trends. We understand that technologies evolve and our training model allow us to evolve with them to ensure that you get advantage. It aims at making you more skilled as per industry expectations.

What you will learn:

  • Build a solid understanding on the Basics of Microsoft Excel
  • How to use Workbooks and Worksheets
  • FILTER, XLOOKUP, SORT & UNIQUE functions
  • How to avoid the most common Database Design flaws
  • Functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, INDEX and much more…
  • Learn several hidden Excel tips and tricks
  • Learn to use Charts, Pivot Tables, Pivot Charts, Slicers and Time Lines for Interactive Excel Reports.
  • Learn to make dashboards.
  • Learn how to work with Google Sheets
  • Learn Excel with ChatGPT
  • Create, design, and operate with SQL databases
  • Perform basic SQL operations using SELECT, INSERT, UPDATE & DELETE statements
  • Create tables and load data
  •  Query data using string patterns and ranges
  • Sort and group data in result sets
  • Invoke built-in database functions such as MIN(), MAX(), AVG(), etc.
  • Handle complex SQL joins with ease
  • SQL’s triggers, sequences, local and global variables, indexes, and more…
  • Become a proficient SQL user by writing flawless and efficient queries
  • Understand Power BI Desktop and its components
  • Learn how to use the Query Editor  & Data Model
  • How to create calculated columns and measures
  • How to build relationships between different tables
  • How to create a report with different interactive visualization types
  • Learn how to use Power BI Service(= Power BI Pro) to create dashboards and to share and publish your results

Download Brochure

Topics for this course

99h 59m 59s

Time Duration : 6 – 8 Months

MS Advanced Excel

SQL Analytics

MS Power BI

13,999.00
  • Course level: Expert
  • Duration 99h 59m 59s