The objective of the workshop is to familiarize the participants with the fundamentals of how to manage, transform and analyze data using the various functions and the power of Microsoft Excel. Excel is a very widely used tool with many organizations and departments and being able to produce a quick analysis is an asset. Along with Excel being a data source and tool to manipulate data, nowadays databases are becoming very popular and part of every organization. Hence, learning and knowing the basics of SQL (Structured Query Language) has become very important. This workshop also takes you through the nuances and fundamentals of how SQL can be used with databases to ingest, manipulate and store data.
With the basic knowledge of Excel and a love for analysis, learn how this tool combined with advanced techniques can help you build analytics systems, data pipelines and interactive reports for stakeholder analysis.
Learn In No Time
In this module the learners will learn about various data transformation functions and will be able to apply the relevant function based on their use case with their own data.
In this module the learners will learn about various lookup functions as well as on how to handle errors.
In this module the learners will learn XLOOKUP, FUZZY LOOKUP, partial lookup using wildcards as well as lookup using INDEX and MATCH. The learners will be able to understand the usage of the various lookup functions and its applications.
In this module the learners will get comfortable with different date functions like NETWORKDAY.INTL, WORKDAY.INTL and how to handle data related to the calendar.
In this module the learners will learn to apply different text functions for data transformation.
This module will allow the learners to learn powerful features to summarize and organize the data for analysis.
By the end of this module, the learners will get a hands-on experience working on pivot table and the various components of pivot tables. Additionally, the learners will also learn how to perform quick analysis.
By the end of this module, the learners will get an understanding of ETL process, get comfortable in extracting data from multiple sources both live and static, cleaning them in power query and finally loading them in Excel. The learners will also learn to create an interactive dashboard for detailed analysis.
By the end of this module, the learners will get a hands-on experience working on advanced analytics features.
Forecasting in Excel
Depicting the insights from your data in the best possible manner is very important to any organization. This course provides an intensive hands on training on PowerBI for storytelling and analytics!
Depicting the insights from your data in the best possible manner is very important to any organization. This course provides an intensive hands on training on Tableau for storytelling and analytics!
MicroStrategy platform supports interactive dashboards, scorecards, highly formatted reports, ad-hoc queries, thresholds and alerts, and automated report distribution.
It's time to upskill for the Industry 4.0