Andrea AllenSQL lesson learned 1Today I was working on Hackerrank questions for SQL practice. The problem was to:Sep 2, 2021Sep 2, 2021
Andrea AllenHow to Write a Quick Start GuideI took a writing course titled “How to Write a Quick Start Guide”. This course included a writing exercise to revise. Below you can find…May 26, 2021May 26, 2021
Andrea AllenRevisions to the 2021 Summary of Benefits documentThe below document is page 4 of the Blue Cross Blue Shield 2021 Summary of Benefits. The purpose of the entire document is described as:May 26, 2021May 26, 2021
Andrea AllenTechnical Writing Practice-Revised DoorDash Help ArticleA recent Zoom call made me aware that technical documentation, aka technical writing, is a career path I should explore considering I have…May 12, 2021May 12, 2021
Andrea AllenSales Report (Part 4)- Line Chart and SlicersPivot tables are great way to analyze and showcase your data. It’s also easy to create visuals called Pivot Charts. As a reminder, this is…Apr 29, 2021Apr 29, 2021
Andrea AllenExcel Sales Report (Part 3)-Pivot TablesNow it’s time to create our reports using standard pivot tables. A pivot table creates calculations based on criteria and conditions. For…Apr 27, 2021Apr 27, 2021
Andrea AllenExcel Sales Report(Part 2)- FormulasAfter importing the data from the previous article, I must create a flat table that contains all of my data so that I will be able to pivot…Apr 26, 2021Apr 26, 2021
Andrea AllenExcel Sales Report (Part 1)-Import DataThis series will follow the steps of creating a Sales Report.Apr 26, 2021Apr 26, 2021
Andrea AllenExcel Dashboard-MarketingThis dashboard was created from marketing data in Maven data playground. I cleaned the data in power query and used pivot tables to…Apr 25, 2021Apr 25, 2021