TRAINING
FOR BUSINESS USERS
Datashift training for businesses users is a set of workshops that will introduce participants with "self-service BI" and enable themto create a BI system that will meet their needs for reporting.
Training is divided in a couple of units:
1
Theory basics
Introduces student with Excel and provides him with an insight into the basics of reporting and the quality of data visualization.
2
Reporting based on Excel
Based on a range of Microsoft free plug-ins and standalone tools which facilitate reporting in the standard table view (reporting using POWER PIVOT), retrieve and preparation of data for reporting (MS POWER QUERY) and facilitates creating real-life reporting system and corporate reporting system based on dashboards (control panels) with the use of MS POWER BI tool.
3
Research and analytics
Focuses on the use of statistics for the purpose of forecast, sales and customer behavior prediction. It is comprised of theoretical introduction intended for users of non-mathematical education and practical exercises using MS Excel.
4
Automatization in Excel
Includes everything that „can't be done manually“and is based on several MS Excel tools from VBA and macros to POWERQUERY usage.
5
Enterprise reporting
Based on industry leading software for data visualization - Tableau (other common enterprise solutions like Oracle based OBIEE, MS Reporting Services or Cognos are more IT than business users oriented and are covered in IT education).