academics Excel Expert University Degree Data Management and Visualization - Information and Facts

More and more, we have to manipulate and reprocess data from internal company software (ERP, accounting packages, etc.) or from our partners (customers, suppliers, etc.) in order to produce analyses that enable us to monitor our activity and transform the usable information into action. These analyses (reports and dashboards) and the processing that allows them to be generated are rarely automated in companies, which results in a significant loss of time when they are updated. Their preparation is also greatly complicated by the heterogeneity and the large volume of source data on which they are based. New tools and best practices now make it possible to automate these reports and dashboards quite easily.

Download in PDF format :

If you have any queries, please use the form at the bottom of this page.

START OF THE academics : consult us

Contact:

OBJECTIVES :

  • Ensure proficiency in tools such as Microsoft Excel, Microsoft Access, Microsoft Power BI.
  • Master the methods dedicated to data management.
  • Visualise and manipulate big data.
  • Discover the R language for statistics and data science.

RHYTHM:

  • The academics cycle of 154 hours takes place from January to December, with 2 to 4 days per month, i.e. 22 days of 7 hours each in person.
  • Possibility to follow the modules à la carte and the DU over 2 years.

MODULES 1: Legislation and data security - 1 day

  • Understand the new rules related to the PMPRB.
  • Understand the logic of data security.

MODULES 2: Statistical Calculations for Decision-Making - 3 Days

  • Exploit management tools.
  • Identify the right law for a management problem and interpret probabilities.
  • Calculate and interpret an expectation and a standard deviation of different indicators for a product.

MODULES 3: Data analysis with Microsoft Excel and VBA - 4 days

  • Structure data in a spreadsheet program for processing in lists, extractions and consolidations.
  • Graphically format the data.
  • Build and manipulate pivot tables in Excel.
  • Automate tasks with VBA.

MODULES 4: Excel Tools for Business Intelligence: Power Query, Power Pivot, Power View and Power Map - 2 days

  • Automate the loading of heterogeneous data with the Power Query tool.
  • Master the Power Pivot tool for data analysis.
  • Master the Power View interactive dashboard creation tool.
  • Master the realization of indicators on geographical maps using Power Map.

MODULES 5: Data Visualization with Microsoft Power BI - 4 Days

  • Automate the loading of complex data with Power Query. Create star and flake decision models.
  • Create interactive dashboards in Power BI.
  • Master report publishing in Microsoft Power BI Service, report sharing and report viewing on mobile and tablet devices.

MODULE 6: Database Management - 4 days

  • Design a database and manipulate data in a relational database.
  • Develop a Microsoft Access application for data management (querying, displaying data in reports and forms).

MODULES 7: New Challenges in Data Management: Towards Data Intelligence - 4 Days

  • Programming dynamic dashboards with the R programming language dedicated to data sciences.
  • Integrate R code into Power BI to improve data dynamicity.
  • Understand advanced concepts related to data intelligence.

PUBLICS :

Any professional handling data: Production Managers, Management Staff, Accountants/Accountants, Salespeople, HR Managers, Financial Analysts...

REQUIREMENTS :

  • Baccalaureate level.
  • Good knowledge of computers, regular use of office automation tools.
  • CV+letter explaining the candidate's motivations.

ADMISSION DEADLINES :

  • Send the application 15 days before the start of the academics.

VAPP GATEWAY :

  • If you do not have the required diploma, you can access academics through the Validation of Personal and Professional Experience (VAPP): vapp@univ-smb.fr. See our dedicated page.

DISABILITY ACCESSIBILITY :

SPECIFICATIONS :

  • Free registration for the module or the complete cycle.
  • Rhythm of the academics specially arranged to allow the continuation of the professional activity.
  • Active pedagogy, alternating theoretical contributions and practical situations.
  • Complementarity of profiles within the promotion and richness of exchanges.

HOW TO OBTAIN IT :

  • Continuous control: all modules are evaluated with specific MCQs or TPs. Each module is given a mark out of 20 (except for the introductory module 1).
  • The awarding of the diploma is conditional on the complete follow-up of the course at academics and an overall average of at least 10/20 (possible capitalisation of modules for validation in two years).

LOCATION:

Université Savoie Mont Blanc
IUT of ANNECY
9 rue de l'Arc-en-Ciel - BP 240
74942 Annecy-le-Vieux cedex

RATES :

  • Full degree course (154 h): €3,696 (€24/hour - rate with funding)
  • Individual financing, à la carte modules: contact us using the form below.

ADMINISTRATIVE FOLLOW-UP

REQUEST FOR INFORMATION: academics Excel Expert University Diploma Data Management and Visualization

Ask all your questions on academics Excel Expert DU Data Management and Visualization!

  • This field is used for validation purposes only and should remain unchanged.

Useful links :