Below I demonstrate a basic analysis of the “Region and Category” Microstrategy template. Showcasing the Northeast Region, electronics category and subcategories; filtered on color by discount % of revenue.
Author Archives: Notable Office
Data Analysis With OLAP Tool WebPivotTable
Here I demonstrate data analysis and knowledge of OLAP tool, WebPivotTable. See sample pivot table below:
PostgresSQL: Cube, RollUP, Grouping Sets, Partial Cube, AND Partial RollUP Operators
Continuing my SQL education, I have been working with PostgresSQL while taking online courses via Coursera. I have create some SQL statements using cube, rollup and grouping sets operators. See below: Cube ROLLUP: Grouping Sets: Partial Cube: Partial RollUP:
Entity Relationship Diagram: Conversions
When you finish creating your Entity Relationship Diagram and made sure that there are no errors; you can then start converting to tables by using the conversion rules. See below. Entity Type Rule: Convert the Student, Loan, Institution, Lender and DisburseLine entity types into tables. 1-M Relationships rule for all relationships except Sent relationship. UseContinue reading “Entity Relationship Diagram: Conversions”
Business Intelligence: Entity Relationship Diagram
When building a schema for a relational database, opt for keeping data to the granular level. It is imperative that an ERD (Entity Relationship Diagram) is created to visualize objects(tables) within an organization or information system and their relationships to one another. Say you have a “Customer” table, this table should have all the attributesContinue reading “Business Intelligence: Entity Relationship Diagram”
Lean Wednesday Tip: Buyer Product Satisfaction
“Yield higher buyer satisfaction by developing products that actually solves a problem, is easy to use/set up, is convenient, fun and environmentally friendly.”
Tax Reform: The best way to utilize tax savings
The new tax law will offer tax cuts to businesses which raises many questions among leaders as to how to best utilize that capital/ tax savings. Many companies have decided to invest in their people by giving away generous bonuses which embodies the employee-centric philosophy. In addition, to demonstrating your appreciation for your employees youContinue reading “Tax Reform: The best way to utilize tax savings”
Digging into Logistics: Data Analysis with SQL
By understanding customer priorities you yield profitable insights. When you plan your data analysis around your strategic goals and customer priorities you reduce waste and enhance productivity. Below I have developed a relative logistics SQL database schema to demonstrate my skills. (SQLlite Source) CREATE TABLE customers ( cust_id INTEGER PRIMARY KEY, cname TEXT,Continue reading “Digging into Logistics: Data Analysis with SQL”
Happy Holidays!
Happy Holidays! I hope you have a great, delicious and safe holiday!
Planning, Budgeting and Forecasting
Profitability and optimized performance pressure from top management are driving CFOs and Finance executives to develop and maintain effective financial planning and analysis skills. It also means going beyond the numbers by bringing the voice of the customer into the spectrum. To deliver exemplary financial planning and analysis results, you must have clear understanding ofContinue reading “Planning, Budgeting and Forecasting”
Notable 