The following images are snapshots from complex projects.
Product Development Practicum. Utilized project management tools and methodologies to simulate development of commercial aircraft tire. Shown below are project schedule and sales presentation slide:
Microsoft Access and Pivot Table Case. Created entity-relationship model in MS Access for large sales order database file. Executed queries on data and exported to MS Excel. Created pivot tables from exported data to analyze sales. Shown below are ER diagram in MS Access, sample of information structure in MS Access, sample of pivot table analysis in MS Excel:
Entity-Relationship Model. Created an entity-relationship diagram based on a business case:
Cost-Benefit Analysis. Performed DCF and break-even analysis of a hypothetical IT implementation project. Shown below is DCF analysis:
Microsoft SQL Server Data Tools Practicum. Executed an SQL script in Management Studio to populate OLTP database and create data mart structure, followed by using Integration Services for ETL procedure (e.g. data flow mapping) to create and populate a data mart; Executed an SQL script in Management Studio to create a data mart based upon a star schema, followed by using Analysis Services to create and deploy a data cube structure for browsing in Management Studio; Used Analysis Services to create and evaluate an analytic decision tree mining model; Used Reporting Services to create a basic sales report.
Strategic Analysis of Spotify. Performed industry and company analysis of Spotify to answer strategic questions. Shown below are samples of financial analysis:
Value Chain Analysis of Artizone and Two-Step Distribution System. Performed company analysis of activity systems to answer strategic questions. Presented to CFO and founder of respective companies. Shown below are presentation samples:
Forecasting in Microsoft Excel. Created fundamental forecasting techniques using written equations. Shown below are forecast outputs:
Tableau Practicum. Shown below are examples of my fundamental Tableau knowledge:
All images © 2015 Brian Kihneman All Rights Reserved