Data Modeling

Jacobs Mgt Center.

Introduction to Data Modeling using Excel

Spreadsheets are tremendously powerful tools; they provide the capability to manipulate complex data to supply information and to make decisions. Most self-proclaimed Excel users actually use less than 10% of a spreadsheet’s analytical capability. This course is designed to enhance the skill of Excel users and introduce spreadsheets as a tool to model and support your decision-making.

Best for participants who wish to refresh or learn more about the following:

  • Formulas and Functions (sum, average, count...)
  • Logical and Reference Functions (if, lookups, index and match...)
  • Text Functions for data cleaning (trim, left, right, find...)
  • Conditional Formatting
  • Basic Data Modeling (Pivot Tables, What If Analysis...)

Dates: TBD

Cost: $1,095

Data Modeling and Dashboards using Excel Power Tools

Develop skills to analyze data and create interactive data visualizations. Excel provides a set of tools that allow you to save time cleaning, formatting and importing data from a variety of sources. These tools also assist in creating and updating standard reports and dashboards to dynamically visualize data. 

  • Get and Transform tool imports, cleans, formats and combines data from a variety of sources​.
  • Power Query takes the time and energy out of updating reports. 
  • Power Pivot allows the user to create data models that make seamless connections between a variety of data sources. 
  • Power View and Power Map create interactive dashboards that communicate the story of your data.

Dates: TBD

Cost: $1,095

*Discounted rate for registering for both Data Modeling programs- $2,000 (must register for both at the same time).

About the Instructor

Dianna Cichocki.

Dianna Cichocki

Clinical Assistant Professor
Management Science and Systems Department

Education

MS, Oswego State University
BA, St. John Fisher College

Dianna Cichocki teaches "Statistical Decisions in Management" and "Statistical Foundations in Analytics." She has given several presentations at both the state and national levels concerning incorporating technology into statistics, educational practices and assurance of learning. Cichocki has been honored with academic excellence awards for her instruction.

Teaching

    MGQ301 – Statistical Decisions in Management
    MGQ 606 - Statistical Foundations in Analytics

Professional Affiliations

    American Mathematics Association of Two-Year Colleges (AMATYC)
    New York State Association of Two-Year Colleges (NYSMATYC)

Awards and Recognition

    National Institute for Staff and Organizational Development (2010)
    Outstanding Classroom or Alternative Instruction (2010)

Payment Options

Each program costs $1,095 and includes all materials used.

Payment can be made as follows:

Credit card (Visa, MasterCard, American Express or Discover)
or
Check made payable to UB Foundation Activities Inc. and mailed to:
Office of Professional and Executive Development
339 Jacobs Management Center
Buffalo, NY 14260